TDV Adapter for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesInvoicesreceivablesInvoiceGdf

Contains global descriptive flexfields at the invoice level, supporting multi-regional billing and compliance requirements.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long The unique identifier for the customer transaction in the invoice General Data flexfield, linking the invoice to the associated transaction.
CustomerTrxId [KEY] Long The unique identifier for the customer transaction in the invoice, enabling precise tracking and management of transaction details.
ExcludeFromNetting String A flag indicating whether the invoice is excluded from netting, typically used in multi-party transactions where some amounts are excluded from netting calculations.
DeliveryDateforTaxPointDate Date The date used to determine the tax point for the invoice, which is important for tax calculations and reporting.
_FLEX_Context String The context segment of the invoice General Data flexfield, which categorizes the invoice distribution or other related financial data.
_FLEX_Context_DisplayValue String The human-readable display value for the context segment, making it easier for users to understand the context of the invoice data.
AccountingDate Date The date when the financial transaction for the invoice is recognized in the accounting system, which can differ from the transaction date.
AllowCompletion String Indicates whether the invoice is ready to be completed in the system. A value of 'Y' allows the invoice to be finalized, while 'N' indicates pending actions.
BillingDate Date The date when the invoice is officially issued or billed to the customer, marking the beginning of the payment term.
BillToCustomerName String The name of the customer being billed, which is necessary for identifying the recipient of the invoice.
BillToCustomerNumber String The unique identifier for the bill-to customer, which helps link the invoice to the specific customer account.
BillToSite String The identifier for the bill-to customer site, which helps specify the physical or virtual location where the billing occurs.
BusinessUnit String The business unit under which the invoice is generated, typically used for organizational purposes and to track business divisions.
CrossReference String A reference used to link the invoice to other related records, such as sales orders or contracts, facilitating easy cross-referencing.
CustomerTransactionId Long The unique identifier for the customer transaction, linking the invoice to the original transaction in the customer account system.
DocumentNumber Long The unique document number assigned to the invoice, helping to identify and track the specific invoice in records.
DueDate Date The due date for the payment of the invoice, indicating when the payment is expected from the customer.
Finder String A field used for searching and locating the invoice based on various criteria, facilitating quicker retrieval of records.
FirstPartyTaxRegistration String The tax registration number of the first party involved in the transaction, typically the seller or service provider, for tax reporting purposes.
InvoiceCurrencyCode String The currency code used for the invoice, indicating the currency in which the amount is denominated.
InvoiceStatus String The status of the invoice, such as 'Paid', 'Unpaid', or 'Pending', which helps track the invoice's processing state.
LegalEntityIdentifier String The identifier of the legal entity under which the invoice is created, necessary for compliance with legal and tax regulations.
PaymentTerms String The payment terms for the invoice, specifying the conditions under which the customer must pay, such as 'Net 30' or 'Due on receipt'.
PurchaseOrder String The purchase order number associated with the invoice, linking the invoice to the original purchase order for tracking and reconciliation.
ShipToCustomerName String The name of the customer receiving the goods or services, which can differ from the bill-to customer in some cases.
ShipToSite String The identifier of the site to which goods or services are shipped, ensuring accurate delivery tracking.
ThirdPartyTaxRegistration String The tax registration number of a third-party entity involved in the transaction, such as a shipping or logistics provider, required for tax reporting.
TransactionDate Date The date when the transaction related to the invoice occurred, which can differ from the invoice creation date.
TransactionNumber String The transaction number assigned to the invoice, providing a unique identifier for tracking and referencing the transaction.
TransactionSource String The source of the transaction that generated the invoice, such as 'Sales Order' or 'Return', indicating the origin of the invoice data.
TransactionType String The type of transaction associated with the invoice, such as 'Sale', 'Refund', or 'Credit', which helps categorize the nature of the invoice.

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