WFRDSTPROV FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WSP-COUNTRY-CODE     Alpha 2
Country Code         The country code.  Required for VAT and
                     intrastat reporting.  Must be defined in
                      IN01.1 (Country Maintenance).


WSP-STATE-PROV       Alpha 2
State or Province    The state or province.

WSP-DESCRIPTION      Alpha 30  (Lower Case)
Description          This field contains the description.

                         WFRDSTPROV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WSPSET1   COUNTRY-CODE
          STATE-PROV

                         WFRDSTPROV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfrdctry       WFRDCTRY     Required

                            WSP-COUNTRY-CODE    -> WCT-COUNTRY-CODE  (WCTSET1)