GLNLOC

UPDATED BY
AP510

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLO-ITEM-GROUP
Element: Item Group		Alpha 5
AP510
GLO-GLN-NBR
Element: Gln Nbr		Alpha 13
AP510
GLO-DESCRIPTION
Element: Description 60		Alpha 60 (Lower Case)
AP510
GLO-PARENT
Element: Gln Nbr		Alpha 13
AP510
GLO-STATUS
Element: Status		Numeric 1

0 = Inactive
1 = Active
AP510


GLNLOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLOSET1 ITEM-GROUP
GLN-NBR
AP510
GLOSET2 ITEM-GROUP
PARENT
GLN-NBR
Subset
WherePARENT !=Spaces
AP510


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: Wed Jun 08 20:49:37 2016

Home
Contact Us



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