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.

Expand all

Collapse all

Business Views

** Available for extracting data

• customerAccountsExtract**

  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.

  Label, Plural Label

  Customer Accounts, Customer Accounts

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountEstablishedDate (date)

    Date when the customer account was originally established through either an Oracle Application or a legacy system.

    Label

    Account Established Date

  • accountName (string)

    Customer account name.

    Label

    Account Name

    Properties

    • searchable
    • sortable
  • accountNumber (string)

    Customer account number.

    Label

    Account Number

    Properties

    • searchable
    • not nullable
  • accountTerminationDate (date)

    Date a customer account is terminated.

    Label

    Account Termination Date

  • arrivalSetsIncludedInLinesFlag (boolean)

    Indicates whether order lines are included in the arrival sets for the customer account.

    Label

    Arrival Sets Included in Lines Indicator

  • autopayFlag (boolean)

    Indicate whether a customer account is enabled for automatic payments.

    Label

    Autopay

  • comments (string)

    Comments about the customer account.

    Label

    Comments

  • coterminateDate (string)

    Identifies the date, in the format DD-MON, when services ordered by the customer account will end.

    Label

    Coterminate Date

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • customerAccountId (int64)

    Identifier of the customer account.

    Label

    Customer Account ID

    Properties

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

    Preferred format of month-day-year for the customer account shipping date or arrival date.

    Label

    Date Type Preference

  • depositRefundMethod (string)

    Method by which a deposit is refunded to the customer account.

    Label

    Deposit Refund Method

  • heldBillExpirationDate (date)

    Date a hold on a bill receivable belonging to the customer account expires.

    Label

    Held Bill Expiration Date

    Properties

    • searchable
  • holdBillFlag (boolean)

    Indicates whether a bill receivable belonging to the customer account is placed on hold.

    Label

    Hold Bill Indicator

    Properties

    • searchable
  • npaNumber (string)

    Phone area code for the customer account.

    Label

    NPA Number

  • originalSystemReferenceForCustomerAccount (string)

    Identifier of a customer account that originates from a foreign or legacy system.

    Label

    Original System Reference for Customer Account

    Properties

    • not nullable
  • sourceCode (string)

    Code that identifies a customer source reference for the customer account.

    Label

    Source Code

  • status (enumeration: CustomerAccountStatus)

    Status of the customer account. A list of valid values is defined in the CODE_STATUS lookup type.

    Label

    Status

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: CustomerAccountStatus

    Properties

    • searchable
    • not nullable

    Valid Values

    • A
    • D
    • I
  • statusUpdateDate (date)

    Date the status of a customer account was updated.

    Label

    Status Update Date

  • taxHeaderLevelFlag (boolean)

    Indicates whether tax is assigned at the header level of transactions belonging to the customer account.

    Label

    Tax Header Level Indicator

  • taxRoundingRule (enumeration: TaxRoundingRule)

    Tax rounding rule assigned to the customer account that indicates the method used to round off calculated taxes.

    Label

    Tax Rounding Rule

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: TaxRoundingRule

    Valid Values

    • DOWN
    • NEAREST
    • UP
  • 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 (string)

    Type of the customer account. A list of valid values is defined in the CUSTOMER_TYPE lookup type. I for internal customers, R for revenue generating external customers.

    Label

    Type

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • createdByModule (StandardLookupCode)

    The module through which the record was created.

    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

  • customer (Customer)

    Business Object

    Customer

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • customerClass (StandardLookupCode)

    The customer class identifier. For example, an account created for a reseller or educational customers would have a customer_class_code as reseller or education.

    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

Back to Top