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 PO131 PO133 PO230
PO52.1 PO32.2 RQ39.1 RQ39.2 IC52.1
UPDATED BY
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
IC29.1 IC29.2 IC29.3 IC300 IC500 IC850
IC90.1 IC964 MA300 OE114 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE830 OE950 PO30.1 PO30.2 PO31.1 PO33.1
PO34.1 PO35.1 PO39.1 PO530 RQ35.1 WH130
WH132 WH190 WH30.1 WH30.2 WH30.3 WH31.1
WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 WH966 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICD-COMPANY Numeric 4 BL92.1 IC175
Company The company number represents an IC22.1 IC22.2
established company and is entered on IC23.3 IC23.4
all function codes. IC23.5 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC29.3 IC500
IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
ICD-LOCATION Alpha 5 BL92.1 IC175
Location Code This field contains a valid stock IC22.1 IC22.2
location within the company inventory. IC23.3 IC23.4
IC23.5 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC29.3 IC500
IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
ICD-DOC-TYPE Alpha 2 BL92.1 IC175
Document Type This field contains the type of IC22.1 IC22.2
transaction. IC23.1 IC23.2
AJ = Adjustment IC23.3 IC23.4
BT = Bin Transfer IC23.5 IC25.1
CA = Cost Adjustment IC26.1 IC26.2
CR = Credit Return to Stock IC29.1 IC29.2
HD = Hold For Inspection IC29.3 IC500
IR = Intransit Receiving IC850 IC964
IS = Issue OE114 OE30.1
IT = Issue Transfer OE30.2 OE30.3
PO = PO Receiving OE30.4 OE30.5
RA = Rec Adjustment OE30.6 OE30.7
RC = Receipt OE30.9 OE830
RJ = Reject OE950 PO30.1
RT = Receiving Transfer PO31.1 PO33.1
SH = Shipping PO34.1 PO35.1
RR = Requisition Return PO39.1 PO530
VR = Vendor Returns RQ35.1 WH130
DT = Direct Transfer WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
...
ICD-SYSTEM-CD Alpha 2 BL92.1 IC175
System Code This field indicates on what system IC22.1 IC22.2
the transaction originated. IC23.1 IC23.2
CX = Case Cart IC23.3 IC23.4
IC = Inventory Control IC23.5 IC25.1
OE = Order Entry IC26.1 IC26.2
RQ = Requisition IC29.1 IC29.2
PO = Purchase Order IC29.3 IC500
WO = Work Order IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
ICD-DOCUMENT Alpha 10 (Right Justified) BL92.1 IC175
Document ID This field contains the document ID, IC22.1 IC22.2
which is used to reference transactions IC23.1 IC23.2
in a transaction form. IC23.3 IC23.4
IC23.5 IC25.1
Transactions are released (updated) to IC26.1 IC26.2
the Inventory Control system by document IC29.1 IC29.2
ID. IC29.3 IC500
IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO33.1 PO34.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
ICD-SHIPMENT-NBR Numeric 10 BL92.1 IC22.1
Shipment Number This field contains the shipment IC22.2 IC23.3
number. One order can have several IC23.4 IC23.5
shipment numbers if the items of the IC25.1 IC29.1
order were not shipped at the same time. IC29.2 IC29.3
IC500 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WH966
WO132 WO140
ICD-LINE-NBR Numeric 6 BL92.1 IC175
Line Number This field contains the line number. IC22.1 IC22.2
IC23.3 IC23.4
IC23.5 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC29.3 IC500
IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
ICD-COMPONENT-SEQ Numeric 3 BL92.1 IC22.1
Component Sequence This field contains the component IC22.2 IC23.3
Number sequence number. IC23.4 IC23.5
IC25.1 IC29.1
IC29.2 IC29.3
IC500 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
ICD-SEQ Numeric 3 BL92.1 IC175
Sequence Number This field contains unique numbers IC22.1 IC22.2
assigned to each detail line records for IC23.3 IC23.4
the transaction. IC23.5 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC29.3 IC500
IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO33.1 PO34.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
ICD-UOM Alpha 4 BL92.1 IC22.1
Unit of Measure This field contains the valid stock IC22.2 IC23.3
unit of measure for this item. IC23.4 IC23.5
IC25.1 IC29.1
IC29.2 IC29.3
IC500 IC850
IC90.1 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
ICD-LOT-SERIAL Alpha 16 BL92.1 IC175
Lot/Serial Number This field contains the lot or sublot IC22.1 IC22.2
number or the serial number for the IC23.3 IC23.4
item. IC23.5 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC500 IC850
IC964 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 PO39.1
PO530 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
ICD-BIN Alpha 7 BL92.1 IC175
Bin This field contains a storage area for IC22.1 IC22.2
an item or any number of items. IC23.1 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC29.1
IC29.2 IC29.3
IC500 IC850
IC964 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 PO39.1
PO530 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
...
ICD-TRANS-DATE Numeric 8 (yyyymmdd) BL92.1 IC175
Transaction Date This is the date a document was created IC20.1 IC20.2
for one or more transactions. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC500
IC850 IC90.1
IC964 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO30.1 PO31.1
PO33.1 PO34.1
PO35.1 PO39.1
PO530 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
ICD-ITEM Alpha 32 BL92.1 IC175
Item Number This field contains the item number IC20.1 IC20.2
defined in IC12.1 (Item Location) or IC21.1 IC21.2
IC10.1 (Item Master and Location). IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC23.5 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC29.3 IC500
IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
...
ICD-UOM-MULT Signed 13.7 BL92.1 IC22.1
Unit of Measure This field contains the multiplier for IC22.2 IC23.4
Multiplier converting this unit of measure to the IC23.5 IC25.1
stock unit of measure. IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
IC964 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 PO39.1
PO530 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
ICD-QUANTITY Signed 13.4 BL92.1 IC175
Quantity This field contains the quantity of IC20.1 IC20.2
this detail line. 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
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
IC964 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO30.1 PO31.1
PO33.1 PO34.1
PO35.1 PO39.1
PO530 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
...
ICD-OPEN-QTY Signed 13.4 BL92.1 IC22.1
Open Quantity This field contains the quantity of the IC22.2 IC23.1
item not yet received. It is used only IC23.2 IC23.4
for intransit transactions. IC25.1 IC500
IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO34.1 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
ICD-ORIGINAL-QTY Signed 13.4 BL92.1 IC22.1
Original Quantity This field contains the original IC22.2 IC500
quantity of the detail line. It is used IC850 IC964
only for intransit transactions. OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO30.1
PO31.1 PO33.1
PO34.1 PO35.1
PO530 RQ35.1
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
ICD-SECONDARY-QTY Signed 13.4 BL92.1 IC175
Secondary Quantity This field contains a secondary IC20.1 IC20.2
quantity that is tracked if the item is IC21.1 IC21.2
a catch weight item. IC22.1 IC22.2
IC23.1 IC23.2
IC23.3 IC23.4
IC24.1 IC24.2
IC25.1 IC29.1
IC29.3 IC500
IC850 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
ICD-HOLD-FLAG Alpha 1 IC22.1 IC22.2
On Hold Flag This field is used to place a lot on IC25.1 IC29.1
hold, not allowing any issues or IC500 IC850
transfers. IC964 OE30.1
N = No OE30.2 OE30.3
Y = Yes OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO39.1
PO530 RQ35.1
ICD-EXPIRE-DATE Numeric 8 (yyyymmdd) IC29.1 IC500
Expiration Date This field contains the expiration date IC850 IC964
for the lot. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO39.1 PO530
RQ35.1
ICD-UPDATE-DATE Numeric 8 (yyyymmdd) BL92.1 IC175
Update Date This field contains the system date the IC20.1 IC20.2
transaction was updated (released) to IC21.1 IC21.2
the Inventory Control system. IC22.1 IC22.2
IC23.1 IC23.2
This date is established by the system IC24.1 IC24.2
when a transaction document is released IC25.1 IC26.1
in a transaction form. IC26.2 IC500
IC850 IC90.1
IC964 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO30.1 PO31.1
PO33.1 PO34.1
PO35.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
...
ICD-UPDATE-TIME Numeric 6 BL92.1 IC175
Update Time This field contains the system time IC20.1 IC20.2
when the transaction was updated IC21.1 IC21.2
(released) to the Inventory Control IC22.1 IC22.2
system. IC23.1 IC23.2
IC24.1 IC24.2
This time is established by the system IC25.1 IC26.1
when you release a transaction document IC26.2 IC500
in a transaction form. IC850 IC90.1
IC964 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO30.1 PO31.1
PO33.1 PO34.1
PO35.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
...
ICD-STATUS Numeric 1 BL92.1 IC175
Status This field contains the status of the IC20.1 IC20.2
transaction. IC21.1 IC21.2
0 = Unreleased IC22.1 IC22.2
1 = Released IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC500
IC850 IC90.1
IC964 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO30.1 PO31.1
PO33.1 PO34.1
PO35.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
...
ICD-POTENCY Signed 7.3 BL92.1 IC500
Potency Factor This field is not used by the Inventory IC850 IC964
Control system. OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
ICD-ACTUAL-TIME Numeric 4 BL92.1 IC20.1
Actual Time This field contains the system time IC20.2 IC21.1
when this transaction took place. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC850
IC90.1 IC964
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO30.1
PO31.1 PO33.1
PO34.1 PO35.1
PO39.1 PO530
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
...
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
SEQ IC25.1 IC29.1
IC29.2 IC29.3
IC300 IC500
IC850 IC90.1
MA300 PO131
PO133 PO230
PO30.1 PO30.2
...
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
SEQ OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO32.2 PO33.1
...
ICDSET3 COMPANY Duplicates, 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
SEQ
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-DOC-TYPE -> PRL-DOC-TYPE
ICD-DOCUMENT -> PRL-DOCUMENT
ICD-LINE-NBR -> PRL-LINE-NBR
Rec Reject PORECLINE Required
When ICD-DOC-TYPE = "RJ"
ICD-COMPANY -> PRL-COMPANY
ICD-DOC-TYPE -> PRL-DOC-TYPE
ICD-DOCUMENT -> PRL-DOCUMENT
ICD-LINE-NBR -> PRL-LINE-NBR
Receive PORECLINE Required
When ICD-DOC-TYPE = "PO"
ICD-COMPANY -> PRL-COMPANY
ICD-DOC-TYPE -> PRL-DOC-TYPE
ICD-DOCUMENT -> PRL-DOCUMENT
ICD-LINE-NBR -> PRL-LINE-NBR
|