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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
ICR-COMPANY
Element: Company | Numeric 4
Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
|
|
ICR-LOCATION
Element: Location | Alpha 5
This field contains a valid stocking
location within the company inventory.
|
|
ICR-ITEM
Element: Item | Alpha 32
This field contains the item
identifier.
|
|
ICR-DOCUMENT
Element: Document | Alpha 10 (Right Justified)
This field identifies the document from
which this transaction record was
created.
|
|
ICR-DOC-TYPE
Element: Doc Type | Alpha 2
This field contains the type of
transaction.
AJ = Adjustment
CR = Customer Return
PI = Physical Inventory Adjustment
PO = PO Receiving
RC = Receipt
RT = Receiving Transfer
SH = Shipment
RR = Requisition Return
VI = Vendor Return Adj to Inventory |
|
ICR-SYSTEM-CD
Element: System Cd | Alpha 2
This field indicates the originating
system of the transaction.
IC = Inventory Control
PO = Purchase Order
OE = Order Entry
RQ = Requisitions
WO = Work Order |
|
ICR-LINE-NBR
Element: Line Nbr | Numeric 6
This field displays the system-assigned
transaction number.
|
|
ICR-COMPONENT-SEQ
Element: Seq | Numeric 3
This field contains the component
sequence number.
|
|
ICR-RECEIVED-QTY
Element: Quantity | Signed 13.4
This field contains the quantity of the
original transaction that is added to
the stock-on-hand quantity.
|
|
ICR-USED-QTY
Element: Quantity | Signed 13.4
This field contains the quantity that
has been used by outgoing transactions.
|
|
ICR-UNIT-COST
Element: Intl Cost | Signed 18.5
This field contains the actual unit
cost for this incoming transaction.
|
|
ICR-RECEIVED-DATE
Element: Received Date | Numeric 8 (yyyymmdd)
This field contains the date when this
transaction record was created.
|
|
ICR-RECEIVED-TIME
Element: Sys Time | Numeric 6 (hhmmss)
This field contains the actual time
this receipt took place.
|
|
ICR-LAST-ACT-DATE
Element: Last Activity Date | Numeric 8 (yyyymmdd)
This field contains the date this
record was last updated. Whenever this
record is updated, the system date
defaults.
|
|
ICR-HOLD-QTY
Element: Quantity | Signed 13.4
This is the quantity of the receipt that
is waiting inspection or it is the
quantity that was rejected by an
inspection for which a PO vendor return
was automatically built and is now
waiting for the ship function against
the PO vendor return.
|
|
ICR-CREATED-BY
Element: Operator | Alpha 10
|
|
ICR-LAST-UPDT-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
ICR-LAST-UPDT-TIME
Element: Time | Numeric 8
|
|
ICR-LAST-UPDATE-BY
Element: Operator | Alpha 10
|
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| ICRSET1 |
COMPANY
LOCATION
ITEM
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
|
|
|
| ICRSET2 |
COMPANY
LOCATION
ITEM
RECEIVED-DATE*
RECEIVED-TIME*
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
|
|
|
| ICRSET3 |
COMPANY
LOCATION
ITEM
RECEIVED-DATE
RECEIVED-TIME
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
|
|
Subset |
| Where | | RECEIVED-QTY |
!= | USED-QTY | |
|
|
| ICRSET4 |
COMPANY
LOCATION
ITEM
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
|
|
Subset |
| Where | | RECEIVED-QTY |
!= | USED-QTY | |
|
|
| ICRSET5 |
COMPANY
LOCATION
ITEM
RECEIVED-DATE*
RECEIVED-TIME*
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
|
|
Subset |
| Where | | RECEIVED-QTY |
!= | USED-QTY | |
|
|
| ICRSET6 |
COMPANY
RECEIVED-DATE
RECEIVED-TIME
LAST-ACT-DATE
LOCATION
ITEM
DOCUMENT
DOC-TYPE
SYSTEM-CD
LINE-NBR
COMPONENT-SEQ
|
|
|
