WFRDCTRY FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


WCT-EC-CTRY-NBR      Numeric 3
Ec Ctry Nbr          The European Community Country number;
                     leave blank if not a member of the
                     European Community.

WCT-ISO-CTRY-NBR     Numeric 3
Iso Ctry Nbr         The ISO country number.

WCT-COUNTRY-DESC     Alpha 30  (Lower Case)
Country Description

WCT-EC-FLAG          Alpha 1
Ec Flag              Set to Y if the country is a member of
                     the European Community. Used for
                     Intrastat processing.
                     N = No
                     Y = Yes

                         WFRDCTRY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCTSET1   COUNTRY-CODE

                         WFRDCTRY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfrdport       WFRDPORT

                            WCT-COUNTRY-CODE    -> WPR-COUNTRY-CODE  (WPRSET1)
                                                   WPR-PORT-CD

Wfrdregion     WFRDREGION

                            WCT-COUNTRY-CODE    -> WRG-COUNTRY-CODE
                                                   WRG-REGION-CODE

Wfrdstprov     WFRDSTPROV

                            WCT-COUNTRY-CODE    -> WSP-COUNTRY-CODE
                                                   WSP-STATE-PROV