The Transaction History file contains the history of an item's inventory
transactions summarized by transaction type and period or year. This history
file is updated by the Order Entry, Purchase Order, and Inventory Control
systems.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
ICH-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.
|
|
ICH-LOCATION
Element: Location | Alpha 5
This field contains a valid stocking
location within the company inventory.
|
|
ICH-ITEM
Element: Item | Alpha 32
This field contains the item
identifier.
|
|
ICH-YEAR
Element: Year | Numeric 4
This is the year as determined by the
current year in the Company Parameter
file.
|
|
ICH-QUARTER
Element: Quarter | Numeric 1
This field contains the quarter of the
history. The quarter is used for weekly
history.
0 = Monthly Company
1 = First Quarter
2 = Second Quarter
3 = Third Quarter
4 = Fourth Quarter |
|
ICH-BEG-SOH-QTY
Element: Quantity | Signed 13.4
This field contains the beginning
stock-on-hand quantity at the beginning
of the year. It is updated when Closing
(IC190) is run for year end closing.
|
|
ICH-BEG-CLOSE-CST
Element: Intl Amt | Signed 18.2
This field contains the unit cost of
the beginning stock-on-hand quantity
when IC190 (Closing) is run.
|
|
ICH-ISSUE-QTY
Element: Quantity | Signed 13.4 Occurs 14 Times
This field contains the total issued
quantity for the period.
|
|
ICH-ISSUE-COST
Element: Intl Amt | Signed 18.2 Occurs 14 Times
This field contains the total cost of
all issues for the period.
|
|
ICH-SALES-QTY
Element: Quantity | Signed 13.4 Occurs 14 Times
This field contains the total sales
quantity for the period.
|
|
ICH-SALES-COST
Element: Intl Amt | Signed 18.2 Occurs 14 Times
This field contains the total cost of
all sales for the period.
|
|
ICH-SALES-PRICE
Element: Intl Amt | Signed 18.2 Occurs 14 Times
This field contains the total price of
all sales for the period.
|
|
ICH-ADJ-IN-QTY
Element: Quantity | Signed 13.4 Occurs 14 Times
This field contains the total quantity
of all incoming adjustments for the
period.
|
|
ICH-ADJ-OUT-QTY
Element: Quantity | Signed 13.4 Occurs 14 Times
This field contains the total quantity
of all outgoing adjustments for the
period.
|
|
ICH-ADJ-OUT-COST
Element: Intl Amt | Signed 18.2 Occurs 14 Times
This field contains the total cost of
all outgoing adjustments for the period.
|
|
ICH-TRAN-IN-QTY
Element: Quantity | Signed 13.4 Occurs 14 Times
This field contains the total quantity
of all incoming transfers for the
period.
|
|
ICH-TRAN-OUT-QTY
Element: Quantity | Signed 13.4 Occurs 14 Times
This field contains the total quantity
of all outgoing transfers for the
period.
|
|
ICH-TRAN-OUT-COST
Element: Intl Amt | Signed 18.2 Occurs 14 Times
This field contains the total cost of
all outgoing transactions for the
period.
|
|
ICH-RECEIPT-QTY
Element: Quantity | Signed 13.4 Occurs 14 Times
This field contains the total quantity
of all receipts for the period.
|
|
ICH-PER-END-QTY
Element: Quantity | Signed 13.4 Occurs 14 Times
This field contains the stock-on-hand
quantity at the time of the period
close. This is updated when Closing
(IC190) is run for period end closing.
|
|
ICH-CLOSE-COST
Element: Intl Amt | Signed 18.2 Occurs 14 Times
This field contains the cost of the
item updated at the time of the period
end closing (IC190).
|
|
ICH-NDC-NBR
Element: Ndc Nbr | Alpha 15
National Drug Code.
|
|
ICH-GRANT-NBR
Element: Grant Nbr | Alpha 12
|
|
