CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ReceivablesInvoices

Controls the creation, retrieval, and management of receivables invoices, streamlining billing and revenue tracking.

Table-Specific Information

Select

The connector uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The connector processes other filters within the connector.

For example, the following query is processed server-side: 

SELECT * FROM [Cdata].[Financials].[ReceivablesInvoices] WHERE CustomerTransactionId = 10003

Insert

Create a ReceivablesInvoices. 

INSERT INTO [Cdata].[Financials].[ReceivablesInvoices] (BillToCustomerNumber,FreightAmount) VALUES ('2112', 150.22)

If you want to add child views/tables along with the parent table, you can add the child in one of the following ways.

  • Using the TEMP table: 

    INSERT INTO ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines#TEMP(TaxAmount,TaxRegimeCode,TaxRateCode,CUReferenceNumber) VALUES (680,'FUS_STCC_REGIME-UES','VAT20',1)
INSERT INTO ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines#TEMP(TaxAmount,TaxRegimeCode,TaxRateCode,CUReferenceNumber) VALUES (741,'FUS_STCC_REGIME-UES','VAT20',2)
INSERT INTO ReceivablesInvoicesreceivablesInvoiceLines#TEMP(receivablesInvoiceLineTaxLines,LineNumber,Quantity,UnitSellingPrice,TaxClassificationCode,CUReferenceNumber) VALUES ('ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines#TEMP',46,21,2,'VAT20',1)
INSERT INTO ReceivablesInvoicesreceivablesInvoiceLines#TEMP(receivablesInvoiceLineTaxLines,LineNumber,Quantity,UnitSellingPrice,TaxClassificationCode,CUReferenceNumber) VALUES ('ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines#TEMP',47,25,27,'VAT20',2)
INSERT INTO [Cdata].[Financials].[ReceivablesInvoices] (BillToCustomerNumber,FreightAmount,receivablesInvoiceLines) VALUES ('2112', 150.22,'ReceivablesInvoicesreceivablesInvoiceLines#TEMP')

    Note: you can use CUReferenceNumber to map the child views/tables to their parent. For example, if receivablesInvoiceLines has CUReferenceNumber 1, the child aggregates also have CUReferenceNumber 1.

  • Directly providing the aggregate: 

    INSERT INTO [Cdata].[Financials].[ReceivablesInvoices] (BillToCustomerNumber,FreightAmount,receivablesInvoiceLines) VALUES ('2112', 150.22,'[
  {
    "LineNumber": 3,
    "Quantity": 45,
    "UnitSellingPrice": 45,
	"TaxClassificationCode":"VAT20"
  }
]')

Update

The Oracle Fusion Cloud Financials API uses CustomerTransactionUniqId instead of CustomerTransactionId as a path parameter in the URL to update the record.

If you want to update a record directly using the Id (without any other filter), you can update the record in the following way: 

UPDATE [Cdata].[Financials].[ReceivablesInvoices] SET Comments='abcd' WHERE CustomerTransactionUniqId = 454545454;

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use CustomerTransactionId instead of CustomerTransactionUniqId. You can update the record in the following way: 

UPDATE [Cdata].[Financials].[ReceivablesInvoices] SET Comments='abcd' WHERE CustomerTransactionId = 454545454 AND comments='aaw';

Note: Update on aggregates are not allowed by the API. Use the child tables to add/update/delete aggregates.

Delete

The Oracle Fusion Cloud Financials API uses CustomerTransactionUniqId instead of CustomerTransactionId as a path parameter in the URL to delete the record.

If you want to delete a record directly using the Id (without any other filter), you can delete the record in the following way: 

DELETE FROM [Cdata].[Financials].[ReceivablesInvoices] WHERE CustomerTransactionUniqId = 454545454

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use CustomerTransactionId instead of CustomerTransactionUniqId. You can delete the record in the following way: 

DELETE FROM [Cdata].[Financials].[ReceivablesInvoices] WHERE CustomerTransactionId = 454545454 AND comments='aaw';

Columns

Name Type ReadOnly Description
CustomerTransactionId [KEY] Long False

The unique identifier for the invoice within the Receivables module. This ID is used to reference the specific transaction for accounting and reporting purposes.

CustomerTransactionUniqId [KEY] String True

A unique identifier assigned to the invoice that replaces CustomerTransactionId for insert, update, and delete operations. This field ensures consistency across transaction modifications.

DueDate Date False

The date on which the invoice installment is due to be paid by the customer. This date is important for determining payment deadlines and overdue statuses.

ConversionDate Date False

The date used for applying a specific conversion rate to convert the invoice currency to the ledger currency. This date may vary from the transaction date depending on the accounting requirements.

ConversionRate Decimal False

The exchange rate applied to convert the invoice's currency to the ledger currency. This rate ensures that financial data is accurately represented in the organization's reporting currency.

InvoiceCurrencyCode String False

The code representing the currency in which the invoice was originally issued. This field ensures that transactions are tracked and reported in the correct currency.

SpecialInstructions String False

