|
|
WFGRPTEMP FILE
Resource Directory Group Temp
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GUT-DIRECTORY-GRP Alpha 25 (Lower Case)
Directory Grp
GUT-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.)
GUT-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
GUT-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.
GUT-VENDOR-GROUP Alpha 4
Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
GUT-VENDOR Alpha 9
Vendor ID The vendor's identification code.
GUT-CUST-GROUP Alpha 5
Customer Group Customer group. Used to identify a
group of customer associated with one or
more companies.
GUT-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
GUT-BUYER-CODE Alpha 3
Buyer Code The user defined buyer identifier.
GUT-REQUESTER Alpha 10 (Lower Case)
Requester This is the person who requested this
requisition.
GUT-WEB-USER Alpha 15 (Lower Case)
Web User
GUT-DATE Numeric 8 (yyyymmdd)
Date This field contains the system date
when this was created.
GUT-TIME Numeric 8
Time This field is updated automatically to
indicate the time that the GL entry was
created. It is system-maintained.
WFGRPTEMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GUTSET1 DIRECTORY-GRP
GUTSET2 WEB-USER KeyChange, Subset
DIRECTORY-GRP Where WEB-USER != Spaces
GUTSET3 COMPANY KeyChange, Subset
EMPLOYEE Where EMPLOYEE != Zeroes
GUTSET4 VENDOR-GROUP KeyChange, Subset
VENDOR Where VENDOR != Spaces
GUTSET5 COMPANY KeyChange, Subset
CUSTOMER Where CUSTOMER != Spaces
GUTSET6 COMPANY KeyChange, Subset
REQUESTER Where REQUESTER != Spaces
GUTSET7 COMPANY KeyChange, Subset
BUYER-CODE Where BUYER-CODE != Spaces
WFGRPTEMP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apvenmast APVENMAST Required
GUT-VENDOR-GROUP -> VEN-VENDOR-GROUP (VENSET1)
GUT-VENDOR -> VEN-VENDOR
Buyer BUYER Required
GUT-COMPANY -> BUY-COMPANY
GUT-BUYER-CODE -> BUY-BUYER-CODE
Custdesc CUSTDESC Required
GUT-CUST-GROUP -> CUD-CUST-GROUP
GUT-CUSTOMER -> CUD-CUSTOMER
Employee EMPLOYEE Required
GUT-COMPANY -> EMP-COMPANY
GUT-EMPLOYEE -> EMP-EMPLOYEE
Glsystem GLSYSTEM Required
GUT-COMPANY -> GLS-COMPANY
Requester REQUESTER Required
GUT-COMPANY -> REQ-COMPANY
GUT-REQUESTER -> REQ-REQUESTER
Wfgrouphdr WFGROUPHDR Required
GUT-DIRECTORY-GRP -> WGH-DIRECTORY-GRP
|