GLNLOCDTL

REFERENCED BY
AP161 ZA161 IC258 IC58.1 IC58.2 IC58.3


UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 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 AP271 AP30.2 AP30.4
AP300 AP305 AP510 AP90.1 AP91.1 API1.1
API2.1 API3.1 API4.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC02.1 IC14.1 IC140 IC142
IC15.2 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC802
IC81.1 IC83.1 IC840 MX123 MX500 MA180
MA279 MA41.1 MA41.2 MA41.4 MA41.7 MA42.1
MA42.2 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA44.1 MA44.2 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD235
PO04.1 PO10.1 PO10.2 PO100 PO101 PO120
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.2 PO22.3 PO22.4 PO22.5
PO220 PO223 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO27.2
PO278 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.1 PO54.2 PO54.3 PO54.4 PO54.5
PO560 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 RQ01.1 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1 RQ500
RQIF.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
ZW130 IC01.1

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


GLNLOCDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLXSET1 ITEM-GROUP
GLN-NBR
GLN-TYPE
SEQUENCE
AP510 IC258
IC58.1 IC58.2
IC58.3 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
MA531 MA540
PO122 PO560
GLXSET2 ITEM-GROUP
GLN-TYPE
COMPANY
LOCATION
BIN
GLN-NBR
Subset
WhereCOMPANY !=Zeroes
AndGLN-TYPE !=1
AP510 IC01.1
IC02.1 IC15.2
IC258 IC58.1
IC58.2 IC58.3
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
MA540 RQ01.1
GLXSET3 ITEM-GROUP
GLN-TYPE
BUYER-CODE
GLN-NBR
Subset
WhereBUYER-CODE !=Spaces
AndGLN-TYPE =12
AP510 IC258
IC58.1 IC58.2
IC58.3 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
PO04.1
GLXSET4 ITEM-GROUP
GLN-TYPE
VENDOR
LOCATION-CODE
GLN-NBR
Subset
WhereVENDOR !=Spaces
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
GLXSET5 ITEM-GROUP
GLN-TYPE
MANUF-CODE
MANUF-DIVISION
GLN-NBR
Subset
WhereMANUF-CODE !=Spaces
AP510 IC14.1
IC258 IC58.1
IC58.2 IC58.3
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9
GLXSET6 COMPANY
Subset
WhereCOMPANY !=Zeroes
AndGLN-TYPE =1
AP161 AP510
ZA161 IC258
IC58.1 IC58.2
IC58.3 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
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: Thu Jun 09 11:16:47 2016

Home
Contact Us



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