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 DR100 IC125 IC130 IC140 IC141
IC142 IC182 IC211 IC225 IC226 IC270
IC281 IC282 IC36.1 IC520 IC521 IC522
IC523 IC524 IC525 IC526 IC527 IC530
IC531 IC598 IC83.1 PC120 SEA1.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE111 OE113 OE114 OE116 OE129 OE13.1
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE810 OE830 PO16.1
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 WO140
UPDATED BY
IC10.2 IC12.2 IC320 IC330 IC331 IC81.1
IC812 IC82.1 IC840
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITM-COMPANY Numeric 4 IC10.2 IC12.2
Element: Company Identifies the AP company if the IC320 IC331
resource type = V. Identifies the HR IC81.1 IC812
company if the resource type = E. It is IC82.1 IC840
blank for type A, P or Q resources.
ITM-LOCATION Alpha 5 IC10.2 IC12.2
Element: Location Code This field contains a valid stocking IC320 IC331
location within the company inventory. IC81.1 IC812
IC82.1 IC840
ITM-ITEM Alpha 32 IC10.2 IC12.2
Element: Item Number This field contains the item IC331 IC81.1
identifier. IC812 IC82.1
IC840
ITM-REPLENISH-PRI Numeric 6 IC10.2 IC12.2
Element: Replenish Pri Replenishment Priority. A priority of IC331 IC81.1
1 is the top priority. IC812 IC82.1
IC840
ITM-VENDOR Alpha 9 (Right Justified) IC10.2 IC12.2
Element: Vendor ID The vendor's identification code. IC320 IC330
IC331 IC81.1
IC812 IC82.1
IC840
ITM-PURCH-FR-LOC Alpha 4 IC10.2 IC12.2
Purchase From The vendor's purchase from location. IC330 IC331
Location Code IC81.1 IC812
IC82.1 IC840
ITM-REPL-FROM-CO Numeric 4 IC10.2 IC12.2
Element: Company This is the source company from which IC330 IC331
this line will be replenished. IC81.1 IC812
IC82.1 IC840
ITM-REPL-FROM-LOC Alpha 5 IC10.2 IC12.2
Element: Location Code This is the default location from which IC330 IC331
the location gets replenished. This is IC81.1 IC812
used in the par cart replenishment IC82.1 IC840
process.
ITM-REPL-FROM-BIN Alpha 7 IC10.2 IC12.2
Element: Bin Relpenishment from bin. Bin number IC330 IC331
within the replenishment from location. IC81.1 IC812
IC82.1 IC840
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 DR100
IC10.2 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC182 IC211
IC225 IC226
IC270 IC281
IC282 IC320
...
ITMSET2 REPL-FROM-CO IC12.1 IC12.2
REPL-FROM-LOC IC330 IC331
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
|