ReceivablesReceipt

The receivables receipt contains information about receipts, including receipt number, receipt method, receipt type, status, business unit, customer, receipt date, amount, and total applied amount. One record is created for each receipt.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesReceiptsExtract**

  The receivables receipt contains information about receipts, including receipt number, receipt method, receipt type, status, business unit, customer, receipt date, amount, and total applied amount. One record is created for each receipt.

  Label, Plural Label

  Receivables Receipts, Receivables Receipts

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • actualValueDate (date)

    The date cash is withdrawn or deposited in a bank account.

    Label

    Actual Value Date

  • addressVerificationCode (string)

    The credit card address verification code retrieved from the Oracle Payments Server.

    Label

    Address Verification Code

  • anticipatedClearingDate (date)

    The date the receipt is expected to clear the bank.

    Label

    Anticipated Clearing Date

  • approvalCode (string)

    The payment approval code provided by the credit card issuer.

    Label

    Approval Code

  • cashReceiptId (int64)

    The identifier of the cash receipt.

    Label

    Cash Receipt ID

    Properties

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

    The comments about the cash receipt.

    Label

    Comments

  • confirmed (enumeration: ConfirmedIndicator)

    The option that indicates whether a cash receipt is confirmed. Valid values are: Y or Null - Cash receipt confirmed, N - Cash receipt not confirmed. Always use Null when checking this column.

    Label

    Confirmed

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: ConfirmedIndicator

    Valid Values

    • N
    • Y
  • conversionDate (date)

    The receipt conversion date.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The receipt conversion rate.

    Label

    Conversion Rate

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • creditCardErrorCode (string)

    The error code derived from the credit card payment processor.

    Label

    Credit Card Error Code

  • creditCardErrorFlag (boolean)

    The option that indicates whether a transaction had a credit card processing error.

    Label

    Credit Card Error

    Properties

    • searchable
  • creditCardErrorText (string)

    The user-enterable description of the credit card error code.

    Label

    Credit Card Error Text

  • depositDate (date)

    The date the cash receipt was deposited.

    Label

    Deposit Date

    Properties

    • searchable
  • documentNumber (int64)

    The identifier of the document sequence number assigned to the receipt.

    Label

    Document Number

  • factorDiscountAmount (big-decimal)

    The amount of factor discount taken by the bank when factoring a receipt.

  • fundsStatusCode (enumeration: FundsStatus)

    Status of the funds update on the receipt. A list of valid values is defined in the ORA_XCC_FUNDS_STATUS lookup type.

    Label

    Funds Status Code

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: FundsStatus

    Valid Values

    • ORA_CAPTURING_EVENT
    • ORA_ERROR
    • ORA_FAILED
    • ORA_INTERFACE_ERROR
    • ORA_IN_PROCESS
    • ORA_NOT_APPLICABLE
    • ORA_NOT_INITIATED
    • ORA_PARTIAL
    • ORA_PASSED
    • ORA_PROCESS_ERROR

    For a complete list of valid values, see the FundsStatus enumeration type.

  • isSelectedForFactoring (enumeration: SelectedForFactoringIndicator)

    The option that indicates whether the receipt is a factored receipt.

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: SelectedForFactoringIndicator

    Valid Values

    • N
    • Y
  • issueDate (date)

    The date the bill receivable was issued.

    Label

    Issue Date

  • issuerName (string)

    The issuer of the bill receivable.

    Label

    Issuer Name

  • miscellaneousPaymentSource (string)

    The source of the miscellaneous payment against the cash receipt.

    Label

    Paid By

    Properties

    • searchable
    • sortable
  • overrideRemittanceAccount (enumeration: OverrideRemitAccountIndicator)

    The option that indicates whether the remittance batch remittance bank account can override the receipt remittance bank account.

    Label

    Override Remittance Account

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: OverrideRemitAccountIndicator

    Valid Values

    • N
    • Y
  • paymentServerOrderNumber (string)

    Number that indicates that a credit card payment was authorized by the Payment Server.

    Label

    Payment Server Order Number

  • postmarkDate (date)

    The date the cash receipt is postmarked.

    Label

    Postmark Date

  • receiptAmount (big-decimal)

    The amount of the payment from the history record to allow querying on the amount.

    Label

    Receipt Amount

    Properties

    • not nullable
  • receiptDate (date)

    The cash receipt creation date.

    Label

    Receipt Date

    Properties

    • searchable
    • not nullable
  • receiptNumber (string)

    The cash receipt number.

    Label

    Receipt Number

    Properties

    • searchable
  • recommendationCount (int64)

    The total number of transaction application recommendations generated for the cash receipt.

    Label

    Recommendation Count

  • reconciled (enumeration: ReconciledIndicator)

    The option that indicates whether Cash Management is enabled. The default value in Receivables is N, modified by Cash Management during bank reconciliation.

    Label

    Reconciled

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: ReconciledIndicator

    Properties

    • searchable
    • sortable

    Valid Values

    • N
    • Y
  • reference (string)

    The customer reference value for receipt confirmation.

    Label

    Reference

  • referenceType (enumeration: ChargebackReferenceType)

    The cash receipt reference type. Valid values are: PAYMENT, RECEIPT, and REMITTANCE.

    Label

    Reference Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: ChargebackReferenceType

    Properties

    • searchable
    • sortable

    Valid Values

    • CREDIT_MEMO
    • PAYMENT
    • PAYMENT_BATCH
    • RECEIPT
  • reversalCategory (enumeration: ReversalCategoryType)

    The reversal category assigned to the receipt reversal.

    Label

    Reversal Category

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: ReversalCategoryType

    Properties

    • searchable

    Valid Values

    • CCRR
    • CC_CHARGEBACK_REV
    • NSF
    • REV
    • STOP
  • reversalComments (string)

    The user-defined information that accompanies the reversal category.

    Label

    Reversal Comments

  • reversalDate (date)

    The date of the receipt reversal.

    Label

    Reversal Date

    Properties

    • searchable
  • status (enumeration: CheckStatus)

    The status of the cash receipt. Valid values are: Applied, Unapplied, Unidentified, Insufficient Funds, Reverse Payment, and Stop Payment.

    Label

    Status

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: CheckStatus

    Properties

    • searchable

    Valid Values

    • APP
    • CCRR
    • CC_CHARGEBACK_REV
    • CORRECTED
    • ERROR
    • NSF
    • REV
    • STOP
    • UNAPP
    • UNID
  • structuredPaymentReference (string)

    An industry standard reference on receivables receipts composed of letters, check digits, and transaction information, used to identify the transaction, transaction lines, and its payments to the customer and bank.

    Label

    Structured Payment Reference

  • taxAmount (big-decimal)

    The cash receipt tax amount.

    Label

    Tax Amount

  • 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
  • type (enumeration: PaymentCategoryType)

    The receipt type of the cash receipt. Valid values are Standard and Miscellaneous.

    Label

    Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: PaymentCategoryType

    Properties

    • searchable

    Valid Values

    • CASH
    • MISC
  • uniqueReference (string)

    The user-entered alphanumeric reference for the receipt.

    Label

    Unique Reference

    Properties

    • searchable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • ussglTransactionCode (string)

    The descriptive flexfield context name of the public sector accounting descriptive flexfield.

    Label

    USSGL Transaction Code

  • ussglTransactionCodeContext (string)

    The descriptive flexfield context name of the public sector accounting descriptive flexfield.

    Label

    USSGL Transaction Code Context

  Expand all

  Collapse all

  Reference Object

  • activity (ReceivablesActivity)

    A receivables activity represents various transactions and events that occur within the accounts receivables of a business. This activity encompasses a wide range of actions related to managing and processing receivables. The receivables activity includes details such as business unit, name, description, activity type, active option, GL account source, tax rate code source, and distribution set for miscellaneous receipts. Receivables activities provide default accounting information for all activities in Receivables other than transactions and receipts. The receivables activity types are Adjustment, Bank Error, Bills Receivable Funds Recovery, Credit Card Chargeback, Credit Card Refund, Earned Discount, Late Charges, Miscellaneous Cash, Payment Netting, Prepayments, Receipt Write-offs, Refund, Short Term Debt, and Unearned Discount.

    Business Object

    ReceivablesActivity

    Expand all

    Collapse all

    Fields

    • businessUnitId (int64)

      The identifier of the business unit associated with the receivables activity.

      Label

      Business Unit ID

      Properties

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

      The identifier of the receivables activity.

      Label

      Receivables Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • bankAccountUse (BankAccountBusinessUnitAssignment)

    A bank account business unit assignment provides details of how each business unit can use a bank account for payables, receivables, payroll, and treasury activities. For example, a business unit might restrict a bank account to payroll disbursements or enable it for multiple application uses. This ensures that only authorized business processes access or use specific bank accounts, supporting operational requirements and internal controls.

    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

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • cashReceiptHistory (ReceivablesReceiptHistory)

    Business Object

    ReceivablesReceiptHistory

    Expand all

    Collapse all

    Fields

    • cashReceiptHistoryId (int64)

      The identifier of the historical cash receipt entry.

      Label

      Cash Receipt History ID

      Properties

      • searchable
      • sortable
      • not nullable

  • currentCashReceiptHistory (ReceivablesReceiptHistory)

    The receipt history provides information about each step in the lifecycle of a receipt, including history status, accounting date, entered amount, accounted amount, conversion rate, reversal category, and reversal reason.

    Business Object

    ReceivablesReceiptHistory

    Expand all

    Collapse all

    Fields

    • cashReceiptHistoryId (int64)

      The identifier of the historical cash receipt entry.

      Label

      Cash Receipt History ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerBankBranch (BankBranch)

    The bank branch represent the branch details of a bank. The details include the ban branch name, branch number, branch type.

    Business Object

    BankBranch

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier for the bank branch.

      Label

      Bank Branch ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerSiteUse (CustomerAccountSitePurpose)

    The Customer Account Site Business Purpose business object provides the details of the business purposes assigned to customer account sites, for example Bill-to, Ship-to, and Statements. Each customer account site can have one or more business purposes.

    Business Object

    CustomerAccountSitePurpose

    Expand all

    Collapse all

    Fields

    • siteUseId (int64)

      Identifier of the customer account site business purpose.

      Label

      Site Use ID

      Properties

      • searchable
      • sortable
      • not nullable

  • distributionSet (ReceivablesDistributionSet)

    A distribution set represents a predefined set of rules or instructions to distribute receipts across multiple accounts or categories automatically. The distribution set typically includes details such as name, business unit, description, total percent distribution, and active status. The distribution sets and distribution set lines are used to automatically distribute miscellaneous receipt payments. In a distribution set, the sum of all the allocation percentages for each line item must be equal to 100%.

    Business Object

    ReceivablesDistributionSet

    Expand all

    Collapse all

    Fields

    • distributionSetId (int64)

      The identifier of the distribution set.

      Label

      Distribution Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • documentSequence (DocumentSequence)

    A document sequence is a unique number assigned to documents and is useful in tracking the transactions.

    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

  • exchangeRateTypeLookup (CurrencyConversionRateType)

    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

  • externalBankAccount (ExternalBankAccount)

    An external bank account business object defines the external bank account entity.

    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

  • fundsCapturePaymentTransactionExtension (FundsCapturePaymentTransactionExtension)

    This business object stores information about Payment attributes for a given funds capture transaction.

    Business Object

    FundsCapturePaymentTransactionExtension

    Expand all

    Collapse all

    Fields

    • trxnExtensionId (int64)

      Unique system-generated primary key. Value from the sequence IBY_FNDCPT_TX_EXTENSIONS_S.nextval.

      Label

      Transaction Extension ID

      Properties

      • searchable
      • sortable
      • not nullable

  • generalLedgerAccount (GeneralLedgerAccount)

    A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • 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

  • 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

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger 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

  • paymentSchedule (ReceivablesReceiptPaymentSchedule)

    A receivables transaction payment schedule outlines the timeline and terms for payments to be made by customers for sales of goods or services. The details include information about all transactions except adjustments and miscellaneous cash receipts. It's updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. When a receipt is applied to a transaction, the system updates the amount applied, the remaining amount due, and the transaction status. The status changes from open to closed when the amount due remaining is zero.

    Business Object

    ReceivablesReceiptPaymentSchedule

    Expand all

    Collapse all

    Fields

    • paymentScheduleId (int64)

      The identifier of the payment schedule.

      Label

      Payment Schedule ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • previousAccountSitePurpose (CustomerAccountSitePurpose)

    The Customer Account Site Business Purpose business object provides the details of the business purposes assigned to customer account sites, for example Bill-to, Ship-to, and Statements. Each customer account site can have one or more business purposes.

    Business Object

    CustomerAccountSitePurpose

    Expand all

    Collapse all

    Fields

    • siteUseId (int64)

      Identifier of the customer account site business purpose.

      Label

      Site Use ID

      Properties

      • searchable
      • sortable
      • not nullable

  • previousCustomerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receiptBatch (ReceivablesManualReceiptBatch)

    The Receivables Manual Receipt Batch and Receivables Automatic Receipt Batch business object provides information that includes the receipt batch name, the total number of receipts in the batch, the total receipt amount, currency, and the deposit date and accounting date, as well as information about each receipt in the manual or automatic receipt batch.

    Business Object

    ReceivablesManualReceiptBatch

    Expand all

    Collapse all

    Fields

    • batchId (int64)

      The identifier of the receipt batch.

      Label

      Batch ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receiptCurrency (Currency)

    A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

    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

  • receiptMethod (ReceivablesReceiptMethod)

    The receipt method contains information that defines how payments are applied or allocated within receivables. The information includes the receipt class, receipt method name and description, the option for debit memos to inherit receipt numbers, the option for receipt to inherit transaction numbers, grouping number of receipts rule, receipt maturity date rule, and lead days. For automatically created receipts, receipt methods define the rules for creating these receipts. For manually created receipts, receipt methods define user-definable receipt types. Each receipt method is linked with a specific set of remittance bank accounts, which can be assigned to a receipt. For instance, if you receive lockbox transmissions from multiple banks, you can create a lockbox receipt method with the bank accounts from the banks assigned to them.

    Business Object

    ReceivablesReceiptMethod

    Expand all

    Collapse all

    Fields

    • receiptMethodId (int64)

      The identifier of the receipt method.

      Label

      Receipt Method ID

      Properties

      • searchable
      • sortable
      • not nullable

  • remittanceBankAccount (BankAccount)

    The bank account provides the details of the internal bank accounts of a company that are used to receive payments and disburse funds. It contains legal entity-level bank account information. Each bank account must be affiliated with one bank branch.

    Business Object

    BankAccount

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier for the bank account.

      Label

      Bank Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • remittanceBatch (ReceivablesManualReceiptBatch)

    The Receivables Manual Receipt Batch and Receivables Automatic Receipt Batch business object provides information that includes the receipt batch name, the total number of receipts in the batch, the total receipt amount, currency, and the deposit date and accounting date, as well as information about each receipt in the manual or automatic receipt batch.

    Business Object

    ReceivablesManualReceiptBatch

    Expand all

    Collapse all

    Fields

    • batchId (int64)

      The identifier of the receipt batch.

      Label

      Batch ID

      Properties

      • searchable
      • sortable
      • not nullable

  • reversalReason (ERPLookupCode)

    The reversal reason code assigned to the receipt reversal.

    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

  • statementLine (BankAccountStatementLine)

    The bank account statement lines contain information related to bank statement lines, such as line number, booking date, transaction code, transaction type, reconciliation reference, transaction amount, transaction identification information, and so on. It includes reconciled and unreconciled bank statements lines.

    Business Object

    BankAccountStatementLine

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the bank statement line. This is the primary key of the Bank Statement Lines view object.

      Label

      Statement Line Identifier

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top