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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
ICD-COMPANY
Element: Company | Numeric 4
Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
|
|
ICD-LOCATION
Element: Location | Alpha 5
This field contains a valid stocking
location within the company inventory.
|
|
ICD-DOC-TYPE
Element: Doc Type | Alpha 2
This field contains the type of
transaction.
AJ = Adjustment
BT = Bin Transfer
CR = Customer Return
DT = Direct Transfer
HD = Lot Hold
IR = Intransit Receiving
IS = Issue
IT = Transfer Issue
PI = Physical Inventory Adjustmnet
PO = PO Receiving
RA = Receiving Adjustment
RC = Receipt
RJ = Inspection Reject
RR = Requisition Return
RT = Receiving Transfer
SH = Shipment
VR = Vendor Return |
|
ICD-SYSTEM-CD
Element: System Cd | Alpha 2
This field indicates on what system the
transaction originated.
CX = Case Cart
IC = Inventory Control
OE = Order Entry
RQ = Requisition
PO = Purchase Order
WO = Work Order |
|
ICD-DOCUMENT
Element: Document | Alpha 10 (Right Justified)
This field contains the document ID,
which is used to reference transactions
in a transaction form.
Transactions are released (updated) to
the Inventory Control system by document
ID.
|
|
ICD-SHIPMENT-NBR
Element: Shipment Nbr | Numeric 10
This field contains the shipment
number. One order can have several
shipment numbers if the items of the
order were not shipped at the same time.
|
|
ICD-LINE-NBR
Element: Line Nbr | Numeric 6
This field contains the line number.
|
|
ICD-COMPONENT-SEQ
Element: Seq | Numeric 3
This field contains the record sequence
number.
|
|
ICD-UOM
Element: Uom | Alpha 4
This field contains the transaction UOM
|
|
ICD-LOT-SERIAL
Element: Serial | Alpha 16
This field contains the lot or sublot
number or the serial number for the
item.
|
|
ICD-BIN
Element: Bin | Alpha 7
This field contains a storage area for
an item or any number of items.
|
|
ICD-TRANS-DATE
Element: Trans Date | Numeric 8 (yyyymmdd)
This is the date a document was created
for one or more transactions.
|
|
ICD-ITEM
Element: Item | Alpha 32
This field contains the item number
defined in IC12.1 (Item Location) or
IC10.1 (Item Master and Location).
|
|
ICD-UOM-MULT
Element: Uom Mult | Signed 13.7
This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
|
|
ICD-QUANTITY
Element: Quantity | Signed 13.4
This field contains the quantity of
this detail line.
|
|
ICD-OPEN-QTY
Element: Quantity | Signed 13.4
This field contains the quantity of the
item not yet received. It is used only
for intransit transactions.
|
|
ICD-ORIGINAL-QTY
Element: Quantity | Signed 13.4
This field contains the original
quantity of the detail line. It is used
only for intransit transactions.
|
|
ICD-SECONDARY-QTY
Element: Secondary Qty | Signed 13.4
This field contains a secondary
quantity that is tracked if the item is
a catch weight item.
|
|
ICD-HOLD-FLAG
Element: Hold Flag | Alpha 1
This field is used to place a lot on
hold, not allowing any issues or
transfers.
N = No
Y = Yes |
|
ICD-EXPIRE-DATE
Element: Expire Date | Numeric 8 (yyyymmdd)
This field contains the expiration date
for the lot.
|
|
ICD-UPDATE-DATE
Element: Update Date | Numeric 8 (yyyymmdd)
This field contains the system date the
transaction was updated (released) to
the Inventory Control system.
This date is established by the system
when a transaction document is released
in a transaction form.
|
|
ICD-UPDATE-TIME
Element: Update Time | Numeric 6
This field contains the system time
when the transaction was updated
(released) to the Inventory Control
system.
This time is established by the system
when you release a transaction document
in a transaction form.
|
|
ICD-STATUS
Element: Status | Numeric 1
This field displays the status of the
transaction.
0 = Unreleased
1 = Released |
|
ICD-ACTUAL-TIME
Element: Actual Time | Numeric 4
This field contains the system time
when this transaction took place.
|
|
ICD-TRAN-COUNTER
Element: Tran Counter | Numeric 6
This field contains a transaction
object number used to determine the
sequence of updating of the Item
Location file.
|
|
ICD-TRANS-BARCODE
Element: Trans Barcode | Alpha 25
|
|
ICD-TRANS-SEQ
Element: Trans Seq | Numeric 6
|
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| ICDSET1 |
COMPANY
LOCATION
DOC-TYPE
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
|
|
|
| ICDSET2 |
COMPANY
LOCATION
DOC-TYPE
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
ITEM
LOT-SERIAL
BIN
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
|
|
|
| ICDSET3 |
COMPANY
LOCATION
ITEM
LOT-SERIAL
UPDATE-DATE*
UPDATE-TIME*
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
DOC-TYPE
SYSTEM-CD
DOCUMENT
|
|
KeyChange, Subset |
| Where | | LOT-SERIAL |
!= | Spaces | |
| And | | STATUS |
!= | Zeroes | |
|
|
| ICDSET4 |
COMPANY
ITEM
LOT-SERIAL
UPDATE-DATE*
UPDATE-TIME*
LOCATION
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
DOC-TYPE
SYSTEM-CD
DOCUMENT
|
|
KeyChange, Subset |
| Where | | DOC-TYPE |
= | "DT" | |
| Or | | DOC-TYPE |
= | "IS" | |
| Or | | DOC-TYPE |
= | "IT" | |
| Or | | DOC-TYPE |
= | "SH" | |
|
|
| ICDSET5 |
COMPANY
TRANS-DATE
UPDATE-DATE
UPDATE-TIME
LOCATION
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
TRANS-SEQ
DOC-TYPE
SYSTEM-CD
DOCUMENT
|
|
|
