ICHISTORY FILE
Transaction History
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, Inventory Control,
Warehouse, and Requisitions systems.
REFERENCED BY
IC12.1 IC120 IC134 IC135 IC150 IC151
IC152 IC224 IC239 IC242 IC49.1 IC530
UPDATED BY
BL92.1 IC130 IC190 IC300 IC851 OE114
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE830 OE950 PO180 PO31.1
RQ35.1 WH130 WH132 WH190 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 WO132
WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICH-COMPANY Numeric 4 BL92.1 IC130
Company The company number represents an IC851 OE114
established company and is entered on OE30.1 OE30.2
all function codes. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-LOCATION Alpha 5 BL92.1 IC130
Location Code This field contains a valid stock IC851 OE114
location within the company inventory. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-ITEM Alpha 32 BL92.1 IC130
Item Number This field contains the item IC851 OE114
identifier. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-YEAR Numeric 4 BL92.1 IC130
Last Closed Year This is the year as determined by the IC851 OE114
current year in the Company Parameter OE30.1 OE30.2
file. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-QUARTER Numeric 1 BL92.1 IC130
Quarter This field contains the quarter of the IC851 OE114
history. The quarter is used for weekly OE30.1 OE30.2
history. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-BEG-SOH-QTY Signed 13.4 BL92.1 IC130
Beginning This field contains the beginning IC851 OE114
StockOnHand Quantity stock-on-hand quantity at the beginning OE30.1 OE30.2
of the year. It is updated when Closing OE30.3 OE30.4
(IC190) is run for year end closing. OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-BEG-CLOSE-CST Signed 15.2 BL92.1 IC130
Beginning Closing This field contains the unit cost of IC851 OE114
Cost the beginning stock-on-hand quantity OE30.1 OE30.2
when IC190 (Closing) is run. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-ISSUE-QTY Signed 13.4 Occurs 14 Times BL92.1 IC130
Issue Quantity This field contains the total issued IC851 OE114
quantity for the period. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-ISSUE-COST Signed 15.2 Occurs 14 Times BL92.1 IC130
Issue Cost This field contains the total cost of IC851 OE114
all issues for the period. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-SALES-QTY Signed 13.4 Occurs 14 Times BL92.1 IC130
Sales Quantity This field contains the total sales IC851 OE114
quantity for the period. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-SALES-COST Signed 15.2 Occurs 14 Times BL92.1 IC130
Sales Cost This field contains the total cost of IC851 OE114
all sales for the period. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-SALES-PRICE Signed 15.2 Occurs 14 Times BL92.1 IC130
Sales Price This field contains the total price of IC851 OE114
all sales for the period. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-ADJ-IN-QTY Signed 13.4 Occurs 14 Times BL92.1 IC130
Adjustments In This field contains the total quantity IC851 OE114
Quantity of all incoming adjustments for the OE30.1 OE30.2
period. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-ADJ-OUT-QTY Signed 13.4 Occurs 14 Times BL92.1 IC130
Adjustment Out This field contains the total quantity IC851 OE114
Quantity of all outgoing adjustments for the OE30.1 OE30.2
period. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-ADJ-OUT-COST Signed 15.2 Occurs 14 Times BL92.1 IC130
Adjustment Out Cost This field contains the total cost of IC851 OE114
all outgoing adjustments for the period. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-TRAN-IN-QTY Signed 13.4 Occurs 14 Times BL92.1 IC130
Transfers In This field contains the total quantity IC851 OE114
Quantity of all incoming transfers for the OE30.1 OE30.2
period. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-TRAN-OUT-QTY Signed 13.4 Occurs 14 Times BL92.1 IC130
Transfer Out This field contains the total quantity IC851 OE114
Quantity of all outgoing transfers for the OE30.1 OE30.2
period. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-TRAN-OUT-COST Signed 15.2 Occurs 14 Times BL92.1 IC130
Transfer Out Cost This field contains the total cost of IC851 OE114
all outgoing transactions for the OE30.1 OE30.2
period. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-RECEIPT-QTY Signed 13.4 Occurs 14 Times BL92.1 IC130
Receipts Quantity This field contains the total quantity IC851 OE114
of all receipts for the period. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
RQ35.1 WH130
WH132 WH190
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
ICH-PER-END-QTY Signed 13.4 Occurs 14 Times IC851
Period End Quantity 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 Signed 15.2 Occurs 14 Times IC190 IC851
Closing Cost This field contains the cost of the
item updated at the time of the period
end closing (IC190).
ICHISTORY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICHSET1 COMPANY BL92.1 IC12.1
LOCATION IC120 IC130
ITEM IC134 IC135
YEAR IC150 IC151
QUARTER IC152 IC190
IC224 IC239
IC242 IC300
IC49.1 IC530
IC851 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO180 PO31.1
...
ICHSET2 COMPANY IC190 IC851
LOCATION
ITEM
YEAR*
QUARTER*
ICHISTORY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
ICH-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
ICH-COMPANY -> ICL-COMPANY
ICH-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
ICH-COMPANY -> ITL-COMPANY
ICH-LOCATION -> ITL-LOCATION
ICH-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ICH-ITEM -> ITE-ITEM
|