ICTRANS

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
CX05.1 CX05.2 CX805 IC01.2 IC02.1 IC10.2
IC110 IC15.2 IC183 IC221 IC222 IC223
IC234 IC242 IC244 IC250 IC287 IC320
IC331 IC48.1 IC503 IC52.1 IC524 IC53.1
IC58.1 IC62.1 IC81.1 IC811 IC812 IC82.1
IC840 IC851 ICBD.1 ICBD.2 POI6.1 POIF.1
MM280 MM80.1 MM80.2 RQIC.1 RQID.1 RQIG.1
WH110 WH120 WH21.1 WH21.2 WH21.3 WH21.4
WH210 WH22.1 WH25.1 WH25.2 WHD1.1 WHD2.1
IC220 IC231 IC50.1 IC50.2 IC55.1 IC55.2
IC17.1 IC229 IC190 IC199 IC153


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC130 IC138 IC140 IC141 IC142
IC145 IC175 IC20.1 IC20.2 IC21.1 IC21.2
IC21.5 IC22.1 IC22.2 IC23.1 IC23.2 IC23.3
IC23.4 IC23.5 IC24.1 IC24.2 IC243 IC25.1
IC26.1 IC26.2 IC28.1 IC29.1 IC29.2 IC29.3
IC330 IC500 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 IC850 IC90.1 ICIZ.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 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 IC11.1 IC247 IC300 IC37.1
IC240 IC280 IC216 IC282

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICT-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC330
ICT-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC330
ICT-DOC-TYPE
Element: Doc Type
Alpha 2
This field contains the type of transaction.
AJ = Adjustment
BT = Bin Transfer
CA = Cost Adjustment
CR = Customer Return
DT = Direct Transfer
IR = Intransit Receiving
IS = Issue
IT = Transfer Issue
PI = Physical Inventory Adjustment
RC = Receipt
RR = Requisition Return
RT = Receiving Transfer
SH = Shipment
VA = Vendor Return Adjustment
VR = Vendor Return
PO = PO Receiving
RA = PO Receiving Adjustment
RJ = Rejected Inspection Item
AC = Accepted Inspection Item
VI = Vendor Return Adj to Inventory
AR = Receipt Archive
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC330
ICT-SYSTEM-CD
Element: System Cd
Alpha 2
This field indicates on what system the transaction originated.
IC = Inventory Control
OE = Order Entry
RQ = Requisition
CX = Case Cart
PO = Purchase Order
WO = Work Order
PH = Pharmacy
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC330
ICT-DOCUMENT
Element: Document
Alpha 10 (Right Justified)
This field identifies the document from which this transaction record was created.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC330
ICT-SHIPMENT-NBR
Element: Shipment Nbr
Numeric 10
This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 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
IC243 IC29.1
IC29.2 IC29.3
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
ICT-DOCUMENT-SEQ
Element: Seq
Numeric 3
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
Element: Line Nbr
Numeric 6
This field displays the system-assigned transaction number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC243
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC330 IC500
ICT-COMPONENT-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 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
IC243 IC28.1
IC29.1 IC29.2
IC29.3 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
ICT-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
ICT-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
ICT-TRAN-COUNTER
Element: Tran Counter
Numeric 6
This field contains a transaction object number used to determine the sequence of updating of the Item Location file.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC26.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-TRANS-DATE
Element: Trans Date
Numeric 8 (yyyymmdd)
The date of the transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
ICT-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC330
IC500 IC64.1
IC64.2 IC64.3
ICT-SOH-QTY
Element: Quantity
Signed 13.4
This field contains the stock-on-hand quantity before this transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
ICT-QUANTITY
Element: Quantity
Signed 13.4
This field contains the quantity of the transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC26.1 IC26.2
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
ICT-ORIGINAL-QTY
Element: Quantity
Signed 13.4
This field contains the original intransit quantity. It is used only for intransit transfers.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC22.1
IC22.2 IC243
IC25.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
IC850 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
ICT-OPEN-QTY
Element: Quantity
Signed 13.4
This field contains the open intransit quantity not yet received.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC22.1 IC22.2
IC23.1 IC23.2
IC243 IC25.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
ICT-STOCK-UOM
Element: Uom
Alpha 4
This field contains the stock unit of measure for the item.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
ICT-UNIT-COST
Element: Intl Cost
Signed 18.5
This field contains the unit cost for this transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
ICT-UNIT-COST-CURR
Element: Intl Cost
Signed 18.5
This field contains the unit cost for this transaction in transaction currency.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
ICT-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
0
2
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC243 IC25.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
ICT-ADD-UNIT-COST
Element: Intl Cost
Signed 18.5
This field contains the add-on unit cost or freight cost that is added to the incoming unit cost to determine a new unit cost for this intransit receiving.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC23.1 IC23.2
IC243 IC25.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
ICT-BASE-COST
Element: Intl Cost
Signed 18.5
This field contains the base cost used for calculating the standard cost of an item, if the company uses the standard costing method. The base cost is then used for standard cost variance calculation. Also, this field is used for negative average costing (if the company uses average costing and this field is flagged for allowing negative stock-on-hand). This field captures the average cost of the item prior to the transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-CURRENT-COST
Element: Intl Cost
Signed 18.5
This field contains the cost used for capturing the current cost of the item when the transaction is released. This is the same overall cost used for valuation, and is calculated by the costing method of the company.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
ICT-UNIT-PRICE
Element: Intl Cost
Signed 18.5
This field is not used by the Inventory Control system.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
ICT-TRAN-UOM
Element: Uom
Alpha 4
This field contains the entered unit of measure on this transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC153 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC26.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
ICT-TRAN-UOM-MULT
Element: Uom Mult
Signed 13.7
This field contains the transaction unit of measure multiplier.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
ICT-SECONDARY-QTY
Element: Secondary Qty
Signed 13.4
This field contains a secondary quantity that is tracked if the item is a catch weight item.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
ICT-SEC-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
ICT-SEC-UOM-MULT
Element: Uom Mult
Signed 13.7
This field contains the secondary quantity unit of measure multiplier. It is used to convert the stock-on-hand quantity to the secondary quantity or visa versa.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.2 IC21.2
IC22.1 IC22.2
IC23.2 IC24.1
IC243 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
IC850 MA180
MA278 MA41.1
ICT-GL-DATE
Element: Gl Date
Numeric 8 (yyyymmdd)
This field contains the date this transaction is to be posted to General Ledger.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
ICT-EST-DEL-DATE
Element: Est Del Date
Numeric 8 (yyyymmdd)
This field contains the estimated delivery date. This field is required on an intransit transfer transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC22.1
IC22.2 IC243
IC25.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
IC850 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
ICT-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
This field contains the reference information.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC20.2 IC21.2
IC22.2 IC23.2
IC24.1 IC24.2
IC243 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
IC850 IC90.1
MA180 MA278
ICT-BIN
Element: Bin
Alpha 7
This field contains a storage area for an item or any number of items.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC243
IC25.1 IC26.1
IC26.2 IC29.1
IC29.2 IC330
IC500 IC64.1
ICT-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code for the transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.2
IC21.2 IC22.2
IC23.2 IC24.2
IC243 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
IC90.1 MA180
ICT-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC20.2 IC21.1
IC21.2 IC24.2
IC243 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
ICT-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC20.2 IC21.1
IC21.2 IC24.2
IC243 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
ICT-LINE-COMMENT
Element: Line Comment
Alpha 40 (Lower Case)
This field contains the user-defined comments for the transaction line. These comments are for reference purposes only.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC20.2 IC21.2
IC22.2 IC23.2
IC24.2 IC243
IC28.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
IC850 IC90.1
MA180 MA278
ICT-INV-ACCT-UNIT
Element: Acct Unit
Alpha 15
This field contains the general ledger inventory account unit.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-INV-ACCOUNT
Element: Account
Numeric 6
This field contains the general ledger inventory account number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-INV-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the general ledger inventory subaccount number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-OFF-ACCT-UNIT
Element: Acct Unit
Alpha 15
This field contains the general ledger offset account unit.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
ICT-OFF-ACCOUNT
Element: Account
Numeric 6
This field contains the general ledger offset account number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
ICT-OFF-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the general ledger offset subaccount number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC28.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
ICT-OFF-DIST-CO
Element: Company
Numeric 4
Company number used for posting the transaction to the Offset Account
IC21.1 IC21.2
IC24.1 IC24.2
ICT-VAR-ACCT-UNIT
Element: Acct Unit
Alpha 15
This field contains the general ledger cost variance account unit.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-VAR-ACCOUNT
Element: Account
Numeric 6
This field contains the general ledger cost variance account number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-VAR-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the general ledger cost variance subaccount number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-ADD-ACCT-UNIT
Element: Acct Unit
Alpha 15
This field contains the general ledger add-on cost account unit.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC23.2 IC243
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
ICT-ADD-ACCOUNT
Element: Account
Numeric 6
This field contains the general ledger add-on cost account number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC23.2 IC243
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
ICT-ADD-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the general ledger add-on cost subaccount number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC23.2 IC243
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
ICT-ADD-DIST-CO
Element: Company
Numeric 4
Company number used for posting the transaction to the Add-On Cost Account
IC23.2
ICT-STATUS
Element: Status
Numeric 1
This field contains the processing status of the transaction.
0 = Unreleased
1 = Released
2 = General Ledger Updated
5 = Intermediate Status(see IC130)
3 = Non General Ledger
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC138 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC243 IC25.1
IC26.1 IC26.2
IC28.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
ICT-FR-DOCUMENT
Element: Document
Alpha 10 (Right Justified)
This field contains the document number for the from-location for a transfer transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC22.1 IC22.2
IC23.1 IC23.2
IC243 IC25.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
ICT-FROM-TO-BIN
Element: Bin
Alpha 7
This field contains the from or to bin for a transfer transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC22.1 IC22.2
IC243 IC25.1
IC26.1 IC26.2
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
IC90.1 MA180
MA278 MA41.1
ICT-FROM-TO-LOC
Element: Location
Alpha 5
This field contains the from or to location for a transfer location.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC243
IC25.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
IC850 MA180
MA278 MA41.1
ICT-DETAIL-BAL-FL
Element: All Flag
Alpha 1
This field is used to balance the bin, lot, and serial number detail lines with the transaction lines before releasing the document.
N = No
Y = Yes
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC243 IC25.1
IC29.1 IC29.2
IC29.3 IC330
IC500 IC64.1
IC64.2 IC64.3
ICT-LAST-DST-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
ICT-ACTUAL-TIME
Element: Actual Time
Numeric 4
This field contains the system time when a transaction took place. This is in 24-hour format (HHMM).
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-FROM-TO-CMPY
Element: Company
Numeric 4
This field contains the from or to company for an intercompany transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
ICT-TO-CO-B-UCOST
Element: Intl Cost
Signed 18.5
This field contains the base unit cost for the To company. This field is converted from the 'From' company unit cost. It can be in a different currency if the two companies have different base currencies.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC243
IC25.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
IC850 MA180
ICT-FROM-CURR-CD
Element: Currency Code
Alpha 5
This field contains the currency code of the company that initiated the transaction.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC20.1
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC24.1
IC24.2 IC243
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
ICT-TO-CURR-CD
Element: Currency Code
Alpha 5
This field contains the currency code of the company to which the inventory is being transferred.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC20.1
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC24.1
IC24.2 IC243
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
ICT-HIST-PERIOD
Element: Hist Period
Numeric 2
This field and the history period to which the transaction was posted ties a transaction to the period and year to which it was posted in the history file. This field is updated based on the transaction date when General Ledger Interface (IC130) is run.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
ICT-HIST-YEAR
Element: Year
Numeric 4
This field and the HIST YEAR field tie a transaction to the period and year it was posted to on the history file. This field is updated based on the transaction date when General Ledger Interface (IC130) is run.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
ICT-OPERATOR-ID
Element: Operator
Alpha 10
This field contains the terminal sign on identifier when this transaction was created.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC243
IC26.1 IC26.2
IC28.1 IC330
IC500 IC64.1
IC64.2 IC64.3
ICT-TO-UOM
Element: Uom
Alpha 4
This field contains the unit of measure resulting from a bin-to-bin transfer from one unit of measure to another. This is also used by IC22.1 (Transfers) to store the unit of measure of a quantity being transferred. It is only used for intransit transfers.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC22.1
IC22.2 IC243
IC25.1 IC26.1
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 IC850
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
ICT-KIT-FL
Element: Kit Fl
Alpha 1
This field is used to indicate that this transaction is for kit item.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
ICT-BL-INVOICED
Element: Bl Invoiced
Alpha 1
Not currently used.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
ICT-SA-INVOICED
Element: Sa Invoiced
Alpha 1
Not currently used.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
ICT-MATCH-DTL-KEY
Element: Match Dtl Key
Alpha 85
ICT-NDC-NBR
Element: Ndc Nbr
Alpha 15
National Drug Code.
ICT-GRANT-NBR
Element: Grant Nbr
Alpha 12
ICT-TRANS-SEQ
Element: Trans Seq
Numeric 6
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC243 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC29.3 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
ICT-ENTERED-ITEM
Element: Entered Item
Alpha 25
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
ICT-ENTRY-FL
Element: Entry Fl
Alpha 1

