Power BI Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

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.

Columns

Name Type Description
InvoicesInvoiceId [KEY] Long InvoicesInvoiceId of InvoicesinvoiceInstallments
InstallmentNumber [KEY] Long 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.
UnpaidAmount Decimal UnpaidAmount of InvoicesinvoiceInstallments
FirstDiscountAmount Decimal 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 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 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 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 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 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 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 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 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 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 NetAmountOne of InvoicesinvoiceInstallments
NetAmountTwo Decimal NetAmountTwo of InvoicesinvoiceInstallments
NetAmountThree Decimal NetAmountThree of InvoicesinvoiceInstallments
HoldFlag Bool 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 HeldBy of InvoicesinvoiceInstallments
HoldType String HoldType of InvoicesinvoiceInstallments
PaymentMethod String 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 The user-entered payment method code that helps to uniquely identify a payment method.
HoldDate Datetime HoldDate of InvoicesinvoiceInstallments
BankAccount String 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 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 CreatedBy of InvoicesinvoiceInstallments
CreationDate Datetime CreationDate of InvoicesinvoiceInstallments
LastUpdateDate Datetime LastUpdateDate of InvoicesinvoiceInstallments
LastUpdatedBy String LastUpdatedBy of InvoicesinvoiceInstallments
LastUpdateLogin String LastUpdateLogin of InvoicesinvoiceInstallments
RemitToAddressName String 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 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 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 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 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.
Finder String Finder of InvoicesinvoiceInstallments
InvoiceId Long InvoiceId of InvoicesinvoiceInstallments

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