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