ICTRANS – Inventory Transaction

System
Inventory Control (IC)
Prefix
ICT
Primary key
COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ
Fields
90
Updated by
256 programs
Referenced by
65 programs

ICTRANS is the Inventory Transaction table in Lawson Inventory Control (prefix ICT). It is indexed by COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ (ICTSET1); alternate indexes: ICTSET2, ICTSET3, ICTSET4, ICTSET5, ICTSET7, ICTSET8 and ICTSET9. It is related 1:1 to ICCOMPANY, GLNAMES, HAZARD, ICICTUF, ICLOCATION, ICTBOD, PORECADJLN, ITEMLOC and 7 more and 1:M to ICTRANSDTL, ITCOMMENT, MMDIST and ITSERIAL. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 248 more and referenced by CX05.1, CX05.2, CX805, IC01.2, IC02.1, IC10.2, IC110, IC15.2 and 57 more. The table has 90 fields, 8 indexes and 25 documented relations.

About ICTRANS

The Inventory Transaction file contains all the inventory transactions entered in the Inventory Control system. Each transaction type is given a unique document type.

Fields (90)

Column = COBOL field name without the ICT- 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
#ICT-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)
#ICT-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)
#ICT-DOC-TYPE PK
DOC_TYPE		Alpha 2This field contains the type of transaction.
  • AJ Adjustment
  • BT Bin Transfer
  • CA Cost Adjustment
  • CR Customer Return
  • DT Direct Transfer
  • IR Intransit Receiving
  • IS Issue
  • IT Transfer Issue
  • PI Physical Inventory Adjustment
  • RC Receipt
  • RR Requisition Return
  • RT Receiving Transfer
  • SH Shipment
  • VA Vendor Return Adjustment
  • VR Vendor Return
  • PO PO Receiving
  • RA PO Receiving Adjustment
  • RJ Rejected Inspection Item
  • AC Accepted Inspection Item
  • VI Vendor Return Adj to Inventory
  • AR Receipt Archive
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This field indicates on what system the transaction originated.
  • IC Inventory Control
  • OE Order Entry
  • RQ Requisition
  • CX Case Cart
  • PO Purchase Order
  • WO Work Order
  • PH Pharmacy
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-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)
#ICT-SHIPMENT-NBR PK
SHIPMENT_NBR		Numeric 10This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-DOCUMENT-SEQ
DOCUMENT_SEQ		Numeric 3This field is a counter field. It is used in the Warehouse system to create an audit trail for the Undo form action in case a shipment is processed multiple times.—
#ICT-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)
#ICT-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the record sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-UPDATE-DATE SET2 SET3 SET4
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-UPDATE-TIME SET2 SET3 SET4
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-TRAN-COUNTER SET2 SET3 SET4 SET7
TRAN_COUNTER		Numeric 6This field contains a transaction object number used to determine the sequence of updating of the Item Location file.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-TRANS-DATE SET7 SET8 SET9
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ITEM SET2 SET3 SET4 SET5 SET7
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)
#ICT-SOH-QTY
SOH_QTY		Signed 13.4This field contains the stock-on-hand quantity before this transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-QUANTITY
QUANTITY		Signed 13.4This field contains the quantity of the transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ORIGINAL-QTY
ORIGINAL_QTY		Signed 13.4This field contains the original intransit quantity. It is used only for intransit transfers.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-OPEN-QTY
OPEN_QTY		Signed 13.4This field contains the open intransit quantity not yet received.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-STOCK-UOM
STOCK_UOM		Alpha 4This field contains the stock unit of measure for the item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-UNIT-COST
UNIT_COST		Signed 18.5This field contains the unit cost for this transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-UNIT-COST-CURR
UNIT_COST_CURR		Signed 18.5This field contains the unit cost for this transaction in transaction currency.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency. 0 2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ADD-UNIT-COST
ADD_UNIT_COST		Signed 18.5This field contains the add-on unit cost or freight cost that is added to the incoming unit cost to determine a new unit cost for this intransit receiving.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-BASE-COST
BASE_COST		Signed 18.5This field contains the base cost used for calculating the standard cost of an item, if the company uses the standard costing method. The base cost is then used for standard cost variance calculation. Also, this field is used for negative average costing (if the company uses average costing and this field is flagged for allowing negative stock-on-hand). This field captures the average cost of the item prior to the transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-CURRENT-COST
CURRENT_COST		Signed 18.5This field contains the cost used for capturing the current cost of the item when the transaction is released. This is the same overall cost used for valuation, and is calculated by the costing method of the company.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-UNIT-PRICE
UNIT_PRICE		Signed 18.5This field is not used by the Inventory Control system.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-TRAN-UOM SET5
TRAN_UOM		Alpha 4This field contains the entered unit of measure on this transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-TRAN-UOM-MULT
TRAN_UOM_MULT		Signed 13.7This field contains the transaction unit of measure multiplier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-SECONDARY-QTY
SECONDARY_QTY		Signed 13.4This field contains a secondary quantity that is tracked if the item is a catch weight item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-SEC-UOM
SEC_UOM		Alpha 4This field contains the valid stock unit of measure for this item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-SEC-UOM-MULT
SEC_UOM_MULT		Signed 13.7This field contains the secondary quantity unit of measure multiplier. It is used to convert the stock-on-hand quantity to the secondary quantity or visa versa.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-GL-DATE
GL_DATE		Numeric 8 (yyyymmdd)This field contains the date this transaction is to be posted to General Ledger.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-EST-DEL-DATE
EST_DEL_DATE		Numeric 8 (yyyymmdd)This field contains the estimated delivery date. This field is required on an intransit transfer transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-REFERENCE
REFERENCE		Alpha 10 (Lower Case)This field contains the reference information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-BIN SET5
BIN		Alpha 7This field contains a storage area for an item or any number of items.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-REASON-CODE SET3
REASON_CODE		Alpha 4This field contains the reason code for the transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-LINE-COMMENT
LINE_COMMENT		Alpha 40 (Lower Case)This field contains the user-defined comments for the transaction line. These comments are for reference purposes only.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-INV-ACCT-UNIT
INV_ACCT_UNIT		Alpha 15This field contains the general ledger inventory account unit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-INV-ACCOUNT
INV_ACCOUNT		Numeric 6This field contains the general ledger inventory account number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-INV-SUB-ACCT
INV_SUB_ACCT		Numeric 4This field contains the general ledger inventory subaccount number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-OFF-ACCT-UNIT
OFF_ACCT_UNIT		Alpha 15This field contains the general ledger offset account unit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-OFF-ACCOUNT
OFF_ACCOUNT		Numeric 6This field contains the general ledger offset account number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-OFF-SUB-ACCT
OFF_SUB_ACCT		Numeric 4This field contains the general ledger offset subaccount number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-OFF-DIST-CO
OFF_DIST_CO		Numeric 4Company number used for posting the transaction to the Offset AccountIC21.1, IC21.2, IC24.1, IC24.2
#ICT-VAR-ACCT-UNIT
VAR_ACCT_UNIT		Alpha 15This field contains the general ledger cost variance account unit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-VAR-ACCOUNT
VAR_ACCOUNT		Numeric 6This field contains the general ledger cost variance account number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-VAR-SUB-ACCT
VAR_SUB_ACCT		Numeric 4This field contains the general ledger cost variance subaccount number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ADD-ACCT-UNIT
ADD_ACCT_UNIT		Alpha 15This field contains the general ledger add-on cost account unit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ADD-ACCOUNT
ADD_ACCOUNT		Numeric 6This field contains the general ledger add-on cost account number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ADD-SUB-ACCT
ADD_SUB_ACCT		Numeric 4This field contains the general ledger add-on cost subaccount number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ADD-DIST-CO
ADD_DIST_CO		Numeric 4Company number used for posting the transaction to the Add-On Cost AccountIC23.2
#ICT-STATUS SET9
STATUS		Numeric 1This field contains the processing status of the transaction.
  • 0 Unreleased
  • 1 Released
  • 2 General Ledger Updated
  • 5 Intermediate Status(see IC130)
  • 3 Non General Ledger
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-FR-DOCUMENT
FR_DOCUMENT		Alpha 10 (Right Justified)This field contains the document number for the from-location for a transfer transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-FROM-TO-BIN
FROM_TO_BIN		Alpha 7This field contains the from or to bin for a transfer transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-FROM-TO-LOC SET9
FROM_TO_LOC		Alpha 5This field contains the from or to location for a transfer location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-DETAIL-BAL-FL
DETAIL_BAL_FL		Alpha 1This field is used to balance the bin, lot, and serial number detail lines with the transaction lines before releasing the document.
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-LAST-DST-SEQ
LAST_DST_SEQ		Numeric 3This field contains the record sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ACTUAL-TIME SET7
ACTUAL_TIME		Numeric 4This field contains the system time when a transaction took place. This is in 24-hour format (HHMM).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-FROM-TO-CMPY SET9
FROM_TO_CMPY		Numeric 4This field contains the from or to company for an intercompany transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-TO-CO-B-UCOST
TO_CO_B_UCOST		Signed 18.5This field contains the base unit cost for the To company. This field is converted from the 'From' company unit cost. It can be in a different currency if the two companies have different base currencies.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-FROM-CURR-CD
FROM_CURR_CD		Alpha 5This field contains the currency code of the company that initiated the transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-TO-CURR-CD
TO_CURR_CD		Alpha 5This field contains the currency code of the company to which the inventory is being transferred.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-HIST-PERIOD
HIST_PERIOD		Numeric 2This field and the history period to which the transaction was posted ties a transaction to the period and year to which it was posted in the history file. This field is updated based on the transaction date when General Ledger Interface (IC130) is run.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-HIST-YEAR
HIST_YEAR		Numeric 4This field and the HIST YEAR field tie a transaction to the period and year it was posted to on the history file. This field is updated based on the transaction date when General Ledger Interface (IC130) is run.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-OPERATOR-ID
OPERATOR_ID		Alpha 10This field contains the terminal sign on identifier when this transaction was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-TO-UOM
TO_UOM		Alpha 4This field contains the unit of measure resulting from a bin-to-bin transfer from one unit of measure to another. This is also used by IC22.1 (Transfers) to store the unit of measure of a quantity being transferred. It is only used for intransit transfers.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-KIT-FL
KIT_FL		Alpha 1This field is used to indicate that this transaction is for kit item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-BL-INVOICED
BL_INVOICED		Alpha 1Not currently used.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-SA-INVOICED
SA_INVOICED		Alpha 1Not currently used.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-MATCH-DTL-KEY
MATCH_DTL_KEY		Alpha 85——
#ICT-NDC-NBR
NDC_NBR		Alpha 15National Drug Code.—
#ICT-GRANT-NBR
GRANT_NBR		Alpha 12——
#ICT-TRANS-SEQ
TRANS_SEQ		Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ENTERED-ITEM
ENTERED_ITEM		Alpha 25—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ENTRY-FL
ENTRY_FL		Alpha 1—
  • 1 Item
  • 2 UPC
  • 3 UPN1
  • 4 UPN2
  • 5 NDC
  • 6 SKU
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-MANUF-ID SET8
MANUF_ID		Numeric 4A unique idenitifier for a manufacturerAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-MANUF-NBR SET8
MANUF_NBR		Alpha 35This is the identifier that the manufacturer has assigned to an item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-ST-FACILITY SET8
ST_FACILITY		Alpha 15A unique identifier for a ship to facility.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#ICT-EAM-OPER-NBR
EAM_OPER_NBR		Numeric 4—IC21.2, ICIZ.1, WH130, WH132, WH190, WH30.1, WH30.2, WH30.3 +26 more
#ICT-EAM-SEQ-NBR
EAM_SEQ_NBR		Numeric 4—IC21.2, ICIZ.1, WH130, WH132, WH190, WH30.1, WH30.2, WH30.3 +26 more
#ICT-EAM-WO-NBR
EAM_WO_NBR		Numeric 8—IC21.2, ICIZ.1, WH130, WH132, WH190, WH30.1, WH30.2, WH30.3 +26 more
#ICT-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)
#ICT-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)
#ICT-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)
#ICT-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)
#ICT-GLBL-LINE-TYPE
GLBL_LINE_TYPE		Alpha 15—IC141, IC22.1, IC22.2
#ICT-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10—IC141, IC22.1, IC22.2
#ICT-TEMP-HOLD
TEMP_HOLD		Alpha 1—
  • A Approved by Engine
  • S Sent for Approval
