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.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesPaymentExtract**

  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.

  Label, Plural Label

  Payables Payment, Payables Payments

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • actualValueDate (date)

    The date when the cash activity is recognized in a bank account.

    Label

    Actual Value Date

  • anticipatedValueDate (date)

    The anticipated date when the funds will be credited to the destination bank account.

    Label

    Anticipated Value Date

  • bankAccountName (string)

    The name of the bank account associated with the payment.

    Label

    Payee Bank Account Name

    Properties

    • not nullable
  • checkrunName (string)

    The name of the payment batch or quick payment identifier.

    Label

    Payment Process Request

  • clearingAmount (big-decimal)

    The payment amount cleared against the payment in Oracle Cash Management.

    Label

    Cleared Amount

  • clearingBaseAmount (big-decimal)

    The payment amount cleared against the payment in ledger currency.

    Label

    Clearing Base Amount

  • clearingChargesAmount (big-decimal)

    The clearing charge amount for the payment cleared.

    Label

    Clearing Charges Amount

  • clearingChargesBaseAmount (big-decimal)

    The clearing charge amount for the payment cleared in ledger currency.

    Label

    Clearing Charges Base Amount

  • clearingConversionDate (date)

    The date when the clearing conversion rate is effective, which is usually the accounting date of a transaction.

    Label

    Cleared Conversion Date

  • clearingConversionRate (big-decimal)

    The conversion rate used to convert foreign currency payments.

    Label

    Cleared Conversion Rate

  • clearingDate (date)

    The date when the payment is cleared in Cash Management.

    Label

    Cleared Date

  • clearingErrorAmount (big-decimal)

    The cleared payment error amount for the payment cleared.

    Label

    Clearing Error Amount

  • clearingErrorBaseAmount (big-decimal)

    The cleared payment error amount in the ledger currency.

    Label

    Clearing Error Base Amount

  • conversionDate (date)

    The date when the conversion rate was used to convert foreign currency payments.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The conversion rate used to convert foreign currency payments.

    Label

    Conversion Rate

  • createdBy (string)

    The user who created the row.

    Label

    Payment Created By

    Properties

    • not nullable
  • crossCurrencyRateType (string)

    The conversion rate type used to convert the invoice currency to payment currency.

    Label

    Cross-Currency Rate Type

  • description (string)

    A brief description about the payment.

    Label

    Payment Description

  • documentCategoryCode (string)

    The sequential numbering document category name.

    Label

    Document Category

  • documentSequenceValue (big-decimal)

    The sequence number is a number assigned to the document when document sequential numbering is enabled.

    Label

    Voucher Number

  • employeeAddressCode (string)

    The address code of the employee. Valid values are HOME and OFFICE.

    Label

    Employee Address

  • futurePayDueDate (date)

    Negotiable date for future dated payment.

    Label

    Maturity Date

    Properties

    • searchable
    • sortable
  • logicalGroupReference (string)

    The reference of the logical group available on the manual reconciliation search results. This attribute value is used by Oracle Cash Management.

    Label

    Logical Group Reference

  • maturityConversionDate (date)

    The date when the maturity conversion rate is effective, which is usually the maturity date for the payment.

    Label

    Maturity Conversion Date

  • maturityConversionRate (big-decimal)

    The conversion rate of a future dated maturity payment. This attribute value is only used for foreign currency payments.

    Label

    Maturity Conversion Rate

  • paymentAmount (big-decimal)

    The payment amount in the payment currency.

    Label

    Payment Amount

    Properties

    • sortable
    • not nullable
  • paymentBaseAmount (big-decimal)

    The payment amount in ledger currency.

    Label

    Payment Base Amount

  • paymentDate (date)

    The date when the payment is made. The same is mentioned on the payment document.

    Label

    Payment Date

    Properties

    • searchable
    • sortable
    • not nullable
  • paymentId (int64)

    The unique identifier of the payment record.

    Label

    Payment ID

    Properties

    • searchable
    • sortable
    • not nullable
  • paymentNumber (int64)

    Check number printed on physical check.

    Label

    Payment Number

    Properties

    • searchable
    • sortable
    • not nullable
  • positivePayStatusCode (string)

    Indicates the payment status of the invoice. Value of this attribute is used by the positive pay report to select the records.

    Label

    Payment Status

  • reconciledFlag (boolean)

    Indicates whether the payment is reconciled. If Y, the amount is cleared. If N, the amount isn't cleared.

    Label

    Reconciled Indicator

    Properties

    • searchable
  • releasedBy (int64)

    The user who released the stop payment.

    Label

    Released By

  • releasedDate (date)

    The date when the stop payment was released.

    Label

    Release Date

  • remitToAddressName (string)

    The third-party payment related remit-to address where the payment is sent.

    Label

    Third-Party Address Name

  • remitToSupplierName (string)

    The third-party payment related remit-to supplier where the payment is sent.

    Label

    Third-Party Supplier

  • stampDutyAmount (big-decimal)

    Stamp duty tax amount for globalization.

    Label

    Stamp Duty Amount

  • stampDutyBaseAmount (big-decimal)

    Stamp duty tax amount in functional currency for globalization.

    Label

    Stamp Duty Amount in Ledger Currency

  • state (string)

    The state name of the party to whom the payment is made.

    Label

    State

  • stopDate (date)

    The date and time when the user recorded the stop payment.

    Label

    Stop Date

    Properties

    • searchable
    • sortable
  • stoppedBy (int64)

    The user who recorded the stop payment.

    Label

    Stopped By

  • supplierName (string)

    The identifier of the supplier to whom the payment is made.

  • supplierSiteCode (string)

    The name of the supplier site to whom the payment is made.

    Label

    Payee Site

  • timeCreated (date-time)

    The date and time when the row was created.

    Label

    Payment Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the row was last updated.

    Label

    Payment Last Updated Date

    Properties

    • searchable
    • not nullable
  • transferPriority (string)

    The transfer priority of the payment.

    Label

    Transfer Priority

  • treasuryPayDate (date)

    The date when the internal treasury department of the organization processed the payment.

    Label

    Treasury Pay Date

  • treasuryPayNumber (int64)

    The payment number is an identifier assigned to the payment processed through the internal treasury department of the organization.

    Label

    Treasury Pay Number

  • updatedBy (string)

    The user who last updated the record.

    Label

    Payment Last Updated By

    Properties

    • not nullable
  • ussglTransactionCode (string)

    The USSGL transaction code used to create standard general ledger journal entries.

    Label

    USSGL Transaction Code

  • ussglTransactionCodeContext (string)

    Descriptive flexfield context name for USSGL transaction code.

    Label

    USSGL Transaction Code Context

  • voidDate (date)

    The date when the payment is voided.

    Label

    Void Date

  Expand all

  Collapse all

  Reference Object

  • accountPaymentProfile (AccountPaymentProfile)

    Stores account-related information that completes the specification for handling payment instructions. Entries in this table are based on entries in the System Payment Profile. The selection of a payment process profile is driven by the payment method assigned to a document and other factors.

    Business Object

    AccountPaymentProfile

    Expand all

    Collapse all

    Fields

    • paymentProfileId (int64)

      System-generated primary key for IBY_ACCT_PMT_PROFILES_B.

      Label

      Payment Process Profile ID

      Properties

      • searchable
      • sortable
      • not nullable
    • paymentProfileName (string)

      Name of the payment process profile.

      Label

      Payment Profile Name

      Properties

      • translatable

  • bankAccountBusinessUnitAssignment (BankAccountBusinessUnitAssignment)

    The bank account assignment provides the assignment details of the operating unit with the bank account.

    Business Object

    BankAccountBusinessUnitAssignment

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier for the bank account use.

      Label

      Bank Account Use Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • effectiveEndDate (date)

      The end date of the date range within which the business unit is effective.

      Label

      End Date

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • effectiveStartDate (date)

      The start date of the date range within which the business unit is effective.

      Label

      Start Date

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable
    • name (string)

      The translated name for the business unit.

      Label

      Business Unit

      Properties

      • inherited
      • translatable
      • not nullable
      • overridable

  • 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

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • 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

  • digitalPaymentAccount (DigitalPaymentAccount)

    Digital Payment Account business object stores the information about digital or virtual payment accounts.

    Business Object

    DigitalPaymentAccount

    Expand all

    Collapse all

    Fields

    • digitalPaymentAccountId (int64)

      Digital payment account identifier.

      Label

      Digital Payment Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • documentSequence (DocumentSequence)

    The unique identifier of the document sequential numbering.

    Business Object

    DocumentSequence

    Expand all

    Collapse all

    Fields

    • docSequenceId (int64)

      The unique identifier of the document sequence.

      Label

      Document Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

  • externalBankAccount (ExternalBankAccount)

    The identifier of the external bank account.

    Business Object

    ExternalBankAccount

    Expand all

    Collapse all

    Fields

    • id (int64)

      Primary key of the physical entity IBY_EXT_BANK_ACCOUNTS.

      Label

      External Bank Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable
    • legalEntityIdentifier (string)

      The unique number assigned to identify a legal entity.

      Label

      Legal Entity Identifier

      Properties

      • searchable
      • sortable
      • not nullable
    • legalEntityName (string)

      The name of the legal entity.

      Label

      Legal Entity Name

      Properties

      • searchable
      • sortable
      • not nullable

  • party (Party)

    Parties includes information about a person, organization, household, or group.

    Business Object

    Party

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • searchable
      • sortable
      • not nullable
      • overridable
    • name (string)

      The name of the party.

      Label

      Party Name

      Properties

      • searchable
      • not nullable
      • overridable

  • partySite (Address)

    A supplier address represents the location information of a supplier. You can have multiple addresses for a supplier, each with different address purposes. For example, a supplier address with purposes for ordering and remit-to, or a supplier address with purpose a for bidding or RFQ.

    Business Object

    Address

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for an address.

      Label

      Site ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • paymentClearingConversionRateType (CurrencyConversionRateType)

    The conversion rate type at which the payment is cleared. This attribute is only used for foreign currency payments.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • 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

  • paymentCurrency (Currency)

    Currency in which payment is made.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentDocument (BankAccountPaymentDocument)

    This provides the details of payment documents that are used for disbursing funds. These documents can include checks, electronic payments, or other types of remittance forms.

    Business Object

    BankAccountPaymentDocument

    Expand all

    Collapse all

    Fields

    • id (int64)

      Uniquely identifies the payment document.

      Label

      Payment Document Id

      Properties

      • searchable
      • sortable
      • not nullable
    • paymentDocument (string)

      Name given to a set of documents such as check stock.

      Label

      Payment Document

      Properties

      • not nullable

  • paymentInstruction (PayablesPaymentFile)

    It's a child object of Abstract Payments Payment File. A payment file stores information on payment instructions. A payment instruction is a set of one or more payments submitted together to a payment system. This table corresponds to the Payment File page.

    Business Object

    PayablesPaymentFile

    Expand all

    Collapse all

    Fields

    • paymentInstructionId (int64)

      System-generated identifier used to identify the payment file to payment systems and to users.

      Label

      Reference

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • paymentMaturityConversionRateType (CurrencyConversionRateType)

    The conversion rate at a future dated payment maturity time. This attribute is only used for foreign currency payments.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • 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

  • paymentMethod (PaymentMethod)

    The payment method used to make the payment.

    Business Object

    PaymentMethod

    Expand all

    Collapse all

    Fields

    • code (string)

      Primary key entered by the user.

      Label

      Payment Method Code

      Properties

      • searchable
      • sortable
      • not nullable
    • paymentMethodName (string)

      Name of the payment method used to create the transaction

      Label

      Payment Method Name

      Properties

      • translatable
      • not nullable

  • paymentMode (StandardLookupCode)

    Unique identifier of the invoice payment mode.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • 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

  • 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

    PayablesPaymentProcessRequest

    Expand all

    Collapse all

    Fields

    • 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
    • checkrunName (string)

      The name of the payment batch or quick payment identifier.

      Label

      Name

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentSettlementPriority (StandardLookupCode)

    The priority with which the financial institution or payment system should settle payment for this document. A list of accepted values is defined in the lookup type IBY_SETTLEMENT_PRIORITY.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • 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

  • paymentStatus (ERPLookupCode)

    Indicates the status of the payment. For example, Negotiable, Setup, and Spoiled.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • 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

  • paymentType (ERPLookupCode)

    The type of the payment.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • 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

  • paymentsPayment (PayablesDisbursementPayment)

    A disbursement payment business object stores information on payments. A payment is a single check or fund transfer transaction between first party payer and third party payee. A payment pays one or more documents payable, and there may be one or more payments in a payment instruction. Payments are built by grouping documents payable according to Oracle Payments' grouping rules. This table corresponds to the Payments tab of the Funds Disbursement Process Home.

    Business Object

    PayablesDisbursementPayment

    Expand all

    Collapse all

    Fields

    • paymentId (int64)

      The user who created the record.

      Label

      Payment ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • remitToAddress (Address)

    Remit-to address where payment should be sent.

    Business Object

    Address

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for an address.

      Label

      Site ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • remitToSupplier (Supplier)

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

    Business Object

    Supplier

    Expand all

    Collapse all

    Fields

    • supplierId (int64)

      Value that uniquely identifies the supplier.

      Label

      Supplier ID

      Properties

      • searchable
      • sortable
      • not nullable

  • supplier (Supplier)

    A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.

    Business Object

    Supplier

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the organization profile.

      Label

      Organization ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • name (string)

      The name of the organization.

      Label

      Name

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
      • overridable
      • updatable
    • supplierId (int64)

      Value that uniquely identifies the supplier.

      Label

      Supplier ID

      Properties

      • searchable
      • sortable
      • not nullable
    • supplierNumber (string)

      Number that identifies the supplier.

      Label

      Supplier Number

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable

Back to Top