Lawson Insight Technical Documentation |
|
ITEMSRC
ITEMSRC FILE
REFERENCED BY
BL120 BL122 BL130 BL140 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 IC130 IC211 PO16.1 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO23.1 PO27.2
PO520 POIJ.1 RQ10.1 RQ10.3 RQ11.1 RQ35.1
RQ500 RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIH.1
RQIJ.1 WH20.2 WH20.7
UPDATED BY
IC12.2 IC320 IC330 IC812
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITM-COMPANY Numeric 4 IC12.2 IC320
Element: Company Identifies the AP company if the IC812
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
ITM-LOCATION Alpha 5 IC12.2 IC320
Element: Location This field contains a valid stocking IC812
location within the company inventory.
ITM-ITEM Alpha 32 IC12.2 IC812
Element: Item This field contains the item
identifier.
ITM-REPLENISH-PRI Numeric 6 IC12.2 IC812
Element: Replenish Pri Replenishment Priority. A priority of
1 is the top priority.
ITM-VENDOR Alpha 9 (Right Justified) IC12.2 IC320
Element: Vendor The vendor's identification code. IC330 IC812
ITM-PURCH-FR-LOC Alpha 4 IC12.2 IC330
Element: Purch Fr Loc The vendor's purchase from location. IC812
ITM-REPL-FROM-CO Numeric 4 IC12.2 IC330
Element: Company Identifies the AP company if the IC812
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
ITM-REPL-FROM-LOC Alpha 5 IC12.2 IC330
Element: Location This field contains a valid stocking IC812
location within the company inventory.
ITM-REPL-FROM-BIN Alpha 7 IC12.2 IC330
Element: Bin This field contains a storage area for IC812
an item or any number of items.
ITEMSRC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITMSET1 COMPANY BL120 BL122
LOCATION BL130 BL140
ITEM BL20.1 BL20.3
REPLENISH-PRI BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC12.1
IC12.2 IC130
IC211 IC320
IC330 PO16.1
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO23.1 PO27.2
PO520 POIJ.1
...
ITMSET2 REPL-FROM-CO IC12.1 IC12.2
REPL-FROM-LOC IC330
COMPANY
LOCATION
ITEM
REPLENISH-PRI
ITMSET3 VENDOR IC12.2 IC330
PURCH-FR-LOC
COMPANY
LOCATION
ITEM
REPLENISH-PRI
ITMSET4 COMPANY Subset BL140 IC330
LOCATION Where VENDOR != Spaces
VENDOR
ITEM
PURCH-FR-LOC
ITMSET5 COMPANY Subset IC330
LOCATION Where VENDOR != Spaces
ITEM
VENDOR
PURCH-FR-LOC
ITEMSRC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When ITM-VENDOR != Spaces
ITM-COMPANY -> CPY-COMPANY
Company ICCOMPANY Required
ITM-COMPANY -> ICC-COMPANY
Gl Company GLSYSTEM Required
ITM-COMPANY -> GLS-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ITM-ITEM -> ITE-ITEM
Location ICLOCATION Required
ITM-COMPANY -> ICL-COMPANY
ITM-LOCATION -> ICL-LOCATION
Poitemven POITEMVEN Required
When ITM-VENDOR != Spaces
PCG-PROCURE-GROUP -> PIV-PROCURE-GROUP
ITM-ITEM -> PIV-ITEM
ITM-VENDOR -> PIV-VENDOR
Procuregrp PROCUREGRP Required
ICC-ITEM-GROUP -> PCG-ITEM-GROUP
Repl From Bin ICBIN Required
ITM-REPL-FROM-CO -> ICB-COMPANY
ITM-REPL-FROM-LOC -> ICB-LOCATION
ITM-REPL-FROM-BIN -> ICB-BIN
Repl Itemloc ITEMLOC Not Required
ITM-REPL-FROM-CO -> ITL-COMPANY
ITM-REPL-FROM-LOC -> ITL-LOCATION
ITM-ITEM -> ITL-ITEM
Vendloc APVENLOC Required
When ITM-VENDOR != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
ITM-VENDOR -> VLO-VENDOR
ITM-PURCH-FR-LOC -> VLO-LOCATION-CODE
Vendmast APVENMAST Required
When ITM-VENDOR != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
ITM-VENDOR -> VEN-VENDOR
Vendorgroup APVENGROUP Required
When ITM-VENDOR != Spaces
CPY-VENDOR-GROUP -> VGP-VENDOR-GROUP
|