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 POI6.1 POIF.1 MM280 IC12.1
IC220 IC240 IC280 IC50.1 IC50.2 IC55.1
IC55.2 IC17.1 IC229 IC190 IC199 IC153
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 DR100 IC130 IC138 IC141
IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1
IC22.2 IC23.1 IC23.2 IC23.3 IC23.4 IC23.5
IC24.1 IC24.2 IC25.1 IC26.1 IC26.2 IC28.1
IC29.1 IC29.2 IC29.3 IC300 IC500 IC850
IC90.1 MA180 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 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE111
OE113 OE114 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE81.1 OE810 OE830 OE90.1 OE90.2
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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICT-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP25.1
resource type = V. Identifies the HR AP25.2 AP26.1
company if the resource type = E. It is AP27.1 AP30.4
blank for type A, P or Q resources. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
...
ICT-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
...
ICT-DOC-TYPE Alpha 2 AP125 AP126
Element: Document Type This field contains the type of AP131 AP25.1
transaction. AP25.2 AP26.1
AJ = Adjustment AP27.1 AP30.4
BT = Bin Transfer BL120 BL122
CA = Cost Adjustment BL130 BL20.1
CR = Customer Return BL20.3 BL21.2
DT = Direct Transfer BL21.5 BL29.1
IR = Intransit Receiving BL29.2 BL520
IS = Issue BL820 BL92.1
IT = Transfer Issue DR100 IC138
PI = Physical Inventory Adjustment IC141 IC175
RC = Receipt IC20.1 IC20.2
RR = Requisition Return IC21.1 IC21.2
RT = Receiving Transfer IC22.1 IC22.2
SH = Shipment IC23.1 IC23.2
VA = Vendor Return Adjustment IC23.3 IC23.4
VR = Vendor Return IC23.5 IC24.1
PO = PO Receiving IC24.2 IC25.1
RA = PO Receiving Adjustment IC26.1 IC26.2
RJ = Rejected Inspection Item IC28.1 IC29.1
AC = Accepted Inspection Item IC29.2 IC29.3
IC500 IC850
IC90.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
...
ICT-SYSTEM-CD Alpha 2 AP125 AP126
Element: System Code This field indicates on what system the AP131 AP25.1
transaction originated. AP25.2 AP26.1
IC = Inventory Control AP27.1 AP30.4
OE = Order Entry BL120 BL122
RQ = Requisition BL130 BL20.1
CX = Case Cart BL20.3 BL21.2
PO = Purchase Order BL21.5 BL29.1
WO = Work Order BL29.2 BL520
PH = Pharmacy BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
...
ICT-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Element: Document ID This field identifies the document from AP131 AP25.1
which this transaction record was AP25.2 AP26.1
created. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
...
ICT-SHIPMENT-NBR Numeric 10 AP125 AP126
Element: Shipment NumbeThis 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 AP30.4
order were not shipped at the same time. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
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 AP25.1
transaction number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
MA180 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-COMPONENT-SEQ Numeric 3 AP125 AP126
Element: Sequence NumbeThis field contains the component AP131 AP25.1
sequence number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Update Date This field contains the date the record AP131 AP25.1
was updated. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
...
ICT-UPDATE-TIME Numeric 6 AP125 AP126
Element: Update Time This field contains the system time AP131 AP25.1
when the record was updated. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
...
ICT-TRAN-COUNTER Numeric 6 AP125 AP126
Element: 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 AP30.4
Location file. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
...
ICT-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Transaction DaThe date of the transaction. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC851 IC90.1
MA180 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 OE10.1
OE10.2 OE10.3
...
ICT-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
...
ICT-SOH-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the stock-on-hand AP131 AP25.1
quantity before this transaction. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
...
ICT-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of the AP131 AP25.1
transaction. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
...
ICT-ORIGINAL-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the original AP131 AP25.1
intransit quantity. It is used only for AP25.2 AP26.1
intransit transfers. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC141
IC22.1 IC22.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
ICT-OPEN-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the open intransit AP131 AP25.1
quantity not yet received. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
...
ICT-STOCK-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the stock unit of AP131 AP25.1
measure for the item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
...
ICT-UNIT-COST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the unit cost for AP131 AP25.1
this transaction. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
...
ICT-UNIT-COST-CURR Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the unit cost for AP131 AP25.1
this transaction in transaction AP25.2 AP26.1
currency. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
ICT-CURR-ND Numeric 1 AP125 AP126
Account Currency Represents the number of decimals AP131 AP25.1
Code defined for the currency of the object. AP25.2 AP26.1
0 AP27.1 AP30.4
2 BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC21.1 IC21.2
IC22.1 IC22.2
IC25.1 IC28.1
IC500 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
ICT-ADD-UNIT-COST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the add-on unit AP131 AP25.1
cost or freight cost that is added to AP25.2 AP26.1
the incoming unit cost to determine a AP27.1 AP30.4
new unit cost for this intransit BL120 BL122
receiving. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
...
ICT-BASE-COST Signed 18.5 AP125 AP126
Element: Intl 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 AP30.4
costing method. The base cost is then BL120 BL122
used for standard cost variance BL130 BL20.1
calculation. BL20.3 BL21.2
BL21.5 BL29.1
Also, this field is used for negative BL29.2 BL520
average costing (if the company uses BL820 BL92.1
average costing and this field is DR100 IC138
flagged for allowing negative IC141 IC175
stock-on-hand). This field captures the IC20.1 IC20.2
average cost of the item prior to the IC21.1 IC21.2
transaction. IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-CURRENT-COST Signed 18.5 AP125 AP126
Element: Intl 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 AP30.4
is the same overall cost used for BL120 BL122
valuation, and is calculated by the BL130 BL20.1
costing method of the company. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
...
ICT-UNIT-PRICE Signed 18.5 AP125 AP126
Element: Intl Cost This field is not used by the Inventory AP131 AP25.1
Control system. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC28.1
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
...
ICT-TRAN-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the entered unit of AP131 AP25.1
measure on this transaction. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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
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
OE10.1 OE10.2
OE10.3 OE10.4
...
ICT-TRAN-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure This field contains the transaction AP131 AP25.1
Multiplier unit of measure multiplier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC28.1 IC500
IC850 IC90.1
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-SECONDARY-QTY Signed 13.4 AP125 AP126
Element: Secondary QuanThis 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
...
ICT-SEC-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the secondary AP131 AP25.1
quantity unit of measure. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
...
ICT-SEC-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure 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 AP30.4
quantity to the secondary quantity or BL120 BL122
visa versa. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC175
IC20.2 IC21.2
IC22.1 IC22.2
IC23.2 IC24.1
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
...
ICT-GL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: General LedgerThis field contains the date this AP131 AP25.1
transaction is to be posted to the AP25.2 AP26.1
General Ledger system. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC141
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
IC850 IC90.1
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC141
IC22.1 IC22.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
ICT-REFERENCE Alpha 10 (Lower Case) AP125 AP126
Element: Reference This field contains the reference AP131 AP25.1
information. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC20.2
IC21.2 IC22.2
IC23.2 IC24.1
IC24.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
...
ICT-BIN Alpha 7 AP125 AP126
Element: Bin This field contains a storage area for AP131 AP25.1
an item or any number of items. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC500
IC850 IC90.1
MA180 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 OE10.1
...
ICT-REASON-CODE Alpha 4 AP125 AP126
Element: Reason Code This field contains the reason code for AP131 AP25.1
the transaction. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.2 IC21.2
IC22.2 IC23.2
IC24.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
...
ICT-ACTIVITY Alpha 15 AP125 AP126
Element: Activity Activities are the processes or AP131 AP25.1
procedures that produce work. Cost AP25.2 AP26.1
objects (products, services, customers, AP27.1 AP30.4
and so on) are the reasons for BL120 BL122
performing the activity. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC20.2
IC21.2 IC24.2
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
...
ICT-ACCT-CATEGORY Alpha 5 AP125 AP126
Element: Account CategoAccount 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 AP30.4
for activities in the Activity BL120 BL122
Management system. All transactions are BL130 BL20.1
posted to an account category within an BL20.3 BL21.2
activity. You can assign a specific BL21.5 BL29.1
General Ledger account or range of BL29.2 BL520
accounts (company, accounting unit, BL820 BL92.1
account, and subaccount) that make up IC138 IC141
the transactions posted to an account IC20.2 IC21.2
category using AC07.1 (Account IC24.2 IC28.1
Assignment). IC500 IC850
MA180 MA530
Period-to-date, year-to-date, and MA531 MA60.2
life-to-date balances are maintained by MA60.3 MA60.5
account category for activities. Account MA61.1 MA66.2
categories must be assigned to MA66.3 MA67.1
activities before you do any budgeting MA67.2 MA70.1
or transaction processing. MA75.1 MA80.1
MAI1.1 OE10.1
Valid account category types are: OE10.2 OE10.3
cost OE10.4 OE10.5
revenue OE10.6 OE10.7
accrual OE10.8 OE11.1
pass thru OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
ICT-LINE-COMMENT Alpha 40 (Lower Case) AP125 AP126
Element: 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 AP30.4
only. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC20.2
IC21.2 IC22.2
IC23.2 IC24.2
IC28.1 IC500
IC850 IC90.1
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
...
ICT-INV-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThis field contains the general ledger AP131 AP25.1
inventory account unit. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-INV-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the general ledger AP131 AP25.1
inventory account number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-INV-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount This field contains the general ledger AP131 AP25.1
inventory subaccount number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-OFF-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThis field contains the general ledger AP131 AP25.1
offset account unit. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-OFF-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the general ledger AP131 AP25.1
offset account number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-OFF-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount This field contains the general ledger AP131 AP25.1
offset subaccount number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-VAR-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThis field contains the general ledger AP131 AP25.1
cost variance account unit. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-VAR-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the general ledger AP131 AP25.1
cost variance account number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-VAR-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount This field contains the general ledger AP131 AP25.1
cost variance subaccount number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-ADD-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThis field contains the general ledger AP131 AP25.1
add-on cost account unit. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC23.2
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
ICT-ADD-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the general ledger AP131 AP25.1
add-on cost account number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC23.2
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
ICT-ADD-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount This field contains the general ledger AP131 AP25.1
add-on cost subaccount number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC23.2
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
ICT-STATUS Numeric 1 AP125 AP126
Element: Status This field contains the processing AP131 AP25.1
status of the transaction. AP25.2 AP26.1
0 = Unreleased AP27.1 AP30.4
1 = Released BL120 BL122
2 = General Ledger Updated BL130 BL20.1
5 = Intermediate Status(see IC130) BL20.3 BL21.2
3 = Non General Ledger BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 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 OE10.1
OE10.2 OE10.3
...
ICT-FR-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Element: Document ID This field contains the document number AP131 AP25.1
for the from-location for a transfer AP25.2 AP26.1
transaction. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC22.1
IC22.2 IC23.1
IC23.2 IC25.1
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
...
ICT-FROM-TO-BIN Alpha 7 AP125 AP126
Element: Bin This field contains the from or to bin AP131 AP25.1
for a transfer transaction. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC22.1
IC22.2 IC25.1
IC26.1 IC26.2
IC28.1 IC500
IC850 IC90.1
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
...
ICT-FROM-TO-LOC Alpha 5 AP125 AP126
Element: Location Code This field contains the from or to AP131 AP25.1
location for a transfer location. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC21.1
IC21.2 IC22.1
IC22.2 IC25.1
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
...
ICT-DETAIL-BAL-FL Alpha 1 AP125 AP126
Element: All 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 AP30.4
the document. BL120 BL122
N = No BL130 BL20.1
Y = Yes BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 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 OE10.1
...
ICT-LAST-DST-SEQ Numeric 3 AP125 AP126
Element: Sequence Number AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC130 IC28.1
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
ICT-ACTUAL-TIME Numeric 4 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-FROM-TO-CMPY Numeric 4 AP125 AP126
Element: Company This field contains the from or to AP131 AP25.1
company for an intercompany transaction. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
...
ICT-TO-CO-B-UCOST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the base unit cost AP131 AP25.1
for the To company. This field is AP25.2 AP26.1
converted from the 'From' company unit AP27.1 AP30.4
cost. It can be in a different currency BL120 BL122
if the two companies have different base BL130 BL20.1
currencies. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
MA180 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
...
ICT-FROM-CURR-CD Alpha 5 AP125 AP126
Element: Currency Code This field contains the currency code AP131 AP25.1
of the company that initiated the AP25.2 AP26.1
transaction. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC141 IC20.1
IC21.1 IC21.2
IC22.1 IC22.2
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
...
ICT-TO-CURR-CD Alpha 5 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC141 IC20.1
IC21.1 IC21.2
IC22.1 IC22.2
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
...
ICT-HIST-PERIOD Numeric 2 AP125 AP126
Element: Historical PerThis 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 AP30.4
which it was posted in the history file. BL120 BL122
This field is updated based on the BL130 BL20.1
transaction date when General Ledger BL20.3 BL21.2
Interface (IC130) is run. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC130 IC28.1
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
ICT-HIST-YEAR Numeric 4 AP125 AP126
Element: Last Closed YeThis 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 AP30.4
field is updated based on the BL120 BL122
transaction date when General Ledger BL130 BL20.1
Interface (IC130) is run. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC130 IC28.1
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
ICT-OPERATOR-ID Alpha 10 AP125 AP126
Element: Operator Code This field contains the terminal sign AP131 AP25.1
on identifier when this transaction was AP25.2 AP26.1
created. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
DR100 IC138
IC141 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC26.1
IC26.2 IC28.1
IC500 IC850
IC90.1 MA180
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
OE10.1 OE10.2
...
ICT-TO-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis 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 AP30.4
BL120 BL122
This is also used by IC22.1 (Transfers) BL130 BL20.1
to store the unit of measure of a BL20.3 BL21.2
quantity being transferred. It is only BL21.5 BL29.1
used for intransit transfers. BL29.2 BL520
BL820 BL92.1
IC22.1 IC22.2
IC25.1 IC26.1
IC28.1 IC500
IC850 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
ICT-KIT-FL Alpha 1 AP125 AP126
Element: Kit Flag This field is used to indicate that AP131 AP25.1
this transaction is for kit item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
ICT-BL-INVOICED Alpha 1 AP125 AP126
Element: Bl Invoiced Not currently used. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
ICT-SA-INVOICED Alpha 1 AP125 AP126
Element: Sa Invoiced Not currently used. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
ICT-MATCH-DTL-KEY Alpha 85
Element: Match Dtl Key
ICT-NDC-NBR Alpha 15
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 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 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 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
ICT-ENTERED-ITEM Alpha 25 AP125 AP126
Element: Entered Item AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
ICT-ENTRY-FL Alpha 1 AP125 AP126
Element: Entry Fl 1 = Item AP131 AP25.1
2 = UPC AP25.2 AP26.1
3 = UPN1 AP27.1 AP30.4
4 = UPN2 BL120 BL122
5 = NDC BL130 BL20.1
6 = SKU BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
ICT-MANUF-ID Numeric 4 AP125 AP126
Element: Manuf Id A unique idenitifier for a manufacturer AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
...
ICT-MANUF-NBR Alpha 15 AP125 AP126
Manufacturer's Item This is the identifier that the AP131 AP25.1
Number manufacturer has assigned to an item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
...
ICT-ST-FACILITY Alpha 15 AP125 AP126
Element: St Facility A unique identifier for a ship to AP131 AP25.1
facility. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
...
ICTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICTSET1 COMPANY DR100 IC01.2
LOCATION IC110 IC130
DOC-TYPE IC138 IC141
SYSTEM-CD IC175 IC20.1
DOCUMENT IC20.2 IC21.1
SHIPMENT-NBR IC21.2 IC22.1
LINE-NBR IC22.2 IC221
COMPONENT-SEQ IC222 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC234 IC24.1
IC24.2 IC242
IC244 IC25.1
IC28.1 IC282
IC287 IC29.1
...
ICTSET2 COMPANY KeyChange, Subset AP125 AP126
LOCATION Where STATUS != Zeroes AP131 AP25.1
ITEM AP25.2 AP26.1
UPDATE-DATE* AP27.1 AP30.4
UPDATE-TIME* BL120 BL122
TRAN-COUNTER* BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC220
IC234 IC240
IC28.1 IC280
IC300 IC37.1
IC50.1 IC50.2
...
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 IC37.1
LOCATION Where STATUS != Zeroes IC50.1
ITEM
TRANS-DATE*
ACTUAL-TIME*
TRAN-COUNTER*
ICTSET8 MANUF-ID Subset IC153
COMPANY Where MANUF-ID != Zeroes
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
|