Lawson Insight Technical Documentation |
|
ICTRANSDTL
ICTRANSDTL FILE
Inventory Transaction Detail
The Inventory Transaction Detail file is a detail file associated with the
Inventory Transaction file and is created for lot or serial number tracked
items or for a multiple bin or unit of measure transaction. It contains the
serial number, lot, bin numbers, units of measure, and their quantities.
REFERENCED BY
IC110 IC220 IC222 IC244 IC50.1 IC50.2
PO133 PO230 RQ39.1 RQ39.2 IC52.1
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 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
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ35.1 RQIE.1
WH130 WH132 WH190 WH20.2 WH20.7 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 WO132 WO140 POD0.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICD-COMPANY Numeric 4 AP125 AP126
Element: Company The company number represents an AP131 AP20.1
established company and is entered on AP20.2 AP20.3
all function codes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC22.1
IC22.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
...
ICD-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC22.1
IC22.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
...
ICD-DOC-TYPE Alpha 2 AP125 AP126
Element: Document Type This field contains the type of AP131 AP20.1
transaction. AP20.2 AP20.3
AJ = Adjustment AP20.4 AP20.5
BT = Bin Transfer AP20.7 AP23.1
CR = Customer Return AP25.1 AP25.2
DT = Direct Transfer AP26.1 AP27.1
HD = Lot Hold AP30.4 API1.1
IR = Intransit Receiving IC175 IC22.1
IS = Issue IC22.2 IC23.1
IT = Transfer Issue IC23.2 IC23.3
PI = Physical Inventory Adjustmnet IC23.4 IC23.5
PO = PO Receiving IC25.1 IC26.1
RA = Receiving Adjustment IC26.2 IC28.1
RC = Receipt IC29.1 IC29.2
RJ = Inspection Reject IC29.3 IC500
RR = Requisition Return IC850 MA180
RT = Receiving Transfer MA41.2 MA41.7
SH = Shipment MA43.1 MA43.2
VR = Vendor Return MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
...
ICD-SYSTEM-CD Alpha 2 AP125 AP126
Element: System Code This field indicates on what system the AP131 AP20.1
transaction originated. AP20.2 AP20.3
CX = Case Cart AP20.4 AP20.5
IC = Inventory Control AP20.7 AP23.1
OE = Order Entry AP25.1 AP25.2
RQ = Requisition AP26.1 AP27.1
PO = Purchase Order AP30.4 API1.1
WO = Work Order IC175 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
...
ICD-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Element: Document ID This field contains the document ID, AP131 AP20.1
which is used to reference transactions AP20.2 AP20.3
in a transaction form. AP20.4 AP20.5
AP20.7 AP23.1
Transactions are released (updated) to AP25.1 AP25.2
the Inventory Control system by document AP26.1 AP27.1
ID. AP30.4 API1.1
IC175 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
...
ICD-SHIPMENT-NBR Numeric 10 AP125 AP126
Element: Shipment NumbeThis field contains the shipment AP131 AP20.1
number. One order can have several AP20.2 AP20.3
shipment numbers if the items of the AP20.4 AP20.5
order were not shipped at the same time. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC22.1 IC22.2
IC23.3 IC23.4
IC23.5 IC25.1
IC28.1 IC29.1
IC29.2 IC29.3
IC500 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICD-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC22.1
IC22.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
...
ICD-COMPONENT-SEQ Numeric 3 AP125 AP126
Element: Sequence Number AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC22.1 IC22.2
IC23.3 IC23.4
IC23.5 IC25.1
IC28.1 IC29.1
IC29.2 IC29.3
IC500 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
...
ICD-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the transaction UOM AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC22.1 IC22.2
IC23.3 IC23.4
IC23.5 IC25.1
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
ICD-LOT-SERIAL Alpha 16 AP125 AP126
Element: Serial Number This field contains the lot or sublot AP131 AP20.1
number or the serial number for the AP20.2 AP20.3
item. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC22.1
IC22.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC500 IC850
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
...
ICD-BIN Alpha 7 AP125 AP126
Element: Bin This field contains a storage area for AP131 AP20.1
an item or any number of items. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC22.1
IC22.2 IC23.1
IC23.3 IC23.4
IC23.5 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC29.2 IC29.3
IC500 IC850
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
...
ICD-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This is the date a document was created AP131 AP20.1
for one or more transactions. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICD-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item number AP131 AP20.1
defined in IC12.1 (Item Location) or AP20.2 AP20.3
IC10.1 (Item Master and Location). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 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 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
...
ICD-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure This field contains the multiplier for AP131 AP20.1
Multiplier converting this unit of measure to the AP20.2 AP20.3
stock unit of measure. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC22.1 IC22.2
IC23.4 IC23.5
IC25.1 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
...
ICD-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of AP131 AP20.1
this detail line. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC23.5
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
...
ICD-OPEN-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of the AP131 AP20.1
item not yet received. It is used only AP20.2 AP20.3
for intransit transactions. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC22.1 IC22.2
IC23.1 IC23.2
IC23.4 IC25.1
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
...
ICD-ORIGINAL-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the original AP131 AP20.1
quantity of the detail line. It is used AP20.2 AP20.3
only for intransit transactions. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC22.1 IC22.2
IC28.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
...
ICD-SECONDARY-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains a secondary AP131 AP20.1
quantity that is tracked if the item is AP20.2 AP20.3
a catch weight item. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC24.1
IC24.2 IC25.1
IC28.1 IC29.1
IC29.3 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
...
ICD-HOLD-FLAG Alpha 1 AP125 AP126
Element: On Hold Flag This field is used to place a lot on AP131 AP20.1
hold, not allowing any issues or AP20.2 AP20.3
transfers. AP20.4 AP20.5
N = No AP20.7 AP23.1
Y = Yes AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC22.1 IC22.2
IC25.1 IC28.1
IC29.1 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
...
ICD-EXPIRE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the expiration date AP131 AP20.1
for the lot. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 IC29.1
IC500 IC850
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO29.1 PO30.1
...
ICD-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the system date the AP131 AP20.1
transaction was updated (released) to AP20.2 AP20.3
the Inventory Control system. AP20.4 AP20.5
AP20.7 AP23.1
This date is established by the system AP25.1 AP25.2
when a transaction document is released AP26.1 AP27.1
in a transaction form. AP30.4 API1.1
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICD-UPDATE-TIME Numeric 6 AP125 AP126
Element: Update Time This field contains the system time AP131 AP20.1
when the transaction was updated AP20.2 AP20.3
(released) to the Inventory Control AP20.4 AP20.5
system. AP20.7 AP23.1
AP25.1 AP25.2
This time is established by the system AP26.1 AP27.1
when you release a transaction document AP30.4 API1.1
in a transaction form. IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICD-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP131 AP20.1
transaction. AP20.2 AP20.3
0 = Unreleased AP20.4 AP20.5
1 = Released AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC500
IC850 IC90.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
...
ICD-ACTUAL-TIME Numeric 4 AP125 AP126
Element: Actual Time This field contains the system time AP131 AP20.1
when this transaction took place. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC850
IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
...
ICD-TRAN-COUNTER Numeric 6
Element: Item Count
ICD-TRANS-BARCODE Alpha 25
Element: Trans Barcode
ICD-TRANS-SEQ Numeric 6 AP125 AP126
Element: Trans Seq AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC175 IC22.1
IC22.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC28.1
IC29.1 IC29.2
IC29.3 IC500
IC850 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
...
ICTRANSDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICDSET1 COMPANY IC110 IC20.1
LOCATION IC20.2 IC21.1
DOC-TYPE IC21.2 IC22.1
SYSTEM-CD IC22.2 IC220
DOCUMENT IC222 IC23.1
SHIPMENT-NBR IC23.2 IC23.3
LINE-NBR IC23.4 IC23.5
COMPONENT-SEQ IC24.1 IC24.2
TRANS-SEQ IC244 IC25.1
IC29.1 IC29.2
IC29.3 IC300
IC50.1 IC50.2
IC500 IC850
IC90.1 PO131
PO133 PO230
...
ICDSET2 COMPANY KeyChange IC20.1 IC20.2
LOCATION IC21.1 IC21.2
DOC-TYPE IC22.1 IC22.2
SYSTEM-CD IC23.1 IC23.2
DOCUMENT IC23.3 IC23.4
SHIPMENT-NBR IC23.5 IC24.1
ITEM IC24.2 IC25.1
LOT-SERIAL IC29.1 IC29.2
BIN IC29.3 IC500
LINE-NBR RQ35.1 RQ39.1
COMPONENT-SEQ RQ39.2
TRANS-SEQ
ICDSET3 COMPANY KeyChange, Subset IC52.1 IC850
LOCATION Where LOT-SERIAL != Spaces
ITEM And STATUS != Zeroes
LOT-SERIAL
UPDATE-DATE*
UPDATE-TIME*
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
DOC-TYPE
SYSTEM-CD
DOCUMENT
ICDSET4 COMPANY KeyChange, Subset
ITEM Where DOC-TYPE = "DT"
LOT-SERIAL Or DOC-TYPE = "IS"
UPDATE-DATE* Or DOC-TYPE = "IT"
UPDATE-TIME* Or DOC-TYPE = "SH"
LOCATION
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
DOC-TYPE
SYSTEM-CD
DOCUMENT
ICTRANSDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bin ICBIN Required
When ICD-BIN != Spaces
ICD-COMPANY -> ICB-COMPANY
ICD-LOCATION -> ICB-LOCATION
ICD-BIN -> ICB-BIN
Company ICCOMPANY Required
ICD-COMPANY -> ICC-COMPANY
Item ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ICD-ITEM -> ITE-ITEM
Itserial ITSERIAL Not Required
ICD-COMPANY -> SER-COMPANY
ICD-ITEM -> SER-ITEM
ICD-LOT-SERIAL -> SER-SERIAL
Rec Adjust PORECLINE Required
When ICD-DOC-TYPE = "RA"
ICD-COMPANY -> PRL-COMPANY
ICD-DOCUMENT -> PRL-REC-NUMBER
ICD-LINE-NBR -> PRL-LINE-NBR
Rec Reject PORECLINE Required
When ICD-DOC-TYPE = "RJ"
ICD-COMPANY -> PRL-COMPANY
ICD-DOCUMENT -> PRL-REC-NUMBER
ICD-LINE-NBR -> PRL-LINE-NBR
Receive PORECLINE Required
When ICD-DOC-TYPE = "PO"
ICD-COMPANY -> PRL-COMPANY
ICD-DOCUMENT -> PRL-REC-NUMBER
ICD-LINE-NBR -> PRL-LINE-NBR
|