CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ReceiptCosts

Manages receipt and layer transactions eligible for cost adjustments, providing visibility into cost elements.

Columns

Name Type Description
TransactionId [KEY] Long The unique identifier of the transaction associated with ReceiptCosts.
CostOrganizationId Long The identifier for the cost organization that is linked to ReceiptCosts.
CostOrganizationName String The name of the cost organization related to the ReceiptCosts.
CostBookId Long The identifier for the cost book associated with the ReceiptCosts.
CostBook String The name of the cost book to which the ReceiptCosts belong.
InventoryOrganizationId Long The identifier for the inventory organization linked with the ReceiptCosts.
InventoryOrganizationName String The name of the inventory organization associated with the ReceiptCosts.
ItemId Long The unique identifier for the item related to the ReceiptCosts.
Item String The name or description of the item tied to the ReceiptCosts.
TransactionTypeName String The name of the transaction type related to the ReceiptCosts, such as 'Purchase' or 'Return'.
ValuationUnitId Long The identifier of the valuation unit used for the ReceiptCosts.
ValuationUnit String The name of the valuation unit associated with the ReceiptCosts.
CostProfileId Long The identifier for the cost profile linked to the ReceiptCosts.
CostProfile String The name of the cost profile applied to the ReceiptCosts.
CostDate Datetime The date when the cost of the transaction is recognized in the system for the ReceiptCosts.
CostEffectiveDate Datetime The effective date of the cost for the ReceiptCosts, which may differ from the transaction date.
ReceiptNumber String The unique identifier for the receipt document related to the ReceiptCosts.
ReferenceNumber String A reference number associated with the ReceiptCosts, typically linked to the purchase order or other relevant document.
ReceiptQuantity Decimal The total quantity received as part of the transaction that impacts the ReceiptCosts.
QuantityOnhand Decimal The current quantity of the item that is available in the inventory after the transaction is recorded.
TotalUnitCost Decimal The total cost per unit for the item involved in the ReceiptCosts, including any additional charges or adjustments.
CurrencyCode String The code representing the currency in which the ReceiptCosts are recorded (for example, 'USD', 'EUR').
UOMName String The name of the unit of measure used for the items in the ReceiptCosts (for example, 'Each', 'Box').
UOMCode String The code for the unit of measure used in the ReceiptCosts (for example, 'EA', 'BX').
BindCostBook String The name of the cost book that is bound to the ReceiptCosts for tracking purposes.
BindCostOrgName String The name of the cost organization that is bound to the ReceiptCosts for allocation or reporting.
BindCostProfile String The cost profile name that is linked to the ReceiptCosts for managing pricing and cost adjustments.
BindItem String The name or description of the item that is bound to the ReceiptCosts for consistency across records.
BindItemId Long The unique identifier of the item bound to the ReceiptCosts, used for consistency in transactions.
BindReceiptNumber String The receipt number bound to the ReceiptCosts, ensuring alignment with the corresponding receipt document.
BindReferenceNumber String The reference number bound to the ReceiptCosts, typically for linking to related documents like orders.
BindTxnTypeName String The transaction type bound to the ReceiptCosts, ensuring consistency in categorizing the cost type.
BindValuationUnit String The valuation unit bound to the ReceiptCosts, ensuring that the cost calculations use the correct unit of measurement.
Finder String A search keyword or code used for locating and filtering ReceiptCosts based on specific criteria.

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