Unit Cost
The integrator supports manual cost entry for inventory transactions when the Use Current Cost Flag is set to No. This allows users to specify the exact cost of an inventory transaction rather than relying on the item’s current system cost.
Unit Cost Columns
Field |
Required |
Description |
Use Current Cost Flag |
Yes |
Controls whether Oracle uses the item’s current system cost (Yes) or the manually entered cost (No). Defaults to Yes when not entered. |
Transaction Cost Identifier |
When No |
A unique numeric identifier for the manual cost transaction. Must be unique per upload batch. The integrator generates this automatically when not provided. |
Cost Component Code |
When No |
The cost component to assign the manual cost to. Valid values are defined in the CST_COMPONENT_CODES lookup. Typical values are ITEM_PRICE (material cost) and NONRECOVERABLE_TAX. Multiple cost component rows can be entered per transaction line by adding additional rows with the same transaction identifiers. |
Unit Cost |
When No |
The cost value for the specified Cost Component Code. Must be a positive decimal value. One row per cost component per transaction line. |