Any specific instructions or notes provided with the invoice, often used for internal purposes or to convey important details to the customer.

CrossReference String False

A reference to the source document that generated this invoice. This could be a sales order or purchase order that links the invoice to the originating transaction.

DocumentNumber Long False

A unique sequential number assigned to the invoice document. This is used for document identification, record-keeping, and integration with other systems.

TransactionNumber String False

A unique identifier assigned to each invoice transaction. This number is used for tracking and reconciling payments and receipts related to the invoice.

TransactionDate Date False

The date when the invoice was created. This date is crucial for accounting and reporting purposes, marking the start of the payment cycle.

TransactionType String False

The type of transaction that this invoice represents (for example, sale, refund, adjustment). This field categorizes the invoice for proper handling and accounting.

TransactionSource String False

The source of the transaction that led to the creation of this invoice. It can help identify whether the invoice was generated from a manual entry or an automated process.

BillToCustomerNumber String False

The account number of the customer being billed. This is used for customer identification and managing accounts receivable.

BillToSite String False

The unique identifier for the billing site of the customer. It helps in distinguishing different locations or divisions within a customer’s organization that receive billing.

Comments String False

User-defined comments attached to the invoice for providing additional context or instructions that may be relevant for processing or customer communication.

InternalNotes String False

Notes intended for internal use only, often to provide details for staff members regarding invoice adjustments, exceptions, or special handling instructions.

PaymentTerms String False

The conditions under which payment is expected for this invoice, such as net 30, net 60, or due upon receipt. These terms define the time frame for the customer’s payment.

LegalEntityIdentifier String False

A unique identifier for the legal entity under which the invoice is generated. This helps to distinguish between different legal entities within the organization for compliance and tax reporting.

ConversionRateType String False

The categorization of conversion rates applied to the invoice, such as Spot, Corporate, User, or Fixed. This determines which exchange rate is used during the conversion process.

PurchaseOrder String False

The purchase order number associated with this invoice. This links the invoice to the corresponding purchase order for the goods or services provided.

PurchaseOrderDate Date False

The date when the purchase order was issued. This date helps track the timeline from order to invoicing, ensuring proper alignment of accounting periods.

PurchaseOrderRevision String False

The revision number of the purchase order linked to the invoice. This is useful when changes are made to a purchase order after its initial creation.

FirstPartyRegistrationNumber String False

The tax registration number of the deploying company. This is required for tax reporting and ensures the company’s compliance with tax regulations.

ThirdPartyRegistrationNumber String False

The tax registration number of the bill-to customer. This number is important for tax purposes and to verify the customer’s tax status.

InvoicingRule String False

The accounting rule applied to the invoice for revenue recognition, such as 'In Advance' or 'In Arrears'. This determines how and when revenue from the invoice is recognized.

ShipToCustomerName String False

The name of the customer receiving the goods or services. This may differ from the bill-to customer and is used to accurately track shipments and deliveries.

ShipToCustomerNumber String False

The unique registry identifier of the customer receiving the shipment. This identifier ensures proper tracking of the shipment within the customer’s account.

BillingDate Date False

The date when the balance forward bill for the customer is generated. This is used for recurring billing scenarios where the invoice consolidates multiple charges over a period.

BillToPartyId Long True

A unique identifier assigned to the bill-to customer. This is critical for associating the invoice with the correct customer account for payment processing.

BusinessUnit String False

The business unit under which the invoice is created. It helps in categorizing transactions by the part of the organization responsible for the transaction.

InvoiceStatus String False

Indicates the current status of the invoice, such as 'Complete', 'Incomplete', or 'Frozen'. This is used for tracking the progress of the invoice through the approval and payment processes.

AccountingDate Date False

The date that is used for accounting purposes to recognize the revenue and expenses associated with the invoice. This may differ from the transaction date.

ShipToSite String False

The unique identifier for the ship-to location of the customer. This helps in managing logistics and ensuring goods are shipped to the correct site.

PayingCustomerName String False

The name of the customer responsible for paying the invoice. This may be different from the bill-to customer if payments are made by a third party.

PayingCustomerSite String False

The identifier for the site responsible for making payments on the invoice. This is useful for tracking payments when there are multiple payment locations for a customer.

BillToCustomerName String False

The name of the customer being billed for the goods or services. This is typically the entity responsible for paying the invoice.

FreightAmount Decimal False

The amount charged for shipping and handling related to the invoice. This amount is added to the total invoice amount if applicable.

Carrier String False

The name of the shipping carrier responsible for delivering the goods. This field helps track which logistics provider is used for shipment.

ShipDate Date False

The date when the items listed on the invoice were shipped to the customer. This date is important for tracking delivery timelines and calculating due dates.

ShippingReference String False

The reference number or waybill provided by the carrier for the shipment. This helps in tracking the shipment status and handling customer inquiries.

BillToContact String False

The contact details of the bill-to customer, such as the name, phone number, and email address. This is useful for communication regarding the invoice.

ShipToContact String False

The contact details of the ship-to customer, which may differ from the bill-to contact. This ensures proper communication about shipments.

