ICCTRNDTL – Inventory Detail Adjustment

System
Inventory Control (IC)
Prefix
ITJ
Primary key
COMPANY, LOCATION, RECRD-TYPE, DOC-TYPE, DOCUMENT, LINE-NBR, SEQ
Fields
16
Updated by
2 programs
Referenced by
0 programs

ICCTRNDTL is the Inventory Detail Adjustment table in Lawson Inventory Control (prefix ITJ). It is indexed by COMPANY, LOCATION, RECRD-TYPE, DOC-TYPE, DOCUMENT, LINE-NBR, SEQ (ITJSET1). It is updated by IC500 and IC54.3. The table has 16 fields, 1 index and 0 documented relations.

About ICCTRNDTL

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the ITJ- 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
#ITJ-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.IC54.3
#ITJ-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.IC54.3
#ITJ-RECRD-TYPE PK
RECRD_TYPE		Numeric 2—IC54.3
#ITJ-DOC-TYPE PK
DOC_TYPE		Alpha 2This field contains the type of transaction.IC54.3
#ITJ-DOCUMENT PK
DOCUMENT		Alpha 10 (Right Justified)This field identifies the document from which this transaction record was created.IC54.3
#ITJ-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.IC54.3
#ITJ-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.IC54.3
#ITJ-SERIAL
SERIAL		Alpha 16—IC54.3
#ITJ-BIN
BIN		Alpha 7This field contains a storage area for an item or any number of items.IC54.3
#ITJ-LOT
LOT		Alpha 10This field contains the identifier for the homogeneous quantity of material.IC54.3
#ITJ-SUB-LOT
SUB_LOT		Alpha 6—IC54.3
#ITJ-ITEM
ITEM		Alpha 32This field contains the item identifier.IC54.3
#ITJ-QUANTITY
QUANTITY		Signed 13.4This field contains the desired quantity.IC54.3
#ITJ-HOLD-FL
HOLD_FL		Alpha 1—IC54.3
#ITJ-EXP-DATE
EXP_DATE		Numeric 8 (yyyymmdd)—IC54.3
#ITJ-SEC-QTY
SEC_QTY		Signed 13.4—IC54.3

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
ITJSET1
  1. COMPANY
  2. LOCATION
  3. RECRD-TYPE
  4. DOC-TYPE
  5. DOCUMENT
  6. LINE-NBR
  7. SEQ
PrimaryIC500, IC54.3

Programs

Updated by (2)