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 RQ500 RQIC.1 RQID.1 RQIF.1
RQIG.1 IC120 IC170 IC227 IC228 IC530
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 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
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
ICR-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 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
IC500 IC812
IC820 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
...
ICR-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 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
IC500 IC812
IC820 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
...
ICR-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 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
IC500 IC812
IC820 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
...
ICR-DOCUMENT Alpha 10 (Right Justified) AP125 AP126
Document ID This field identifies the document from AP131 AP25.1
which this transaction record was AP25.2 AP26.1
created. AP27.1 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
IC500 IC812
IC820 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
...
ICR-DOC-TYPE Alpha 2 AP125 AP126
Document Type This field contains the type of AP131 AP25.1
transaction. AP25.2 AP26.1
AJ = Adjustment AP27.1 IC175
CR = Customer Return IC20.1 IC20.2
PI = Physical Inventory Adjustment IC21.1 IC21.2
PO = PO Receiving IC22.1 IC22.2
RC = Receipt IC23.1 IC23.2
RT = Receiving Transfer IC24.1 IC24.2
SH = Shipment IC25.1 IC28.1
RR = Requisition Return IC500 IC812
IC820 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
...
ICR-SYSTEM-CD Alpha 2 AP125 AP126
System Code This field indicates the originating AP131 AP25.1
system of the transaction. AP25.2 AP26.1
IC = Inventory Control AP27.1 IC175
PO = Purchase Order IC20.1 IC20.2
OE = Order Entry IC21.1 IC21.2
RQ = Requisitions IC22.1 IC22.2
WO = Work Order IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC812
IC820 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
...
ICR-LINE-NBR Numeric 6 AP125 AP126
Line Number This field displays the system-assigned AP131 AP25.1
transaction number. AP25.2 AP26.1
AP27.1 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
IC500 IC812
IC820 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
...
ICR-COMPONENT-SEQ Numeric 3 AP125 AP126
Component Sequence This field contains the component AP131 AP25.1
Number sequence number. AP25.2 AP26.1
AP27.1 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
IC500 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
...
ICR-RECEIVED-QTY Signed 13.4 AP125 AP126
Received Quantity This field contains the quantity of the AP131 AP25.1
original transaction that is added to AP25.2 AP26.1
the stock-on-hand quantity. AP27.1 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
IC500 IC812
IC820 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
...
ICR-USED-QTY Signed 13.4 AP125 AP126
Used Quantity This field contains the quantity that AP131 AP25.1
has been used by outgoing transactions. AP25.2 AP26.1
AP27.1 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
IC500 IC812
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
...
ICR-UNIT-COST Signed 13.5 AP125 AP126
Unit Cost This field contains the actual unit AP131 AP25.1
cost for this incoming transaction. AP25.2 AP26.1
AP27.1 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
IC500 IC812
IC820 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
...
ICR-RECEIVED-DATE Numeric 8 (yyyymmdd) AP125 AP126
Received Date This field contains the date when this AP131 AP25.1
transaction record was created. AP25.2 AP26.1
AP27.1 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
IC500 IC812
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
...
ICR-RECEIVED-TIME Numeric 6 (hhmmss) AP125 AP126
Received Time This field contains the actual time AP131 AP25.1
this receipt took place. AP25.2 AP26.1
AP27.1 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
IC500 IC812
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
...
ICR-LAST-ACT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Last Activity Date This field contains the date this AP131 AP25.1
record was last updated. Whenever this AP25.2 AP26.1
record is updated, the system date AP27.1 IC175
defaults. IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC812
IC820 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
...
ICR-HOLD-QTY Signed 13.4 AP125 AP126
Hold Quantity AP131 AP25.1
AP25.2 AP26.1
AP27.1 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
IC500 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
...
ICRECEIPTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICRSET1 COMPANY AP125 AP126
LOCATION AP131 AP25.1
ITEM AP25.2 AP26.1
DOCUMENT AP27.1 IC12.1
DOC-TYPE IC175 IC20.1
SYSTEM-CD IC20.2 IC21.1
LINE-NBR IC21.2 IC22.1
COMPONENT-SEQ IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC28.1 IC300
IC47.1 IC500
IC820 MA180
MA43.9 MA530
MA531 MA60.2
...
ICRSET2 COMPANY IC234 IC47.1
LOCATION
ITEM
RECEIVED-DATE
RECEIVED-TIME
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
ICRSET3 COMPANY Subset AP125 AP126
LOCATION Where RECEIVED-QTY != USED-QTY AP131 AP25.1
ITEM AP25.2 AP26.1
RECEIVED-DATE AP27.1 DR100
RECEIVED-TIME IC141 IC142
DOCUMENT IC175 IC190
DOC-TYPE IC20.1 IC20.2
SYSTEM-CD IC21.1 IC21.2
LINE-NBR IC22.1 IC22.2
COMPONENT-SEQ IC222 IC23.1
IC23.2 IC233
IC234 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC47.1
...
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 AP125 AP126
LOCATION Where RECEIVED-QTY != USED-QTY AP131 AP25.1
ITEM AP25.2 AP26.1
RECEIVED-DATE* AP27.1 DR100
RECEIVED-TIME* IC120 IC141
DOCUMENT IC142 IC170
DOC-TYPE IC175 IC20.1
SYSTEM-CD IC20.2 IC21.1
LINE-NBR IC21.2 IC22.1
COMPONENT-SEQ IC22.2 IC222
IC227 IC228
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 IC530
...
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
|