1 = Item
2 = UPC
3 = UPN1
4 = UPN2
5 = NDC
6 = SKU
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
ICT-MANUF-ID
Element: Manuf Id
Numeric 4
A unique idenitifier for a manufacturer
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC243
IC25.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
ICT-MANUF-NBR
Element: Manuf Nbr
Alpha 35
This is the identifier that the manufacturer has assigned to an item.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC243
IC25.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
ICT-ST-FACILITY
Element: St Facility
Alpha 15
A unique identifier for a ship to facility.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC243
IC25.1 IC330
IC500 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
ICT-EAM-OPER-NBR
Element: Operation Nbr
Numeric 4
IC21.2 ICIZ.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ICT-EAM-SEQ-NBR
Element: Seq Nbr
Numeric 4
IC21.2 ICIZ.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ICT-EAM-WO-NBR
Element: Work Order
Numeric 8
IC21.2 ICIZ.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
ICT-CREATED-BY
Element: Operator
Alpha 10
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC138
IC140 IC141
IC142 IC145
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC26.1 IC26.2
IC330 IC500
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
ICT-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC138 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC243 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
ICT-LAST-UPDT-TIME
Element: Time
Numeric 8
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC138 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC243 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
ICT-LAST-UPDATE-BY
Element: Operator
Alpha 10
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC138 IC140
IC141 IC142
IC145 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC243 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
ICT-GLBL-LINE-TYPE
Element: Glbl Line Type
Alpha 15
IC141 IC22.1
IC22.2
ICT-GLBL-DOC-TYPE
Element: Glbl Doc Type
Alpha 10
IC141 IC22.1
IC22.2
ICT-TEMP-HOLD
Element: Temp Hold
Alpha 1

