ICRECEIPTS – Costing Record

System
Inventory Control (IC)
Prefix
ICR
Primary key
COMPANY, LOCATION, ITEM, DOCUMENT, DOC-TYPE, SYSTEM-CD, LINE-NBR, COMPONENT-SEQ
Fields
19
Updated by
238 programs
Referenced by
27 programs

ICRECEIPTS is the Costing Record table in Lawson Inventory Control (prefix ICR). It is indexed by COMPANY, LOCATION, ITEM, DOCUMENT, DOC-TYPE, SYSTEM-CD, LINE-NBR, COMPONENT-SEQ (ICRSET1); alternate indexes: ICRSET2, ICRSET3, ICRSET4, ICRSET5 and ICRSET6. It is related 1:1 to ICCOMPANY, ICLOCATION, ITEMLOC and ITEMMAST and 1:M to ICICRAUDIT. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 230 more and referenced by IC120, IC170, IC182, IC190, IC222, IC227, IC228, IC233 and 19 more. The table has 19 fields, 6 indexes and 5 documented relations.

About ICRECEIPTS

The Costing Record file is the cost history file. Every incoming inventory update transaction creates a record in this file which is used for LIFO and FIFO costing. Outgoing transactions consume inventory by updating the used quantity.

Fields (19)

Column = COBOL field name without the ICR- 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 / columnTypeDescription & valuesUpdated by
#ICR-COMPANY PK
COMPANY		Numeric 4Identifies 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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-ITEM PK
ITEM		Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-DOCUMENT PK
DOCUMENT		Alpha 10 (Right Justified)This field identifies the document from which this transaction record was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-DOC-TYPE PK
DOC_TYPE		Alpha 2This field contains the type of transaction.
  • AJ Adjustment
  • CR Customer Return
  • PI Physical Inventory Adjustment
  • PO PO Receiving
  • RC Receipt
  • RT Receiving Transfer
  • SH Shipment
  • RR Requisition Return
  • VI Vendor Return Adj to Inventory
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This field indicates the originating system of the transaction.
  • IC Inventory Control
  • PO Purchase Order
  • OE Order Entry
  • RQ Requisitions
  • WO Work Order
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-LINE-NBR PK
LINE_NBR		Numeric 6This field displays the system-assigned transaction number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the component sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-RECEIVED-QTY
RECEIVED_QTY		Signed 13.4This field contains the quantity of the original transaction that is added to the stock-on-hand quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-USED-QTY
USED_QTY		Signed 13.4This field contains the quantity that has been used by outgoing transactions.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-UNIT-COST
UNIT_COST		Signed 18.5This field contains the actual unit cost for this incoming transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-RECEIVED-DATE SET2 SET3 SET5 SET6
RECEIVED_DATE		Numeric 8 (yyyymmdd)This field contains the date when this transaction record was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-RECEIVED-TIME SET2 SET3 SET5 SET6
RECEIVED_TIME		Numeric 6 (hhmmss)This field contains the actual time this receipt took place.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-LAST-ACT-DATE SET6
LAST_ACT_DATE		Numeric 8 (yyyymmdd)This field contains the date this record was last updated. Whenever this record is updated, the system date defaults.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-HOLD-QTY
HOLD_QTY		Signed 13.4This is the quantity of the receipt that is waiting inspection or it is the quantity that was rejected by an inspection for which a PO vendor return was automatically built and is now waiting for the ship function against the PO vendor return.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-CREATED-BY
CREATED_BY		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICR-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (6)

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.

IndexKeysFlagsConditionUsed in
ICRSET1
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. DOCUMENT
  5. DOC-TYPE
  6. SYSTEM-CD
  7. LINE-NBR
  8. COMPONENT-SEQ
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ICRSET2
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. RECEIVED-DATE ↓
  5. RECEIVED-TIME ↓
  6. DOCUMENT
  7. DOC-TYPE
  8. SYSTEM-CD
  9. LINE-NBR
  10. COMPONENT-SEQ
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ICRSET3
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. RECEIVED-DATE
  5. RECEIVED-TIME
  6. DOCUMENT
  7. DOC-TYPE
  8. SYSTEM-CD
  9. LINE-NBR
  10. COMPONENT-SEQ
SubsetWhere RECEIVED-QTY != USED-QTYAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ICRSET4
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. DOCUMENT
  5. DOC-TYPE
  6. SYSTEM-CD
  7. LINE-NBR
  8. COMPONENT-SEQ
SubsetWhere RECEIVED-QTY != USED-QTYIC28.1, IC47.1
ICRSET5
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. RECEIVED-DATE ↓
  5. RECEIVED-TIME ↓
  6. DOCUMENT
  7. DOC-TYPE
  8. SYSTEM-CD
  9. LINE-NBR
  10. COMPONENT-SEQ
SubsetWhere RECEIVED-QTY != USED-QTYAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ICRSET6
  1. COMPANY
  2. RECEIVED-DATE
  3. RECEIVED-TIME
  4. LAST-ACT-DATE
  5. LOCATION
  6. ITEM
  7. DOCUMENT
  8. DOC-TYPE
  9. SYSTEM-CD
  10. LINE-NBR
  11. COMPONENT-SEQ
KeyChange—

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyICCOMPANYRequired
ICR-COMPANY→ICC-COMPANY (ICCSET1)
IclocationICLOCATIONRequired
ICR-COMPANY→ICL-COMPANY
ICR-LOCATION→ICL-LOCATION
ItemlocITEMLOCRequired
ICR-COMPANY→ITL-COMPANY
ICR-LOCATION→ITL-LOCATION
ICR-ITEM→ITL-ITEM
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
ICR-ITEM→ITE-ITEM

One to many (1) — child tables

RelationTableRulesConditionField map
IcicrauditICICRAUDIT
ICR-COMPANY→IRA-COMPANY
ICR-LOCATION→IRA-LOCATION
ICR-ITEM→IRA-ITEM
ICR-DOCUMENT→IRA-DOCUMENT
ICR-DOC-TYPE→IRA-DOC-TYPE
ICR-SYSTEM-CD→IRA-SYSTEM-CD
ICR-LINE-NBR→IRA-LINE-NBR
ICR-COMPONENT-SEQ→IRA-COMPONENT-SEQ
—→IRA-DATE
—→IRA-TIME
—→IRA-FLD-NBR

Programs

Updated by (238)

Referenced by (27)