ITEMSRC – Item Source
- System
- Inventory Control (IC)
- Prefix
ITM- Primary key
COMPANY,LOCATION,ITEM,REPLENISH-PRI- Fields
- 9
- Updated by
- 10 programs
- Referenced by
- 64 programs
ITEMSRC is the Item Source table in Lawson Inventory Control (prefix ITM). It is indexed by COMPANY, LOCATION, ITEM, REPLENISH-PRI (ITMSET1); alternate indexes: ITMSET2, ITMSET3, ITMSET4 and ITMSET5. It is related 1:1 to APCOMPANY, ICCOMPANY, GLSYSTEM, ITEMMAST, ICLOCATION, PROCUREGRP, ICBIN, ITEMLOC and 3 more and 1:M to POITEMVEN. It is updated by AP300, IC10.2, IC12.2, IC320, IC330, IC331, IC81.1, IC812 and 2 more and referenced by CX205, DR100, IC125, IC130, IC140, IC141, IC142, IC175 and 56 more. The table has 9 fields, 5 indexes and 12 documented relations.
About ITEMSRC
No description in the Lawson data dictionary.
Fields (9)
Column = COBOL field name without the ITM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ITM-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | IC10.2, IC12.2, IC320, IC331, IC81.1, IC812, IC82.1, IC840 |
ITM-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC10.2, IC12.2, IC320, IC331, IC81.1, IC812, IC82.1, IC840 |
ITM-ITEM PKITEM | Alpha 32 | This field contains the item identifier. | IC10.2, IC12.2, IC331, IC81.1, IC812, IC82.1, IC840 |
ITM-REPLENISH-PRI PKREPLENISH_PRI | Numeric 6 | Replenishment Priority. A priority of 1 is the top priority. | IC10.2, IC12.2, IC331, IC81.1, IC812, IC82.1, IC840 |
ITM-VENDORVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | IC10.2, IC12.2, IC320, IC330, IC331, IC81.1, IC812, IC82.1 +1 more |
ITM-PURCH-FR-LOCPURCH_FR_LOC | Alpha 4 | The vendor's purchase from location. | IC10.2, IC12.2, IC330, IC331, IC81.1, IC812, IC82.1, IC840 |
ITM-REPL-FROM-COREPL_FROM_CO | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | IC10.2, IC12.2, IC330, IC331, IC81.1, IC812, IC82.1, IC840 |
ITM-REPL-FROM-LOCREPL_FROM_LOC | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC10.2, IC12.2, IC330, IC331, IC81.1, IC812, IC82.1, IC840 |
ITM-REPL-FROM-BINREPL_FROM_BIN | Alpha 7 | This field contains a storage area for an item or any number of items. | IC10.2, IC12.2, IC330, IC331, IC81.1, IC812, IC82.1, IC840 |
Indexes (5)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ITMSET1 | COMPANY, LOCATION, ITEM, REPLENISH-PRI | Primary | CX205, DR100, IC10.2, IC12.1, IC12.2, IC125, IC130, IC140 +22 more (list truncated in source) | |
ITMSET2 | REPL-FROM-CO, REPL-FROM-LOC, COMPANY, LOCATION, ITEM, REPLENISH-PRI | IC12.1, IC12.2, IC330, IC331 | ||
ITMSET3 | VENDOR, PURCH-FR-LOC, COMPANY, LOCATION, ITEM, REPLENISH-PRI | KeyChange | IC12.2, IC330 | |
ITMSET4 | COMPANY, LOCATION, VENDOR, ITEM, PURCH-FR-LOC | KeyChange, Subset | Where VENDOR != Spaces | AP300, IC330 |
ITMSET5 | COMPANY, LOCATION, ITEM, VENDOR, PURCH-FR-LOC | KeyChange, Subset | Where VENDOR != Spaces | IC330 |
Relations
One to one (11) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 | |
| 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 |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Poitemven | POITEMVEN | PCG-PROCURE-GROUP → PIV-PROCURE-GROUP, ITM-ITEM → PIV-ITEM, ITM-VENDOR → PIV-VENDOR, PIV-VEN-ITEM |
Programs
Updated by (10)
- AP300 Invoice and Vendor History Purge
- IC10.2 Item Master and Location
- IC12.2 Replenishment Setup
- IC320 Mass Item Location Copy
- IC330 Item Mass Change
- IC331 Par Cart Mass Changes
- IC81.1 Cart, Par Location
- IC812 Item Location Load
- IC82.1 Par Location Item Mass Change
- IC840 Cart Par Location Conversion
Referenced by (64)
- CX205 Preference Template Items
- DR100 Distribution Requirements Report
- IC125 Standard Cost Valuation
- IC130 General Ledger Interface
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC175 Update Variances
- IC182 Par Location Utilization
- IC211 Item Location Listing
- IC225 Inventory Reorder Advice
- IC226 Leadtime Review Report
- IC227 Potential Obsolete
- IC270 Count Sheets
- IC281 Par Inventory Worksheet
- IC282 Requesting Location Usage
- IC283 Par Location Valuation
- IC285 Detail Par Loc Utilization
- IC36.1 User Defined Item Inquiry
- IC511 Item Master-Item Location Extr
- IC520 Handheld Item Master Interface
- IC521 Bar Code Item Master Interface
- IC522 HL7 Item Master - Atwork
- IC523 HL7 Item Master - OmniCell
- IC524 CSV Item Master
- IC525 HL7 Item Master Interface
- IC526 HL7 Item Master - McKesson
- IC527 HL7 Item Master - DeRoyal
- IC598 Bin Label Export
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- IC84.1 Detail Par Location Utilization by Month
- IC84.2 Detail Par Location Utilization by Month
- PC120 Price Calculation
- PO16.1 Bid
- PO20.1 Purchase Order Entry
- PO20.9 Multiple Lines
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO23.1 Purchase Order Worksheet
- PO27.2 Select Blanket Lines
- PO27.4 Select and Copy Template
- PO520 Purchase Order Interface from Non Lawson
- PO54.5 PO Line Detail List
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- RQ10.1 Requisition
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ35.1 Requisition Returns
- RQ500 Requisition Interface
- RQIC.1 Get Item List Invoke Object
- RQID.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIG.1 Get Shopping List Invoke Object
- RQIH.1 Invoke Determine Express Data
- RQIJ.1 Requisition Copy
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location