IC22.1, IC22.2, IC23.1, IC23.2, IC25.1, IC500

Indexes (8)

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
ICTSET1
  1. COMPANY
  2. LOCATION
  3. DOC-TYPE
  4. SYSTEM-CD
  5. DOCUMENT
  6. SHIPMENT-NBR
  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)
ICTSET2
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. UPDATE-DATE ↓
  5. UPDATE-TIME ↓
  6. TRAN-COUNTER ↓
KeyChange, SubsetWhere STATUS != ZeroesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ICTSET3
  1. COMPANY
  2. REASON-CODE
  3. LOCATION
  4. ITEM
  5. UPDATE-DATE
  6. UPDATE-TIME
  7. TRAN-COUNTER
KeyChange, SubsetWhere STATUS != ZeroesIC17.1, IC229, IC247, MA66.2, MA70.1, MA75.1
ICTSET4
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. UPDATE-DATE ↓
  5. UPDATE-TIME ↓
  6. TRAN-COUNTER ↓
KeyChange, SubsetWhere (STATUS = 1 Or STATUS = 5)IC130, IC190, IC199
ICTSET5
  1. COMPANY
  2. LOCATION
  3. DOC-TYPE
  4. SYSTEM-CD
  5. DOCUMENT
  6. ITEM
  7. BIN
  8. TRAN-UOM
  9. LINE-NBR
