ICICRAUDIT – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
IRA
Primary key
COMPANY, LOCATION, ITEM, DOCUMENT, DOC-TYPE, SYSTEM-CD, LINE-NBR, COMPONENT-SEQ, DATE, TIME, FLD-NBR
Fields
16
Updated by
239 programs
Referenced by
0 programs

ICICRAUDIT is a Lawson Inventory Control table (prefix IRA); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, ITEM, DOCUMENT, DOC-TYPE, SYSTEM-CD, LINE-NBR, COMPONENT-SEQ, DATE, TIME, FLD-NBR (IRASET1). It is related 1:1 to ICCOMPANY, ICLOCATION, ICRECEIPTS, ITEMLOC and ITEMMAST. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 231 more. The table has 16 fields, 1 index and 5 documented relations.

About ICICRAUDIT

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the IRA- 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
#IRA-COMPANY PK
COMPANY		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-LOCATION PK
LOCATION		Alpha 5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-ITEM PK
ITEM		Alpha 32—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-DOCUMENT PK
DOCUMENT		Alpha 10 (Right Justified)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-DOC-TYPE PK
DOC_TYPE		Alpha 2—
  • AJ Adjustment
  • PI Physical Inventory Adjustment
  • PO PO Receiving
  • RC Receipt
  • RT Receiving Transfer
  • SH Shipment
  • RR Requisition Return
  • VI Vendor Return Adj to Inventory
  • CR Customer Return
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-SYSTEM-CD PK
SYSTEM_CD		Alpha 2—
  • 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)
#IRA-LINE-NBR PK
LINE_NBR		Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-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)
#IRA-DATE PK
DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-TIME PK
TIME		Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-FLD-NBR PK
FLD_NBR		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 35—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-AFTER-IMAGE
AFTER_IMAGE		Alpha 35This field contains the field image after the change.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-OPERATOR
OPERATOR		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#IRA-AUDIT-ACTION
AUDIT_ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (1)

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
IRASET1
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. DOCUMENT
  5. DOC-TYPE
  6. SYSTEM-CD
  7. LINE-NBR
  8. COMPONENT-SEQ
  9. DATE ↓
  10. TIME ↓
  11. FLD-NBR
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
IRA-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequired
IRA-COMPANY→ICL-COMPANY
IRA-LOCATION→ICL-LOCATION
IcreceiptsICRECEIPTSRequired
IRA-COMPANY→ICR-COMPANY
IRA-LOCATION→ICR-LOCATION
IRA-ITEM→ICR-ITEM
IRA-DOCUMENT→ICR-DOCUMENT
IRA-DOC-TYPE→ICR-DOC-TYPE
IRA-SYSTEM-CD→ICR-SYSTEM-CD
IRA-LINE-NBR→ICR-LINE-NBR
IRA-COMPONENT-SEQ→ICR-COMPONENT-SEQ
ItemlocITEMLOCRequired
IRA-COMPANY→ITL-COMPANY
IRA-LOCATION→ITL-LOCATION
IRA-ITEM→ITL-ITEM
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
IRA-ITEM→ITE-ITEM

Programs

Updated by (239)