ICRECEIPTS FILE
Costing Record
The Costing Record file is the cost history file. Every incoming inventory
update transaction creates a record in this file which is used for LIFO and
FIFO costing. Outgoing transactions consume inventory by updating the used
quantity.
REFERENCED BY
IC12.1 IC47.1 IC234 DR100 IC141 IC142
IC190 IC222 IC233 IC26.1 IC26.2 IC83.1
IC90.1 RQ11.1 IC120 IC170 IC227 IC228
IC530
UPDATED BY
IC175 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1
IC22.2 IC23.1 IC23.2 IC24.1 IC24.2 IC25.1
IC28.1 IC300 IC500 IC812 IC820 ICI3.1
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
ICR-COMPANY Numeric 4 IC175 IC20.1
Company The company number represents an IC20.2 IC21.1
established company and is entered on IC21.2 IC22.1
all function codes. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
IC820 ICI3.1
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
ICR-LOCATION Alpha 5 IC175 IC20.1
Location Code This field contains a valid stocking IC20.2 IC21.1
location within the company inventory. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
IC820 ICI3.1
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
ICR-ITEM Alpha 32 IC175 IC20.1
Item Number This field contains the item IC20.2 IC21.1
identifier. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
IC820 ICI3.1
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
ICR-DOCUMENT Alpha 10 (Right Justified) IC175 IC20.1
Document ID This field identifies the document from IC20.2 IC21.1
which this transaction record was IC21.2 IC22.1
created. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
IC820 ICI3.1
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
ICR-DOC-TYPE Alpha 2 IC175 IC20.1
Document Type This field contains the type of IC20.2 IC21.1
transaction. IC21.2 IC22.1
AJ = Adjustment IC22.2 IC23.1
CR = Customer Return IC23.2 IC24.1
PI = Physical Inventory Adjustment IC24.2 IC25.1
PO = PO Receiving IC500 IC812
RC = Receipt IC820 ICI3.1
RT = Receiving Transfer POIJ.1 WH130
SH = Shipment WH33.1 WH33.2
RR = Requisition Return WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
ICR-SYSTEM-CD Alpha 2 IC175 IC20.1
System Code This field indicates the originating IC20.2 IC21.1
system of the transaction. IC21.2 IC22.1
IC = Inventory Control IC22.2 IC23.1
PO = Purchase Order IC23.2 IC24.1
OE = Order Entry IC24.2 IC25.1
RQ = Requisitions IC500 IC812
WO = Work Order IC820 ICI3.1
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
ICR-LINE-NBR Numeric 6 IC175 IC20.1
Line Number This field displays the system-assigned IC20.2 IC21.1
transaction number. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
IC820 ICI3.1
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
ICR-COMPONENT-SEQ Numeric 3 IC175 IC20.1
Component Sequence This field contains the component IC20.2 IC21.1
Number sequence number. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 ICI3.1
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
ICR-RECEIVED-QTY Signed 13.4 IC175 IC20.1
Received Quantity This field contains the quantity of the IC20.2 IC21.1
original transaction that is added to IC21.2 IC22.1
the stock-on-hand quantity. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
IC820 ICI3.1
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
ICR-USED-QTY Signed 13.4 IC175 IC20.1
Used Quantity This field contains the quantity that IC20.2 IC21.1
has been used by outgoing transactions. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
ICI3.1 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
ICR-UNIT-COST Signed 13.5 IC175 IC20.1
Unit Cost This field contains the actual unit IC20.2 IC21.1
cost for this incoming transaction. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
IC812 IC820
ICI3.1 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
ICR-RECEIVED-DATE Numeric 8 (yyyymmdd) IC175 IC20.1
Received Date This field contains the date when this IC20.2 IC21.1
transaction record was created. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
ICI3.1 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
ICR-RECEIVED-TIME Numeric 6 (hhmmss) IC175 IC20.1
Received Time This field contains the actual time IC20.2 IC21.1
this receipt took place. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 IC812
ICI3.1 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
ICR-LAST-ACT-DATE Numeric 8 (yyyymmdd) IC175 IC20.1
Last Activity Date This field contains the date this IC20.2 IC21.1
record was last updated. Whenever this IC21.2 IC22.1
record is updated, the system date IC22.2 IC23.1
defaults. IC23.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
IC812 IC820
ICI3.1 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
ICR-HOLD-FLAG Alpha 1 IC812 IC820
On Hold Flag This field indicates this receipt is on ICI3.1
hold for inspection by the Purchase
Order system.
Y = Yes
ICR-HOLD-QTY Signed 13.4 IC175 IC20.1
Hold Quantity IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC500 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
ICRECEIPTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICRSET1 COMPANY IC12.1 IC175
LOCATION IC20.1 IC20.2
ITEM IC21.1 IC21.2
DOCUMENT IC22.1 IC22.2
DOC-TYPE IC23.1 IC23.2
SYSTEM-CD IC24.1 IC24.2
LINE-NBR IC25.1 IC300
COMPONENT-SEQ IC47.1 IC500
IC820 ICI3.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
...
ICRSET2 COMPANY IC234 IC47.1
LOCATION
ITEM
RECEIVED-DATE
RECEIVED-TIME
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
ICRSET3 COMPANY Subset DR100 IC141
LOCATION Where RECEIVED-QTY != USED-QTY IC142 IC175
ITEM IC190 IC20.1
RECEIVED-DATE IC20.2 IC21.1
RECEIVED-TIME IC21.2 IC22.1
DOCUMENT IC22.2 IC222
DOC-TYPE IC23.1 IC23.2
SYSTEM-CD IC233 IC234
LINE-NBR IC24.1 IC24.2
COMPONENT-SEQ IC25.1 IC26.1
IC26.2 IC28.1
IC47.1 IC500
IC83.1 IC90.1
ICI3.1 POIJ.1
RQ11.1 WH130
...
ICRSET4 COMPANY Subset IC28.1 IC47.1
LOCATION Where RECEIVED-QTY != USED-QTY
ITEM
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
ICRSET5 COMPANY Subset DR100 IC120
LOCATION Where RECEIVED-QTY != USED-QTY IC141 IC142
ITEM IC170 IC175
RECEIVED-DATE* IC20.1 IC20.2
RECEIVED-TIME* IC21.1 IC21.2
DOCUMENT IC22.1 IC22.2
DOC-TYPE IC222 IC227
SYSTEM-CD IC228 IC23.1
LINE-NBR IC23.2 IC24.1
COMPONENT-SEQ IC24.2 IC25.1
IC28.1 IC500
IC530 IC83.1
IC90.1 ICI3.1
POIJ.1 RQ11.1
WH130 WH33.1
...
ICRECEIPTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
ICR-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
ICR-COMPANY -> ICL-COMPANY
ICR-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
ICR-COMPANY -> ITL-COMPANY
ICR-LOCATION -> ITL-LOCATION
ICR-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ICR-ITEM -> ITE-ITEM
|