GLNLOCDTL

REFERENCED BY
IC10.2 IC11.1 IC175 IC183 IC20.1 IC20.2
IC21.1 IC21.2 IC22.1 IC22.2 IC223 IC23.1
IC24.1 IC24.2 IC25.1 IC258 IC320 IC331
IC500 IC503 IC524 IC58.1 IC58.2 IC58.3
IC62.1 IC811 IC812 IC82.1 PO560 AP161
ZA161


UPDATED BY
AP510 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC02.1 IC12.1
IC15.2 IC330 IC81.1 IC840 MA531 MA540
PO122 PO150 PO25.6 PO25.7 PO25.1 PO25.5
PO26.3 PO26.7 PO26.9 PO28.2 PO36.2 PO36.1
PO536 IC01.1 IC802 RQ01.1 PO04.1 PO04.2
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 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 IC140 IC141 IC142 IC145 IC243
IC66.1 IC83.1 MX123 MX500 MA126 MA180
MA278 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 MA53.1 MA530
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
PD570 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO17.1 PO190 PO192 PO195 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO222 PO223 PO224 PO225
PO229 PO23.1 PO230 PO233 PO234 PO24.1
PO251 PO253 PO254 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO278 PO280 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
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO529 PO54.1 PO54.2 PO54.3 PO54.4
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.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
IC14.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 IC02.1
IC10.2 IC11.1
IC12.1 IC15.2
IC175 IC183
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC223 IC23.1
IC24.1 IC24.2
IC25.1 IC258
IC320 IC330
IC331 IC500
IC503 IC524
IC58.1 IC58.2
IC58.3 IC62.1
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
MA540


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 02:18:26 2016

Home
Contact Us



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