ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

ReceivablesInvoices

The receivables invoices resource is used to create, get, update, and delete a receivables invoice.

Table Specific Information

Select

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

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 following ways:

  • Using 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, receivablesInvoiceLines having CUReferenceNumber 1, will have the child aggregates having 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 of the invoice.

CustomerTransactionUniqId [KEY] String True

The unique identifier of the invoice. Use this column's value in insert, update and delete operations, wherever applicable, instead of CustomerTransactionId

DueDate Date False

The date when the invoice installment is due to be paid.

ConversionDate Date False

The date a specific conversion rate is used to convert the invoice currency to the ledger currency.

ConversionRate Decimal False

The rate used to convert the invoice currency to the ledger currency.

InvoiceCurrencyCode String False

The code that identifies the entered currency of the invoice.

SpecialInstructions String False

The special instructions that accompany the invoice.

CrossReference String False

The reference field default value from the transaction source assigned to the invoice. The reference field default value is the source document used to identify transactions created using the transaction source.

DocumentNumber Long False

The document sequence number assigned to the invoice.

TransactionNumber String False

The transaction number assigned to the invoice.

TransactionDate Date False

The date when the invoice was created.

TransactionType String False

The transaction type assigned to the invoice.

TransactionSource String False

The transaction source assigned to the invoice.

BillToCustomerNumber String False

The account number of the bill-to customer assigned to the invoice.

BillToSite String False

The number that identifies the bill-to customer site assigned to the invoice.

Comments String False

The user comments that accompany the invoice.

InternalNotes String False

The user-defined internal notes that accompany the invoice.

PaymentTerms String False

The payment terms assigned to the invoice.

LegalEntityIdentifier String False

The unique identifier of the legal entity under which the invoice is created. A legal entity is a recognized party with rights and responsibilities given by legislation.

ConversionRateType String False

The grouping of conversion rates between currencies, used to automatically populate a specific rate to an invoice or invoice line according to business requirements. Valid values are Spot, Corporate, User, and Fixed.

PurchaseOrder String False

The purchase order number on the invoice.

PurchaseOrderDate Date False

The date when the purchase order was generated for the invoice.

PurchaseOrderRevision String False

The revision number of the purchase order on the invoice.

FirstPartyRegistrationNumber String False

The tax registration number of the deploying company.

ThirdPartyRegistrationNumber String False

The tax registration number of the bill-to customer.

InvoicingRule String False

The accounting approach used to recognize revenue on the invoice. The valid values are In Advance and In Arrears.

ShipToCustomerName String False

The name of the customer who receives the goods or services billed on the invoice.

ShipToCustomerNumber String False

The registry identifier of the ship-to customer assigned to the invoice.

BillingDate Date False

The balance forward bill date, if the invoice belongs to a balance forward bill.

BillToPartyId Long True

The unique identifier of the bill-to customer assigned to the invoice.

BusinessUnit String False

The business unit under which the invoice is created. A business unit is a unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy.

InvoiceStatus String False

The value that indicates the level of completion of the invoice. Valid values are Complete, Incomplete, and Frozen. Value must be Complete when creating a receivables invoice.

AccountingDate Date False

The accounting date assigned to the invoice.

ShipToSite String False

The number that identifies the ship-to customer site assigned to the invoice.

PayingCustomerName String False

The name of the customer who pays for the goods or services on the invoice.

PayingCustomerSite String False

The number that identifies the paying customer site assigned to the invoice.

BillToCustomerName String False

The name that identifies the bill-to customer assigned to the invoice.

FreightAmount Decimal False

The freight applicable at the invoice level.

Carrier String False

The name of the shipping vendor.

ShipDate Date False

The date when the items on the invoice are shipped.

ShippingReference String False

The waybill reference on the invoice.

BillToContact String False

The contact details of the bill-to customer.

ShipToContact String False

The contact details of the ship-to customer.

PrintOption String False

The option that indicates whether to print the invoice.

CreatedBy String True

The user who created the record.

CreationDate Datetime True

The date and time the record was created.

LastUpdatedBy String True

The user who last updated the record.

LastUpdateDate Datetime True

The date on which the record is last updated.

PayingCustomerAccount String False

The account number of the paying customer assigned to the invoice.

SoldToPartyNumber String False

The unique number used to identify the sold-to customer on the invoice.

RemitToAddress String False

The address to which the customer should send payment for the invoice.

DefaultTaxationCountry String False

The country where the invoice transaction takes place for tax purposes.

EnteredAmount Decimal True

The original invoice amount.

InvoiceBalanceAmount Decimal True

The Invoice balance amount.

Prepayment String False

The option used to identify the invoice as a transaction requiring prepayment for goods and services.

Intercompany String False

The option used to identify the invoice as an intercompany transaction.

DocumentFiscalClassification String False

The classification for tax purposes of invoice transactions that require special documentation to accompany the transaction, as designated by a tax authority.

BankAccountNumber String False

The bank account number of the customer on the invoice.

CreditCardAuthorizationRequestIdentifier String False

The authorization request identifier received from the tokenization service provider to authorize the credit card number.

CreditCardExpirationDate String False

The date when the credit card expires.

CreditCardIssuerCode String False

The code for the credit card issuer, such as Visa or MasterCard.

CreditCardTokenNumber String False

The token number issued by the tokenization service provider corresponding to a credit card number.

CreditCardVoiceAuthorizationCode String False

The voice authorization code received from the tokenization service provider for authorization.

CreditCardErrorCode String False

The error code when credit card authorization fails.

CreditCardErrorText String False

The error text when credit card authorization fails.

CardHolderLastName String False

The last name of the credit card holder.

CardHolderFirstName String False

The first name of the credit card holder.

ReceiptMethod String False

The receipt method assigned to the invoice.

SalesPersonNumber String False

The number that identifies the primary salesperson on the invoice.

StructuredPaymentReference String False

An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction and its payments to the customer and bank.

InvoicePrinted String False

Option that indicates whether the invoice has been printed at least once. The user must enter Y to update print attributes.

LastPrintDate Date False

Date when the transaction was last reprinted.

OriginalPrintDate Date False

Date when the transaction was first printed.

DeliveryMethod String False

Method used to deliver printed transactions. Valid values are E-Mail, Paper, Portal Upload, or any of the custom values defined in the product.

Email String False

Email address of the customer bill-to contact who receives printed transactions.

AllowCompletion String False

Indicates whether the transaction is reviewed and can be allowed to complete. Valid value to allow completion is 'Y'.

ControlCompletionReason String False

Reason that determines transaction completion.

receivablesInvoiceDFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

receivablesInvoiceInstallments String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

receivablesInvoiceDistributions String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

notes String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

receivablesInvoiceGdf String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

receivablesInvoiceLines String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

receivablesInvoiceTransactionDFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

Finder String True

finder

FirstPartyTaxRegistration String True

firstpartytaxregistration

ThirdPartyTaxRegistration String True

thirdpartytaxregistration

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111