PayablesInvoiceInstallment
Invoice installment provides details of the scheduled payments for a supplier invoice. Each supplier invoice has one or more installments, and this information is used to determine when to make payments on an invoice and how much to pay in an automatic payment batch. Each row of this object stores the installment amount, discount available, payment priority, payment status, and so on.
Business Views
** Available for extracting data- payablesInvoiceInstallmentsExtract**
Invoice installment provides details of the scheduled payments for a supplier invoice. Each supplier invoice has one or more installments, and this information is used to determine when to make payments on an invoice and how much to pay in an automatic payment batch. Each row of this object stores the installment amount, discount available, payment priority, payment status, and so on.
Label, Plural Label
Invoice Installment, Payables Invoice Installments
Data Source
Read-optimized data store
Fields
- campaignName (string)
Name of the discount offer proposed to the supplier.
Label
Discount Campaign
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- digitalPaymentAccountIdentifier (int64)
Digital payment account identifier.
Label
Digital Payment Account ID
- discountAPR (big-decimal)
Annual Percent Rate (APR) for dynamic discount calculation.
Label
Discount APR
- discountAmountRemaining (big-decimal)
The discount amount available for the remaining payment amount.
Label
Discount Amount Remaining
- dueDate (date)
The date when the invoice or installment is due for payment.
Label
Due Date
Properties
- searchable
- sortable
- firstDiscountAmount (big-decimal)
The discount amount that's available on the first discount date.
Label
First Discount Amount
- firstDiscountDate (date)
The date when the first discount is available.
Label
First Discount Date
- heldBy (string)
The user who placed or requested the hold.
Label
Held By
- holdDate (date)
The date on which the hold was placed.
Label
Hold Date
- holdReason (string)
The reason for placing a hold on the invoice installment, such as cancellation or close out.
Label
Hold Reason
Properties
- searchable
- sortable
- installmentAmount (big-decimal)
Installment amount that's due before applying any discounts.
Label
Installment Amount
Properties
- searchable
- sortable
- installmentNumber (int64)
The number used to identify an invoice installment.
Label
Installment Number
Properties
- searchable
- sortable
- not nullable
- invoiceCurrencyGrossAmount (big-decimal)
Installment amount that's due before applying any discounts.
Label
Gross Amount
- invoiceId (int64)
The unique identifier of the invoice that's generated while creating the invoice.
Label
Invoice ID
Properties
- searchable
- sortable
- not nullable
- invoiceToPaymentConversionRate (big-decimal)
Conversion rate between the invoice and payment currencies. Value is typically 1 when both currencies are the same or use standard exchange rates.
Label
Payment Cross Rate
Properties
- not nullable
- netAmounAfterSecondDiscount (big-decimal)
Amount remaining on the invoice after applying the second discount.
Label
Net Amount After Second Discount
- netAmounAfterThirdDiscount (big-decimal)
Amount remaining on the invoice after applying the third discount.
Label
Net Amount After Third Discount
- netAmountOne (big-decimal)
Amount remaining on the invoice after applying the first discount.
Label
Net Amount After First Discount
- onHoldFlag (boolean)
Indicates whether the installment is placed on hold. If true, then the installment can't be selected for payment until the hold is released. If false, then the installment is eligible for payment according to the schedule.
Label
On Hold
Properties
- searchable
- paymentPriority (int32)
Number representing payment priority of a scheduled payment. Valid values are 1 to 99.
Label
Payment Priority
Properties
- searchable
- sortable
- relationshipIdentifier (int64)
The unique identifier of the third party relationship to whom the payment is made.
Label
Third-Party Payment Relationship ID
- remitToAddressName (string)
The third-party payment related remit-to address where the payment is sent.
Label
Remit-to Address Name
- remitToSupplierName (string)
The name of the third-party supplier to whom payment is sent.
Label
Remit-to Supplier Name
- remittanceMessage1 (string)
Remittance message used for payment processing.
Label
Remittance Message 1
- remittanceMessage2 (string)
Remittance message used for payment processing.
Label
Remittance Message 2
- remittanceMessage3 (string)
Remittance message used for payment processing.
Label
Remittance Message 3
- secondDiscountAmount (big-decimal)
The discount amount that's available on the second discount date.
Label
Second Discount Amount
- secondDiscountDate (date)
The date when the second discount is available.
Label
Second Discount Date
- thirdDiscountAmount (big-decimal)
The discount amount that's available on the third discount date.
Label
Third Discount Amount
- thirdDiscountDate (date)
The date when the third discount is available.
Label
Third Discount Date
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- not nullable
- unpaidAmount (big-decimal)
Represents the payment installment unpaid amount, or the total of unpaid amount from invoice records that are validated or not validated, including negative amount invoices but not including unpaid prepayments.
Label
Unpaid Amount
Properties
- searchable
- sortable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
Reference Object
- businessUnit (BusinessUnit)
A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.
Business Object
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- code (ERPLookupCode)
Indicates whether payment has been made for the installment. A value of Y indicates fully paid, N indicates unpaid and P indicates partially paid installments.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- externalBankAccount (ExternalBankAccount)
An external bank account business object defines the external bank account entity.
Business Object
ExternalBankAccountFields
- id (int64)
Primary key of the physical entity IBY_EXT_BANK_ACCOUNTS.
Label
External Bank Account ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- financeProgram (FinancingProgram)
A financing program defines a working capital solution such as supply chain financing, dynamic discounting, or virtual cards along with participating parties, restrictions, and other program-specific attributes.
Business Object
FinancingProgramFields
- financingOptionTypeCode (string)
Type of financing option the program is meant for. Value from lookup ORA_CE_FINANCING_TYPES.
Label
Financing Option Type Code
Properties
- creatable
- searchable
- not nullable
- updatable
- financingProgramId (int64)
System generated unique identifier of the financing program.
Label
Financing Program Id
Properties
- creatable
- searchable
- sortable
- not nullable
- financingOptionTypeCode (string)
- financeProgramOffer (FinancingProgramOffer)
Financing Program Offer stores information about financing program offers made to third parties as part of financing campaigns. It includes details such as associated campaign third-party assignment, contact information, offer type and key dates. The object tracks the lifecycle and communication status of each offer.
Business Object
FinancingProgramOfferFields
- financingProgramOfferId (int64)
System generated unique identifier for the financing program offer.
Label
Financing Program Offer Id
Properties
- creatable
- searchable
- sortable
- not nullable
- financingProgramOfferId (int64)
- invoice (PayablesInvoiceTransaction)
An invoice transaction represents details of all the transactions related to purchases made for producing goods and services or managing business operations, excluding payment requests, taxes, joint ventures, and intercompany transactions.
Business Object
PayablesInvoiceTransactionFields
- invoiceId (int64)
The unique identifier of the invoice that's generated while creating the invoice.
Label
Invoice ID
Properties
- searchable
- sortable
- not nullable
- invoiceNumber (string)
The unique number for supplier invoice.
Label
Invoice Number
Properties
- searchable
- sortable
- not nullable
- invoiceTypeDiscriminator (string)
The discriminator to distinguish Payables Invoice and Payment Request subtypes.
Label
Discriminator
Properties
- creatable
- searchable
- sortable
- not nullable
- updatable
- invoiceId (int64)
- invoiceGroup (PayablesInvoiceBatch)
The unique identifier of the invoice group.
Business Object
PayablesInvoiceBatchFields
- batchId (int64)
The unique identifier of the invoice group.
Label
Invoice Group
Properties
- searchable
- sortable
- not nullable
- batchId (int64)
- invoiceTransaction (PayablesInvoiceTransaction)
An invoice provides the details of the products or services provided by the merchant, including the invoice number, invoice date, invoice amount, supplier, and currency.
Business Object
PayablesInvoiceTransactionFields
- invoiceId (int64)
The unique identifier of the invoice that's generated while creating the invoice.
Label
Invoice ID
Properties
- searchable
- sortable
- not nullable
- invoiceNumber (string)
The unique number for supplier invoice.
Label
Invoice Number
Properties
- searchable
- sortable
- not nullable
- invoiceTypeDiscriminator (string)
The discriminator to distinguish Payables Invoice and Payment Request subtypes.
Label
Discriminator
Properties
- creatable
- searchable
- sortable
- not nullable
- updatable
- invoiceId (int64)
- paymentMethod (PaymentMethod)
A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods include printing paper checks in-house, outsourcing checks to be printed by a payment system, and wiring money. A payment method can be very generic, such as EFT, or very specific, such as EFT in Denmark via Citibank using the EDIFACT format. Some payment methods are predefined, but implementation teams may define their own payment methods.
Business Object
PaymentMethodFields
- code (string)
Primary key entered by the user.
Label
Payment Method Code
Properties
- searchable
- sortable
- not nullable
- code (string)
- paymentProcessRequest (PayablesPaymentProcessRequest)
The payment process request contains the details of the criteria that a payment batch uses to select invoices for payment. It creates a row each time a payment batch is initiated.
Business Object
PayablesPaymentProcessRequestFields
- checkrunId (int64)
The unique identifier of a payment batch, not applicable to a quick payment.
Label
Payment Process Request ID
Properties
- searchable
- sortable
- not nullable
- checkrunId (int64)
- remitToSupplier (Supplier)
The identifier of the third-party payment related remit-to supplier where the payment is sent.
Business Object
SupplierFields
- supplierId (int64)
Value that uniquely identifies the supplier.
Label
Supplier ID
Properties
- searchable
- sortable
- not nullable
- supplierId (int64)
- remitToSupplierAddress (PayablesPaymentRequestorAddress)
Remit-to address where payment should be sent.
Business Object
PayablesPaymentRequestorAddressFields
- id (int64)
The unique identifier for an address.
Label
Site ID
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- campaignName (string)