GLNLOCDTL

REFERENCED BY
AP161


UPDATED BY
AP510 MA540 RQ01.1 PO04.1 AM115 AM117
AM15.1 AM15.2 AM15.3 AM15.4 AM19.1 AM19.2
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP03.3 AP110 AP115 AP125
AP126 AP131 AP150 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP210 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP305 AP90.1 AP91.1 API1.1 API2.1
API3.1 API4.1 MX123 MX500 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MAI1.1 PO10.1 PO10.2 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLX-ITEM-GROUP
Element: Item Group		Alpha 5
AP510
GLX-GLN-NBR
Element: Gln Nbr		Alpha 13
AP510
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
AP510
GLX-SEQUENCE
Element: Sequence		Numeric 6
AP510
GLX-COMPANY
Element: Company		Numeric 4
AP510
GLX-LOCATION
Element: Location		Alpha 5
AP510
GLX-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
AP510
GLX-LOCATION-CODE
Element: Location Code		Alpha 4
AP510
GLX-BUYER-CODE
Element: Buyer		Alpha 3
AP510
GLX-MANUF-CODE
Element: Manuf Code		Alpha 4
AP510
GLX-MANUF-DIVISION
Element: Manuf Division		Alpha 4
AP510
GLX-BIN
Element: Bin		Alpha 7
AP510


GLNLOCDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLXSET1 ITEM-GROUP
GLN-NBR
GLN-TYPE
SEQUENCE
AP510 MA540
GLXSET2 ITEM-GROUP
GLN-TYPE
COMPANY
LOCATION
BIN
GLN-NBR
Subset
WhereCOMPANY !=Zeroes
AndGLN-TYPE !=1
AP510 MA540
RQ01.1
GLXSET3 ITEM-GROUP
GLN-TYPE
BUYER-CODE
GLN-NBR
Subset
WhereBUYER-CODE !=Spaces
AndGLN-TYPE =12
AP510 PO04.1
GLXSET4 ITEM-GROUP
GLN-TYPE
VENDOR
LOCATION-CODE
GLN-NBR
Subset
WhereVENDOR !=Spaces
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
GLXSET5 ITEM-GROUP
GLN-TYPE
MANUF-CODE
MANUF-DIVISION
GLN-NBR
Subset
WhereMANUF-CODE !=Spaces
AP510
GLXSET6 COMPANY
Subset
WhereCOMPANY !=Zeroes
AndGLN-TYPE =1
AP161 AP510
MA540
GLXSET7 GLN-TYPE
GLN-NBR
SEQUENCE
ITEM-GROUP


GLNLOCDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apvenloc APVENLOC Not Required
Valid When GLX-VENDOR !=Spaces
AndGLX-LOCATION-CODE !=Spaces
AndGLX-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
AndGLX-LOCATION-CODE =Spaces
AndGLX-GLN-TYPE =7
PCG-VENDOR-GROUP->VEN-VENDOR-GROUP
GLX-VENDOR->VEN-VENDOR
Buyer BUYER Not Required
Valid When GLX-BUYER-CODE !=Spaces
AndGLX-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
AndGLX-GLN-TYPE =1
GLX-COMPANY->GLX-COMPANY
Icbin ICBIN Not Required
Valid When GLX-COMPANY !=Zeroes
AndGLX-LOCATION !=Spaces
AndGLX-GLN-TYPE =11
GLX-COMPANY->ICB-COMPANY
GLX-LOCATION->ICB-LOCATION
GLX-BIN->ICB-BIN
Iccompany ICCOMPANY Not Required
Valid When GLX-COMPANY !=Zeroes
AndGLX-GLN-TYPE =2
GLX-COMPANY->ICC-COMPANY
Iclocation ICLOCATION Not Required
Valid When GLX-COMPANY !=Zeroes
AndGLX-LOCATION !=Spaces
AndGLX-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
AndGLX-LOCATION-CODE !=Spaces
AndGLX-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
AndGLX-LOCATION-CODE =Spaces
AndGLX-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
AndGLX-LOCATION !=Spaces
AndGLX-GLN-TYPE =4
GLX-COMPANY->RQL-COMPANY
GLX-LOCATION->RQL-REQ-LOCATION

File created: Wed Jun 08 20:49:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.