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 IC240 IC242
IC48.1 IC52.1 IC53.1 IC851 IC964 IC12.1
IC220 IC234 IC280 IC50.1 IC50.2 IC50.3
IC17.1 IC229 IC190 IC199
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 BL92.1 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
IC90.1 IC963 MA530 MA540 OE114 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE830 OE950 PO31.1 RQ35.1 WH130
WH132 WH190 WH30.1 WH30.2 WH30.3 WH31.1
WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 WH966 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICT-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP225 AP226
established company and is entered on AP25.1 AP25.2
all function codes. AP26.1 BL92.1
DR100 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
IC500 IC850
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
...
ICT-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stock AP225 AP226
location within the company inventory. AP25.1 AP25.2
AP26.1 BL92.1
DR100 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
IC500 IC850
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
...
ICT-DOC-TYPE Alpha 2 AP125 AP126
Document Type This field contains the type of AP225 AP226
transaction. AP25.1 AP25.2
AJ = Adjustment AP26.1 BL92.1
BT = Bin Transfer DR100 IC138
CA = Cost Adjustment IC141 IC175
IR = Intransit (Temporary) IC20.1 IC20.2
IS = Issue IC21.1 IC21.2
IT = Issue Transfer IC22.1 IC22.2
PI = Physical Inventory Adjustment IC23.1 IC23.2
RC = Receipt IC23.3 IC23.4
RT = Receiving Transfer IC23.5 IC24.1
CR = Credit Return IC24.2 IC25.1
RR = Requisition Return IC26.1 IC26.2
SH = Shipment IC28.1 IC29.1
DT = Direct Transfer IC29.2 IC29.3
VR = Vendor Return IC500 IC850
VA = Vendor Return Adjustment IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
...
ICT-SYSTEM-CD Alpha 2 AP125 AP126
System Code This field indicates on what system AP225 AP226
the transaction originated. AP25.1 AP25.2
IC = Inventory Control AP26.1 BL92.1
OE = Order Entry DR100 IC138
RQ = Requisition IC141 IC175
CX = Case Cart IC20.1 IC20.2
PO = Purchase Order IC21.1 IC21.2
WO = Work Order 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 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
...
ICT-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Document ID This field identifies the document from AP225 AP226
which this transaction record was AP25.1 AP25.2
created. AP26.1 BL92.1
DR100 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
IC500 IC850
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
...
ICT-SHIPMENT-NBR Numeric 10 BL92.1 IC175
Shipment Number This field contains the shipment IC20.1 IC20.2
number. One order can have several IC21.2 IC22.1
shipment numbers if the items of the IC22.2 IC23.1
order were not shipped at the same time. IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC29.1 IC29.2
IC29.3 IC90.1
IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
...
ICT-DOCUMENT-SEQ Numeric 3 IC963
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 AP125 AP126
Line Number This field displays the system-assigned AP225 AP226
transaction number. AP25.1 AP25.2
AP26.1 BL92.1
DR100 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 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
...
ICT-COMPONENT-SEQ Numeric 3 BL92.1 IC175
Component Sequence This field contains the component IC20.1 IC20.2
Number sequence number. IC21.2 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 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
...
ICT-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Update Date This field contains the date the record AP225 AP226
was updated. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
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
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
...
ICT-UPDATE-TIME Numeric 6 AP125 AP126
Update Time This field contains the system time AP225 AP226
when the record was updated. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
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
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
...
ICT-TRAN-COUNTER Numeric 6 AP125 AP126
Tran Counter This field contains a transaction AP225 AP226
object number used to determine the AP25.1 AP25.2
sequence of updating of the Item AP26.1 BL92.1
Location file. 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 IC28.1
IC500 IC850
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
...
ICT-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Transaction Date The date of the transaction. AP225 AP226
AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
...
ICT-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item identifier. AP225 AP226
AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
...
ICT-SOH-QTY Signed 13.4 AP125 AP126
Stock On Hand This field contains the stock-on-hand AP225 AP226
Quantity quantity before this transaction. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
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
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
...
ICT-QUANTITY Signed 13.4 AP125 AP126
Quantity This field contains the quantity of the AP225 AP226
transaction. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
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 IC500
IC850 IC90.1
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
...
ICT-ORIGINAL-QTY Signed 13.4 BL92.1 DR100
Original Quantity This field contains the original IC141 IC22.1
intransit quantity. It is used only for IC22.2 IC25.1
intransit transfers. IC500 IC850
IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
ICT-OPEN-QTY Signed 13.4 BL92.1 DR100
Open Quantity This field contains the open intransit IC138 IC141
quantity not yet received. IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500
IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-STOCK-UOM Alpha 4 AP125 AP126
Stocking Unit of This field contains the stock unit of AP225 AP226
Measure measure for the item. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
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
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
...
ICT-UNIT-COST Signed 13.5 AP125 AP126
Unit Cost This field contains the unit cost for AP225 AP226
this transaction. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-UNIT-COST-CURR Signed 13.5 AP125 AP126
Unit Cost Curr This field contains the unit cost for AP225 AP226
this transaction in transaction AP25.1 AP25.2
currency. AP26.1 BL92.1
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
ICT-CURR-ND Numeric 1 AP125 AP126
Currency Number of Represents the number of decimals AP225 AP226
Decimals defined for the currency of the object. AP25.1 AP25.2
AP26.1 BL92.1
0 IC963 MA530
2 MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
ICT-ADD-UNIT-COST Signed 13.5 BL92.1 DR100
Add On Unit Cost This field contains the add-on unit IC138 IC141
Amount cost or freight cost that is added to IC23.1 IC23.2
the incoming unit cost to determine a IC25.1 IC500
new unit cost for this intransit IC850 IC963
receiving. OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-BASE-COST Signed 13.5 AP125 AP126
Base Cost This field contains the base cost used AP225 AP226
for calculating the standard cost of an AP25.1 AP25.2
item, if the company uses the standard AP26.1 BL92.1
costing method. The base cost is then DR100 IC138
used for standard cost variance IC141 IC175
calculation. IC20.1 IC20.2
IC21.1 IC21.2
Also, this field is used for negative IC22.1 IC22.2
average costing (if the company uses IC23.1 IC23.2
average costing and this field is IC24.1 IC24.2
flagged for allowing negative IC25.1 IC28.1
stock-on-hand). This field captures the IC500 IC850
average cost of the item prior to the IC963 MA530
transaction. MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-CURRENT-COST Signed 13.5 AP125 AP126
Current Cost This field contains the cost used for AP225 AP226
capturing the current cost of the item AP25.1 AP25.2
when the transaction is released. This AP26.1 BL92.1
is the same overall cost used for DR100 IC138
valuation, and is calculated by the IC141 IC175
costing method of the company. 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 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
...
ICT-UNIT-PRICE Signed 13.5 BL92.1 DR100
Unit Price This field is not used by the Inventory IC138 IC141
Control system. IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-TRAN-UOM Alpha 4 BL92.1 DR100
Transaction Unit of This field contains the entered unit of IC138 IC141
Measure measure on this transaction. 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 IC500
IC850 IC90.1
IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
...
ICT-TRAN-UOM-MULT Signed 13.7 BL92.1 DR100
Transaction UOM This field contains the transaction IC138 IC141
Multiplier unit of measure multiplier. IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC500
IC850 IC90.1
IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
...
ICT-SECONDARY-QTY Signed 13.4 BL92.1 DR100
Secondary Quantity This field contains a secondary IC138 IC175
quantity that is tracked if the item is IC20.1 IC20.2
a catch weight item. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC500 IC850
IC90.1 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
...
ICT-SEC-UOM Alpha 4 BL92.1 DR100
Secondary Unit of This field contains the secondary IC138 IC175
Measure quantity unit of measure. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC500 IC850
IC90.1 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
...
ICT-SEC-UOM-MULT Signed 13.7 BL92.1 DR100
Secondary UOM This field contains the secondary IC175 IC20.2
Multiplier quantity unit of measure multiplier. It IC21.2 IC22.1
is used to convert the stock-on-hand IC22.2 IC23.2
quantity to the secondary quantity or IC24.1 IC500
visa versa. IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-GL-DATE Numeric 8 (yyyymmdd) AP125 AP126
General Ledger Date This field contains the date this AP225 AP226
transaction is to be posted to the AP25.1 AP25.2
General Ledger system. AP26.1 BL92.1
DR100 IC141
IC175 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 IC90.1
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-EST-DEL-DATE Numeric 8 (yyyymmdd) BL92.1 DR100
Estimated Delivery This field contains the estimated IC141 IC22.1
Date delivery date. This field is required on IC22.2 IC25.1
an intransit transfer transaction. IC500 IC850
IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
ICT-REFERENCE Alpha 10 (Lower Case) BL92.1 DR100
Reference This field contains the reference IC138 IC141
information. IC20.2 IC21.2
IC22.2 IC23.2
IC24.1 IC24.2
IC500 IC850
IC90.1 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-BIN Alpha 7 BL92.1 DR100
Bin This field contains a storage area for IC138 IC141
an item or any number of items. 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
IC500 IC850
IC90.1 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
...
ICT-REASON-CODE Alpha 4 AP125 AP126
Reason Code This field contains the reason code for AP225 AP226
the transaction. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
IC20.2 IC21.2
IC22.2 IC23.2
IC24.2 IC28.1
IC500 IC850
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
...
ICT-ACTIVITY Alpha 15 AP125 AP126
Activity Activities are the processes or AP225 AP226
procedures that produce work. Cost AP25.1 AP25.2
objects (products, services, customers, AP26.1 BL92.1
and so on) are the reasons for DR100 IC138
performing the activity. Activities and IC141 IC20.2
cost object activities are used IC21.2 IC24.2
synonymously in the Activity Management IC28.1 IC500
system. Direct costs are posted to IC850 IC963
activities, and indirect costs are MA530 MA540
allocated to activities based on OE114 OE30.1
activity drivers. OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
...
ICT-ACCT-CATEGORY Alpha 5 AP125 AP126
Account Category Account categories are groupings of AP225 AP226
costs, revenues, or a combination of AP25.1 AP25.2
both used for reporting and inquiries AP26.1 BL92.1
for activities in the Activity IC138 IC141
Management system. All transactions are IC20.2 IC21.2
posted to an account category within an IC24.2 IC28.1
activity. You can assign a specific IC500 IC850
General Ledger account or range of IC963 MA530
accounts (company, accounting unit, MA540 OE114
account, and subaccount) that make up OE30.1 OE30.2
the transactions posted to an account OE30.3 OE30.4
category using AC07.1 (Account OE30.5 OE30.6
Assignment). OE30.7 OE30.9
OE830 OE950
Period-to-date, year-to-date, and PO31.1 RQ35.1
life-to-date balances are maintained by WH130 WH132
account category for activities. Account WH190 WH30.1
categories must be assigned to WH30.2 WH30.3
activities before you do any budgeting WH31.1 WH31.2
or transaction processing. WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
...
ICT-LINE-COMMENT Alpha 30 (Lower Case) AP125 AP126
Line Comments This field contains the user-defined AP225 AP226
comments for the transaction line. These AP25.1 AP25.2
comments are for reference purposes AP26.1 BL92.1
only. DR100 IC138
IC141 IC20.2
IC21.2 IC22.2
IC23.2 IC24.2
IC28.1 IC500
IC850 IC90.1
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 AP125 AP126
Inventory Account This field contains the general ledger AP225 AP226
Unit inventory account unit. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-INV-ACCOUNT Numeric 6 AP125 AP126
Inventory Account This field contains the general ledger AP225 AP226
Nbr inventory account number. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-INV-SUB-ACCT Numeric 4 AP125 AP126
Inventory Subaccount This field contains the general ledger AP225 AP226
inventory subaccount number. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-OFF-ACCT-UNIT Alpha 15 AP125 AP126
Offset Accounting This field contains the general ledger AP225 AP226
Unit offset account unit. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-OFF-ACCOUNT Numeric 6 AP125 AP126
Offset Account This field contains the general ledger AP225 AP226
offset account number. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-OFF-SUB-ACCT Numeric 4 AP125 AP126
Offset Subaccount This field contains the general ledger AP225 AP226
offset subaccount number. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-VAR-ACCT-UNIT Alpha 15 AP125 AP126
Cost Variance This field contains the general ledger AP225 AP226
Accounting Unit cost variance account unit. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-VAR-ACCOUNT Numeric 6 AP125 AP126
Cost Variance This field contains the general ledger AP225 AP226
Account Number cost variance account number. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-VAR-SUB-ACCT Numeric 4 AP125 AP126
Cost Variance This field contains the general ledger AP225 AP226
Subaccount cost variance subaccount number. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC138
IC141 IC175
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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
...
ICT-ADD-ACCT-UNIT Alpha 15 BL92.1 DR100
Add On Cost Account This field contains the general ledger IC138 IC141
Unit add-on cost account unit. IC23.2 IC500
IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-ADD-ACCOUNT Numeric 6 BL92.1 DR100
Add On Cost Account This field contains the general ledger IC138 IC141
add-on cost account number. IC23.2 IC500
IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-ADD-SUB-ACCT Numeric 4 BL92.1 DR100
Add On Subaccount This field contains the general ledger IC138 IC141
add-on cost subaccount number. IC23.2 IC500
IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-STATUS Numeric 1 AP125 AP126
Status This field contains the processing AP225 AP226
status of the transaction. AP25.1 AP25.2
0 = Unreleased AP26.1 BL92.1
1 = Released DR100 IC130
2 = General Ledger Updated IC138 IC141
5 = Intermediate Status(see IC130) IC175 IC20.1
3 = Non General Ledger 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
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
...
ICT-FR-DOCUMENT Alpha 10 (Right Justified) BL92.1 DR100
From Document This field contains the document number IC138 IC141
for the from-location for a transfer IC22.1 IC22.2
transaction. IC23.1 IC23.2
IC25.1 IC500
IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-FROM-TO-BIN Alpha 7 BL92.1 DR100
From or To Bin This field contains the from or to bin IC138 IC141
for a transfer transaction. IC22.1 IC22.2
IC25.1 IC26.1
IC26.2 IC500
IC850 IC90.1
IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
ICT-FROM-TO-LOC Alpha 5 BL92.1 DR100
From or To Location This field contains the from or to IC138 IC141
location for a transfer location. IC21.1 IC21.2
IC22.1 IC22.2
IC25.1 IC500
IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-DETAIL-BAL-FL Alpha 1 BL92.1 DR100
Detail Balance Flag This field is used to balance the bin, IC138 IC141
lot, and serial number detail lines with IC20.1 IC20.2
the transaction lines before releasing IC21.1 IC21.2
the document. IC22.1 IC22.2
N = No IC23.1 IC23.2
Y = Yes IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
ICT-SEQ Numeric 3 BL92.1 DR100
Sequence Number This field contains the sequence number IC138 IC141
assigned to the last bin, lot, or serial IC22.1 IC22.2
number detail line within a transaction IC23.1 IC23.2
line. IC23.3 IC23.4
IC25.1 IC26.1
IC26.2 IC29.1
IC29.2 IC29.3
IC500 IC850
IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
...
ICT-POTENCY Signed 7.3 BL92.1 DR100
Potency Factor This field is not used by the Inventory IC138 IC141
Control system. IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-ACTUAL-TIME Numeric 4 BL92.1 DR100
Actual Time This field contains the system time IC138 IC141
when a transaction took place. This is IC20.1 IC20.2
in 24-hour format (HHMM). IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
IC90.1 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
...
ICT-FROM-TO-CMPY Numeric 4 AP125 AP126
From or To Company This field contains the from or to AP225 AP226
company for an intercompany transaction. AP25.1 AP25.2
AP26.1 BL92.1
DR100 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
ICT-TO-CO-B-UCOST Signed 13.5 BL92.1 IC20.1
To Company Base This field contains the base unit cost IC20.2 IC21.1
Unit Cost for the To company. This field is IC21.2 IC22.1
converted from the 'From' company unit IC22.2 IC24.1
cost. It can be in a different currency IC24.2 IC25.1
if the two companies have different base IC500 IC850
currencies. IC963 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
ICT-FROM-CURR-CD Alpha 5 AP125 AP126
From Currency Code This field contains the currency code AP225 AP226
of the company that initiated the AP25.1 AP25.2
transaction. AP26.1 BL92.1
IC141 IC20.1
IC21.1 IC21.2
IC22.1 IC22.2
IC500 IC850
IC963 MA530
MA540 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
...
ICT-TO-CURR-CD Alpha 5 BL92.1 IC141
To Currency Code This field contains the currency code IC20.1 IC21.1
of the company to which the inventory is IC21.2 IC22.1
being transferred. IC22.2 IC500
IC850 IC963
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-HIST-PERIOD Numeric 2 BL92.1 IC130
Historical Period This field and the history period to IC850 IC963
which the transaction was posted ties a OE114 OE30.1
transaction to the period and year to OE30.2 OE30.3
which it was posted in the history file. OE30.4 OE30.5
This field is updated based on the OE30.6 OE30.7
transaction date when General Ledger OE30.9 OE830
Interface (IC130) is run. OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-HIST-YEAR Numeric 4 BL92.1 IC130
Historical Year This field and the HIST YEAR field tie IC850 IC963
a transaction to the period and year it OE114 OE30.1
was posted to on the history file. This OE30.2 OE30.3
field is updated based on the OE30.4 OE30.5
transaction date when General Ledger OE30.6 OE30.7
Interface (IC130) is run. OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-OPERATOR-ID Alpha 10 AP125 AP126
Operator This field contains the terminal sign AP225 AP226
Identification Code on identifier when this transaction was AP25.1 AP25.2
created. AP26.1 BL92.1
DR100 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 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 IC963
MA530 MA540
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
...
ICT-TO-UOM Alpha 4 BL92.1 IC22.1
To Unit of Measure This field contains the unit of measure IC22.2 IC25.1
resulting from a bin-to-bin transfer IC26.1 IC500
from one unit of measure to another. IC850 IC963
OE114 OE30.1
This is also used by IC22.1 (Transfers) OE30.2 OE30.3
to store the unit of measure of a OE30.4 OE30.5
quantity being transferred. It is only OE30.6 OE30.7
used for intransit transfers. OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-KIT-FL Alpha 1 BL92.1 IC963
Kit Flag This field is used to indicate that OE114 OE30.1
this transaction is for kit item. OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-BL-INVOICED Alpha 1 BL92.1 IC963
Bl Invoiced Not currently used. OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-SA-INVOICED Alpha 1 BL92.1 IC963
Sa Invoiced Not currently used. OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICT-INTRASTAT-NBR Numeric 10 IC22.1 IC22.2
Intrastat Nbr The number assigned by the Intrastat IC963
system to a transaction that involves
Intrastat reporting after it has been
added.
ICTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICTSET1 COMPANY AP125 AP126
LOCATION AP225 AP226
DOC-TYPE AP25.1 AP25.2
SYSTEM-CD AP26.1 DR100
DOCUMENT IC01.2 IC110
SHIPMENT-NBR IC138 IC141
LINE-NBR IC175 IC20.1
COMPONENT-SEQ IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC221
IC222 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC240 IC242
...
ICTSET2 COMPANY KeyChange, Subset IC12.1 IC220
LOCATION Where STATUS != Zeroes IC234 IC280
ITEM IC300 IC50.1
UPDATE-DATE* IC50.2 IC851
UPDATE-TIME* RQ35.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.3
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
Addonacct GLMASTER Required
When ICT-ADD-ACCT-UNIT != Spaces
And ICT-ADD-ACCOUNT != Zeroes
And ICT-ADD-SUB-ACCT != Zeroes
ICT-COMPANY -> GLM-COMPANY
ICT-ADD-ACCT-UNIT -> GLM-ACCT-UNIT
ICT-ADD-ACCOUNT -> GLM-ACCOUNT
ICT-ADD-SUB-ACCT -> GLM-SUB-ACCOUNT
Company ICCOMPANY Required
ICT-COMPANY -> ICC-COMPANY
Creditaccount GLMASTER Required
When ICT-OFF-ACCT-UNIT != Spaces
And ICT-OFF-ACCOUNT != Zeroes
And ICT-OFF-SUB-ACCT != Zeroes
ICT-COMPANY -> GLM-COMPANY
ICT-OFF-ACCT-UNIT -> GLM-ACCT-UNIT
ICT-OFF-ACCOUNT -> GLM-ACCOUNT
ICT-OFF-SUB-ACCT -> GLM-SUB-ACCOUNT
Debitaccount GLMASTER Required
When ICT-INV-ACCT-UNIT != Spaces
And ICT-INV-ACCOUNT != Zeroes
And ICT-INV-SUB-ACCT != Zeroes
ICT-COMPANY -> GLM-COMPANY
ICT-INV-ACCT-UNIT -> GLM-ACCT-UNIT
ICT-INV-ACCOUNT -> GLM-ACCOUNT
ICT-INV-SUB-ACCT -> GLM-SUB-ACCOUNT
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
Inventoryacct GLMASTER Required
When ICT-INV-ACCT-UNIT != Spaces
And ICT-INV-ACCOUNT != Zeroes
And ICT-INV-SUB-ACCT != Zeroes
ICT-COMPANY -> GLM-COMPANY
ICT-INV-ACCT-UNIT -> GLM-ACCT-UNIT
ICT-INV-ACCOUNT -> GLM-ACCOUNT
ICT-INV-SUB-ACCT -> GLM-SUB-ACCOUNT
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 Not Required
ICT-COMPANY -> MUA-COMPANY
"IC" -> MUA-SYSTEM-CD
ICT-LOCATION -> MUA-LOCATION
ICT-DOC-TYPE -> MUA-DOC-TYPE
ICT-DOCUMENT -> MUA-DOC-NBR
ICT-SHIPMENT-NBR -> MUA-DOC-NBR-NUM
ICT-LINE-NBR -> MUA-LINE-NBR
Offsetacct GLMASTER Required
When ICT-OFF-ACCT-UNIT != Spaces
And ICT-OFF-ACCOUNT != Zeroes
And ICT-OFF-SUB-ACCT != Zeroes
ICT-COMPANY -> GLM-COMPANY
ICT-OFF-ACCT-UNIT -> GLM-ACCT-UNIT
ICT-OFF-ACCOUNT -> GLM-ACCOUNT
ICT-OFF-SUB-ACCT -> GLM-SUB-ACCOUNT
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
Varianceacct GLMASTER Required
When ICT-VAR-ACCT-UNIT != Spaces
And ICT-VAR-ACCOUNT != Zeroes
And ICT-VAR-SUB-ACCT != Zeroes
ICT-COMPANY -> GLM-COMPANY
ICT-VAR-ACCT-UNIT -> GLM-ACCT-UNIT
ICT-VAR-ACCOUNT -> GLM-ACCOUNT
ICT-VAR-SUB-ACCT -> GLM-SUB-ACCOUNT
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
Accounts MMDIST
ICT-COMPANY -> MMD-COMPANY
ICT-SYSTEM-CD -> MMD-SYSTEM-CD
ICT-LOCATION -> MMD-LOCATION
ICT-DOC-TYPE -> MMD-DOC-TYPE
ICT-DOCUMENT -> MMD-DOC-NBR
ICT-SHIPMENT-NBR -> MMD-DOC-NBR-NUM
ICT-LINE-NBR -> MMD-LINE-NBR
ICT-COMPONENT-SEQ -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
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-SEQ
Itcomment ITCOMMENT
ITE-ITEM-GROUP -> ICO-ITEM-GROUP
ITE-ITEM -> ICO-ITEM
Spaces -> ICO-LANGUAGE-CODE
ICO-SEQ
Poproclev POPROCLEV
ICT-COMPANY -> POP-COMPANY
POP-PROCESS-LEVEL
Serial ITSERIAL
ICT-COMPANY -> SER-COMPANY
ICT-ITEM -> SER-ITEM
SER-SERIAL
|