ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

InvoicesinvoiceInstallments

The payables invoice installments resource is used to manage details about the payment due dates, amounts, and other payment information. An invoice can have one or more installments.

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].[InvoicesinvoiceInstallments] WHERE InstallmentNumber = 10003

Insert

Create an InvoicesinvoiceInstallments.

You need to provide InvoicesUniqId, instead of InvoicesInvoiceId, to insert the record.

INSERT into [Cdata].[Financials].[invoicesinvoiceInstallments](InvoicesUniqId,InstallmentNumber,DueDate,GrossAmount) values (132432,46,'2024-12-31',3.25)

Update

The Oracle Fusion Cloud Financials API uses InvoicesUniqId instead of InvoicesInvoiceId and InstallmentNumberUniqId instead of InstallmentNumber 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].[invoicesinvoiceInstallments] set GrossAmount=45.50 where InstallmentNumberUniqId='1324325,45' and InvoicesUniqId=13243;

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

Alternatively, if you want to apply any other filter. Please use InstallmentNumber instead of InstallmentNumberUniqId and InvoicesInvoiceId instead of InvoicesUniqId. You can update the record in the following way:

Update [Cdata].[Financials].[invoicesinvoiceInstallments] set GrossAmount=45.50 where GrossAmount=41.2 and InvoicesInvoiceId=13243

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 InvoicesUniqId instead of InvoicesInvoiceId and InstallmentNumberUniqId instead of InstallmentNumber 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].[invoicesinvoiceInstallments] where InvoicesUniqId=132432 and InstallmentNumberUniqId='1324325,46'

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

Alternatively, if you want to apply any other filter. Please use InstallmentNumber instead of InstallmentNumberUniqId and InvoicesInvoiceId instead of InvoicesUniqId. You can delete the record in the following way:

Delete from [Cdata].[Financials].[invoicesinvoiceInstallments] where GrossAmount=41.2 and InvoicesInvoiceId=13243

Columns

Name Type ReadOnly Description
InvoicesInvoiceId [KEY] Long True

InvoicesInvoiceId of InvoicesinvoiceInstallments

InvoicesUniqId [KEY] String True

Use this column's value for insert, update and delete operations, wherever applicable, instead of invoicesInvoiceId.

InstallmentNumber [KEY] Long False

The number used to identify an invoice installment. The value must be provided while creating the installment. It cannot be updated once the invoice installment is created.

InstallmentNumberUniqId [KEY] String True

Use this column's value in insert, update and delete operations, wherever applicable, instead of InstallmentNumber

UnpaidAmount Decimal True

UnpaidAmount of InvoicesinvoiceInstallments

FirstDiscountAmount Decimal False

The discount amount available at first discount date. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the First Discount Date attribute. You can also update the value for the first discount amount.

FirstDiscountDate Date False

The date when the first discount is available. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the First Discount Amount attribute. You can also update the value for the first discount date.

DueDate Date False

The date when the invoice installment is due for payment. The value can either be provided while creating an invoice or derived based on the payment terms. You can also update the value for the due date.

GrossAmount Decimal False

The gross amount due for the invoice installment. The value can either be provided while creating an invoice or derived based on the payment terms. You can also update the value for the gross amount.

HoldReason String False

An explanation or justification provided for placing or releasing the hold on the installment. You can also update the value for the hold reason.

PaymentPriority Int False

The number (1 to 99) representing the payment priority of an invoice installment. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit. You can also update the value for the payment priority.

SecondDiscountAmount Decimal False

The discount amount available at second discount date. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the Second Discount Date attribute. You can also update the value for the second discount amount.

SecondDiscountDate Date False

The date when the second discount is available. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the Second Discount Amount attribute. You can also update the value for the second discount date.

ThirdDiscountAmount Decimal False

The discount amount available at third discount date. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the Third Discount Date attribute. You can also update the value for the third discount amount.

ThirdDiscountDate Date False

The date when the third discount is available. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the Third Discount Amount attribute. You can also update the value for the third discount date.

NetAmountOne Decimal True

NetAmountOne of InvoicesinvoiceInstallments

NetAmountTwo Decimal True

NetAmountTwo of InvoicesinvoiceInstallments

NetAmountThree Decimal True

NetAmountThree of InvoicesinvoiceInstallments

HoldFlag Bool False

Indicates whether a scheduled payment is on hold. The value can either be provided while creating an invoice installment or proactive system holds are applied if there are validation failures. The default value is false. You can also update the value for the hold flag.

HeldBy String True

HeldBy of InvoicesinvoiceInstallments

HoldType String True

HoldType of InvoicesinvoiceInstallments

PaymentMethod String False

Indicates how the first party payer is going to make the payment for the invoice. Examples include check, cash, and credit. The value can either be provided while creating an invoice installment or populated by default based on the Payment Method Default Basis setup in the Manage Disbursement System Options. You can also update the value for the payment method.

PaymentMethodCode String False

The user-entered payment method code that helps to uniquely identify a payment method.

HoldDate Datetime True

HoldDate of InvoicesinvoiceInstallments

BankAccount String False

The supplier bank account number to which the payment will be remitted. The value can either be provided while creating an invoice installment or populated by default from the Supplier Site or Address or Profile level payment attributes. You can also update the value for the bank account.

ExternalBankAccountId Long False

The unique identifier for the supplier bank account. The value can either be provided while creating an invoice installment or populated by default from the Supplier Site or Address or Profile level payment attributes. If both Bank Account and External Bank Account ID is provided in the payload then the value for the External Bank Account ID is given preference and the value provided for Bank Account is ignored. You can also update the value for the bank account.

CreatedBy String True

CreatedBy of InvoicesinvoiceInstallments

CreationDate Datetime True

CreationDate of InvoicesinvoiceInstallments

LastUpdateDate Datetime True

LastUpdateDate of InvoicesinvoiceInstallments

LastUpdatedBy String True

LastUpdatedBy of InvoicesinvoiceInstallments

LastUpdateLogin String True

LastUpdateLogin of InvoicesinvoiceInstallments

RemitToAddressName String False

The third-party payment related remit-to address where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to address.

RemitToSupplier String False

The third-party payment related remit-to supplier where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to supplier.

RemittanceMessageOne String False

Remittance message provided for payment processing. You can provide the information during invoice creation or it will be populated by default from the invoice header. You may update the information at a later stage.

RemittanceMessageTwo String False

Remittance message provided for payment processing. You can provide the information during invoice creation or it will be populated by default from the invoice header. You may update the information at a later stage.

RemittanceMessageThree String False

Remittance message provided for payment processing. You can provide the information during invoice creation or it will be populated by default from the invoice header. You may update the information at a later stage.

invoiceInstallmentDff String False

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

invoiceInstallmentGdf 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

InvoiceId Long True

invoiceid

CUReferenceNumber Int False

Maps the child aggregates with Parent tables.

EffectiveDate Date True

This query parameter is used to fetch resources which are effective dated as of the specified start date.

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