A = Approved by Engine
S = Sent for Approval
IC22.1 IC22.2
IC23.1 IC23.2
IC25.1 IC500


ICTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICTSET1 COMPANY
LOCATION
DOC-TYPE
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX05.1
CX05.2 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
ICTSET2 COMPANY
LOCATION
ITEM
UPDATE-DATE*
UPDATE-TIME*
TRAN-COUNTER*
KeyChange, Subset
WhereSTATUS !=Zeroes
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
ICTSET3 COMPANY
REASON-CODE
LOCATION
ITEM
UPDATE-DATE
UPDATE-TIME
TRAN-COUNTER
KeyChange, Subset
WhereSTATUS !=Zeroes
IC17.1 IC229
IC247 MA66.2
MA70.1 MA75.1
ICTSET4 COMPANY
LOCATION
ITEM
UPDATE-DATE*
UPDATE-TIME*
TRAN-COUNTER*
KeyChange, Subset
Where(STATUS =1
OrSTATUS =5)
IC130 IC190
IC199
ICTSET5 COMPANY
LOCATION
DOC-TYPE
SYSTEM-CD
DOCUMENT
ITEM
BIN
TRAN-UOM
LINE-NBR
KeyChange, Subset
WhereSTATUS =Zeroes
IC11.1 IC20.1
IC20.2 IC21.1
IC21.2 IC21.5
IC216 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC90.1
MA66.2 MA70.1
MA75.1
ICTSET7 COMPANY
LOCATION
ITEM
TRANS-DATE*
ACTUAL-TIME*
TRAN-COUNTER*
KeyChange, Subset
WhereSTATUS !=Zeroes
IC220 IC231
IC234 IC247
IC37.1 IC50.1
IC55.1 IC55.2
ICTSET8 MANUF-ID
COMPANY
LOCATION
TRANS-DATE
ST-FACILITY
MANUF-NBR
DOC-TYPE
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
Subset
WhereMANUF-ID !=Zeroes
IC153
ICTSET9 FROM-TO-CMPY
FROM-TO-LOC
COMPANY
LOCATION
DOC-TYPE
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
STATUS
TRANS-DATE
KeyChange
IC282


ICTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
ICT-COMPANY->ICC-COMPANY
Glnamesadd GLNAMES Not Required
ICT-COMPANY->GLN-COMPANY
ICT-ADD-ACCT-UNIT->GLN-ACCT-UNIT
Glnamesinv GLNAMES Not Required
ICT-COMPANY->GLN-COMPANY
ICT-INV-ACCT-UNIT->GLN-ACCT-UNIT
Glnamesoff GLNAMES Not Required
ICT-COMPANY->GLN-COMPANY
ICT-OFF-ACCT-UNIT->GLN-ACCT-UNIT
Glnamesvar GLNAMES Not Required
ICT-COMPANY->GLN-COMPANY
ICT-VAR-ACCT-UNIT->GLN-ACCT-UNIT
Hazard Code HAZARD Not Required
ITE-ITEM-GROUP->HAZ-ITEM-GROUP
ITE-HAZARD-CODE->HAZ-HAZARD-CODE
Icictuf ICICTUF Not Required, Delete Cascades
ICT-COMPANY->UFT-COMPANY
ICT-LOCATION->UFT-LOCATION
ICT-DOC-TYPE->UFT-DOC-TYPE
ICT-SYSTEM-CD->UFT-SYSTEM-CD
ICT-DOCUMENT->UFT-DOCUMENT
ICT-SHIPMENT-NBR->UFT-SHIPMENT-NBR
ICT-LINE-NBR->UFT-LINE-NBR
ICT-COMPONENT-SEQ->UFT-COMPONENT-SEQ
Iclocation ICLOCATION Required
ICT-COMPANY->ICL-COMPANY
ICT-LOCATION->ICL-LOCATION
Ictbod ICTBOD Not Required, Delete Cascades
ICT-COMPANY->IBC-COMPANY
ICT-LOCATION->IBC-LOCATION
ICT-DOC-TYPE->IBC-DOC-TYPE
ICT-SYSTEM-CD->IBC-SYSTEM-CD
ICT-DOCUMENT->IBC-DOCUMENT
ICT-SHIPMENT-NBR->IBC-SHIPMENT-NBR
ICT-LINE-NBR->IBC-LINE-NBR
ICT-COMPONENT-SEQ->IBC-COMPONENT-SEQ
Inspection PORECADJLN Required
When ICT-DOC-TYPE ="RJ"
OrICT-DOC-TYPE ="AC"
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 Not 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
When ICT-DOC-TYPE ="RA"
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"
OrICT-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
Reqline2 REQLINE Required
When ICT-SYSTEM-CD ="RQ"
ICT-FROM-TO-CMPY->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
NAME
RELATED 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


File created: Thu Jun 09 02:18:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.