KeyChange, SubsetWhere STATUS = ZeroesIC11.1, IC20.1, IC20.2, IC21.1, IC21.2, IC21.5, IC216, IC22.1 +11 more
ICTSET7
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. TRANS-DATE ↓
  5. ACTUAL-TIME ↓
  6. TRAN-COUNTER ↓
KeyChange, SubsetWhere STATUS != ZeroesIC220, IC231, IC234, IC247, IC37.1, IC50.1, IC55.1, IC55.2
ICTSET8
  1. MANUF-ID
  2. COMPANY
  3. LOCATION
  4. TRANS-DATE
  5. ST-FACILITY
  6. MANUF-NBR
  7. DOC-TYPE
  8. SYSTEM-CD
  9. DOCUMENT
  10. SHIPMENT-NBR
  11. LINE-NBR
  12. COMPONENT-SEQ
SubsetWhere MANUF-ID != ZeroesIC153
ICTSET9
  1. FROM-TO-CMPY
  2. FROM-TO-LOC
  3. COMPANY
  4. LOCATION
  5. DOC-TYPE
  6. SYSTEM-CD
  7. DOCUMENT
  8. SHIPMENT-NBR
  9. LINE-NBR
  10. COMPONENT-SEQ
  11. STATUS
  12. TRANS-DATE
