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 IC190 IC222 IC233 IC234
IC90.1 IC120 IC170 IC227 IC228 IC530
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 BL92.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC141 IC142 IC175 IC20.1 IC20.2
IC21.1 IC21.2 IC22.1 IC22.2 IC23.1 IC23.2
IC24.1 IC24.2 IC25.1 IC26.1 IC26.2 IC28.1
IC300 IC500 IC812 IC820 IC83.1 IC966
MA530 MA540 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE810 OE830
OE90.1 OE920 OE950 PO30.1 PO31.1 PO33.1
PO34.1 PO35.1 PO530 RQ10.1 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ20.1 RQ35.1 RQ500 RQ961
WH130 WH132 WH190 WH20.1 WH20.2 WH20.3
WH20.4 WH20.5 WH20.6 WH20.7 WH222 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
WO120 WO132 WO140 WO20.1 WO30.1 WO32.1
WO32.2 WO32.3 WO32.4 WO32.5 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO41.1 WO41.2 WO41.3
WO41.4 WO42.1 WO42.2 WO42.3 WO42.4 WO42.5
WO45.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICR-COMPANY Numeric 4 BL92.1 CX100
Company The company number represents an CX20.1 CX20.2
established company and is entered on CX20.4 CX20.5
all function codes. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICR-LOCATION Alpha 5 BL92.1 CX100
Location Code This field contains a valid stock CX20.1 CX20.2
location within the company inventory. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICR-ITEM Alpha 32 BL92.1 CX100
Item Number This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICR-DOCUMENT Alpha 10 (Right Justified) BL92.1 CX100
Document ID This field identifies the document CX20.1 CX20.2
from which this transaction record was CX20.4 CX20.5
created. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICR-DOC-TYPE Alpha 2 BL92.1 CX100
Document Type This field contains the type of CX20.1 CX20.2
transaction. CX20.4 CX20.5
AJ = Adjustments CX220 CX30.1
PI = Physical Inventory Adjustment CX300 CX506
PO = Purchase Orders CXCP.1 DR100
RC = Receipts IC141 IC142
RT = Receiving Transfers IC175 IC20.1
SH = Shipping IC20.2 IC21.1
CR = Credit Return IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICR-SYSTEM-CD Alpha 2 BL92.1 CX100
System Code This field indicates the originating CX20.1 CX20.2
system of the transaction. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICR-LINE-NBR Numeric 6 BL92.1 CX100
Line Number This field displays the system-assigned CX20.1 CX20.2
transaction number. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICR-COMPONENT-SEQ Numeric 3 BL92.1 CX100
Component Sequence This field contains the component CX20.1 CX20.2
Number sequence number. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
...
ICR-RECEIVED-QTY Signed 13.4 BL92.1 CX100
Received Quantity This field contains the quantity of the CX20.1 CX20.2
original transaction that is added to CX20.4 CX20.5
the stock-on-hand quantity. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICR-USED-QTY Signed 13.4 BL92.1 CX100
Used Quantity This field contains the quantity that CX20.1 CX20.2
has been used by outgoing transactions. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC83.1 IC966
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
ICR-UNIT-COST Signed 13.5 AP125 AP126
Unit Cost This field contains the actual unit AP225 AP226
cost for this incoming transaction. AP25.1 AP25.2
AP26.1 BL92.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC141
IC142 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC812
IC820 IC83.1
IC966 MA530
MA540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
...
ICR-RECEIVED-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Received Date This field contains the date when this CX20.1 CX20.2
transaction record was created. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC83.1 IC966
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
ICR-RECEIVED-TIME Numeric 6 (hhmmss) BL92.1 CX100
Received Time This field contains the actual time CX20.1 CX20.2
this receipt took place. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC83.1 IC966
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
ICR-LAST-ACT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Last Activity Date This field contains the date this AP225 AP226
record was last updated. Whenever this AP25.1 AP25.2
record is updated, the system date AP26.1 BL92.1
defaults. CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC141
IC142 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC812
IC820 IC83.1
IC966 MA530
MA540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
...
ICR-HOLD-FLAG Alpha 1 BL92.1 CX100
On Hold Flag This field indicates this receipt is on CX20.1 CX20.2
hold for inspection by the Purchase CX20.4 CX20.5
Order system. CX220 CX30.1
Y = Yes CX300 CX506
CXCP.1 DR100
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC812
IC820 IC83.1
IC966 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
...
ICRECEIPTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICRSET1 COMPANY AP125 AP126
LOCATION AP225 AP226
ITEM AP25.1 AP25.2
DOCUMENT AP26.1 BL92.1
DOC-TYPE CX100 CX20.1
SYSTEM-CD CX20.2 CX20.4
LINE-NBR CX20.5 CX220
COMPONENT-SEQ CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC141 IC142
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
...
ICRSET2 COMPANY 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 AP225 AP226
ITEM AP25.1 AP25.2
RECEIVED-DATE AP26.1 BL92.1
RECEIVED-TIME CX100 CX20.1
DOCUMENT CX20.2 CX20.4
DOC-TYPE CX20.5 CX220
SYSTEM-CD CX30.1 CX300
LINE-NBR CX506 CXCP.1
COMPONENT-SEQ DR100 IC141
IC142 IC175
IC190 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC222
...
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 BL92.1 CX100
LOCATION Where RECEIVED-QTY != USED-QTY CX20.1 CX20.2
ITEM CX20.4 CX20.5
RECEIVED-DATE* CX220 CX30.1
RECEIVED-TIME* CX300 CX506
DOCUMENT CXCP.1 DR100
DOC-TYPE IC120 IC141
SYSTEM-CD IC142 IC170
LINE-NBR IC175 IC20.1
COMPONENT-SEQ IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC222
IC227 IC228
IC23.1 IC23.2
IC24.1 IC24.2
...
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
|