ITLBOD

REFERENCED BY
IC02.1 IC10.2 IC11.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 IC58.1
IC62.1 IC64.2 IC81.1 IC811 IC812 IC82.1
IC840 PO00.1 PO150 PO25.6 PO25.7 PO26.4
PO26.5 PO28.2 PO36.2 PO536


UPDATED BY
IC12.1 ICBD.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IBB-COMPANY
Element: Company		Numeric 4
ICBD.1
IBB-LOCATION
Element: Location		Alpha 5
ICBD.1
IBB-ITEM
Element: Item		Alpha 32
ICBD.1
IBB-BOD-ACCT-ENT
Element: Ext Acct Ent		Alpha 22 (Lower Case)
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
IC58.1 IC62.1
IC64.2 IC81.1
IC811 IC812
IC82.1 IC840
ICBD.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
IBB-BOD-LOCATION
Element: Ext Location		Alpha 22 (Lower Case)
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
IC58.1 IC62.1
IC64.2 IC81.1
IC811 IC812
IC82.1 IC840
ICBD.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
IBB-BOD-DOC-ID
Element: Ext Ship Nbr		Alpha 100 (Lower Case)
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
IC58.1 IC62.1
IC64.2 IC81.1
IC811 IC812
IC82.1 IC840
ICBD.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
IBB-BOD-SOR
Element: Flag		Alpha 1

0 = Lawson
1 = External
ICBD.1
IBB-BOD-REVISION
Element: Ext Acct Ent		Alpha 22 (Lower Case)
ICBD.1
IBB-BOD-VAR-ID
Element: Ext Acct Ent		Alpha 22 (Lower Case)
ICBD.1


ITLBOD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IBBSET1 COMPANY
LOCATION
ITEM
...
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
IC58.1 IC62.1
IC64.2 IC81.1
IC811 IC812
IBBSET2 BOD-DOC-ID
BOD-ACCT-ENT
BOD-LOCATION
BOD-REVISION
ICBD.1 ICBD.2


ITLBOD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemloc ITEMLOC Required
IBB-COMPANY->ITL-COMPANY
IBB-LOCATION->ITL-LOCATION
IBB-ITEM->ITL-ITEM

File created: Thu Jun 09 02:19:07 2016

Home
Contact Us



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