Lawson Insight Technical Documentation |
|
ITEMSRC
ITEMSRC FILE
REFERENCED BY
DR100 IC125 IC130 IC140 IC141 IC142
IC182 IC211 IC225 IC226 IC270 IC281
IC282 IC283 IC285 IC36.1 IC520 IC521
IC522 IC523 IC524 IC525 IC526 IC527
IC530 IC531 IC598 IC83.1 IC84.1 IC84.2
PC120 SEA1.1 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 SEA3.1 SEA4.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 The company number represents an IC320 IC331
established company and is entered on IC81.1 IC812
all function codes. IC82.1 IC840
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 IC330 IC331
IC81.1 IC812
IC82.1 IC840
ITM-REPL-FROM-LOC Alpha 5 IC10.2 IC12.2
Element: Location Code IC330 IC331
IC81.1 IC812
IC82.1 IC840
ITM-REPL-FROM-BIN Alpha 7 IC10.2 IC12.2
Element: Bin IC330 IC331
IC81.1 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 IC182
IC211 IC225
IC226 IC270
IC281 IC282
IC283 IC285
IC320 IC330
IC331 IC36.1
IC520 IC521
IC522 IC523
IC524 IC525
IC526 IC527
...
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 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
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
|