PayablesInvoicePayment
Invoice payment records contain details regarding payments made to suppliers, including payment amount, payment number, bank information, and other relevant data. Each payment made for an invoice is represented by a single row in the database.
Business Views
** Available for extracting data- payablesInvoicePaymentExtract**
Invoice payment records contain details regarding payments made to suppliers, including payment amount, payment number, bank information, and other relevant data. Each payment made for an invoice is represented by a single row in the database.
Label, Plural Label
Payables Invoice Payment, Payables Invoice Payments
Data Source
Read-optimized data store
Fields
- accountingDate (date)
The date when payment accounting is posted.
Label
Payment Accounting Date
Properties
- not nullable
- amount (big-decimal)
The amount paid for each invoice installment in payment currency.
Label
Payment Amount
Properties
- not nullable
- amountPaidInInvoiceCurrency (big-decimal)
The amount paid for each invoice installment in invoice currency.
Label
Amount Paid Invoice Currency
- annualPercentageRate (big-decimal)
The discount percent rate for the dynamic discount calculation.
Label
Discount APR
- assetsAdditionCode (string)
Indicates whether discounts on the invoice payment have been transferred to Oracle Fusion Assets. A value of U indicates that the payment discount isn't yet processed. A value of Y indicates that discount has been transferred and a value of N indicates that the discount hasn't been transferred to Oracle Fusion Assets.
Label
Asset Addition Indicator
- conversionDate (date)
The date on which a conversion rate is used to convert an amount into another currency for an invoice.
Label
Conversion Date
- conversionRate (big-decimal)
The conversion rate used to convert the payment amount to ledger currency.
Label
Conversion Rate
- createdBy (string)
The user who created the invoice payment row.
Label
Created By
Properties
- not nullable
- crossCurrencyConversionRate (big-decimal)
The conversion rate used to convert the invoice currency to the payment currency. Used when the payment currency differs from the invoice currency.
Label
Conversion Rate
- daysAccelerated (big-decimal)
The number of days used for the dynamic discount calculation.
Label
Days Accelerated
- discountLost (big-decimal)
The discount amount lost when the invoice payment isn't made in time to avail the discount.
Label
Invoice Payment Discount Lost
- discountLostInvoiceCurrency (big-decimal)
The discount amount lost in payment currency when the invoice payment isn't made in time to avail the discount.
Label
Discount Lost in Invoice Currency
- discountTaken (big-decimal)
The amount of the discount realized at the time of payment creation.
Label
Discount Taken
- discountTakenInvoiceCurrency (big-decimal)
The amount of the discount realized in invoice currency.
Label
Discount Taken in Invoice Currency
- internalBankAccountType (string)
The bank account type of the bank from which payment is being made. For example, a savings or checking account.
Label
Invoice Payment Bank Account Type
- invoicePaymentId (int64)
The unique identifier of the payment. This is the primary key of the Invoice Payments view object.
Label
Invoice Payment ID
Properties
- searchable
- sortable
- not nullable
- paidAmountInvoiceExchangeRate (big-decimal)
The payment amount in functional currency at the invoice conversion rate. This attribute is only used for foreign currency invoice payments.
Label
Invoice Base Amount
- paidAmountPaymentExchangeRate (big-decimal)
The payment amount in functional currency at the invoice conversion rate. This attribute is only used for foreign currency invoice payments.
Label
Invoice Payment Base Amount
- paymentPostedFlag (boolean)
Indicates if the payment has been posted.
Label
Payment Posted Indicator
Properties
- not nullable
- periodName (string)
The period name associated with the payment.
Label
Payment Period Name
Properties
- not nullable
- reversalFlag (boolean)
Indicates if the invoice payment is a reversal of another invoice payment. Used for payments that are voided.
Label
Payment Reversal Indicator
Properties
- searchable
- sortable
- timeCreated (date-time)
The date and time when the invoice payment was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date when the invoice payment row was last updated.
Label
Last Update Date
Properties
- searchable
- not nullable
- updatedBy (string)
The user who last updated the invoice payment row.
Label
Last Updated By
Properties
- not nullable
Reference Object
- assetAccount (GeneralLedgerAccount)
The identifier of the accounting code combination used for the cash account.
Business Object
GeneralLedgerAccountFields
- chartOfAccountsId (string)
The unique identifier of the chart of accounts.
Label
Chart of Accounts
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- concatenatedSegments (string)
The concatenated full account combination.
Label
Concatenated Segment Values
Properties
- inherited
- creatable
- searchable
- sortable
- chartOfAccountsId (string)
- 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)
- conversionRateType (CurrencyConversionRateType)
A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.
Business Object
CurrencyConversionRateTypeFields
- conversionRateType (string)
The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.
Label
Conversion Rate Type
Properties
- searchable
- sortable
- not nullable
- conversionRateTypeName (string)
The user-defined name of the conversion type.
Label
Conversion Rate Type Name
Properties
- searchable
- sortable
- not nullable
- conversionRateType (string)
- digitalPaymentAccount (DigitalPaymentAccount)
Digital Payment Account business object stores the information about digital or virtual payment accounts.
Business Object
DigitalPaymentAccountFields
- digitalPaymentAccountId (int64)
Digital payment account identifier.
Label
Digital Payment Account ID
Properties
- searchable
- sortable
- not nullable
- digitalPaymentAccountId (int64)
- externalBankAccount (ExternalBankAccount)
The identifier of the external bank account.
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
- maskedAccountNumber (string)
Masked bank account number used for display purposes.
Label
Masked Bank Account Number
- id (int64)
- financingProgramThirdPartyCandidate (FinancingProgramThirdPartyCandidate)
Financing Program Third-Party Candidate contains information related to third parties that are candidates for financing programs.
Business Object
FinancingProgramThirdPartyCandidateFields
- 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
- financingProgramThirdPartyCandidateId (int64)
System generated unique identifier for a financing program candidate.
Label
Financing Program Third-Party Candidate Id
Properties
- creatable
- searchable
- sortable
- not nullable
- financingOptionTypeCode (string)
- gainAccount (GeneralLedgerAccount)
The identifier of the accounting code combination used for the realized exchange rate gains account.
Business Object
GeneralLedgerAccountFields
- chartOfAccountsId (string)
The unique identifier of the chart of accounts.
Label
Chart of Accounts
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- concatenatedSegments (string)
The concatenated full account combination.
Label
Concatenated Segment Values
Properties
- inherited
- creatable
- searchable
- sortable
- chartOfAccountsId (string)
- invoiceCurrency (Currency)
The currency code of the supplier invoice.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- invoiceInstallment (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 Object
PayablesInvoiceInstallmentFields
- installmentNumber (int64)
The number used to identify an invoice installment.
Label
Installment Number
Properties
- searchable
- sortable
- not nullable
- invoiceId (int64)
The unique identifier of the invoice that's generated while creating the invoice.
Label
Invoice ID
Properties
- searchable
- sortable
- not nullable
- installmentNumber (int64)
- invoicingBusinessUnit (BusinessUnit)
The business unit name for the invoice.
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)
- invoicingParty (Party)
Identifier of the original party for third-party payment.
Business Object
PartyFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- invoicingPartySite (Address)
The identifier of the original party site for third party payments.
Business Object
AddressFields
- id (int64)
The unique identifier for an address.
Label
Site ID
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- invoicingSupplierSite (SupplierSite)
The identifier of the original supplier site for third party payments.
Business Object
SupplierSiteFields
- id (int64)
Value that uniquely identifies the supplier site.
Label
Supplier Site ID
Properties
- searchable
- sortable
- not nullable
- name (string)
Name of the supplier site.
Label
Site
Properties
- searchable
- sortable
- not nullable
- id (int64)
- ledger (Ledger)
A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.
Business Object
LedgerFields
- ledgerId (int64)
The unique identifier of the ledger for which the accounting entry is created.
Label
Ledger ID
Properties
- searchable
- sortable
- not nullable
- name (string)
The unique name of the ledger entered by the user.
Label
Name
Properties
- searchable
- sortable
- not nullable
- ledgerId (int64)
- liabilityAccount (GeneralLedgerAccount)
The identifier of the accounting code combination used for the payables liability account.
Business Object
GeneralLedgerAccountFields
- chartOfAccountsId (string)
The unique identifier of the chart of accounts.
Label
Chart of Accounts
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- concatenatedSegments (string)
The concatenated full account combination.
Label
Concatenated Segment Values
Properties
- inherited
- creatable
- searchable
- sortable
- chartOfAccountsId (string)
- lossAccount (GeneralLedgerAccount)
The identifier of the accounting code combination used for realized exchange rate losses.
Business Object
GeneralLedgerAccountFields
- chartOfAccountsId (string)
The unique identifier of the chart of accounts.
Label
Chart of Accounts
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- concatenatedSegments (string)
The concatenated full account combination.
Label
Concatenated Segment Values
Properties
- inherited
- creatable
- searchable
- sortable
- chartOfAccountsId (string)
- payment (PayablesPayment)
Payment represents the payments issued to suppliers or refunds received from suppliers. This information is utilized to accurately record and manage outgoing payments to suppliers or incoming refunds from suppliers.
Business Object
PayablesPaymentFields
- paymentId (int64)
The unique identifier of the payment record.
Label
Payment ID
Properties
- searchable
- sortable
- not nullable
- paymentId (int64)
- paymentCurrency (Currency)
The currency code of the payment.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- name (string)
The user-defined name of the currency.
Label
Name
Properties
- translatable
- not nullable
- currencyCode (string)
- paymentType (ERPLookupCode)
Indicates the type of payment. Possible payment types are Quick, Manual, Payment Process Request, or Refund.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupType (string)
The unique identifier of the Lookup Type.
Label
Lookup Type ID
Properties
- inherited
- searchable
- sortable
- not nullable
- meaning (string)
The translated meaning of the Lookup Code.
Label
Lookup Code Meaning
Properties
- inherited
- translatable
- not nullable
- lookupCode (string)
- remitToAddress (PayablesPaymentRequestorAddress)
The identifier of the remit-to address where the payment is sent.
Business Object
PayablesPaymentRequestorAddressFields
- id (int64)
The unique identifier for an address.
Label
Site ID
Properties
- inherited
- searchable
- sortable
- not nullable
- id (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)
- reversalInvoicePayment (PayablesInvoicePayment)
Unique identifier of the invoice payment reversed by the current invoice payment.
Business Object
PayablesInvoicePaymentFields
- invoicePaymentId (int64)
The unique identifier of the payment. This is the primary key of the Invoice Payments view object.
Label
Invoice Payment ID
Properties
- searchable
- sortable
- not nullable
- invoicePaymentId (int64)
- subledgerAccountingEvent (SubledgerAccountingEvent)
A subledger accounting event contains all information related to a specific accounting event and the transactions linked to the event which are used to generate accounting entries. It stores details associated with the accounting event such as the associated accounting event identifier, application identifier, event type, event status, event processing status, and other information associated with the accounting event.
Business Object
SubledgerAccountingEventFields
- applicationId (int64)
The unique identifier of the source application that represents a functional area.
Label
Application
Properties
- searchable
- sortable
- not nullable
- eventId (int64)
The unique identifier of the accounting event within an application and event class.
Label
Event Identifier
Properties
- searchable
- sortable
- not nullable
- applicationId (int64)
- accountingDate (date)