 |
Lawson Insight Technical Documentation |
|
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, and Inventory Control
systems.
REFERENCED BY
IC12.1 IC120 IC134 IC135 IC150 IC151
IC152 IC224 IC239 IC242 IC49.1 IC530
UPDATED BY
IC130 IC190 IC300 IC851 POIJ.1 WH130
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICH-COMPANY Numeric 4 IC130 IC851
Company The company number represents an POIJ.1 WH130
established company and is entered on WH33.1 WH33.2
all function codes. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-LOCATION Alpha 5 IC130 IC851
Location Code This field contains a valid stocking POIJ.1 WH130
location within the company inventory. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-ITEM Alpha 32 IC130 IC851
Item Number This field contains the item POIJ.1 WH130
identifier. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-YEAR Numeric 4 IC130 IC851
Last Closed Year This is the year as determined by the POIJ.1 WH130
current year in the Company Parameter WH33.1 WH33.2
file. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-QUARTER Numeric 1 IC130 IC851
Quarter This field contains the quarter of the POIJ.1 WH130
history. The quarter is used for weekly WH33.1 WH33.2
history. WH33.3 WH33.4
0 = Monthly Company WH33.5 WH33.6
1 = First Quarter WH33.8 WH33.9
2 = Second Quarter WH34.1 WH34.2
3 = Third Quarter WH34.3 WH34.4
4 = Fourth Quarter
ICH-BEG-SOH-QTY Signed 13.4 IC130 IC851
Beginning This field contains the beginning POIJ.1 WH130
StockOnHand Quantity stock-on-hand quantity at the beginning WH33.1 WH33.2
of the year. It is updated when Closing WH33.3 WH33.4
(IC190) is run for year end closing. WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-BEG-CLOSE-CST Signed 15.2 IC130 IC851
Beginning Closing This field contains the unit cost of POIJ.1 WH130
Cost the beginning stock-on-hand quantity WH33.1 WH33.2
when IC190 (Closing) is run. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-ISSUE-QTY Signed 13.4 Occurs 14 Times IC130 IC851
Issue Quantity This field contains the total issued POIJ.1 WH130
quantity for the period. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-ISSUE-COST Signed 15.2 Occurs 14 Times IC130 IC851
Issue Cost This field contains the total cost of POIJ.1 WH130
all issues for the period. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-SALES-QTY Signed 13.4 Occurs 14 Times IC130 IC851
Sales Quantity This field contains the total sales POIJ.1 WH130
quantity for the period. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-SALES-COST Signed 15.2 Occurs 14 Times IC130 IC851
Sales Cost This field contains the total cost of POIJ.1 WH130
all sales for the period. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-SALES-PRICE Signed 15.2 Occurs 14 Times IC130 IC851
Sales Price This field contains the total price of POIJ.1 WH130
all sales for the period. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-ADJ-IN-QTY Signed 13.4 Occurs 14 Times IC130 IC851
Adjustments In This field contains the total quantity POIJ.1 WH130
Quantity of all incoming adjustments for the WH33.1 WH33.2
period. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-ADJ-OUT-QTY Signed 13.4 Occurs 14 Times IC130 IC851
Adjustment Out This field contains the total quantity POIJ.1 WH130
Quantity of all outgoing adjustments for the WH33.1 WH33.2
period. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-ADJ-OUT-COST Signed 15.2 Occurs 14 Times IC130 IC851
Adjustment Out Cost This field contains the total cost of POIJ.1 WH130
all outgoing adjustments for the period. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-TRAN-IN-QTY Signed 13.4 Occurs 14 Times IC130 IC851
Transfers In This field contains the total quantity POIJ.1 WH130
Quantity of all incoming transfers for the WH33.1 WH33.2
period. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-TRAN-OUT-QTY Signed 13.4 Occurs 14 Times IC130 IC851
Transfer Out This field contains the total quantity POIJ.1 WH130
Quantity of all outgoing transfers for the WH33.1 WH33.2
period. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-TRAN-OUT-COST Signed 15.2 Occurs 14 Times IC130 IC851
Transfer Out Cost This field contains the total cost of POIJ.1 WH130
all outgoing transactions for the WH33.1 WH33.2
period. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICH-RECEIPT-QTY Signed 13.4 Occurs 14 Times IC130 IC851
Receipts Quantity This field contains the total quantity POIJ.1 WH130
of all receipts for the period. WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
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).
ICH-NDC-NBR Alpha 15
National Drug Code National Drug Code.
ICH-GRANT-NBR Alpha 12
Grant Nbr
ICHISTORY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICHSET1 COMPANY IC12.1 IC120
LOCATION IC130 IC134
ITEM IC135 IC150
YEAR IC151 IC152
QUARTER IC190 IC224
IC239 IC242
IC300 IC49.1
IC530 IC851
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
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
|