 |
Lawson Insight Technical Documentation |
|
ITEMSRC FILE
REFERENCED BY
DR100 IC125 IC130 IC140 IC141 IC142
IC211 IC225 IC226 IC281 IC36.1 IC520
IC521 IC522 IC523 IC524 IC525 IC526
IC527 IC530 IC531 IC598 IC83.1 PC120
SEA1.1 PO16.1 POIJ.1 RQ10.1 RQ10.3 RQ11.1
RQ35.1 RQ500 RQIC.1 RQID.1 RQIF.1 RQIG.1
SEA3.1 WH20.2 WH20.7 SEA4.1
UPDATED BY
IC10.2 IC12.2 IC320 IC330 IC81.1 IC812
IC82.1 IC840
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITM-COMPANY Numeric 4 IC10.2 IC12.2
Company The company number represents an IC320 IC81.1
established company and is entered on IC812 IC82.1
all function codes. IC840
ITM-LOCATION Alpha 5 IC10.2 IC12.2
Location Code This field contains a valid stocking IC320 IC81.1
location within the company inventory. IC812 IC82.1
IC840
ITM-ITEM Alpha 32 IC10.2 IC12.2
Item Number This field contains the item IC81.1 IC812
identifier. IC82.1 IC840
ITM-REPLENISH-PRI Numeric 6 IC10.2 IC12.2
Replenish Pri Replenishment Priority. A priority of IC81.1 IC812
1 is the top priority. IC82.1 IC840
ITM-VENDOR Alpha 9 (Right Justified) IC10.2 IC12.2
Vendor ID The vendor's identification code. IC320 IC330
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 IC81.1
Location Code IC812 IC82.1
IC840
ITM-REPL-FROM-CO Numeric 4 IC10.2 IC12.2
Repl From Co This is the source company from which IC330 IC81.1
this line will be replenished. IC812 IC82.1
IC840
ITM-REPL-FROM-LOC Alpha 5 IC10.2 IC12.2
Replenishment From This is the default location from which IC330 IC81.1
Location the location gets replenished. This is IC812 IC82.1
used in the par cart replenishment IC840
process.
ITM-REPL-FROM-BIN Alpha 7 IC10.2 IC12.2
Replenishment From Relpenishment from bin. Bin number IC330 IC81.1
Bin within the replenishment from location. IC812 IC82.1
IC840
ITEMSRC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITMSET1 COMPANY DR100 IC10.2
LOCATION IC12.1 IC12.2
ITEM IC125 IC130
REPLENISH-PRI IC140 IC141
IC142 IC211
IC225 IC226
IC281 IC320
IC330 IC36.1
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
IC530 IC531
IC598 IC81.1
IC82.1 IC83.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 IC330
LOCATION Where VENDOR != Spaces
VENDOR
ITEM
PURCH-FR-LOC
ITMSET5 COMPANY Subset IC330 SEA4.1
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
ITEMSRC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pharittoitmloc PHARITEM
ITM-COMPANY -> PHI-COMPANY
ITM-LOCATION -> PHI-LOCATION
ITM-ITEM -> PHI-ITEM
PHI-NDC-NBR
PHI-UPC
|