Lawson Insight Technical Documentation |
|
SIRDCTRY
SIRDCTRY FILE
This file defines country codes and specific information that pertains to
that country.
REFERENCED BY
RD16.1 RD17.1 RD18.1 RD30.1 RD30.2 RD32.5
RD32.6 RD50.1 RD50.2 RD70.1 RD70.2 RD930
UPDATED BY
RD15.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WCT-COUNTRY-CODE Alpha 2 RD15.1
Element: Country Code
WCT-EC-CTRY-NBR Numeric 3 RD15.1
Element: Ec Ctry Nbr
WCT-ISO-CTRY-NBR Numeric 3 RD15.1
Element: Iso Ctry Nbr
WCT-DESCRIPTION Alpha 50 (Lower Case) RD15.1
Element: Description This field contains the description.
WCT-EC-FLAG Alpha 1 RD15.1
Element: Ec Flag N = No
Y = Yes
WCT-DATE Numeric 8 (yyyymmdd) RD15.1
Element: Date This field contains the system date
when this was created.
WCT-TIME Numeric 6 (hhmmss) RD15.1
Element: Time
SIRDCTRY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WCTSET1 COUNTRY-CODE RD15.1 RD16.1
RD17.1 RD18.1
RD30.1 RD30.2
RD32.5 RD32.6
RD50.1 RD50.2
RD70.1 RD70.2
RD930
SIRDCTRY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Rdport SIRDPORT
WCT-COUNTRY-CODE -> WPR-COUNTRY-CODE
WPR-PORT-CD
Rdregion SIRDREGION
WCT-COUNTRY-CODE -> WRG-COUNTRY-CODE
WRG-REGION-CODE
Rdstprov SIRDSTPROV
WCT-COUNTRY-CODE -> WSP-COUNTRY-CODE
WSP-STATE-PROV
|