CustomerAccountSite

The Customer Account Site business object provides the details of all customer account sites across all business units. A customer account site is one specific location belonging to a customer account. A single customer account can have multiple sites.

Expand all

Collapse all

Business Views

** Available for extracting data

• customerAccountSitesExtract**

  The Customer Account Site business object provides the details of all customer account sites across all business units. A customer account site is one specific location belonging to a customer account. A single customer account can have multiple sites.

  Label, Plural Label

  Customer Account Sites, Customer Account Sites

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • billToSite (enumeration: SiteUsageIndicator)

    Indicates whether the customer site is assigned the Bill-to business purpose. Valid values are Y, P (Yes and Primary), and N.

    Label

    Bill-to Site

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: SiteUsageIndicator

    Valid Values

    • N
    • P
    • Y
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • customerAccountSiteId (int64)

    Identifier of the customer account site.

    Label

    Customer Account Site ID

    Properties

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

    Date the customer site became active.

    Label

    From Date

  • keyAccountFlag (boolean)

    Indicates whether the customer site is a key customer for the sales representative.

    Label

    Key Account

  • marketSite (enumeration: SiteUsageIndicator)

    Indicates whether the customer site is assigned the Marketing business purpose. Valid values are Y, P (Yes and Primary), and N.

    Label

    Market Site

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: SiteUsageIndicator

    Valid Values

    • N
    • P
    • Y
  • originalSystemReferenceForAccountAddress (string)

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

    Label

    Original System Reference for Account Address

    Properties

    • not nullable
  • shipToSite (enumeration: SiteUsageIndicator)

    Indicates whether the customer site is assigned the Ship-to business purpose. Valid values are Y, P (Yes and Primary), and N.

    Label

    Ship-to Site

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: SiteUsageIndicator

    Valid Values

    • N
    • P
    • Y
  • status (enumeration: CustomerAccountStatus)

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

    Label

    Status

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: CustomerAccountStatus

    Properties

    • not nullable

    Valid Values

    • A
    • D
    • I
  • 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
  • toDate (date)

    Date the customer site became inactive.

    Label

    To Date

  • tradingPartnerIdentifier (int64)

    The trading partner header identifier.

    Label

    Trading Partner Identifier

  • translatedCustomerName (string)

    Customer name in the language used at the customer site.

    Label

    Translated Customer Name

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • address (ReceivablesCustomerAddress)

    Addresses include details about attributes that describe a physical address or location associated to a party.

    Business Object

    ReceivablesCustomerAddress

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for an address.

      Label

      Site ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • 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

  • 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

  • customerCategory (StandardLookupCode)

    The user-definable category. The lookup type is ADDRESS_CATEGORY.

    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

  • setIdSet (SetIdSet)

    The set is a logical group used for partitioning and sharing reference data across transactional entities, depending on the business context. The common set indicates that data isn't partitioned and is globally shared.

    Business Object

    SetIdSet

    Expand all

    Collapse all

    Fields

    • setId (int64)

      The unique identifier of the set ID set.

      Label

      Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • siteLanguage (Language)

    The languages list of values resource is used to query the list of languages.

    Business Object

    Language

    Expand all

    Collapse all

    Fields

    • languageCode (string)

      The unique code of the language.

      Label

      Language Code

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top