ICCTRNHDR – Inventory Adjustment
- System
- Inventory Control (IC)
- Prefix
ITH- Primary key
COMPANY,LOCATION,RECRD-TYPE,DOC-TYPE,DOCUMENT- Fields
- 19
- Updated by
- 2 programs
- Referenced by
- 0 programs
ICCTRNHDR is the Inventory Adjustment table in Lawson Inventory Control (prefix ITH). It is indexed by COMPANY, LOCATION, RECRD-TYPE, DOC-TYPE, DOCUMENT (ITHSET1); alternate indexes: ITHSET2. It is related 1:M to ICCTRNLIN. It is updated by IC500 and IC54.1. The table has 19 fields, 2 indexes and 1 documented relation.
About ICCTRNHDR
No description in the Lawson data dictionary.
Fields (19)
Column = COBOL field name without the ITH- 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 |
|---|---|---|---|
#ITH-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.1 |
#ITH-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC54.1 |
#ITH-RECRD-TYPE PKRECRD_TYPE | Numeric 2 | — | IC54.1 |
#ITH-DOC-TYPE PKDOC_TYPE | Alpha 2 | This field contains the type of transaction. | IC54.1 |
#ITH-DOCUMENT PKDOCUMENT | Alpha 10 (Right Justified) | This field identifies the document from which this transaction record was created. | IC54.1 |
#ITH-LINE-NBRLINE_NBR | Numeric 6 | This field contains the line number. | IC54.1 |
#ITH-SEQSEQ | Numeric 3 | This field contains the record sequence number. | IC54.1 |
#ITH-TRANS-DATETRANS_DATE | Numeric 8 (yyyymmdd) | The date of the transaction. | IC54.1 |
#ITH-ACTUAL-TIMEACTUAL_TIME | Numeric 4 | This field contains the actual time the receiver was entered into the system. This filed defaults to the system date if an actual time was not entered. | IC54.1 |
#ITH-GL-DATEGL_DATE | Numeric 8 (yyyymmdd) | This field contains the general ledger posting date. | IC54.1 |
#ITH-EST-DEL-DATEEST_DEL_DATE | Numeric 8 (yyyymmdd) | — | IC54.1 |
#ITH-FR-TO-LOCFR_TO_LOC | Alpha 5 | — | IC54.1 |
#ITH-INTRANSIT-FLINTRANSIT_FL | Alpha 1 | — | IC54.1 |
#ITH-INTRAN-RECVINTRAN_RECV | Alpha 10 | — | IC54.1 |
#ITH-REPRINT-FLREPRINT_FL | Alpha 1 | — | IC54.1 |
#ITH-FR-TO-COFR_TO_CO | Numeric 4 | — | IC54.1 |
#ITH-OPERATOROPERATOR | Alpha 10 | This field is used to store the login id of the person who entered the record. | IC54.1 |
#ITH-RECORD-ERROR SET2RECORD_ERROR | Alpha 1 | — | IC500, IC54.1 |
#ITH-USER-ANALYSISUSER_ANALYSIS | Alpha 103 | — | IC54.1 |
Indexes (2)
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 |
|---|---|---|---|---|
ITHSET1 |
| Primary | IC500, IC54.1 | |
ITHSET2 |
| Subset | Where RECORD-ERROR = "Y" | IC54.1 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Icctrnlin | ICCTRNLIN |
|