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.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesActivitiesExtract**

  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.

  Label, Plural Label

  Receivables Activities, Receivables Activities

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • activeFlag (boolean)

    The status of the receivables activity.

    Label

    Active

    Properties

    • not nullable
  • businessUnitId (int64)

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

    Label

    Business Unit ID

    Properties

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

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

    The description of the receivables activity.

    Label

    Description

  • glAccountSource (string)

    The value that indicates how Receivables derives the accounts for the expense or revenue generated by the Receivables activity. Valid values are: Activity GL Account, Distribution Set, Revenue on Invoice, and Tax Rate Code on Invoice.

    Label

    GL Account Source

  • name (string)

    The name of the receivables activity.

    Label

    Name

    Properties

    • searchable
    • sortable
    • not nullable
  • openReceivableFlag (boolean)

    The option that indicates whether to post transactions with this receivables activity to general ledger.

    Label

    Open Receivable

  • receivablesTransactionId (int64)

    The identifier of the receivables activity.

    Label

    Receivables Transaction ID

    Properties

    • searchable
    • sortable
    • not nullable
  • recoverableFlag (boolean)

    The option on the tax rate code source that indicates whether tax for this receivables activity is recoverable.

    Label

    Recoverable

  • taxRateCodeSource (string)

    The value that indicates how Receivables derives the tax rate code for the Receivables activity. Valid values are: Activity, Invoice, and None.

    Label

    Tax Rate Code Source

  • 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: TransactionActivityType)

    The name of the receivables activity type.

    Label

    Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: TransactionActivityType

    Valid Values

    • ADJUST
    • BANK_ERROR
    • BR_FUND_RECOVERY
    • CCREFUND
    • CC_CHARGEBACK
    • CLAIM_INVESTIGATION
    • CM_REFUND
    • EDISC
    • ENDORSEMENT
    • FINCHRG

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

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • activityGlAccount (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

  • assetTaxRate (TaxRate)

    The tax rate is a percentage of an amount, a value per unit quantity, or a fixed sum per transaction at which an individual or corporation is taxed and is effective for a period of time.

    Business Object

    TaxRate

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax rate.

      Label

      Rate ID

      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

  • 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

  • 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

  • liabilityTaxRate (TaxRate)

    The tax rate is a percentage of an amount, a value per unit quantity, or a fixed sum per transaction at which an individual or corporation is taxed and is effective for a period of time.

    Business Object

    TaxRate

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax rate.

      Label

      Rate ID

      Properties

      • searchable
      • sortable
      • not nullable

  • prepaymentInvoiceApplication (ERPLookupCode)

    Type of prepayment invoice available for application for this prepayment receivables activity. Valid values are Use any prepayment and Use paid prepayments only.

    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

Back to Top