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
PO133 PO230 RQ39.1 RQ39.2
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 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 IC850
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 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 PO100 PO101 PO122 PO131
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.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 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 POI3.1 POID.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 POD0.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICD-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP20.1
resource type = V. Identifies the HR AP20.2 AP20.3
company if the resource type = E. It is AP20.4 AP20.5
blank for type A, P or Q resources. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-LOCATION Alpha 5 AP125 AP126
Element: Location This field contains a valid stocking AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-DOC-TYPE Alpha 2 AP125 AP126
Element: Doc 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 AP21.1
CR = Customer Return AP23.1 AP25.1
DT = Direct Transfer AP25.2 AP26.1
HD = Lot Hold AP27.1 AP30.4
IR = Intransit Receiving API1.1 BL120
IS = Issue BL122 BL130
IT = Transfer Issue BL20.1 BL20.3
PI = Physical Inventory Adjustmnet BL21.2 BL21.5
PO = PO Receiving BL29.1 BL29.2
RA = Receiving Adjustment BL520 BL820
RC = Receipt BL92.1 IC850
RJ = Inspection Reject MA180 MA41.1
RR = Requisition Return MA41.2 MA41.4
RT = Receiving Transfer MA41.7 MA43.1
SH = Shipment MA43.2 MA43.3
VR = Vendor Return MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-SYSTEM-CD Alpha 2 AP125 AP126
Element: System Cd 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 AP21.1
OE = Order Entry AP23.1 AP25.1
RQ = Requisition AP25.2 AP26.1
PO = Purchase Order AP27.1 AP30.4
WO = Work Order API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Element: Document 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 AP21.1
Transactions are released (updated) to AP23.1 AP25.1
the Inventory Control system by document AP25.2 AP26.1
ID. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-SHIPMENT-NBR Numeric 10 AP125 AP126
Element: Shipment Nbr This 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
ICD-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr This field contains the line number. 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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-COMPONENT-SEQ Numeric 3 AP125 AP126
Element: Seq This field contains the record sequence AP131 AP20.1
number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
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
...
ICD-UOM Alpha 4 AP125 AP126
Element: Uom This field contains the transaction UOM 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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-LOT-SERIAL Alpha 16 AP125 AP126
Element: Serial 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Trans 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-ITEM Alpha 32 AP125 AP126
Element: Item 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-UOM-MULT Signed 13.7 AP125 AP126
Element: Uom Mult This field contains the multiplier for AP131 AP20.1
converting this unit of measure to the AP20.2 AP20.3
stock unit of measure. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-SECONDARY-QTY Signed 13.4 AP125 AP126
Element: Secondary Qty 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-HOLD-FLAG Alpha 1 AP125 AP126
Element: 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 AP21.1
Y = Yes AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-EXPIRE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Expire Date This field contains the expiration date AP131 AP20.1
for the lot. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICD-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Update 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 AP21.1
This date is established by the system AP23.1 AP25.1
when a transaction document is released AP25.2 AP26.1
in a transaction form. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
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 AP21.1
AP23.1 AP25.1
This time is established by the system AP25.2 AP26.1
when you release a transaction document AP27.1 AP30.4
in a transaction form. API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
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 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
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC850
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
ICTRANSDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICDSET1 COMPANY IC850 PO131
LOCATION PO133 PO230
DOC-TYPE POD0.1
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
ICDSET2 COMPANY KeyChange RQ35.1 RQ39.1
LOCATION RQ39.2
DOC-TYPE
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
ITEM
LOT-SERIAL
BIN
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
ICDSET3 COMPANY KeyChange, Subset 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
|