 |
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 IC130 IC190 IC28.1 IC300 IC851
MA180 MA43.9 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.3 MA67.1 MA67.2 MA70.1
MAI1.1 PO100 PO101 PO122 PO131 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ35.1 WH130 WH132 WH190 WH20.2 WH20.7
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICH-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-YEAR Numeric 4 AP125 AP126
Last Closed Year This is the year as determined by the AP131 AP25.1
current year in the Company Parameter AP25.2 AP26.1
file. AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-QUARTER Numeric 1 AP125 AP126
Quarter This field contains the quarter of the AP131 AP25.1
history. The quarter is used for weekly AP25.2 AP26.1
history. AP27.1 IC130
0 = Monthly Company IC28.1 IC851
1 = First Quarter MA180 MA43.9
2 = Second Quarter MA530 MA531
3 = Third Quarter MA60.2 MA60.3
4 = Fourth Quarter MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-BEG-SOH-QTY Signed 13.4 AP125 AP126
Beginning This field contains the beginning AP131 AP25.1
StockOnHand Quantity stock-on-hand quantity at the beginning AP25.2 AP26.1
of the year. It is updated when Closing AP27.1 IC130
(IC190) is run for year end closing. IC190 IC28.1
IC851 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
ICH-BEG-CLOSE-CST Signed 15.2 AP125 AP126
Beginning Closing This field contains the unit cost of AP131 AP25.1
Cost the beginning stock-on-hand quantity AP25.2 AP26.1
when IC190 (Closing) is run. AP27.1 IC130
IC190 IC28.1
IC851 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
ICH-ISSUE-QTY Signed 13.4 Occurs 14 Times AP125 AP126
Issue Quantity This field contains the total issued AP131 AP25.1
quantity for the period. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-ISSUE-COST Signed 15.2 Occurs 14 Times AP125 AP126
Issue Cost This field contains the total cost of AP131 AP25.1
all issues for the period. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-SALES-QTY Signed 13.4 Occurs 14 Times AP125 AP126
Sales Quantity This field contains the total sales AP131 AP25.1
quantity for the period. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-SALES-COST Signed 15.2 Occurs 14 Times AP125 AP126
Sales Cost This field contains the total cost of AP131 AP25.1
all sales for the period. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-SALES-PRICE Signed 15.2 Occurs 14 Times AP125 AP126
Sales Price This field contains the total price of AP131 AP25.1
all sales for the period. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-ADJ-IN-QTY Signed 13.4 Occurs 14 Times AP125 AP126
Adjustments In This field contains the total quantity AP131 AP25.1
Quantity of all incoming adjustments for the AP25.2 AP26.1
period. AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-ADJ-OUT-QTY Signed 13.4 Occurs 14 Times AP125 AP126
Adjustment Out This field contains the total quantity AP131 AP25.1
Quantity of all outgoing adjustments for the AP25.2 AP26.1
period. AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-ADJ-OUT-COST Signed 15.2 Occurs 14 Times AP125 AP126
Adjustment Out Cost This field contains the total cost of AP131 AP25.1
all outgoing adjustments for the period. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-TRAN-IN-QTY Signed 13.4 Occurs 14 Times AP125 AP126
Transfers In This field contains the total quantity AP131 AP25.1
Quantity of all incoming transfers for the AP25.2 AP26.1
period. AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-TRAN-OUT-QTY Signed 13.4 Occurs 14 Times AP125 AP126
Transfer Out This field contains the total quantity AP131 AP25.1
Quantity of all outgoing transfers for the AP25.2 AP26.1
period. AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-TRAN-OUT-COST Signed 15.2 Occurs 14 Times AP125 AP126
Transfer Out Cost This field contains the total cost of AP131 AP25.1
all outgoing transactions for the AP25.2 AP26.1
period. AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
ICH-RECEIPT-QTY Signed 13.4 Occurs 14 Times AP125 AP126
Receipts Quantity This field contains the total quantity AP131 AP25.1
of all receipts for the period. AP25.2 AP26.1
AP27.1 IC130
IC28.1 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
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 AP125 AP126
LOCATION AP131 AP25.1
ITEM AP25.2 AP26.1
YEAR AP27.1 IC12.1
QUARTER IC120 IC130
IC134 IC135
IC150 IC151
IC152 IC190
IC224 IC239
IC242 IC28.1
IC300 IC49.1
IC530 IC851
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
...
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
|