GLNLOC

REFERENCED BY
IC00.1


UPDATED BY
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

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
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
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 11:16:47 2016

Home
Contact Us



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