 |
Lawson Insight Technical Documentation |
|
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 PO133 PO230 RQ39.1
RQ39.2 IC52.1
UPDATED BY
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 IC885
IC90.1 POIJ.1 WH130 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICD-COMPANY Numeric 4 IC175 IC22.1
Company The company number represents an IC22.2 IC23.3
established company and is entered on IC23.4 IC23.5
all function codes. IC25.1 IC26.1
IC26.2 IC29.1
IC29.2 IC29.3
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-LOCATION Alpha 5 IC175 IC22.1
Location Code This field contains a valid stocking IC22.2 IC23.3
location within the company inventory. IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC29.1
IC29.2 IC29.3
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-DOC-TYPE Alpha 2 IC175 IC22.1
Document Type This field contains the type of IC22.2 IC23.1
transaction. IC23.2 IC23.3
AJ = Adjustment IC23.4 IC23.5
BT = Bin Transfer IC25.1 IC26.1
CR = Customer Return IC26.2 IC29.1
DT = Direct Transfer IC29.2 IC29.3
HD = Lot Hold IC500 IC850
IR = Intransit Receiving POIJ.1 WH130
IS = Issue WH33.1 WH33.2
IT = Transfer Issue WH33.3 WH33.4
PI = Physical Inventory Adjustmnet WH33.5 WH33.6
PO = PO Receiving WH33.8 WH33.9
RA = Receiving Adjustment WH34.1 WH34.2
RC = Receipt WH34.3 WH34.4
RJ = Inspection Reject
RR = Requisition Return
RT = Receiving Transfer
SH = Shipment
VR = Vendor Return
ICD-SYSTEM-CD Alpha 2 IC175 IC22.1
System Code This field indicates on what system the IC22.2 IC23.1
transaction originated. IC23.2 IC23.3
CX = Case Cart IC23.4 IC23.5
IC = Inventory Control IC25.1 IC26.1
OE = Order Entry IC26.2 IC29.1
RQ = Requisition IC29.2 IC29.3
PO = Purchase Order IC500 IC850
WO = Work Order POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-DOCUMENT Alpha 10 (Right Justified) IC175 IC22.1
Document ID This field contains the document ID, IC22.2 IC23.1
which is used to reference transactions IC23.2 IC23.3
in a transaction form. IC23.4 IC23.5
IC25.1 IC26.1
Transactions are released (updated) to IC26.2 IC29.1
the Inventory Control system by document IC29.2 IC29.3
ID. IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-SHIPMENT-NBR Numeric 10 IC22.1 IC22.2
Shipment Number This field contains the shipment IC23.3 IC23.4
number. One order can have several IC23.5 IC25.1
shipment numbers if the items of the IC29.1 IC29.2
order were not shipped at the same time. IC29.3 IC500
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-LINE-NBR Numeric 6 IC175 IC22.1
Line Number This field contains the line number. IC22.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC29.1
IC29.2 IC29.3
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-COMPONENT-SEQ Numeric 3 IC22.1 IC22.2
Component Sequence This field contains the component IC23.3 IC23.4
Number sequence number. IC23.5 IC25.1
IC29.1 IC29.2
IC29.3 IC500
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-SEQ Numeric 3 IC175 IC23.3
Sequence Number This field contains unique numbers IC23.4 IC23.5
assigned to each detail line records for IC26.1 IC26.2
the transaction. IC29.1 IC29.2
IC29.3 IC500
IC850 IC885
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-UOM Alpha 4 IC22.1 IC22.2
Unit of Measure This field contains the transaction UOM IC23.3 IC23.4
IC23.5 IC25.1
IC29.1 IC29.2
IC29.3 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-LOT-SERIAL Alpha 16 IC175 IC22.1
Lot/Serial Number This field contains the lot or sublot IC22.2 IC23.3
number or the serial number for the IC23.4 IC23.5
item. IC25.1 IC26.1
IC26.2 IC29.1
IC29.2 IC500
IC850 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-BIN Alpha 7 IC175 IC22.1
Bin This field contains a storage area for IC22.2 IC23.1
an item or any number of items. IC23.3 IC23.4
IC23.5 IC25.1
IC26.1 IC26.2
IC29.1 IC29.2
IC29.3 IC500
IC850 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-TRANS-DATE Numeric 8 (yyyymmdd) IC175 IC20.1
Transaction Date This is the date a document was created IC20.2 IC21.1
for one or more transactions. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-ITEM Alpha 32 IC175 IC20.1
Item Number This field contains the item number IC20.2 IC21.1
defined in IC12.1 (Item Location) or IC21.2 IC22.1
IC10.1 (Item Master and Location). 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
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-UOM-MULT Signed 13.7 IC22.1 IC22.2
Unit of Measure This field contains the multiplier for IC23.4 IC23.5
Multiplier converting this unit of measure to the IC25.1 IC29.1
stock unit of measure. IC29.2 IC29.3
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-QUANTITY Signed 13.4 IC175 IC20.1
Quantity This field contains the quantity of IC20.2 IC21.1
this detail line. 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 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-OPEN-QTY Signed 13.4 IC22.1 IC22.2
Open Quantity This field contains the quantity of the IC23.1 IC23.2
item not yet received. It is used only IC23.4 IC25.1
for intransit transactions. IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-ORIGINAL-QTY Signed 13.4 IC22.1 IC22.2
Original Quantity This field contains the original IC500 IC850
quantity of the detail line. It is used POIJ.1 WH130
only for intransit transactions. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-SECONDARY-QTY Signed 13.4 IC175 IC20.1
Secondary Quantity This field contains a secondary IC20.2 IC21.1
quantity that is tracked if the item is IC21.2 IC22.1
a catch weight item. IC22.2 IC23.1
IC23.2 IC23.3
IC23.4 IC24.1
IC24.2 IC25.1
IC29.1 IC29.3
IC500 IC850
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
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. POIJ.1 WH130
N = No WH33.1 WH33.2
Y = Yes WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-EXPIRE-DATE Numeric 8 (yyyymmdd) IC29.1 IC500
Expiration Date This field contains the expiration date IC850 POIJ.1
for the lot. WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-UPDATE-DATE Numeric 8 (yyyymmdd) IC175 IC20.1
Update Date This field contains the system date the IC20.2 IC21.1
transaction was updated (released) to IC21.2 IC22.1
the Inventory Control system. IC22.2 IC23.1
IC23.2 IC24.1
This date is established by the system IC24.2 IC25.1
when a transaction document is released IC26.1 IC26.2
in a transaction form. IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-UPDATE-TIME Numeric 6 IC175 IC20.1
Update Time This field contains the system time IC20.2 IC21.1
when the transaction was updated IC21.2 IC22.1
(released) to the Inventory Control IC22.2 IC23.1
system. IC23.2 IC24.1
IC24.2 IC25.1
This time is established by the system IC26.1 IC26.2
when you release a transaction document IC500 IC850
in a transaction form. IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-STATUS Numeric 1 IC175 IC20.1
Status This field displays the status of the IC20.2 IC21.1
transaction. IC21.2 IC22.1
0 = Unreleased IC22.2 IC23.1
1 = Released IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC850
IC90.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
ICD-ACTUAL-TIME Numeric 4 IC20.1 IC20.2
Actual Time This field contains the system time IC21.1 IC21.2
when this transaction took place. IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC500
IC850 IC90.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICD-TRAN-COUNTER Numeric 6
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
Trans Barcode
ICD-TRANS-SEQ Numeric 6 IC175 IC22.1
Trans Seq IC22.2 IC23.3
IC23.4 IC23.5
IC25.1 IC26.1
IC26.2 IC29.1
IC29.2 IC29.3
IC500 IC850
IC885 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.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 IC25.1 IC29.1
SEQ IC29.2 IC29.3
IC300 IC500
IC850 IC885
IC90.1 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 RQ39.1 RQ39.2
COMPONENT-SEQ
TRANS-SEQ
SEQ
ICDSET3 COMPANY KeyChange, 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
TRANS-SEQ
SEQ
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
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-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
|