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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`ITM-COMPANY` PK COMPANY	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` PK LOCATION	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` PK ITEM	Alpha 32	This field contains the item identifier.	IC10.2, IC12.2, IC331, IC81.1, IC812, IC82.1, IC840
#`ITM-REPLENISH-PRI` PK REPLENISH_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-VENDOR` SET3 SET4 SET5 VENDOR	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-LOC` SET3 SET4 SET5 PURCH_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-CO` SET2 REPL_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-LOC` SET2 REPL_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-BIN` REPL_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 are listed in index order; ↓ marks a descending key. 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

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

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

ITEMSRC – Item Source

About ITEMSRC

Fields (9) Copy as SQL

Indexes (5)

Relations

One to one (11) — lookups and parents

One to many (1) — child tables

Programs

Updated by (10)

Referenced by (64)

Fields (9)