WFGROUP FILE
Resource Directory Group
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GRP-DIRECTORY-GRP Alpha 25 (Lower Case)
Directory Grp
GRP-SEQ-NUMBER Numeric 6
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system.
GRP-DIRGROUP-TYPE Alpha 10
Dirgroup Type
GRP-GROUP-CHILD Alpha 30 (Lower Case)
Group Child
GRP-GROUP-STATUS Alpha 1
Group Status A = Active
I = Inactive
H = Historical
GRP-ADDR-METHOD Alpha 5
Address Method
GRP-TAX-ID-NUMBER Alpha 30 (Lower Case)
Tax Id Number
GRP-LEGAL-NAME Alpha 30 (Lower Case)
Legal Name
GRP-NAME-LAST Alpha 50 (Lower Case)
Last Name
GRP-NAME-FIRST Alpha 50 (Lower Case)
First Name
GRP-NAME-MIDDLE-I Alpha 1
Middle Initial
GRP-ADDR-1 Alpha 50 (Lower Case)
Address 1
GRP-ADDR-2 Alpha 50 (Lower Case)
Address 2
GRP-ADDR-3 Alpha 50 (Lower Case)
Address 3
GRP-ADDR-4 Alpha 50 (Lower Case)
Address 4
GRP-ADDR-5 Alpha 50 (Lower Case)
City or Address 5
GRP-STATE-PROV Alpha 2
State or Province The state or province.
GRP-LOCALITY Alpha 50 (Lower Case)
Locality
GRP-DISTRICT Alpha 50 (Lower Case)
District
GRP-REGION-CODE Alpha 2
Region Code
GRP-PORT-CD Alpha 5
Port Cd The Intrastat port code. Must be
define
in IN04.1 (Port Maintenance)
GRP-COUNTRY-CODE Alpha 2
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
GRP-POSTAL-CODE Alpha 10 (Lower Case)
Postal Code This field contains the postal code.
GRP-CONTACT-ADDR Alpha 50 (Lower Case)
Contact
GRP-POSTAL-BOX1 Alpha 30 (Lower Case)
Postal Box1
GRP-PHONE-PREFIX1 Alpha 10
Phone Prefix1
GRP-PHONE-NUMBER1 Alpha 20
Phone Number1
GRP-PHONE-SUFFIX1 Alpha 10
Phone Suffix1
GRP-MOBILE-PREFIX Alpha 10
Mobile Prefix
GRP-MOBILE-NUMBER Alpha 20
Mobile Number
GRP-MOBILE-SUFFIX Alpha 10
Mobile Suffix
GRP-PAGER-PREFIX Alpha 10
Pager Prefix
GRP-PAGER-NUMBER Alpha 20
Pager Number
GRP-PAGER-SUFFIX Alpha 10
Pager Suffix
GRP-PAGER-EMAIL1 Alpha 99 (Lower Case)
Pager Email1
GRP-FAX-PREFIX1 Alpha 10
Fax Prefix1
GRP-FAX-NUMBER1 Alpha 20
Fax Number1
GRP-FAX-SUFFIX1 Alpha 10
Fax Suffix1
GRP-FAX-EMAIL1 Alpha 99 (Lower Case)
Fax Email1
GRP-TELEX-NUMBER1 Alpha 20
Telex Number1
GRP-URL Alpha 99 (Lower Case)
Url
GRP-E-MAIL1 Alpha 99 (Lower Case)
E Mail1
GRP-EDI-NBR1 Alpha 95
Edi Nbr1
GRP-LOGIN-TYPE Alpha 5
Login Type
GRP-LOGIN1 Alpha 30 (Lower Case)
Login1
GRP-ACCESS1 Alpha 30 (Lower Case)
Access1
GRP-DATE Numeric 8 (yyyymmdd)
Date This field contains the system date
when this was created.
GRP-TIME Numeric 8
Time This field is updated automatically to
indicate the time that the GL entry was
created. It is system-maintained.
GRP-SH-GRP-DESC Derived
Sh Grp Desc
WFGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRPSET1 DIRECTORY-GRP
SEQ-NUMBER
GRPSET2 DIRECTORY-GRP KeyChange
SEQ-NUMBER
DIRGROUP-TYPE
GROUP-CHILD
GROUP-STATUS
GRPSET3 DIRGROUP-TYPE KeyChange
DIRECTORY-GRP
SEQ-NUMBER
GROUP-CHILD
GROUP-STATUS
GRPSET4 LOGIN-TYPE KeyChange
LOGIN1
ACCESS1
DIRECTORY-GRP
SEQ-NUMBER
WFGROUP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfgrouphdr WFGROUPHDR Required
GRP-DIRECTORY-GRP -> WGH-DIRECTORY-GRP (WGHSET1)
Wfgrptype WFGRPTYPE Required
GRP-DIRGROUP-TYPE -> GTP-DIRGROUP-TYPE
Wfrdaddr WFRDADDR Required
GRP-ADDR-METHOD -> WAT-ADDR-METHOD
Wfrdctry WFRDCTRY Required
GRP-COUNTRY-CODE -> WCT-COUNTRY-CODE
Wfrdlogtyp WFRDLOGTYP Required
GRP-LOGIN-TYPE -> WLT-LOGIN-TYPE
Wfrdregion WFRDREGION Required
GRP-COUNTRY-CODE -> WRG-COUNTRY-CODE
GRP-REGION-CODE -> WRG-REGION-CODE
Wfrdstprov WFRDSTPROV Required
GRP-COUNTRY-CODE -> WSP-COUNTRY-CODE
GRP-STATE-PROV -> WSP-STATE-PROV
WFGROUP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfrdidgrp WFRDIDGRP
GRP-DIRECTORY-GRP -> WDG-DIRECTORY-GRP
WDG-DIRECTORY-ID
WDG-EFFECTIVE-DATE
|