ICCTRNLIN – Inventory Line Adjustment
- System
- Inventory Control (IC)
- Prefix
ITI- Primary key
COMPANY,LOCATION,RECRD-TYPE,DOC-TYPE,DOCUMENT,LINE-NBR- Fields
- 30
- Updated by
- 2 programs
- Referenced by
- 0 programs
ICCTRNLIN is the Inventory Line Adjustment table in Lawson Inventory Control (prefix ITI). It is indexed by COMPANY, LOCATION, RECRD-TYPE, DOC-TYPE, DOCUMENT, LINE-NBR (ITISET1). It is related 1:M to ICCTRNDTL. It is updated by IC500 and IC54.2. The table has 30 fields, 1 index and 1 documented relation.
About ICCTRNLIN
No description in the Lawson data dictionary.
Fields (30)
Column = COBOL field name without the ITI- 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 |
|---|---|---|---|
#ITI-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. | IC54.2 |
#ITI-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC54.2 |
#ITI-RECRD-TYPE PKRECRD_TYPE | Numeric 2 | — | IC54.2 |
#ITI-DOC-TYPE PKDOC_TYPE | Alpha 2 | This field contains the type of transaction. | IC54.2 |
#ITI-DOCUMENT PKDOCUMENT | Alpha 10 (Right Justified) | This field identifies the document from which this transaction record was created. | IC54.2 |
#ITI-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | IC54.2 |
#ITI-SEQSEQ | Numeric 3 | This field contains the record sequence number. | IC54.2 |
#ITI-ITEMITEM | Alpha 32 | This field contains the item identifier. | IC500, IC54.2 |
#ITI-QUANTITYQUANTITY | Signed 13.4 | This field contains the desired quantity. | IC54.2 |
#ITI-UNIT-COSTUNIT_COST | Signed 18.5 | — | IC54.2 |
#ITI-AOC-UCOSTAOC_UCOST | Signed 18.5 | — | IC54.2 |
#ITI-TRAN-UOMTRAN_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | IC54.2 |
#ITI-REFERENCEREFERENCE | Alpha 10 (Lower Case) | The reference number associated with the transaction. | IC54.2 |
#ITI-BINBIN | Alpha 7 | This field contains a storage area for an item or any number of items. | IC54.2 |
#ITI-REASON-CODEREASON_CODE | Alpha 4 | This field contains the reason code, which indicates the cause for credit memos. | IC500, IC54.2 |
#ITI-ACTIVITYACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | IC54.2 |
#ITI-ACCT-CATACCT_CAT | Alpha 5 | — | IC54.2 |
#ITI-LINE-COMMLINE_COMM | Alpha 30 | — | IC54.2 |
#ITI-OFFSET-ACCTUNIOFFSET_ACCTUNI | Alpha 15 | — | IC500, IC54.2 |
#ITI-OFFSET-ACCTOFFSET_ACCT | Numeric 6 | — | IC500, IC54.2 |
#ITI-OFFSET-SUBACCTOFFSET_SUBACCT | Numeric 4 | — | IC500, IC54.2 |
#ITI-AOC-ACCTUNITAOC_ACCTUNIT | Alpha 15 | — | IC500, IC54.2 |
#ITI-AOC-ACCTAOC_ACCT | Numeric 6 | — | IC500, IC54.2 |
#ITI-AOC-SUBACCTAOC_SUBACCT | Numeric 4 | — | IC500, IC54.2 |
#ITI-FR-TO-BINFR_TO_BIN | Alpha 7 | — | IC500, IC54.2 |
#ITI-LST-ISS-FLLST_ISS_FL | Alpha 1 | — | IC500, IC54.2 |
#ITI-SEC-QTYSEC_QTY | Signed 13.4 | — | IC54.2 |
#ITI-ORIG-QTYORIG_QTY | Signed 13.4 | — | IC54.2 |
#ITI-USER-ANALYSISUSER_ANALYSIS | Alpha 103 | — | IC54.2 |
#ITI-GTINGTIN | Numeric 14 | — | IC54.2 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ITISET1 |
| Primary | IC500, IC54.2 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Icctrndtl | ICCTRNDTL |
|