CustomerCurrencyObjectSetting

The Customer Profile Currency Setting provides the details of the credit limits specified for a customer account and bill-to site profile in different currencies.

Expand all

Collapse all

Business Views

** Available for extracting data

• customerCurrencyObjectSettingsExtract**

  The Customer Profile Currency Setting provides the details of the credit limits specified for a customer account and bill-to site profile in different currencies.

  Label, Plural Label

  Customer Profile Currency Settings, Customer Profile Currency Settings

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • autocashToleranceAmount (int64)

    Amount defined in the customer profile to add to an underpaid receipt amount to apply to and close an open invoice.

    Label

    AutoCash Tolerance Amount

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • creditLimit (big-decimal)

    The overall credit limit assigned the customer account with this customer profile class.

    Label

    Credit Limit

  • creditLimitExpirationDate (date)

    The customer profile amount expiration date.

    Label

    Credit Limit Expiration Date

  • customerAccountProfileAmountId (int64)

    The identifier of the customer profile amount.

    Label

    Customer Account Profile Amount ID

    Properties

    • searchable
    • sortable
    • not nullable
  • effectiveEndDate (date)

    The effective end date of the customer profile amount.

    Label

    Effective End Date

    Properties

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

    The effective start date of the customer profile amount.

    Label

    Effective Start Date

    Properties

    • searchable
    • sortable
    • not nullable
  • interestChargeAmount (big-decimal)

    The fixed late charge amount to apply to overdue transactions of customers with the customer profile class. This value is used when the Interest Charge Type is Fixed Amount.

    Label

    Interest Charge Amount

  • interestChargeRate (big-decimal)

    The fixed late charge percentage to apply to overdue transactions of customers with the customer profile class. This value is used when the Interest Charge Type is Fixed Rate.

    Label

    Interest Charge Rate

  • interestChargeType (enumeration: InterestType)

    The method to use to calculate late charges on overdue transactions of customers with the customer profile class. Valid values are: Fixed Amount, Fixed Rate, and Charge Schedule.

    Label

    Interest Charge Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: InterestType

    Valid Values

    • CHARGES_SCHEDULE
    • FIXED_AMOUNT
    • FIXED_RATE
  • maximumLateChargePerInvoice (big-decimal)

    The maximum late charge amount to apply to overdue transactions of customers with this customer profile class.

    Label

    Maximum Late Charge per Invoice

  • minimumCustomerBalanceOverdueAmount (big-decimal)

    The minimum overdue balance amount of customers with the customer profile class to generate late charges.

    Label

    Minimum Customer Balance Overdue Amount

  • minimumCustomerBalanceOverduePercent (big-decimal)

    The minimum overdue balance percentage of customers with the customer profile class to generate late charges.

    Label

    Minimum Customer Balance Overdue Percent

  • minimumCustomerBalanceOverdueType (enumeration: CustomerBalanceOverdueType)

    The option that indicates how to define the minimum customer balance threshold for calculating late charges on transactions of customers with the customer profile class. Valid values are Amount and Percent.

    Label

    Minimum Customer Balance Overdue Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: CustomerBalanceOverdueType

    Valid Values

    • AMOUNT
    • PERCENT
  • minimumDunningAmount (big-decimal)

    The minimum account balance of customers with the customer profile class to generate dunning letters.

    Label

    Minimum Dunning Amount

  • minimumDunningInvoiceAmount (big-decimal)

    The minimum overdue transaction amount of customers with the customer profile class to generate dunning letters for the transaction.

    Label

    Minimum Dunning Invoice Amount

  • minimumInvoiceBalanceOverdueAmount (big-decimal)

    The minimum overdue transaction amount of customers with the customer profile class to generate late charges.

    Label

    Minimum Invoice Balance Overdue Amount

  • minimumInvoiceBalanceOverduePercent (big-decimal)

    The minimum overdue transaction percentage of customers with the customer profile class to generate late charges.

    Label

    Minimum Invoice Balance Overdue Percent

  • minimumInvoiceBalanceOverdueType (enumeration: InvoiceBalanceOverdueType)

    The option that indicates how to define the minimum transaction threshold for calculating late charges on transactions of customers with the customer profile class. Valid values are Amount and Percent.

    Label

    Minimum Invoice Balance Overdue Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: InvoiceBalanceOverdueType

    Valid Values

    • AMOUNT
    • PERCENT
  • minimumLateChargePerInvoice (big-decimal)

    The minimum late charge amount to apply to overdue transactions of customers with this customer profile class.

    Label

    Minimum Late Charge per Invoice

  • minimumReceiptAmount (big-decimal)

    The minimum receipt amount in the automatic receipt batch currency to generate automatic receipts for customer transactions with the customer profile class.

    Label

    Minimum Receipt Amount

  • minimumStatementAmount (big-decimal)

    The minimum statement balance of customers with the customer profile class to generate statements.

    Label

    Minimum Statement Amount

  • orderCreditLimit (big-decimal)

    The credit limit assigned to individual orders of customers with this customer profile class.

    Label

    Order Credit Limit

  • penaltyChargeAmount (big-decimal)

    The fixed penalty amount to apply to overdue transactions of customers with the customer profile class. This value is used when the Penalty Charge Type is Fixed Amount.

    Label

    Penalty Charge Amount

  • penaltyChargeRate (big-decimal)

    The fixed penalty charge percentage to apply to overdue transactions of customers with the customer profile class. This value is used when the Penalty Charge Type is Fixed Rate.

    Label

    Penalty Charge Rate

  • penaltyChargeType (enumeration: PenaltyType)

    The method to use to calculate additional penalty charges on overdue transactions of customers with the customer profile class. Valid values are: Fixed Amount, Fixed Rate, and Charge Schedule.

    Label

    Penalty Charge Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: PenaltyType

    Valid Values

    • CHARGES_SCHEDULE
    • FIXED_AMOUNT
    • FIXED_RATE
  • 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
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • warehouseLastUpdatedDate (date)

    The date the customer profile amount was entered or changed in a data warehouse.

    Label

    Warehouse Last Updated Date

  Expand all

  Collapse all

  Reference Object

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

  • 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

  • createdByModule (StandardLookupCode)

    The process that created the customer profile amount.

    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

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

  • 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

  • customerSiteProfile (CustomerProfile)

    Business Object

    CustomerProfile

    Expand all

    Collapse all

    Fields

    • customerAccountProfileId (int64)

      The identifier of the customer profile.

      Label

      Customer Account Profile ID

      Properties

      • searchable
      • sortable
      • not nullable
    • effectiveEndDate (date)

      The effective end date of the customer profile amount.

      Label

      Effective End Date

      Properties

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

      The effective start date of the customer profile amount.

      Label

      Effective Start Date

      Properties

      • searchable
      • sortable
      • not nullable

  • interestChargeSchedule (ReceivablesLateChargeSchedule)

    A late charge schedule outlines the penalties or fees incurred when a payment isn't made by its due date. It provides detailed information on the late charge schedules, including charge schedule names and descriptions.

    Business Object

    ReceivablesLateChargeSchedule

    Expand all

    Collapse all

    Fields

    • scheduleId (int64)

      The identifier of the charge schedule. This is a foreign key of the AR_CHARGE_SCHEDULES view object.

      Label

      Schedule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • penaltyChargeSchedule (ReceivablesLateChargeSchedule)

    A late charge schedule outlines the penalties or fees incurred when a payment isn't made by its due date. It provides detailed information on the late charge schedules, including charge schedule names and descriptions.

    Business Object

    ReceivablesLateChargeSchedule

    Expand all

    Collapse all

    Fields

    • scheduleId (int64)

      The identifier of the charge schedule. This is a foreign key of the AR_CHARGE_SCHEDULES view object.

      Label

      Schedule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • subledgerApplication (SubledgerApplication)

    A subledger application refers to the predefined applications or accounting hub source systems that use subledger accounting rules to generate accounting entries for their transactions. It stores details such as the application identifier, application type code, associated journal source and other relevant information associated with the subledger application.

    Business Object

    SubledgerApplication

    Expand all

    Collapse all

    Fields

    • applicationId (int64)

      The unique identifier of the source application that represents a functional area.

      Label

      Application

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top