FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
GLX-ITEM-GROUP Element: Item Group | Alpha 5
|
|
GLX-GLN-NBR Element: Gln Nbr | Alpha 13
|
|
GLX-GLN-TYPE Element: Gln Type | Numeric 2
01 = GL Company 02 = IC Company 03 = IC Location 04 = Requesting Location 05 = Manufacturer Code 06 = Manufacturer Division 07 = AP Vendor 08 = AP Vendor Location 09 = PO Vendor 10 = PO Vendor Location 11 = IC Bin 12 = Buyer |
|
GLX-SEQUENCE Element: Sequence | Numeric 6
|
|
GLX-COMPANY Element: Company | Numeric 4
|
|
GLX-LOCATION Element: Location | Alpha 5
|
|
GLX-VENDOR Element: Vendor | Alpha 9 (Right Justified)
|
|
GLX-LOCATION-CODE Element: Location Code | Alpha 4
|
|
GLX-BUYER-CODE Element: Buyer | Alpha 3
|
|
GLX-MANUF-CODE Element: Manuf Code | Alpha 4
|
|
GLX-MANUF-DIVISION Element: Manuf Division | Alpha 4
|
|
GLX-BIN Element: Bin | Alpha 7
|
|
NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
GLXSET1 |
ITEM-GROUP
GLN-NBR
GLN-TYPE
SEQUENCE
|
|
|
GLXSET2 |
ITEM-GROUP
GLN-TYPE
COMPANY
LOCATION
BIN
GLN-NBR
|
Subset |
Where | | COMPANY |
!= | Zeroes | |
And | | GLN-TYPE |
!= | 1 | |
|
|
GLXSET3 |
ITEM-GROUP
GLN-TYPE
BUYER-CODE
GLN-NBR
|
Subset |
Where | | BUYER-CODE |
!= | Spaces | |
And | | GLN-TYPE |
= | 12 | |
|
|
GLXSET4 |
ITEM-GROUP
GLN-TYPE
VENDOR
LOCATION-CODE
GLN-NBR
|
Subset |
Where | | VENDOR |
!= | Spaces | |
|
|
GLXSET5 |
ITEM-GROUP
GLN-TYPE
MANUF-CODE
MANUF-DIVISION
GLN-NBR
|
Subset |
Where | | MANUF-CODE |
!= | Spaces | |
|
|
GLXSET6 |
COMPANY
|
Subset |
Where | | COMPANY |
!= | Zeroes | |
And | | GLN-TYPE |
= | 1 | |
|
|
GLXSET7 |
GLN-TYPE
GLN-NBR
SEQUENCE
ITEM-GROUP
|
|
|
RELATION NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
Apvenloc |
APVENLOC |
Not Required
Valid When | | GLX-VENDOR | != | Spaces | |
And | | GLX-LOCATION-CODE | != | Spaces | |
And | | GLX-GLN-TYPE | = | 8 | |
PCG-VENDOR-GROUP | -> | VLO-VENDOR-GROUP |
GLX-VENDOR | -> | VLO-VENDOR |
GLX-LOCATION-CODE | -> | VLO-LOCATION-CODE |
|
Apvenmast |
APVENMAST |
Not Required
Valid When | | GLX-VENDOR | != | Spaces | |
And | | GLX-LOCATION-CODE | = | Spaces | |
And | | GLX-GLN-TYPE | = | 7 | |
PCG-VENDOR-GROUP | -> | VEN-VENDOR-GROUP |
GLX-VENDOR | -> | VEN-VENDOR |
|
Buyer |
BUYER |
Not Required
Valid When | | GLX-BUYER-CODE | != | Spaces | |
And | | GLX-GLN-TYPE | = | 12 | |
PCG-PROCURE-GROUP | -> | BUY-PROCURE-GROUP |
GLX-BUYER-CODE | -> | BUY-BUYER-CODE |
|
Glnloc |
GLNLOC |
Required
GLX-ITEM-GROUP | -> | GLO-ITEM-GROUP |
GLX-GLN-NBR | -> | GLO-GLN-NBR |
|
Glnlocdtl |
GLNLOCDTL |
Not Required
Valid When | | GLX-COMPANY | != | Zeroes | |
And | | GLX-GLN-TYPE | = | 1 | |
|
Icbin |
ICBIN |
Not Required
Valid When | | GLX-COMPANY | != | Zeroes | |
And | | GLX-LOCATION | != | Spaces | |
And | | GLX-GLN-TYPE | = | 11 | |
GLX-COMPANY | -> | ICB-COMPANY |
GLX-LOCATION | -> | ICB-LOCATION |
GLX-BIN | -> | ICB-BIN |
|
Iccompany |
ICCOMPANY |
Not Required
Valid When | | GLX-COMPANY | != | Zeroes | |
And | | GLX-GLN-TYPE | = | 2 | |
|
Iclocation |
ICLOCATION |
Not Required
Valid When | | GLX-COMPANY | != | Zeroes | |
And | | GLX-LOCATION | != | Spaces | |
And | | GLX-GLN-TYPE | = | 3 | |
GLX-COMPANY | -> | ICL-COMPANY |
GLX-LOCATION | -> | ICL-LOCATION |
|
Icmanfcode |
ICMANFCODE |
Not Required
Valid When | | GLX-MANUF-CODE | != | Spaces | |
GLX-ITEM-GROUP | -> | IMC-ITEM-GROUP |
GLX-MANUF-CODE | -> | IMC-MANUF-CODE |
GLX-MANUF-DIVISION | -> | IMC-MANUF-DIVISION |
|
Povendloc |
POVENDLOC |
Not Required
Valid When | | GLX-VENDOR | != | Spaces | |
And | | GLX-LOCATION-CODE | != | Spaces | |
And | | GLX-GLN-TYPE | = | 10 | |
PCG-VENDOR-GROUP | -> | PVL-VENDOR-GROUP |
GLX-VENDOR | -> | PVL-VENDOR |
GLX-LOCATION-CODE | -> | PVL-PURCH-FR-LOC |
|
Povendor |
POVENDOR |
Not Required
Valid When | | GLX-VENDOR | != | Spaces | |
And | | GLX-LOCATION-CODE | = | Spaces | |
And | | GLX-GLN-TYPE | = | 9 | |
PCG-VENDOR-GROUP | -> | POV-VENDOR-GROUP |
GLX-VENDOR | -> | POV-VENDOR |
|
Procuregrp |
PROCUREGRP |
Not Required
GLX-ITEM-GROUP | -> | PCG-ITEM-GROUP |
|
Rqloc |
RQLOC |
Not Required
Valid When | | GLX-COMPANY | != | Zeroes | |
And | | GLX-LOCATION | != | Spaces | |
And | | GLX-GLN-TYPE | = | 4 | |
GLX-COMPANY | -> | RQL-COMPANY |
GLX-LOCATION | -> | RQL-REQ-LOCATION |
|