KeyChangeIC282

Relations

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

One to one (21) — lookups and parents

RelationTableRulesConditionField map
CompanyICCOMPANYRequired
ICT-COMPANY→ICC-COMPANY
GlnamesaddGLNAMESNot Required
ICT-COMPANY→GLN-COMPANY
ICT-ADD-ACCT-UNIT→GLN-ACCT-UNIT
GlnamesinvGLNAMESNot Required
ICT-COMPANY→GLN-COMPANY
ICT-INV-ACCT-UNIT→GLN-ACCT-UNIT
GlnamesoffGLNAMESNot Required
ICT-COMPANY→GLN-COMPANY
ICT-OFF-ACCT-UNIT→GLN-ACCT-UNIT
GlnamesvarGLNAMESNot Required
ICT-COMPANY→GLN-COMPANY
ICT-VAR-ACCT-UNIT→GLN-ACCT-UNIT
Hazard CodeHAZARDNot Required
ITE-ITEM-GROUP→HAZ-ITEM-GROUP
ITE-HAZARD-CODE→HAZ-HAZARD-CODE
IcictufICICTUFNot Required, Delete Cascades
ICT-COMPANY→UFT-COMPANY
ICT-LOCATION→UFT-LOCATION
ICT-DOC-TYPE→UFT-DOC-TYPE
ICT-SYSTEM-CD→UFT-SYSTEM-CD
ICT-DOCUMENT→UFT-DOCUMENT
ICT-SHIPMENT-NBR→UFT-SHIPMENT-NBR
ICT-LINE-NBR→UFT-LINE-NBR
ICT-COMPONENT-SEQ→UFT-COMPONENT-SEQ
IclocationICLOCATIONRequired
ICT-COMPANY→ICL-COMPANY
ICT-LOCATION→ICL-LOCATION
IctbodICTBODNot Required, Delete Cascades
ICT-COMPANY→IBC-COMPANY
ICT-LOCATION→IBC-LOCATION
ICT-DOC-TYPE→IBC-DOC-TYPE
ICT-SYSTEM-CD→IBC-SYSTEM-CD
ICT-DOCUMENT→IBC-DOCUMENT
ICT-SHIPMENT-NBR→IBC-SHIPMENT-NBR
ICT-LINE-NBR→IBC-LINE-NBR
ICT-COMPONENT-SEQ→IBC-COMPONENT-SEQ
InspectionPORECADJLNRequiredWhen ICT-DOC-TYPE = "RJ" Or ICT-DOC-TYPE = "AC"
ICT-COMPANY→PJL-COMPANY
ICT-DOCUMENT→PJL-DOCUMENT-A
ICT-LINE-NBR→PJL-LINE-NBR
ItemlocITEMLOCRequired
ICT-COMPANY→ITL-COMPANY
ICT-LOCATION→ITL-LOCATION
ICT-ITEM→ITL-ITEM
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
ICT-ITEM→ITE-ITEM
MmuavalMMUAVALNot Required
ICT-COMPANY→MUA-COMPANY
ICT-SYSTEM-CD→MUA-SYSTEM-CD
ICT-LOCATION→MUA-LOCATION
ICT-DOC-TYPE→MUA-DOC-TYPE
ICT-DOCUMENT→MUA-DOC-NUMBER
ICT-SHIPMENT-NBR→MUA-DOC-NBR-NUM
Spaces→MUA-PO-CODE
ICT-LINE-NBR→MUA-LINE-NBR
Zeroes→MUA-API-OBJ-ID
Zeroes→MUA-SEQ-NBR
PorecadjlnPORECADJLNRequiredWhen ICT-DOC-TYPE = "RA"
ICT-COMPANY→PJL-COMPANY
ICT-DOCUMENT→PJL-DOCUMENT-A
ICT-LINE-NBR→PJL-LINE-NBR
PoreclinePORECLINERequiredWhen ICT-DOC-TYPE = "PO"
ICT-COMPANY→PRL-COMPANY
ICT-DOCUMENT→PRL-REC-NUMBER-A
ICT-LINE-NBR→PRL-LINE-NBR
PoreturnlnPORETURNLNRequiredWhen ICT-DOC-TYPE = "VR" Or ICT-DOC-TYPE = "VA"
ICT-COMPANY→PTL-COMPANY
ICT-DOCUMENT→PTL-RETURN-NUMBERA
ICT-LINE-NBR→PTL-RET-LINE-NBR
ReasonREASONNot Required
ICT-COMPANY→REA-COMPANY
ICT-REASON-CODE→REA-REASON-CODE
ReasoncodeREASONRequiredWhen ICT-REASON-CODE != Spaces
ICT-COMPANY→REA-COMPANY
ICT-REASON-CODE→REA-REASON-CODE
ReqlineREQLINERequiredWhen ICT-SYSTEM-CD = "RQ"
ICT-COMPANY→RLN-COMPANY
ICT-DOCUMENT→RLN-REQ-NUMBER-A
ICT-LINE-NBR→RLN-LINE-NBR
Reqline2REQLINERequiredWhen ICT-SYSTEM-CD = "RQ"
ICT-FROM-TO-CMPY→RLN-COMPANY
ICT-DOCUMENT→RLN-REQ-NUMBER-A
ICT-LINE-NBR→RLN-LINE-NBR
WhshiplineWHSHIPLINENot Required
ICT-COMPANY→WHL-COMPANY
ICT-SYSTEM-CD→WHL-SYSTEM-CD
ICT-DOCUMENT→WHL-DOC-NBR
ICT-LINE-NBR→WHL-LINE-NBR
ICT-SHIPMENT-NBR→WHL-SHIPMENT-NBR