PrintOption String False

The option indicating whether the invoice should be printed. This field may include options like 'Print', 'Do Not Print', or 'Print on Demand'.

CreatedBy String True

The user who initially created the invoice record in the system. This information is important for auditing and tracking user actions.

CreationDate Datetime True

The date and time when the invoice record was created in the system. This is useful for tracking the creation timeline of invoices.

LastUpdatedBy String True

The user who last updated the invoice record. This is valuable for tracking changes and ensuring proper management of invoice data.

LastUpdateDate Datetime True

The date and time when the invoice record was last updated. It helps to monitor any modifications to the invoice after its creation.

PayingCustomerAccount String False

The account number for the customer responsible for making payments on the invoice.

SoldToPartyNumber String False

A unique identifier for the sold-to customer, typically used for customer management and invoicing purposes.

RemitToAddress String False

The address where payments for the invoice should be sent. This ensures that payments are directed to the correct location.

DefaultTaxationCountry String False

The country in which the invoice transaction takes place for tax purposes. This country determines the applicable tax rates and regulations.

EnteredAmount Decimal True

The original amount of the invoice before any adjustments, taxes, or discounts are applied.

InvoiceBalanceAmount Decimal True

The remaining balance amount due on the invoice after partial payments or adjustments.

Prepayment String False

Indicates whether the invoice requires prepayment for goods and services. This can help manage upfront payment requirements before order fulfillment.

Intercompany String False

Identifies whether the invoice is part of an intercompany transaction, which typically involves transactions between different legal entities within the same organization.

DocumentFiscalClassification String False

The classification assigned to the invoice for tax purposes, required by tax authorities for documentation compliance.

BankAccountNumber String False

The bank account number associated with the customer for payment purposes. This is useful for processing electronic payments.

CreditCardAuthorizationRequestIdentifier String False

The unique authorization request identifier for credit card payments, generated by the tokenization service to authorize the payment.

CreditCardExpirationDate String False

The expiration date of the credit card used for payment. This ensures the validity of the credit card when processing payments.

CreditCardIssuerCode String False

The code representing the credit card issuer, such as Visa, MasterCard, or American Express.

CreditCardTokenNumber String False

A token number generated by the tokenization service corresponding to the credit card used for payment. This enhances security and prevents fraud.

CreditCardVoiceAuthorizationCode String False

The voice authorization code provided by the tokenization service when a credit card payment is manually authorized via phone.

CreditCardErrorCode String False

An error code that indicates why a credit card authorization failed, helping to diagnose issues during payment processing.

CreditCardErrorText String False

The error message associated with a failed credit card authorization, providing additional information about the failure.

CardHolderLastName String False

The last name of the credit card holder, used for verification purposes when processing payments.

CardHolderFirstName String False

The first name of the credit card holder, used for verification purposes when processing payments.

ReceiptMethod String False

The method by which the payment for the invoice is received, such as Credit Card, Bank Transfer, or Cash.

SalesPersonNumber String False

The identifier of the primary salesperson associated with the invoice. This is used for commission calculations and sales tracking.

StructuredPaymentReference String False

A unique reference used to identify a payment transaction across systems, ensuring proper reconciliation and payment matching.

InvoicePrinted String False

Indicates whether the invoice has been printed at least once, used for managing print statuses in billing operations.

LastPrintDate Date False

The date when the invoice was last printed. This helps to track the history of printed invoices.

OriginalPrintDate Date False

The date when the invoice was initially printed. This serves as the original print date for historical reference.

DeliveryMethod String False

The method used to deliver printed invoices, such as email, paper, or portal upload. This determines how invoices are distributed to customers.

Email String False

The email address of the bill-to customer who will receive the invoice if delivered electronically.

AllowCompletion String False

Indicates whether the invoice can be completed based on its review status. A value of 'Y' indicates that the transaction can be completed.

ControlCompletionReason String False

The reason for completing or finalizing the transaction, indicating why the invoice is ready for closure.

receivablesInvoiceDFF String False

Used for inserting data into the invoice. For updates and deletions, the corresponding child table operations should be used.

receivablesInvoiceInstallments String False

Used for inserting invoice installment details. Updates and deletions should be handled through child table operations.

receivablesInvoiceDistributions String False

Used for inserting invoice distribution details. Updates and deletions are handled through child table operations.

notes String False

A field used for inserting notes related to the invoice. For updates and deletions, child table operations should be used.

receivablesInvoiceGdf String False

Used for inserting generalized data fields (GDF) related to the invoice. Updates and deletions are handled through child table operations.

receivablesInvoiceLines String False

Used for inserting invoice line item details. Updates and deletions are handled through child table operations.

receivablesInvoiceTransactionDFF String False

Used for inserting transaction-specific DFF (Descriptive Flexfields) data. Updates and deletions are handled through child table operations.

Finder String True

A field used for searching specific invoice records within the database.

FirstPartyTaxRegistration String True

The tax registration number of the company issuing the invoice.

ThirdPartyTaxRegistration String True

The tax registration number of the customer receiving the invoice.

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