 |
Lawson Insight Technical Documentation |
|
ICTRANS FILE
Inventory Transaction
The Inventory Transaction file contains all the inventory transactions
entered in the Inventory Control system. Each transaction type is given a
unique document type.
REFERENCED BY
IC01.2 IC110 IC221 IC222 IC234 IC242
IC48.1 IC52.1 IC53.1 IC851 IC12.1 IC220
IC240 IC280 IC50.1 IC50.2 IC17.1 IC229
IC190 IC199
UPDATED BY
DR100 IC130 IC138 IC141 IC175 IC20.1
IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC23.1
IC23.2 IC23.3 IC23.4 IC23.5 IC24.1 IC24.2
IC25.1 IC26.1 IC26.2 IC28.1 IC29.1 IC29.2
IC29.3 IC300 IC500 IC850 IC885 IC90.1
POIJ.1 WH130 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICT-COMPANY Numeric 4 DR100 IC138
Company The company number represents an IC141 IC175
established company and is entered on IC20.1 IC20.2
all function codes. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-LOCATION Alpha 5 DR100 IC138
Location Code This field contains a valid stocking IC141 IC175
location within the company inventory. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-DOC-TYPE Alpha 2 DR100 IC138
Document Type This field contains the type of IC141 IC175
transaction. IC20.1 IC20.2
AJ = Adjustment IC21.1 IC21.2
BT = Bin Transfer IC22.1 IC22.2
CA = Cost Adjustment IC23.1 IC23.2
CR = Customer Return IC23.3 IC23.4
DT = Direct Transfer IC23.5 IC24.1
IR = Intransit Receiving IC24.2 IC25.1
IS = Issue IC26.1 IC26.2
IT = Transfer Issue IC28.1 IC29.1
PI = Physical Inventory Adjustment IC29.2 IC29.3
RC = Receipt IC500 IC850
RR = Requisition Return IC90.1 POIJ.1
RT = Receiving Transfer WH130 WH33.1
SH = Shipment WH33.2 WH33.3
VA = Vendor Return Adjustment WH33.4 WH33.5
VR = Vendor Return WH33.6 WH33.8
PO = PO Receiving WH33.9 WH34.1
RA = PO Receiving Adjustment WH34.2 WH34.3
RJ = Rejected Inspection Item WH34.4
AC = Accepted Inspection Item
ICT-SYSTEM-CD Alpha 2 DR100 IC138
System Code This field indicates on what system the IC141 IC175
transaction originated. IC20.1 IC20.2
IC = Inventory Control IC21.1 IC21.2
OE = Order Entry IC22.1 IC22.2
RQ = Requisition IC23.1 IC23.2
CX = Case Cart IC23.3 IC23.4
PO = Purchase Order IC23.5 IC24.1
WO = Work Order IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-DOCUMENT Alpha 10 (Right Justified) DR100 IC138
Document ID This field identifies the document from IC141 IC175
which this transaction record was IC20.1 IC20.2
created. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-SHIPMENT-NBR Numeric 10 IC175 IC20.1
Shipment Number This field contains the shipment IC20.2 IC21.2
number. One order can have several IC22.1 IC22.2
shipment numbers if the items of the IC23.1 IC23.2
order were not shipped at the same time. IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC29.1
IC29.2 IC29.3
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-DOCUMENT-SEQ Numeric 3
Document Seq This 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 Numeric 6 DR100 IC138
Line Number This field displays the system-assigned IC141 IC175
transaction number. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-COMPONENT-SEQ Numeric 3 IC175 IC20.1
Component Sequence This field contains the component IC20.2 IC21.2
Number sequence number. IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC28.1
IC29.1 IC29.2
IC29.3 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-UPDATE-DATE Numeric 8 (yyyymmdd) DR100 IC138
Update Date This field contains the date the record IC141 IC175
was updated. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-UPDATE-TIME Numeric 6 DR100 IC138
Update Time This field contains the system time IC141 IC175
when the record was updated. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-TRAN-COUNTER Numeric 6 IC175 IC20.1
Tran Counter This field contains a transaction IC20.2 IC21.1
object number used to determine the IC21.2 IC22.1
sequence of updating of the Item IC22.2 IC23.1
Location file. IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC28.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-TRANS-DATE Numeric 8 (yyyymmdd) DR100 IC138
Transaction Date The date of the transaction. IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC851 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-ITEM Alpha 32 DR100 IC138
Item Number This field contains the item IC141 IC175
identifier. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-SOH-QTY Signed 13.4 DR100 IC138
Stock On Hand This field contains the stock-on-hand IC141 IC175
Quantity quantity before this transaction. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-QUANTITY Signed 13.4 DR100 IC138
Quantity This field contains the quantity of the IC141 IC175
transaction. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-ORIGINAL-QTY Signed 13.4 DR100 IC141
Original Quantity This field contains the original IC22.1 IC22.2
intransit quantity. It is used only for IC25.1 IC500
intransit transfers. IC850 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-OPEN-QTY Signed 13.4 DR100 IC138
Open Quantity This field contains the open intransit IC141 IC22.1
quantity not yet received. IC22.2 IC23.1
IC23.2 IC25.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-STOCK-UOM Alpha 4 DR100 IC138
Stocking Unit of This field contains the stock unit of IC141 IC175
Measure measure for the item. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-UNIT-COST Signed 13.5 DR100 IC138
Unit Cost This field contains the unit cost for IC141 IC175
this transaction. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-UNIT-COST-CURR Signed 13.5 POIJ.1 WH130
Unit Cost Curr This field contains the unit cost for WH33.1 WH33.2
this transaction in transaction WH33.3 WH33.4
currency. WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-CURR-ND Numeric 1 POIJ.1 WH130
Currency Number of Represents the number of decimals WH33.1 WH33.2
Decimals defined for the currency of the object. WH33.3 WH33.4
0 WH33.5 WH33.6
2 WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-ADD-UNIT-COST Signed 13.5 DR100 IC138
Add On Unit Cost This field contains the add-on unit IC141 IC23.1
Amount cost or freight cost that is added to IC23.2 IC25.1
the incoming unit cost to determine a IC500 IC850
new unit cost for this intransit POIJ.1 WH130
receiving. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-BASE-COST Signed 13.5 DR100 IC138
Base Cost This field contains the base cost used IC141 IC175
for calculating the standard cost of an IC20.1 IC20.2
item, if the company uses the standard IC21.1 IC21.2
costing method. The base cost is then IC22.1 IC22.2
used for standard cost variance IC23.1 IC23.2
calculation. IC24.1 IC24.2
IC25.1 IC28.1
Also, this field is used for negative IC500 IC850
average costing (if the company uses POIJ.1 WH130
average costing and this field is WH33.1 WH33.2
flagged for allowing negative WH33.3 WH33.4
stock-on-hand). This field captures the WH33.5 WH33.6
average cost of the item prior to the WH33.8 WH33.9
transaction. WH34.1 WH34.2
WH34.3 WH34.4
ICT-CURRENT-COST Signed 13.5 DR100 IC138
Current Cost This field contains the cost used for IC141 IC175
capturing the current cost of the item IC20.1 IC20.2
when the transaction is released. This IC21.1 IC21.2
is the same overall cost used for IC22.1 IC22.2
valuation, and is calculated by the IC23.1 IC23.2
costing method of the company. IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-UNIT-PRICE Signed 13.5 DR100 IC138
Unit Price This field is not used by the Inventory IC141 IC850
Control system. POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-TRAN-UOM Alpha 4 DR100 IC138
Transaction Unit of This field contains the entered unit of IC141 IC175
Measure measure on this transaction. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-TRAN-UOM-MULT Signed 13.7 DR100 IC138
Transaction UOM This field contains the transaction IC141 IC175
Multiplier unit of measure multiplier. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-SECONDARY-QTY Signed 13.4 DR100 IC138
Secondary Quantity This field contains a secondary IC175 IC20.1
quantity that is tracked if the item is IC20.2 IC21.1
a catch weight item. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-SEC-UOM Alpha 4 DR100 IC138
Secondary Unit of This field contains the secondary IC175 IC20.1
Measure quantity unit of measure. IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-SEC-UOM-MULT Signed 13.7 DR100 IC175
Secondary UOM This field contains the secondary IC20.2 IC21.2
Multiplier quantity unit of measure multiplier. It IC22.1 IC22.2
is used to convert the stock-on-hand IC23.2 IC24.1
quantity to the secondary quantity or IC500 IC850
visa versa. POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-GL-DATE Numeric 8 (yyyymmdd) DR100 IC141
General Ledger Date This field contains the date this IC175 IC20.1
transaction is to be posted to the IC20.2 IC21.1
General Ledger system. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-EST-DEL-DATE Numeric 8 (yyyymmdd) DR100 IC141
Estimated Delivery This field contains the estimated IC22.1 IC22.2
Date delivery date. This field is required on IC25.1 IC500
an intransit transfer transaction. IC850 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-REFERENCE Alpha 10 (Lower Case) DR100 IC138
Reference This field contains the reference IC141 IC20.2
information. IC21.2 IC22.2
IC23.2 IC24.1
IC24.2 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-BIN Alpha 7 DR100 IC138
Bin This field contains a storage area for IC141 IC175
an item or any number of items. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-REASON-CODE Alpha 4 DR100 IC138
Reason Code This field contains the reason code for IC141 IC175
the transaction. IC20.2 IC21.2
IC22.2 IC23.2
IC24.2 IC28.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-ACTIVITY Alpha 15 DR100 IC138
Activity Activities are the processes or IC141 IC20.2
procedures that produce work. Cost IC21.2 IC24.2
objects (products, services, customers, IC28.1 IC500
and so on) are the reasons for IC850 POIJ.1
performing the activity. WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-ACCT-CATEGORY Alpha 5 IC138 IC141
Account Category Account categories are groupings of IC20.2 IC21.2
costs, revenues, or a combination of IC24.2 IC28.1
both used for reporting and inquiries IC500 IC850
for activities in the Activity POIJ.1 WH130
Management system. All transactions are WH33.1 WH33.2
posted to an account category within an WH33.3 WH33.4
activity. You can assign a specific WH33.5 WH33.6
General Ledger account or range of WH33.8 WH33.9
accounts (company, accounting unit, WH34.1 WH34.2
account, and subaccount) that make up WH34.3 WH34.4
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.
ICT-LINE-COMMENT Alpha 40 (Lower Case) DR100 IC138
Line Comments This field contains the user-defined IC141 IC20.2
comments for the transaction line. These IC21.2 IC22.2
comments are for reference purposes IC23.2 IC24.2
only. IC28.1 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-INV-ACCT-UNIT Alpha 15 DR100 IC138
Inventory Account This field contains the general ledger IC141 IC175
Unit inventory account unit. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-INV-ACCOUNT Numeric 6 DR100 IC138
Inventory Account This field contains the general ledger IC141 IC175
Nbr inventory account number. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-INV-SUB-ACCT Numeric 4 DR100 IC138
Inventory Subaccount This field contains the general ledger IC141 IC175
inventory subaccount number. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-OFF-ACCT-UNIT Alpha 15 DR100 IC138
Offset Account Unit This field contains the general ledger IC141 IC175
offset account unit. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-OFF-ACCOUNT Numeric 6 DR100 IC138
Offset Account This field contains the general ledger IC141 IC175
offset account number. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-OFF-SUB-ACCT Numeric 4 DR100 IC138
Offset Subaccount This field contains the general ledger IC141 IC175
offset subaccount number. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-VAR-ACCT-UNIT Alpha 15 DR100 IC138
Cost Variance This field contains the general ledger IC141 IC175
Accounting Unit cost variance account unit. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-VAR-ACCOUNT Numeric 6 DR100 IC138
Cost Variance This field contains the general ledger IC141 IC175
Account Number cost variance account number. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-VAR-SUB-ACCT Numeric 4 DR100 IC138
Cost Variance This field contains the general ledger IC141 IC175
Subaccount cost variance subaccount number. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-ADD-ACCT-UNIT Alpha 15 DR100 IC138
Add On Cost Account This field contains the general ledger IC141 IC23.2
Unit add-on cost account unit. IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-ADD-ACCOUNT Numeric 6 DR100 IC138
Add On Cost Account This field contains the general ledger IC141 IC23.2
add-on cost account number. IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-ADD-SUB-ACCT Numeric 4 DR100 IC138
Add On Subaccount This field contains the general ledger IC141 IC23.2
add-on cost subaccount number. IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-STATUS Numeric 1 DR100 IC130
Status This field contains the processing IC138 IC141
status of the transaction. IC175 IC20.1
0 = Unreleased IC20.2 IC21.1
1 = Released IC21.2 IC22.1
2 = General Ledger Updated IC22.2 IC23.1
5 = Intermediate Status(see IC130) IC23.2 IC24.1
3 = Non General Ledger IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-FR-DOCUMENT Alpha 10 (Right Justified) DR100 IC138
From Document This field contains the document number IC141 IC22.1
for the from-location for a transfer IC22.2 IC23.1
transaction. IC23.2 IC25.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-FROM-TO-BIN Alpha 7 DR100 IC138
From or To Bin This field contains the from or to bin IC141 IC22.1
for a transfer transaction. IC22.2 IC25.1
IC26.1 IC26.2
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-FROM-TO-LOC Alpha 5 DR100 IC138
From or To Location This field contains the from or to IC141 IC21.1
location for a transfer location. IC21.2 IC22.1
IC22.2 IC25.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-DETAIL-BAL-FL Alpha 1 DR100 IC138
Detail Balance Flag This field is used to balance the bin, IC141 IC20.1
lot, and serial number detail lines with IC20.2 IC21.1
the transaction lines before releasing IC21.2 IC22.1
the document. IC22.2 IC23.1
N = No IC23.2 IC23.3
Y = Yes IC23.4 IC23.5
IC24.1 IC24.2
IC25.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-SEQ Numeric 3 IC500 IC885
Sequence Number This field contains the sequence number
assigned to the last bin, lot, or serial
number detail line within a transaction
line.
ICT-LAST-DST-SEQ Numeric 3 IC130 POIJ.1
Last Distribution WH130 WH33.1
Sequence Nbr WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-ACTUAL-TIME Numeric 4 DR100 IC138
Actual Time This field contains the system time IC141 IC20.1
when a transaction took place. This is IC20.2 IC21.1
in 24-hour format (HHMM). IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-FROM-TO-CMPY Numeric 4 DR100 IC175
From or To Company This field contains the from or to IC20.1 IC20.2
company for an intercompany transaction. IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-TO-CO-B-UCOST Signed 13.5 IC20.1 IC20.2
To Company Base This field contains the base unit cost IC21.1 IC21.2
Unit Cost for the To company. This field is IC22.1 IC22.2
converted from the 'From' company unit IC24.1 IC24.2
cost. It can be in a different currency IC25.1 IC500
if the two companies have different base IC850 POIJ.1
currencies. WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-FROM-CURR-CD Alpha 5 IC141 IC20.1
From Currency Code This field contains the currency code IC21.1 IC21.2
of the company that initiated the IC22.1 IC22.2
transaction. IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-TO-CURR-CD Alpha 5 IC141 IC20.1
To Currency Code This field contains the currency code IC21.1 IC21.2
of the company to which the inventory is IC22.1 IC22.2
being transferred. IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-HIST-PERIOD Numeric 2 IC130 IC850
Historical Period This field and the history period to POIJ.1 WH130
which the transaction was posted ties a WH33.1 WH33.2
transaction to the period and year to WH33.3 WH33.4
which it was posted in the history file. WH33.5 WH33.6
This field is updated based on the WH33.8 WH33.9
transaction date when General Ledger WH34.1 WH34.2
Interface (IC130) is run. WH34.3 WH34.4
ICT-HIST-YEAR Numeric 4 IC130 IC850
Historical Year This field and the HIST YEAR field tie POIJ.1 WH130
a transaction to the period and year it WH33.1 WH33.2
was posted to on the history file. This WH33.3 WH33.4
field is updated based on the WH33.5 WH33.6
transaction date when General Ledger WH33.8 WH33.9
Interface (IC130) is run. WH34.1 WH34.2
WH34.3 WH34.4
ICT-OPERATOR-ID Alpha 10 DR100 IC138
Operator This field contains the terminal sign IC141 IC175
Identification Code on identifier when this transaction was IC20.1 IC20.2
created. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICT-TO-UOM Alpha 4 IC22.1 IC22.2
To Unit of Measure This field contains the unit of measure IC25.1 IC26.1
resulting from a bin-to-bin transfer IC500 IC850
from one unit of measure to another. POIJ.1 WH130
WH33.1 WH33.2
This is also used by IC22.1 (Transfers) WH33.3 WH33.4
to store the unit of measure of a WH33.5 WH33.6
quantity being transferred. It is only WH33.8 WH33.9
used for intransit transfers. WH34.1 WH34.2
WH34.3 WH34.4
ICT-KIT-FL Alpha 1 POIJ.1 WH130
Kit Flag This field is used to indicate that WH33.1 WH33.2
this transaction is for kit item. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-BL-INVOICED Alpha 1 POIJ.1 WH130
Bl Invoiced Not currently used. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-SA-INVOICED Alpha 1 POIJ.1 WH130
Sa Invoiced Not currently used. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICT-MATCH-DTL-KEY Alpha 55
Match Dtl Key
ICT-NDC-NBR Alpha 15
National Drug Code National Drug Code.
ICT-GRANT-NBR Alpha 12
Grant Nbr
ICT-TRANS-SEQ Numeric 6 DR100 IC138
Trans Seq IC141 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC29.3 IC500
IC850 IC885
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICTSET1 COMPANY DR100 IC01.2
LOCATION IC110 IC138
DOC-TYPE IC141 IC175
SYSTEM-CD IC20.1 IC20.2
DOCUMENT IC21.1 IC21.2
SHIPMENT-NBR IC22.1 IC22.2
LINE-NBR IC221 IC222
COMPONENT-SEQ IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC234
IC24.1 IC24.2
IC242 IC25.1
IC28.1 IC29.1
IC29.2 IC29.3
IC48.1 IC500
...
ICTSET2 COMPANY KeyChange, Subset IC12.1 IC220
LOCATION Where STATUS != Zeroes IC234 IC240
ITEM IC280 IC300
UPDATE-DATE* IC50.1 IC50.2
UPDATE-TIME* IC851 POIJ.1
TRAN-COUNTER*
ICTSET3 COMPANY KeyChange, Subset IC17.1 IC229
REASON-CODE Where STATUS != Zeroes
LOCATION
ITEM
UPDATE-DATE
UPDATE-TIME
TRAN-COUNTER
ICTSET4 COMPANY KeyChange, Subset IC130 IC190
LOCATION Where (STATUS = 1 IC199
ITEM Or STATUS = 5 )
UPDATE-DATE*
UPDATE-TIME*
TRAN-COUNTER*
ICTSET5 COMPANY KeyChange, Subset IC20.1 IC20.2
LOCATION Where STATUS = Zeroes IC21.1 IC21.2
DOC-TYPE IC22.1 IC22.2
SYSTEM-CD IC23.1 IC23.2
DOCUMENT IC24.1 IC24.2
ITEM IC25.1 IC500
BIN
TRAN-UOM
LINE-NBR
ICTSET7 COMPANY KeyChange, Subset IC234 IC50.1
LOCATION Where STATUS != Zeroes
ITEM
TRANS-DATE*
ACTUAL-TIME*
TRAN-COUNTER*
ICTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
ICT-COMPANY -> ICC-COMPANY
Hazard Code HAZARD Not Required
ITE-ITEM-GROUP -> HAZ-ITEM-GROUP
ITE-HAZARD-CODE -> HAZ-HAZARD-CODE
Iclocation ICLOCATION Required
ICT-COMPANY -> ICL-COMPANY
ICT-LOCATION -> ICL-LOCATION
Inspection PORECADJLN Required
ICT-COMPANY -> PJL-COMPANY
ICT-DOCUMENT -> PJL-DOCUMENT-A
ICT-LINE-NBR -> PJL-LINE-NBR
Itemloc ITEMLOC Required
ICT-COMPANY -> ITL-COMPANY
ICT-LOCATION -> ITL-LOCATION
ICT-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ICT-ITEM -> ITE-ITEM
Mmuaval MMUAVAL 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
Porecadjln PORECADJLN Required
ICT-COMPANY -> PJL-COMPANY
ICT-DOCUMENT -> PJL-DOCUMENT-A
ICT-LINE-NBR -> PJL-LINE-NBR
Porecline PORECLINE Required
When ICT-DOC-TYPE = "PO"
ICT-COMPANY -> PRL-COMPANY
ICT-DOCUMENT -> PRL-REC-NUMBER-A
ICT-LINE-NBR -> PRL-LINE-NBR
Poreturnln PORETURNLN Required
When 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
Reason REASON Not Required
ICT-COMPANY -> REA-COMPANY
ICT-REASON-CODE -> REA-REASON-CODE
Reasoncode REASON Required
When ICT-REASON-CODE != Spaces
ICT-COMPANY -> REA-COMPANY
ICT-REASON-CODE -> REA-REASON-CODE
Reqline REQLINE Required
When ICT-SYSTEM-CD = "RQ"
ICT-COMPANY -> RLN-COMPANY
ICT-DOCUMENT -> RLN-REQ-NUMBER-A
ICT-LINE-NBR -> RLN-LINE-NBR
Whshipline WHSHIPLINE Not 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
ICTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ictransdtl ICTRANSDTL
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
ICD-SEQ
Itcomment ITCOMMENT
ITE-ITEM-GROUP -> ICO-ITEM-GROUP
ITE-ITEM -> ICO-ITEM
ICO-LANGUAGE-CODE
ICO-SEQ
Mmdist MMDIST Delete 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
Serial ITSERIAL
ICT-COMPANY -> SER-COMPANY
ICT-ITEM -> SER-ITEM
SER-SERIAL
|