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 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 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
ICD-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
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
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
...
ICD-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
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
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
...
ICD-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
CR = Customer Return BL130 BL20.1
DT = Direct Transfer BL20.3 BL21.2
HD = Lot Hold BL21.5 BL29.1
IR = Intransit Receiving BL29.2 BL520
IS = Issue BL820 BL92.1
IT = Transfer Issue IC175 IC22.1
PI = Physical Inventory Adjustmnet IC22.2 IC23.1
PO = PO Receiving IC23.2 IC23.3
RA = Receiving Adjustment IC23.4 IC23.5
RC = Receipt IC25.1 IC26.1
RJ = Inspection Reject IC26.2 IC28.1
RR = Requisition Return IC29.1 IC29.2
RT = Receiving Transfer IC29.3 IC500
SH = Shipment IC850 MA180
VR = Vendor Return 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
...
ICD-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
CX = Case Cart AP27.1 AP30.4
IC = Inventory Control BL120 BL122
OE = Order Entry BL130 BL20.1
RQ = Requisition BL20.3 BL21.2
PO = Purchase Order BL21.5 BL29.1
WO = Work Order BL29.2 BL520
BL820 BL92.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
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
...
ICD-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Element: Document ID This field contains the document ID, AP131 AP25.1
which is used to reference transactions AP25.2 AP26.1
in a transaction form. AP27.1 AP30.4
BL120 BL122
Transactions are released (updated) to BL130 BL20.1
the Inventory Control system by document BL20.3 BL21.2
ID. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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
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
...
ICD-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
IC22.1 IC22.2
IC23.3 IC23.4
IC23.5 IC25.1
IC28.1 IC29.1
IC29.2 IC29.3
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
...
ICD-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line 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
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
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
...
ICD-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
IC22.1 IC22.2
IC23.3 IC23.4
IC23.5 IC25.1
IC28.1 IC29.1
IC29.2 IC29.3
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
...
ICD-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the transaction UOM 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
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
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
...
ICD-LOT-SERIAL Alpha 16 AP125 AP126
Element: Serial Number This field contains the lot or sublot AP131 AP25.1
number or the serial number for the AP25.2 AP26.1
item. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 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
...
ICD-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
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 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
...
ICD-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Transaction DaThis is the date a document was created AP131 AP25.1
for one or more transactions. 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.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 OE10.5
OE10.6 OE10.7
...
ICD-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item number AP131 AP25.1
defined in IC12.1 (Item Location) or AP25.2 AP26.1
IC10.1 (Item Master and Location). 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.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
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
...
ICD-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure This field contains the multiplier for AP131 AP25.1
Multiplier converting this unit of measure to the AP25.2 AP26.1
stock unit of measure. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC22.1 IC22.2
IC23.4 IC23.5
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
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
...
ICD-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of AP131 AP25.1
this detail line. 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.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 MA80.1
MAI1.1 OE10.1
...
ICD-OPEN-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of the AP131 AP25.1
item not yet received. It is used only AP25.2 AP26.1
for intransit transactions. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC22.1 IC22.2
IC23.1 IC23.2
IC23.4 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
...
ICD-ORIGINAL-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the original AP131 AP25.1
quantity of the detail line. It is used AP25.2 AP26.1
only for intransit transactions. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
OE116 OE129
OE13.2 OE13.3
...
ICD-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
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
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
...
ICD-HOLD-FLAG Alpha 1 AP125 AP126
Element: On Hold Flag This field is used to place a lot on AP131 AP25.1
hold, not allowing any issues or AP25.2 AP26.1
transfers. AP27.1 AP30.4
N = No BL120 BL122
Y = Yes BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC22.1 IC22.2
IC25.1 IC28.1
IC29.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
...
ICD-EXPIRE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Expiration DatThis field contains the expiration date AP131 AP25.1
for the lot. 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 IC29.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 OE13.2
OE13.3 OE13.5
...
ICD-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Update Date This field contains the system date the AP131 AP25.1
transaction was updated (released) to AP25.2 AP26.1
the Inventory Control system. AP27.1 AP30.4
BL120 BL122
This date is established by the system BL130 BL20.1
when a transaction document is released BL20.3 BL21.2
in a transaction form. 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 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
...
ICD-UPDATE-TIME Numeric 6 AP125 AP126
Element: Update Time This field contains the system time AP131 AP25.1
when the transaction was updated AP25.2 AP26.1
(released) to the Inventory Control AP27.1 AP30.4
system. BL120 BL122
BL130 BL20.1
This time is established by the system BL20.3 BL21.2
when you release a transaction document BL21.5 BL29.1
in a transaction form. 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 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
...
ICD-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP131 AP25.1
transaction. AP25.2 AP26.1
0 = Unreleased AP27.1 AP30.4
1 = Released 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 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
...
ICD-ACTUAL-TIME Numeric 4 AP125 AP126
Element: Actual Time This field contains the system time AP131 AP25.1
when this transaction took place. 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
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 OE10.8
OE11.1 OE11.4
...
ICD-TRAN-COUNTER Numeric 6
Element: Tran Counter This field contains a transaction
object number used to determine the
sequence of updating of the Item
Location file.
ICD-TRANS-BARCODE Alpha 25
Element: Trans Barcode
ICD-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
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
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
...
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 OE30.1 OE30.2
COMPONENT-SEQ OE30.3 OE30.4
TRANS-SEQ OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RQ35.1 RQ39.1
...
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
|