JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf

Employs global descriptive flexfields for invoice lines, supporting globalized business scenarios and complex data requirements.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long The unique identifier of the customer transaction associated with the invoice line, linking the invoice line to a specific customer transaction.
ReceivablesinvoicelinesCustomerTransactionLineId [KEY] Long The unique identifier for the invoice line associated with the general ledger distribution flexfield, enabling precise tracking of line-level details.
CustomerTrxLineId [KEY] Long The identifier of the invoice line within the descriptive flexfield structure, used to uniquely identify and manage line items.
_FLEX_Context String The context segment of the descriptive flexfield, providing additional classifications or categorization for the invoice line as per business requirements.
_FLEX_Context_DisplayValue String The human-readable value representing the descriptive flexfield context, displaying the context segment's information for easier interpretation.
AccountingDate Date The date for accounting purposes associated with the invoice line, used to determine when the revenue or expense is recognized.
AllowCompletion String Indicates whether the processing of the invoice line can be completed, providing control over line status and workflow progression.
BillingDate Date The date the invoice line was billed, important for scheduling and tracking billing cycles, especially for periodic invoicing.
BillToCustomerName String The name of the bill-to customer associated with the invoice line, specifying the party responsible for payment of the invoice.
BillToCustomerNumber String The customer number of the bill-to customer, uniquely identifying the customer in the system for billing and reporting purposes.
BillToSite String The site identifier of the bill-to customer, linking the invoice line to a specific location or address for shipping or billing purposes.
BusinessUnit String The business unit under which the invoice line is created, used for financial reporting and managing transactions across various parts of the organization.
CrossReference String A cross-reference code used to link the invoice line to related transactions or systems, providing a reference for audit and reconciliation purposes.
CustomerTransactionId Long The unique identifier for the customer transaction associated with the invoice line, enabling full traceability of the transaction in the system.
DocumentNumber Long The unique document number associated with the invoice line, used for tracking and managing invoices within the accounting system.
DueDate Date The due date for payment of the invoice line, helping to track outstanding amounts and ensure timely payments.
Finder String A field used to facilitate quick searches or filtering of invoice lines, aiding in locating specific lines within the invoicing system.
FirstPartyTaxRegistration String The tax registration number of the first party involved in the transaction, used for tax compliance and reporting.
InvoiceCurrencyCode String The currency code associated with the invoice line, ensuring that the correct currency is applied to the invoicing process.
InvoiceStatus String The status of the invoice line, such as 'Pending', 'Paid', or 'Partially Paid', indicating the current processing stage of the invoice line.
LegalEntityIdentifier String The unique identifier of the legal entity responsible for the invoice line, used for legal and financial reporting purposes.
PaymentTerms String The payment terms for the invoice line, specifying when payment is due and any applicable discounts or penalties for early or late payment.
PurchaseOrder String The purchase order number linked to the invoice line, connecting the invoice to the corresponding procurement or sales order.
ShipToCustomerName String The name of the customer receiving the goods or services for the invoice line, specifying the end recipient of the transaction.
ShipToSite String The site identifier where the goods or services for the invoice line are being delivered, ensuring proper logistics and tracking.
ThirdPartyTaxRegistration String The tax registration number of any third party involved in the transaction, relevant for tax calculations and compliance when applicable.
TransactionDate Date The date on which the transaction related to the invoice line occurred, helping to track and report transaction timings.
TransactionNumber String The unique transaction number assigned to the invoice line, serving as an identifier for the transaction in the system.
TransactionSource String The source of the transaction that generated the invoice line, such as 'Sales Order' or 'Credit Memo', helping to categorize the invoice line.
TransactionType String The type of transaction associated with the invoice line, such as 'Sale', 'Refund', or 'Adjustment', categorizing the invoice line's business activity.

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