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