ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ReceiptCostsReceiptCostDetails

Provides details on cost elements and unit costs of received items, supporting financial reconciliation.

Columns

Name Type Description
ReceiptCostsTransactionId [KEY] Long Unique identifier for the transaction associated with the receipt in the ReceiptCostsReceiptCostDetails table.
TransactionCostId [KEY] Long Identifier for the specific cost record associated with the transaction in the ReceiptCostsReceiptCostDetails table.
CostElementId Long Unique identifier for the cost element type in the ReceiptCostsReceiptCostDetails table, such as freight, handling, etc.
UnitCost Decimal The per-unit cost for the item or service associated with the receipt transaction in the ReceiptCostsReceiptCostDetails table.
CurrencyCode String The currency in which the unit cost is measured, represented by a 3-character currency code, such as USD, EUR.
CostElement String The name or description of the cost element (for example, freight, labor) associated with the receipt transaction.
CostElementType String Defines the category or type of cost element (for example, fixed, variable) for the receipt transaction in the ReceiptCostsReceiptCostDetails table.
ExpensePoolId Long Identifier for the expense pool to which this receipt cost belongs, which helps categorize costs by groupings or departments.
ExpensePool String The name or code of the expense pool, which categorizes the costs associated with the receipt.
BindCostBook String The name of the cost book used for binding costs to transactions in the ReceiptCostsReceiptCostDetails table.
BindCostOrgName String The name of the organization or entity responsible for the cost binding, as associated with the receipt cost details.
BindCostProfile String The profile that defines how costs are allocated and tracked within the context of this receipt transaction.
BindItem String The identifier or description of the item that the cost is associated with, used for binding the cost to a specific inventory or transaction.
BindItemId Long Unique identifier for the item in the transaction to which the receipt cost is bound.
BindReceiptNumber String The number associated with the receipt in the transaction, used to track or reference this receipt in the system.
BindReferenceNumber String A reference number for the transaction, possibly used for cross-referencing with external systems or documents.
BindTxnTypeName String The name or type of the transaction, such as purchase, return, or adjustment, linked to the receipt cost details.
BindValuationUnit String The unit of measurement used for the valuation of costs in the receipt transaction, such as unit, kilogram, or liter.
Finder String Identifier for the search or query tool that was used to locate or filter the specific receipt cost details in the system.
TransactionId Long Unique identifier for the transaction related to the receipt cost, linking the cost record to the larger transactional context.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175