WFRDIDDTL FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WRD-DIRECTORY-ID     Numeric 15
Directory Id

WRD-SEQ-NUMBER       Numeric 6
Record Sequence      A unique number assigned to each
Number               transaction to be transferred into the
                     Lawson system.

WRD-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)
Effective Date       The date a vendor's prices will be in
                     effect.

WRD-DIR-ID-TYPE      Alpha 10
Dir Id Type

WRD-PARENT-DIR-ID    Numeric 15
Parent Dir Id

WRD-DIR-STATUS       Alpha 1
Dir Status           A = Active
                     I = Inactive
                     H = Historical

WRD-ADDR-METHOD      Alpha 5
Address Method

WRD-TAX-ID-NUMBER    Alpha 30  (Lower Case)
Tax Id Number

WRD-LEGAL-NAME       Alpha 30  (Lower Case)
Legal Name

WRD-NAME-LAST        Alpha 50  (Lower Case)
Last Name

WRD-NAME-FIRST       Alpha 50  (Lower Case)
First Name

WRD-NAME-MIDDLE-I    Alpha 1
Middle Initial

WRD-ADDR-1           Alpha 50  (Lower Case)
Address 1

WRD-ADDR-2           Alpha 50  (Lower Case)
Address 2

WRD-ADDR-3           Alpha 50  (Lower Case)
Address 3

WRD-ADDR-4           Alpha 50  (Lower Case)
Address 4

WRD-ADDR-5           Alpha 50  (Lower Case)
City or Address 5

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

WRD-LOCALITY         Alpha 50  (Lower Case)
Locality

WRD-DISTRICT         Alpha 50  (Lower Case)
District

WRD-REGION-CODE      Alpha 2
Region Code

WRD-PORT-CD          Alpha 5
Port Cd              The Intrastat port code.  Must be
                     define
                     in IN04.1 (Port Maintenance)

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


WRD-POSTAL-CODE      Alpha 10  (Lower Case)
Postal Code          This field contains the postal code.

WRD-CONTACT-ADDR     Alpha 50  (Lower Case)
Contact

WRD-POSTAL-BOX1      Alpha 30  (Lower Case)
Postal Box1

WRD-PHONE-PREFIX1    Alpha 10
Phone Prefix1

WRD-PHONE-NUMBER1    Alpha 20
Phone Number1

WRD-PHONE-SUFFIX1    Alpha 10
Phone Suffix1

WRD-MOBILE-PREFIX    Alpha 10
Mobile Prefix

WRD-MOBILE-NUMBER    Alpha 20
Mobile Number

WRD-MOBILE-SUFFIX    Alpha 10
Mobile Suffix

WRD-PAGER-PREFIX     Alpha 10
Pager Prefix

WRD-PAGER-NUMBER     Alpha 20
Pager Number

WRD-PAGER-SUFFIX     Alpha 10
Pager Suffix

WRD-PAGER-EMAIL1     Alpha 99  (Lower Case)
Pager Email1

WRD-FAX-PREFIX1      Alpha 10
Fax Prefix1

WRD-FAX-NUMBER1      Alpha 20
Fax Number1

WRD-FAX-SUFFIX1      Alpha 10
Fax Suffix1

WRD-FAX-EMAIL1       Alpha 99  (Lower Case)
Fax Email1

WRD-TELEX-NUMBER1    Alpha 20
Telex Number1

WRD-URL              Alpha 99  (Lower Case)
Url

WRD-E-MAIL1          Alpha 99  (Lower Case)
E Mail1

WRD-EDI-NBR1         Alpha 95
Edi Nbr1

WRD-LOGIN-TYPE       Alpha 5
Login Type

WRD-LOGIN1           Alpha 30  (Lower Case)
Login1

WRD-ACCESS1          Alpha 30  (Lower Case)
Access1

WRD-DATE             Numeric 8  (yyyymmdd)
Date                 This field contains the system date
                     when this was created.

WRD-TIME             Numeric 8
Time                 This field is updated automatically to
                     indicate the time that the GL entry was
                     created. It is system-maintained.


WRD-SH-ID-DESC       Derived
Sh Id Desc

WRD-NAME-LAST-CHAR   Derived
Name Last Char

                         WFRDIDDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WRDSET1   DIRECTORY-ID
          SEQ-NUMBER*

WRDSET2   DIRECTORY-ID  KeyChange
          SEQ-NUMBER*
          EFFECTIVE-DATE*
          DIR-ID-TYPE
          PARENT-DIR-ID

WRDSET3   DIR-ID-TYPE   KeyChange
          DIRECTORY-ID
          SEQ-NUMBER*
          EFFECTIVE-DATE*
          PARENT-DIR-ID

WRDSET4   DIRECTORY-ID  KeyChange
          SEQ-NUMBER*
          EFFECTIVE-DATE*

WRDSET5   DIR-ID-TYPE   KeyChange
          DIRECTORY-ID
          EFFECTIVE-DATE*
          SEQ-NUMBER*

WRDSET6   DIRECTORY-ID  KeyChange
          DIR-ID-TYPE
          EFFECTIVE-DATE*
          SEQ-NUMBER*

WRDSET7   LOGIN-TYPE    KeyChange
          LOGIN1
          ACCESS1
          DIRECTORY-ID
          EFFECTIVE-DATE*
          SEQ-NUMBER*

                         WFRDIDDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfrdaddr       WFRDADDR     Required

                            WRD-ADDR-METHOD       -> WAT-ADDR-METHOD  (WATSET1)

Wfrdctry       WFRDCTRY     Required

                            WRD-COUNTRY-CODE      -> WCT-COUNTRY-CODE

Wfrdidhdr      WFRDIDHDR    Required

                            WRD-DIRECTORY-ID      -> WDR-DIRECTORY-ID

Wfrdidtype     WFRDIDTYPE   Required

                            WRD-DIR-ID-TYPE       -> WTY-DIR-ID-TYPE

Wfrdlogtyp     WFRDLOGTYP   Required

                            WRD-LOGIN-TYPE        -> WLT-LOGIN-TYPE

Wfrdregion     WFRDREGION   Required

                            WRD-COUNTRY-CODE      -> WRG-COUNTRY-CODE
                            WRD-REGION-CODE       -> WRG-REGION-CODE

Wfrdstprov     WFRDSTPROV   Required

                            WRD-COUNTRY-CODE      -> WSP-COUNTRY-CODE
                            WRD-STATE-PROV        -> WSP-STATE-PROV

                         WFRDIDDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfrdidgrp      WFRDIDGRP

                            WRD-DIRECTORY-ID      -> WDG-DIRECTORY-ID
                            WRD-EFFECTIVE-DATE    -> WDG-EFFECTIVE-DATE
                                                     WDG-DIRECTORY-GRP