WFRDIDTEMP FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

DTP-DIRECTORY-ID     Numeric 15
Directory Id

DTP-SYSTEM           Alpha 2
System Code          A two-character code representing an
                     application used within the Lawson
                     system. (i.e.: GL = General Ledger, AP =
                     Accounts Payable, etc.)

DTP-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.

DTP-EMPLOYEE         Numeric 9
Employee             Contains the employee number. Each
                     person employed by the company is
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.

DTP-VENDOR-GROUP     Alpha 4
Vendor Group         A vendor group represents a group of
                     vendors that can be shared by one or
                     more companies.

DTP-VENDOR           Alpha 9
Vendor ID            The vendor's identification code.



DTP-CUST-GROUP       Alpha 5
Customer Group       Customer group. Used to identify a
                     group of customer associated with one or
                     more companies.

DTP-CUSTOMER         Alpha 9  (Right Justified)
Customer Number      This field contains the number that
                     represents a customer.

DTP-BUYER-CODE       Alpha 3
Buyer Code           The user defined buyer identifier.

DTP-REQUESTER        Alpha 10  (Lower Case)
Requester            This is the person who requested this
                     requisition.

DTP-WEB-USER         Alpha 15  (Lower Case)
Web User

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

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


                         WFRDIDTEMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DTPSET1   DIRECTORY-ID

DTPSET2   COMPANY       KeyChange, Subset
          EMPLOYEE      Where EMPLOYEE != Zeroes

DTPSET3   VENDOR-GROUP  KeyChange, Subset
          VENDOR        Where VENDOR != Spaces

DTPSET4   COMPANY       KeyChange, Subset
          CUSTOMER      Where CUSTOMER != Spaces

DTPSET5   COMPANY       KeyChange, Subset
          REQUESTER     Where REQUESTER != Spaces

DTPSET6   COMPANY       KeyChange, Subset
          BUYER-CODE    Where BUYER-CODE != Spaces

DTPSET7   WEB-USER      KeyChange
          DIRECTORY-ID

                         WFRDIDTEMP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvenmast      APVENMAST    Required

                            DTP-VENDOR-GROUP    -> VEN-VENDOR-GROUP  (VENSET1)
                            DTP-VENDOR          -> VEN-VENDOR

Buyer          BUYER        Required

                            DTP-COMPANY         -> BUY-COMPANY
                            DTP-BUYER-CODE      -> BUY-BUYER-CODE

Custdesc       CUSTDESC     Required

                            DTP-CUST-GROUP      -> CUD-CUST-GROUP
                            DTP-CUSTOMER        -> CUD-CUSTOMER

Employee       EMPLOYEE     Required

                            DTP-COMPANY         -> EMP-COMPANY
                            DTP-EMPLOYEE        -> EMP-EMPLOYEE

Glsystem       GLSYSTEM     Required

                            DTP-COMPANY         -> GLS-COMPANY

Requester      REQUESTER    Required

                            DTP-COMPANY         -> REQ-COMPANY
                            DTP-REQUESTER       -> REQ-REQUESTER

Wfrdidhdr      WFRDIDHDR    Required

                            DTP-DIRECTORY-ID    -> WDR-DIRECTORY-ID