InvoicesinvoiceInstallments

Tracks multiple payment installments tied to a single invoice, detailing amounts and due dates for staged payables.

Table-Specific Information

Select

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

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 an extra GET request to retrieve the UniqId.

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

Alternatively, if you want to apply any other filter, 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	Unique identifier of the invoice associated with the installment, linking the installment data to the corresponding invoice.
InvoicesUniqId [KEY]	String	True	Unique identifier for managing insert, update, and delete operations in place of InvoicesInvoiceId for handling invoice installments.
InstallmentNumber [KEY]	Long	False	The unique number assigned to an invoice installment, helping to track and identify the installment within the larger invoice.
InstallmentNumberUniqId [KEY]	String	True	Unique identifier used for managing insert, update, and delete operations related to invoice installments, preferred over InstallmentNumber.
UnpaidAmount	Decimal	True	The outstanding amount of the invoice installment that has not yet been paid.
FirstDiscountAmount	Decimal	False	Discount amount available on the first discount date, which can be provided during invoice creation or derived from payment terms.
FirstDiscountDate	Date	False	Date when the first discount becomes available, either provided during invoice creation or calculated based on payment terms.
DueDate	Date	False	The date when the installment is due for payment, either provided during invoice creation or determined from payment terms.
GrossAmount	Decimal	False	Total amount due for the installment, representing the full amount before any discounts or adjustments.
HoldReason	String	False	Reason provided for placing or releasing the hold on the installment, allowing flexibility in managing payment statuses.
PaymentPriority	Int	False	Priority number for paying this installment, influencing the order in which installments are processed.
SecondDiscountAmount	Decimal	False	Discount amount available on the second discount date, similar to the first discount amount, either provided or derived from payment terms.
SecondDiscountDate	Date	False	Date when the second discount becomes available, derived from payment terms or specified during invoice creation.
ThirdDiscountAmount	Decimal	False	Discount amount available on the third discount date, provided or calculated based on terms.
ThirdDiscountDate	Date	False	Date when the third discount is available, calculated based on the payment terms or provided at invoice creation.
NetAmountOne	Decimal	True	Net amount associated with the first installment of the invoice, after applying any discounts or adjustments.
NetAmountTwo	Decimal	True	Net amount for the second installment of the invoice, reflecting any changes due to discounts or other factors.
NetAmountThree	Decimal	True	Net amount for the third installment of the invoice, calculated after all applicable adjustments.
HoldFlag	Bool	False	Indicates whether a scheduled payment is currently on hold due to validation issues or other reasons.
HeldBy	String	True	The user or system entity responsible for placing the installment on hold, for traceability and accountability.
HoldType	String	True	Type of hold applied to the installment, detailing the nature of the issue (for example, validation failure).
PaymentMethod	String	False	Method used by the payer to settle the installment, such as check, cash, or credit, which can be defaulted or manually entered.
PaymentMethodCode	String	False	Code representing the payment method, uniquely identifying the chosen payment method.
HoldDate	Datetime	True	Timestamp indicating when the hold on the installment was placed or released.
BankAccount	String	False	Bank account number for the supplier where the payment is made, either manually entered or populated from the supplier profile.
ExternalBankAccountId	Long	False	Unique identifier for the supplier's external bank account, prioritized over the bank account if both are provided.
CreatedBy	String	True	Username of the individual who created the installment record, ensuring accountability for data entry.
CreationDate	Datetime	True	Timestamp when the installment record was created, helping track the creation time of the installment.
LastUpdateDate	Datetime	True	Timestamp indicating when the installment record was last updated, providing visibility into its most recent changes.
LastUpdatedBy	String	True	Username of the individual who last updated the installment record, adding traceability for changes.
LastUpdateLogin	String	True	Session login associated with the user who last updated the installment, helping identify the update session.
RemitToAddressName	String	False	Name of the remit-to address where the payment for the installment should be sent, either provided or defaulted from the supplier profile.
RemitToSupplier	String	False	Name of the remit-to supplier where payment should be directed, defined at invoice creation or sourced from the supplier profile.
RemittanceMessageOne	String	False	First remittance message for payment processing, provided during invoice creation or updated later as needed.
RemittanceMessageTwo	String	False	Second remittance message for payment processing, with similar functionality as RemittanceMessageOne.
RemittanceMessageThree	String	False	Third remittance message, serving the same purpose as RemittanceMessageOne and Two, for detailed payment instructions.
invoiceInstallmentDff	String	False	Field for user-defined descriptive flexfield data related to the installment, used for custom data during insert operations.
invoiceInstallmentGdf	String	False	Global descriptive flexfield field for capturing custom, global attributes associated with the invoice installment.
Finder	String	True	Search term or identifier used to locate and retrieve specific invoice installment records.
InvoiceId	Long	True	Unique identifier of the invoice related to the installment, used for tracking the installment data in relation to the invoice.
CUReferenceNumber	Int	False	Reference number that links child aggregate records to parent tables, providing a relationship between data entities.
EffectiveDate	Date	True	Date parameter used to fetch resources that are effective as of a specific start date, ensuring accurate retrieval of relevant data.