The Inventory Transaction file contains all the inventory transactions
entered in the Inventory Control system. Each transaction type is given a
unique document type.
FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
ICT-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.
|
|
ICT-LOCATION Element: Location | Alpha 5 This field contains a valid stocking
location within the company inventory.
|
|
ICT-DOC-TYPE Element: Doc Type | Alpha 2 This field contains the type of
transaction.
AJ = Adjustment BT = Bin Transfer CA = Cost Adjustment CR = Customer Return DT = Direct Transfer IR = Intransit Receiving IS = Issue IT = Transfer Issue PI = Physical Inventory Adjustment RC = Receipt RR = Requisition Return RT = Receiving Transfer SH = Shipment VA = Vendor Return Adjustment VR = Vendor Return PO = PO Receiving RA = PO Receiving Adjustment RJ = Rejected Inspection Item AC = Accepted Inspection Item VI = Vendor Return Adj to Inventory AR = Receipt Archive |
|
ICT-SYSTEM-CD Element: System Cd | Alpha 2 This field indicates on what system the
transaction originated.
IC = Inventory Control OE = Order Entry RQ = Requisition CX = Case Cart PO = Purchase Order WO = Work Order PH = Pharmacy |
|
ICT-DOCUMENT Element: Document | Alpha 10 (Right Justified) This field identifies the document from
which this transaction record was
created.
|
|
ICT-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.
|
|
ICT-DOCUMENT-SEQ Element: Seq | Numeric 3 This field is a counter field. It is
used in the Warehouse system to create
an audit trail for the Undo form action
in case a shipment is processed multiple
times.
|
|
ICT-LINE-NBR Element: Line Nbr | Numeric 6 This field displays the system-assigned
transaction number.
|
|
ICT-COMPONENT-SEQ Element: Seq | Numeric 3 This field contains the record sequence
number.
|
|
ICT-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record
was updated.
|
|
ICT-UPDATE-TIME Element: Update Time | Numeric 6 This field contains the system time
when the record was updated.
|
|
ICT-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.
|
|
ICT-TRANS-DATE Element: Trans Date | Numeric 8 (yyyymmdd) The date of the transaction.
|
|
ICT-ITEM Element: Item | Alpha 32 This field contains the item
identifier.
|
|
ICT-SOH-QTY Element: Quantity | Signed 13.4 This field contains the stock-on-hand
quantity before this transaction.
|
|
ICT-QUANTITY Element: Quantity | Signed 13.4 This field contains the quantity of the
transaction.
|
|
ICT-ORIGINAL-QTY Element: Quantity | Signed 13.4 This field contains the original
intransit quantity. It is used only for
intransit transfers.
|
|
ICT-OPEN-QTY Element: Quantity | Signed 13.4 This field contains the open intransit
quantity not yet received.
|
|
ICT-STOCK-UOM Element: Uom | Alpha 4 This field contains the stock unit of
measure for the item.
|
|
ICT-UNIT-COST Element: Intl Cost | Signed 18.5 This field contains the unit cost for
this transaction.
|
|
ICT-UNIT-COST-CURR Element: Intl Cost | Signed 18.5 This field contains the unit cost for
this transaction in transaction
currency.
|
|
ICT-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a
particular account as determined by the
account currency.
0 2 |
|
ICT-ADD-UNIT-COST Element: Intl Cost | Signed 18.5 This field contains the add-on unit
cost or freight cost that is added to
the incoming unit cost to determine a
new unit cost for this intransit
receiving.
|
|
ICT-BASE-COST Element: Intl Cost | Signed 18.5 This field contains the base cost used
for calculating the standard cost of an
item, if the company uses the standard
costing method. The base cost is then
used for standard cost variance
calculation.
Also, this field is used for negative
average costing (if the company uses
average costing and this field is
flagged for allowing negative
stock-on-hand). This field captures the
average cost of the item prior to the
transaction.
|
|
ICT-CURRENT-COST Element: Intl Cost | Signed 18.5 This field contains the cost used for
capturing the current cost of the item
when the transaction is released. This
is the same overall cost used for
valuation, and is calculated by the
costing method of the company.
|
|
ICT-UNIT-PRICE Element: Intl Cost | Signed 18.5 This field is not used by the Inventory
Control system.
|
|
ICT-TRAN-UOM Element: Uom | Alpha 4 This field contains the entered unit of
measure on this transaction.
|
|
ICT-TRAN-UOM-MULT Element: Uom Mult | Signed 13.7 This field contains the transaction
unit of measure multiplier.
|
|
ICT-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.
|
|
ICT-SEC-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
ICT-SEC-UOM-MULT Element: Uom Mult | Signed 13.7 This field contains the secondary
quantity unit of measure multiplier. It
is used to convert the stock-on-hand
quantity to the secondary quantity or
visa versa.
|
|
ICT-GL-DATE Element: Gl Date | Numeric 8 (yyyymmdd) This field contains the date this
transaction is to be posted to General
Ledger.
|
|
ICT-EST-DEL-DATE Element: Est Del Date | Numeric 8 (yyyymmdd) This field contains the estimated
delivery date. This field is required on
an intransit transfer transaction.
|
|
ICT-REFERENCE Element: Reference | Alpha 10 (Lower Case) This field contains the reference
information.
|
|
ICT-BIN Element: Bin | Alpha 7 This field contains a storage area for
an item or any number of items.
|
|
ICT-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code for
the transaction.
|
|
ICT-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
|
|
ICT-ACCT-CATEGORY Element: Acct Category | Alpha 5 Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
|
|
ICT-LINE-COMMENT Element: Line Comment | Alpha 40 (Lower Case) This field contains the user-defined
comments for the transaction line. These
comments are for reference purposes
only.
|
|
ICT-INV-ACCT-UNIT Element: Acct Unit | Alpha 15 This field contains the general ledger
inventory account unit.
|
|
ICT-INV-ACCOUNT Element: Account | Numeric 6 This field contains the general ledger
inventory account number.
|
|
ICT-INV-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains the general ledger
inventory subaccount number.
|
|
ICT-OFF-ACCT-UNIT Element: Acct Unit | Alpha 15 This field contains the general ledger
offset account unit.
|
|
ICT-OFF-ACCOUNT Element: Account | Numeric 6 This field contains the general ledger
offset account number.
|
|
ICT-OFF-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains the general ledger
offset subaccount number.
|
|
ICT-OFF-DIST-CO Element: Company | Numeric 4 Company number used for posting the
transaction to the Offset Account
|
|
ICT-VAR-ACCT-UNIT Element: Acct Unit | Alpha 15 This field contains the general ledger
cost variance account unit.
|
|
ICT-VAR-ACCOUNT Element: Account | Numeric 6 This field contains the general ledger
cost variance account number.
|
|
ICT-VAR-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains the general ledger
cost variance subaccount number.
|
|
ICT-ADD-ACCT-UNIT Element: Acct Unit | Alpha 15 This field contains the general ledger
add-on cost account unit.
|
|
ICT-ADD-ACCOUNT Element: Account | Numeric 6 This field contains the general ledger
add-on cost account number.
|
|
ICT-ADD-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains the general ledger
add-on cost subaccount number.
|
|
ICT-ADD-DIST-CO Element: Company | Numeric 4 Company number used for posting the
transaction to the Add-On Cost Account
|
|
ICT-STATUS Element: Status | Numeric 1 This field contains the processing
status of the transaction.
0 = Unreleased 1 = Released 2 = General Ledger Updated 5 = Intermediate Status(see IC130) 3 = Non General Ledger |
|
ICT-FR-DOCUMENT Element: Document | Alpha 10 (Right Justified) This field contains the document number
for the from-location for a transfer
transaction.
|
|
ICT-FROM-TO-BIN Element: Bin | Alpha 7 This field contains the from or to bin
for a transfer transaction.
|
|
ICT-FROM-TO-LOC Element: Location | Alpha 5 This field contains the from or to
location for a transfer location.
|
|
ICT-DETAIL-BAL-FL Element: All Flag | Alpha 1 This field is used to balance the bin,
lot, and serial number detail lines with
the transaction lines before releasing
the document.
N = No Y = Yes |
|
ICT-LAST-DST-SEQ Element: Seq | Numeric 3 This field contains the record sequence
number.
|
|
ICT-ACTUAL-TIME Element: Actual Time | Numeric 4 This field contains the system time
when a transaction took place. This is
in 24-hour format (HHMM).
|
|
ICT-FROM-TO-CMPY Element: Company | Numeric 4 This field contains the from or to
company for an intercompany transaction.
|
|
ICT-TO-CO-B-UCOST Element: Intl Cost | Signed 18.5 This field contains the base unit cost
for the To company. This field is
converted from the 'From' company unit
cost. It can be in a different currency
if the two companies have different base
currencies.
|
|
ICT-FROM-CURR-CD Element: Currency Code | Alpha 5 This field contains the currency code
of the company that initiated the
transaction.
|
|
ICT-TO-CURR-CD Element: Currency Code | Alpha 5 This field contains the currency code
of the company to which the inventory is
being transferred.
|
|
ICT-HIST-PERIOD Element: Hist Period | Numeric 2 This field and the history period to
which the transaction was posted ties a
transaction to the period and year to
which it was posted in the history file.
This field is updated based on the
transaction date when General Ledger
Interface (IC130) is run.
|
|
ICT-HIST-YEAR Element: Year | Numeric 4 This field and the HIST YEAR field tie
a transaction to the period and year it
was posted to on the history file. This
field is updated based on the
transaction date when General Ledger
Interface (IC130) is run.
|
|
ICT-OPERATOR-ID Element: Operator | Alpha 10 This field contains the terminal sign
on identifier when this transaction was
created.
|
|
ICT-TO-UOM Element: Uom | Alpha 4 This field contains the unit of measure
resulting from a bin-to-bin transfer
from one unit of measure to another.
This is also used by IC22.1 (Transfers)
to store the unit of measure of a
quantity being transferred. It is only
used for intransit transfers.
|
|
ICT-KIT-FL Element: Kit Fl | Alpha 1 This field is used to indicate that
this transaction is for kit item.
|
|
ICT-BL-INVOICED Element: Bl Invoiced | Alpha 1 Not currently used.
|
|
ICT-SA-INVOICED Element: Sa Invoiced | Alpha 1 Not currently used.
|
|
ICT-MATCH-DTL-KEY Element: Match Dtl Key | Alpha 85
|
|
ICT-NDC-NBR Element: Ndc Nbr | Alpha 15 National Drug Code.
|
|
ICT-GRANT-NBR Element: Grant Nbr | Alpha 12
|
|
ICT-TRANS-SEQ Element: Trans Seq | Numeric 6
|
|
ICT-ENTERED-ITEM Element: Entered Item | Alpha 25
|
|
ICT-ENTRY-FL Element: Entry Fl | Alpha 1
1 = Item 2 = UPC 3 = UPN1 4 = UPN2 5 = NDC 6 = SKU |
|
ICT-MANUF-ID Element: Manuf Id | Numeric 4 A unique idenitifier for a manufacturer
|
|
ICT-MANUF-NBR Element: Manuf Nbr | Alpha 35 This is the identifier that the
manufacturer has assigned to an item.
|
|
ICT-ST-FACILITY Element: St Facility | Alpha 15 A unique identifier for a ship to
facility.
|
|
ICT-EAM-OPER-NBR Element: Operation Nbr | Numeric 4
|
|
ICT-EAM-SEQ-NBR Element: Seq Nbr | Numeric 4
|
|
ICT-EAM-WO-NBR Element: Work Order | Numeric 8
|
|
ICT-CREATED-BY Element: Operator | Alpha 10
|
|
ICT-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd)
|
|
ICT-LAST-UPDT-TIME Element: Time | Numeric 8
|
|
ICT-LAST-UPDATE-BY Element: Operator | Alpha 10
|
|
ICT-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15
|
|
ICT-GLBL-DOC-TYPE Element: Glbl Doc Type | Alpha 10
|
|
ICT-TEMP-HOLD Element: Temp Hold | Alpha 1
A = Approved by Engine S = Sent for Approval |
|