One to many (4) — child tables

RelationTableRulesConditionField map
IctransdtlICTRANSDTL
ICT-COMPANY→ICD-COMPANY
ICT-LOCATION→ICD-LOCATION
ICT-DOC-TYPE→ICD-DOC-TYPE
ICT-SYSTEM-CD→ICD-SYSTEM-CD
ICT-DOCUMENT→ICD-DOCUMENT
ICT-SHIPMENT-NBR→ICD-SHIPMENT-NBR
ICT-LINE-NBR→ICD-LINE-NBR
ICT-COMPONENT-SEQ→ICD-COMPONENT-SEQ
—→ICD-TRANS-SEQ
ItcommentITCOMMENT
ITE-ITEM-GROUP→ICO-ITEM-GROUP
ITE-ITEM→ICO-ITEM
—→ICO-LANGUAGE-CODE
—→ICO-SEQ
MmdistMMDISTDelete Cascades
ICT-COMPANY→MMD-COMPANY
ICT-SYSTEM-CD→MMD-SYSTEM-CD
ICT-LOCATION→MMD-LOCATION
ICT-DOC-TYPE→MMD-DOC-TYPE
ICT-DOCUMENT→MMD-DOC-NUMBER
ICT-SHIPMENT-NBR→MMD-DOC-NBR-NUM
Spaces→MMD-PO-CODE
ICT-LINE-NBR→MMD-LINE-NBR
—→MMD-COMPONENT-SEQ
—→MMD-AOC-CODE
—→MMD-LINE-SEQ
—→MMD-REQ-LOCATION
—→MMD-API-OBJ-ID
SerialITSERIAL
ICT-COMPANY→SER-COMPANY
ICT-ITEM→SER-ITEM
—→SER-SERIAL

Programs

Updated by (256)

Referenced by (65)