Lawson Insight Technical Documentation |
|
ICTRANS
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
IC244 IC282 IC287 IC37.1 IC48.1 IC52.1
IC53.1 IC851 POIF.1 MM280 MM80.1 MM80.2
WHD1.1 WHD2.1 IC12.1 IC220 IC240 IC280
IC50.1 IC50.2 IC55.1 IC55.2 IC17.1 IC229
IC190 IC199 IC153
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.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 IC781 IC850 IC90.1 MA180 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 PO100 PO101 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POI3.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ35.1 RQIE.1 WH130
WH132 WH190 WH20.2 WH20.7 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICT-COMPANY Numeric 4 AP125 AP126
Element: Company The company number represents an AP131 AP20.1
established company and is entered on AP20.2 AP20.3
all function codes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
...
ICT-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
...
ICT-DOC-TYPE Alpha 2 AP125 AP126
Element: Document Type This field contains the type of AP131 AP20.1
transaction. AP20.2 AP20.3
AJ = Adjustment AP20.4 AP20.5
BT = Bin Transfer AP20.7 AP23.1
CA = Cost Adjustment AP25.1 AP25.2
CR = Customer Return AP26.1 AP27.1
DT = Direct Transfer AP30.4 API1.1
IR = Intransit Receiving DR100 IC138
IS = Issue IC141 IC175
IT = Transfer Issue IC20.1 IC20.2
PI = Physical Inventory Adjustment IC21.1 IC21.2
RC = Receipt IC22.1 IC22.2
RR = Requisition Return IC23.1 IC23.2
RT = Receiving Transfer IC23.3 IC23.4
SH = Shipment IC23.5 IC24.1
VA = Vendor Return Adjustment IC24.2 IC25.1
VR = Vendor Return IC26.1 IC26.2
PO = PO Receiving IC28.1 IC29.1
RA = PO Receiving Adjustment IC29.2 IC29.3
RJ = Rejected Inspection Item IC500 IC850
AC = Accepted Inspection Item IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
...
ICT-SYSTEM-CD Alpha 2 AP125 AP126
Element: System Code This field indicates on what system the AP131 AP20.1
transaction originated. AP20.2 AP20.3
IC = Inventory Control AP20.4 AP20.5
OE = Order Entry AP20.7 AP23.1
RQ = Requisition AP25.1 AP25.2
CX = Case Cart AP26.1 AP27.1
PO = Purchase Order AP30.4 API1.1
WO = Work Order DR100 IC138
PH = Pharmacy 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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
...
ICT-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Element: Document ID This field identifies the document from AP131 AP20.1
which this transaction record was AP20.2 AP20.3
created. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
...
ICT-SHIPMENT-NBR Numeric 10 AP125 AP126
Element: Shipment NumbeThis field contains the shipment AP131 AP20.1
number. One order can have several AP20.2 AP20.3
shipment numbers if the items of the AP20.4 AP20.5
order were not shipped at the same time. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC20.1
IC20.2 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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-DOCUMENT-SEQ Numeric 3
Element: Sequence NumbeThis 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
Element: Line Number This field displays the system-assigned AP131 AP20.1
transaction number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
...
ICT-COMPONENT-SEQ Numeric 3 AP125 AP126
Element: Sequence Number AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC20.1
IC20.2 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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
...
ICT-UPDATE-TIME Numeric 6 AP125 AP126
Element: Update Time This field contains the system time AP131 AP20.1
when the record was updated. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
...
ICT-TRAN-COUNTER Numeric 6 AP125 AP126
Element: Item Count AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
...
ICT-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
...
ICT-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP20.1
identifier. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
...
ICT-SOH-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the stock-on-hand AP131 AP20.1
quantity before this transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
...
ICT-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of the AP131 AP20.1
transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
...
ICT-ORIGINAL-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the original AP131 AP20.1
intransit quantity. It is used only for AP20.2 AP20.3
intransit transfers. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC141
IC22.1 IC22.2
IC25.1 IC28.1
IC500 IC850
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
...
ICT-OPEN-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the open intransit AP131 AP20.1
quantity not yet received. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICT-STOCK-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the stock unit of AP131 AP20.1
measure for the item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
...
ICT-UNIT-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the unit cost for AP131 AP20.1
this transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
...
ICT-UNIT-COST-CURR Signed 13.5 AP125 AP126
Element: Base Cost This field contains the unit cost for AP131 AP20.1
this transaction in transaction AP20.2 AP20.3
currency. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
ICT-CURR-ND Numeric 1 AP125 AP126
Account Currency 0 AP131 AP20.1
Code 2 AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC21.1 IC21.2
IC22.1 IC22.2
IC25.1 IC28.1
IC500 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
...
ICT-ADD-UNIT-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the add-on unit AP131 AP20.1
cost or freight cost that is added to AP20.2 AP20.3
the incoming unit cost to determine a AP20.4 AP20.5
new unit cost for this intransit AP20.7 AP23.1
receiving. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
...
ICT-BASE-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the base cost used AP131 AP20.1
for calculating the standard cost of an AP20.2 AP20.3
item, if the company uses the standard AP20.4 AP20.5
costing method. The base cost is then AP20.7 AP23.1
used for standard cost variance AP25.1 AP25.2
calculation. AP26.1 AP27.1
AP30.4 API1.1
Also, this field is used for negative DR100 IC138
average costing (if the company uses IC141 IC175
average costing and this field is IC20.1 IC20.2
flagged for allowing negative IC21.1 IC21.2
stock-on-hand). This field captures the IC22.1 IC22.2
average cost of the item prior to the IC23.1 IC23.2
transaction. IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-CURRENT-COST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the cost used for AP131 AP20.1
capturing the current cost of the item AP20.2 AP20.3
when the transaction is released. This AP20.4 AP20.5
is the same overall cost used for AP20.7 AP23.1
valuation, and is calculated by the AP25.1 AP25.2
costing method of the company. AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
...
ICT-UNIT-PRICE Signed 13.5 AP125 AP126
Element: Base Price This field is not used by the Inventory AP131 AP20.1
Control system. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC28.1
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
...
ICT-TRAN-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the entered unit of AP131 AP20.1
measure on this transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC153
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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
...
ICT-TRAN-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure This field contains the transaction AP131 AP20.1
Multiplier unit of measure multiplier. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
IC28.1 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-SECONDARY-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains a secondary AP131 AP20.1
quantity that is tracked if the item is AP20.2 AP20.3
a catch weight item. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC28.1
IC500 IC850
IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
...
ICT-SEC-UOM Alpha 4 AP125 AP126
Element: Unit of Measure AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC28.1
IC500 IC850
IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
...
ICT-SEC-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure This field contains the secondary AP131 AP20.1
Multiplier quantity unit of measure multiplier. It AP20.2 AP20.3
is used to convert the stock-on-hand AP20.4 AP20.5
quantity to the secondary quantity or AP20.7 AP23.1
visa versa. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC175
IC20.2 IC21.2
IC22.1 IC22.2
IC23.2 IC24.1
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICT-GL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the date this AP131 AP20.1
transaction is to be posted to the AP20.2 AP20.3
General Ledger system. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-EST-DEL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the estimated AP131 AP20.1
delivery date. This field is required on AP20.2 AP20.3
an intransit transfer transaction. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC141
IC22.1 IC22.2
IC25.1 IC28.1
IC500 IC850
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
...
ICT-REFERENCE Alpha 10 (Lower Case) AP125 AP126
Element: Requester This field contains the reference AP131 AP20.1
information. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC20.2
IC21.2 IC22.2
IC23.2 IC24.1
IC24.2 IC28.1
IC500 IC850
IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
ICT-BIN Alpha 7 AP125 AP126
Element: Bin This field contains a storage area for AP131 AP20.1
an item or any number of items. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
...
ICT-REASON-CODE Alpha 4 AP125 AP126
Accounts Receivable This field contains the reason code for AP131 AP20.1
Code the transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC175
IC20.2 IC21.2
IC22.2 IC23.2
IC24.2 IC28.1
IC500 IC850
IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
ICT-ACTIVITY Alpha 15 AP125 AP126
Element: Activity Activities are the processes or AP131 AP20.1
procedures that produce work. Cost AP20.2 AP20.3
objects (products, services, customers, AP20.4 AP20.5
and so on) are the reasons for AP20.7 AP23.1
performing the activity. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC20.2
IC21.2 IC24.2
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
...
ICT-ACCT-CATEGORY Alpha 5 AP125 AP126
Element: Account CategoAccount categories are groupings of AP131 AP20.1
costs, revenues, or a combination of AP20.2 AP20.3
both used for reporting and inquiries AP20.4 AP20.5
for activities in the Activity AP20.7 AP23.1
Management system. All transactions are AP25.1 AP25.2
posted to an account category within an AP26.1 AP27.1
activity. You can assign a specific AP30.4 API1.1
General Ledger account or range of IC138 IC141
accounts (company, accounting unit, IC20.2 IC21.2
account, and subaccount) that make up IC24.2 IC28.1
the transactions posted to an account IC500 IC850
category using AC07.1 (Account MA180 MA41.2
Assignment). MA41.7 MA43.1
MA43.2 MA43.3
Period-to-date, year-to-date, and MA43.9 MA530
life-to-date balances are maintained by MA531 MA60.2
account category for activities. Account MA60.3 MA60.5
categories must be assigned to MA61.1 MA66.2
activities before you do any budgeting MA66.3 MA67.1
or transaction processing. MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
...
ICT-LINE-COMMENT Alpha 40 (Lower Case) AP125 AP126
Element: Line Comments This field contains the user-defined AP131 AP20.1
comments for the transaction line. These AP20.2 AP20.3
comments are for reference purposes AP20.4 AP20.5
only. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC20.2
IC21.2 IC22.2
IC23.2 IC24.2
IC28.1 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
...
ICT-INV-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThis field contains the general ledger AP131 AP20.1
inventory account unit. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-INV-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the general ledger AP131 AP20.1
inventory account number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-INV-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount This field contains the general ledger AP131 AP20.1
inventory subaccount number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-OFF-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThis field contains the general ledger AP131 AP20.1
offset account unit. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-OFF-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the general ledger AP131 AP20.1
offset account number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-OFF-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount This field contains the general ledger AP131 AP20.1
offset subaccount number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-VAR-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThis field contains the general ledger AP131 AP20.1
cost variance account unit. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-VAR-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the general ledger AP131 AP20.1
cost variance account number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-VAR-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount This field contains the general ledger AP131 AP20.1
cost variance subaccount number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-ADD-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThis field contains the general ledger AP131 AP20.1
add-on cost account unit. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC23.2
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
...
ICT-ADD-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the general ledger AP131 AP20.1
add-on cost account number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC23.2
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
...
ICT-ADD-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount This field contains the general ledger AP131 AP20.1
add-on cost subaccount number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC23.2
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
...
ICT-STATUS Numeric 1 AP125 AP126
Element: Status This field contains the processing AP131 AP20.1
status of the transaction. AP20.2 AP20.3
0 = Unreleased AP20.4 AP20.5
1 = Released AP20.7 AP23.1
2 = General Ledger Updated AP25.1 AP25.2
5 = Intermediate Status(see IC130) AP26.1 AP27.1
3 = Non General Ledger AP30.4 API1.1
DR100 IC130
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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
...
ICT-FR-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Element: Document ID This field contains the document number AP131 AP20.1
for the from-location for a transfer AP20.2 AP20.3
transaction. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICT-FROM-TO-BIN Alpha 7 AP125 AP126
Element: Bin This field contains the from or to bin AP131 AP20.1
for a transfer transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC22.1
IC22.2 IC25.1
IC26.1 IC26.2
IC28.1 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
...
ICT-FROM-TO-LOC Alpha 5 AP125 AP126
Element: Location Code This field contains the from or to AP131 AP20.1
location for a transfer location. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC21.1
IC21.2 IC22.1
IC22.2 IC25.1
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICT-DETAIL-BAL-FL Alpha 1 AP125 AP126
Element: All Flag This field is used to balance the bin, AP131 AP20.1
lot, and serial number detail lines with AP20.2 AP20.3
the transaction lines before releasing AP20.4 AP20.5
the document. AP20.7 AP23.1
N = No AP25.1 AP25.2
Y = Yes AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 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 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
...
ICT-LAST-DST-SEQ Numeric 3 AP125 AP126
Element: Sequence Number AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC130 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO29.1 PO30.1
PO30.2 PO30.3
...
ICT-ACTUAL-TIME Numeric 4 AP125 AP126
Element: Actual Time This field contains the system time AP131 AP20.1
when a transaction took place. This is AP20.2 AP20.3
in 24-hour format (HHMM). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 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
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-FROM-TO-CMPY Numeric 4 AP125 AP126
Element: Company This field contains the from or to AP131 AP20.1
company for an intercompany transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC141
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
...
ICT-TO-CO-B-UCOST Signed 13.5 AP125 AP126
Element: Base Cost This field contains the base unit cost AP131 AP20.1
for the To company. This field is AP20.2 AP20.3
converted from the 'From' company unit AP20.4 AP20.5
cost. It can be in a different currency AP20.7 AP23.1
if the two companies have different base AP25.1 AP25.2
currencies. AP26.1 AP27.1
AP30.4 API1.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
...
ICT-FROM-CURR-CD Alpha 5 AP125 AP126
Element: Currency Code This field contains the currency code AP131 AP20.1
of the company that initiated the AP20.2 AP20.3
transaction. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC141 IC20.1
IC21.1 IC21.2
IC22.1 IC22.2
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
...
ICT-TO-CURR-CD Alpha 5 AP125 AP126
Element: Currency Code This field contains the currency code AP131 AP20.1
of the company to which the inventory is AP20.2 AP20.3
being transferred. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC141 IC20.1
IC21.1 IC21.2
IC22.1 IC22.2
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
...
ICT-HIST-PERIOD Numeric 2 AP125 AP126
Element: Current PeriodThis field and the history period to AP131 AP20.1
which the transaction was posted ties a AP20.2 AP20.3
transaction to the period and year to AP20.4 AP20.5
which it was posted in the history file. AP20.7 AP23.1
This field is updated based on the AP25.1 AP25.2
transaction date when General Ledger AP26.1 AP27.1
Interface (IC130) is run. AP30.4 API1.1
IC130 IC28.1
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
ICT-HIST-YEAR Numeric 4 AP125 AP126
Element: Last Closed YeThis field and the HIST YEAR field tie AP131 AP20.1
a transaction to the period and year it AP20.2 AP20.3
was posted to on the history file. This AP20.4 AP20.5
field is updated based on the AP20.7 AP23.1
transaction date when General Ledger AP25.1 AP25.2
Interface (IC130) is run. AP26.1 AP27.1
AP30.4 API1.1
IC130 IC28.1
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
...
ICT-OPERATOR-ID Alpha 10 AP125 AP126
Element: Operator Code This field contains the terminal sign AP131 AP20.1
on identifier when this transaction was AP20.2 AP20.3
created. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
...
ICT-TO-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the unit of measure AP131 AP20.1
resulting from a bin-to-bin transfer AP20.2 AP20.3
from one unit of measure to another. AP20.4 AP20.5
AP20.7 AP23.1
This is also used by IC22.1 (Transfers) AP25.1 AP25.2
to store the unit of measure of a AP26.1 AP27.1
quantity being transferred. It is only AP30.4 API1.1
used for intransit transfers. IC22.1 IC22.2
IC25.1 IC26.1
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
...
ICT-KIT-FL Alpha 1 AP125 AP126
Element: Kit Flag This field is used to indicate that AP131 AP20.1
this transaction is for kit item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
ICT-BL-INVOICED Alpha 1 AP125 AP126
Element: Ac Usage AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
ICT-SA-INVOICED Alpha 1 AP125 AP126
Element: Ac Usage AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
ICT-MATCH-DTL-KEY Alpha 85
Element: Match Dtl Key
ICT-NDC-NBR Alpha 15 IC781
Element: National Drug National Drug Code.
ICT-GRANT-NBR Alpha 12
Element: Grant Nbr
ICT-TRANS-SEQ Numeric 6 AP125 AP126
Element: Trans Seq AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
DR100 IC138
IC141 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICT-ENTERED-ITEM Alpha 25 AP125 AP126
Element: Entered Item AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 IC781
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO29.1 PO30.1
PO30.2 PO30.3
...
ICT-ENTRY-FL Alpha 1 AP125 AP126
Element: Entry Fl 1 = Item AP131 AP20.1
2 = UPC AP20.2 AP20.3
3 = UPN1 AP20.4 AP20.5
4 = UPN2 AP20.7 AP23.1
5 = NDC AP25.1 AP25.2
6 = SKU AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
ICT-MANUF-ID Numeric 4 AP125 AP126
Element: Manuf Id AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICT-MANUF-NBR Alpha 15 AP125 AP126
Manufacturer's Item This is the identifier that the AP131 AP20.1
Number manufacturer has assigned to an item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICT-ST-FACILITY Alpha 15 AP125 AP126
Element: St Facility AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICTSET1 COMPANY AP125 AP126
LOCATION AP131 AP20.1
DOC-TYPE AP20.2 AP20.3
SYSTEM-CD AP20.4 AP20.5
DOCUMENT AP20.7 AP23.1
SHIPMENT-NBR AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
COMPONENT-SEQ AP30.4 API1.1
DR100 IC01.2
IC110 IC130
IC138 IC141
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC221
...
ICTSET2 COMPANY KeyChange, Subset AP125 AP126
LOCATION Where STATUS != Zeroes AP131 AP20.1
ITEM AP20.2 AP20.3
UPDATE-DATE* AP20.4 AP20.5
UPDATE-TIME* AP20.7 AP23.1
TRAN-COUNTER* AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC12.1 IC220
IC234 IC240
IC28.1 IC280
IC300 IC37.1
IC50.1 IC50.2
IC55.1 IC55.2
IC851 MA180
...
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 IC90.1
TRAN-UOM
LINE-NBR
ICTSET6 COMPANY Subset
TRANS-DATE Where (DOC-TYPE = "IS"
ITEM Or DOC-TYPE = "RR" )
LOCATION And STATUS = 2
OFF-ACCT-UNIT
DOC-TYPE
SYSTEM-CD
DOCUMENT
LINE-NBR
ICTSET7 COMPANY KeyChange, Subset IC234 IC37.1
LOCATION Where STATUS != Zeroes IC50.1
ITEM
TRANS-DATE*
ACTUAL-TIME*
TRAN-COUNTER*
ICTSET8 MANUF-ID Subset IC153
COMPANY Where MANUF-NBR != Spaces
LOCATION
TRANS-DATE
ST-FACILITY
MANUF-NBR
DOC-TYPE
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
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
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
|