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-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-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
|
|
