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. |