GLNLOC

REFERENCED BY
IC00.1 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 IC320 IC330 IC331 IC500 IC503
IC524 IC62.1 IC81.1 IC811 IC812 IC82.1
IC840 PO150 PO25.6 PO25.7 PO26.4 PO26.5
PO28.2 PO36.2 PO536


UPDATED BY
AP510 IC258 IC558 IC58.1 IC58.2 IC58.3
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLO-ITEM-GROUP
Element: Item Group
Alpha 5
AP510 IC258
IC558 IC58.1
IC58.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
GLO-GLN-NBR
Element: Gln Nbr
Alpha 13
AP510 IC258
IC558 IC58.1
IC58.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
GLO-DESCRIPTION
Element: Description 60
Alpha 60 (Lower Case)
AP510 IC258
IC558 IC58.1
IC58.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
GLO-PARENT
Element: Gln Nbr
Alpha 13
AP510 IC258
IC558 IC58.1
IC58.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
GLO-STATUS
Element: Status
Numeric 1

0 = Inactive
1 = Active
AP510 IC258
IC558 IC58.1
IC58.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9


GLNLOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLOSET1 ITEM-GROUP
GLN-NBR
...
AP510 IC00.1
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 IC558
IC58.1 IC58.2
GLOSET2 ITEM-GROUP
PARENT
GLN-NBR
Subset
WherePARENT !=Spaces
AP510 IC258
IC58.1 IC58.2


GLNLOC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Not Required
GLO-ITEM-GROUP->ITG-ITEM-GROUP
Procuregrp PROCUREGRP Not Required
GLO-ITEM-GROUP->PCG-ITEM-GROUP


GLNLOC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glnlocdtl GLNLOCDTL
GLO-ITEM-GROUP->GLX-ITEM-GROUP
GLO-GLN-NBR->GLX-GLN-NBR
  GLX-GLN-TYPE
  GLX-SEQUENCE


File created: Thu Jun 09 02:18:26 2016

Home
Contact Us



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