Trading Community Customer Account Site

An address associated with a customer account.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/customerAccountService/}CustomerAccountSite

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Trading Community Customer Billing Account Site Global Descriptive Flexfield SDO

Contains

Trading Community Customer Account or Site Role

Contains

Trading Community Customer Account Site Use

Contains

Trading Community Customer Account Site Additional Information

Contains

Source System Reference

Contained by

Trading Community Customer Billing Account

Handled by

Trading Community Customer Account

Attributes

The following table describes attributes in the service data object.

Name Type Description

BillToIndicator

string

Indicates if this is a Bill-To site. Y for a Bill-To site, P for the primary Bill-To site, and N for a site that is not a Bill-To site.

CreatedBy

string

The user who created the record.

CreatedByModule

string

The module that created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

CustAccountSiteGdf

Trading Community Customer Billing Account Site Global Descriptive Flexfield SDO

Customer Account Address Regional Information

CustAcctSiteInformation

Trading Community Customer Account Site Additional Information

The customer account address information.

CustomerAccountContact

Trading Community Customer Account or Site Role

The customer account contact associated with the account address.

CustomerAccountId

long

The identifier for a customer account. Foreign key to the HZ_CUST_ACCOUNTS table.

CustomerAccountSiteId

long

The customer site identifier.
  • Primary Key

CustomerAccountSiteUse

Trading Community Customer Account Site Use

The customer account address use associated with the account address.

CustomerCategoryCode

string

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

EceTpLocationCode

string

Stores the EDI location code. It should be unique for a customer. The column accepts free-form text.

EndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this.

KeyAccountFlag

boolean

The key account for sales representatives.

Language

string

The operating language for account sites.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

MarketIndicator

string

Indicates if this is a marketing site. Y for a Marketing site, P for the primary Marketing site, and N for a site that is not a Marketing site.

OrigSystemReference

string

The identifier for the record from the original system.

OriginalSystemReference

Source System Reference

The identifier for the record from the original system.

PartySiteId

long

The identifier for the party site. It is the foreign key to the HZ_PARTY_SITES table.

RequestId

long

A system-generated read-only attribute used by the application framework.

SetCode

string

The unique code to identify the reference data set for the account address.

SetId

long

Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.

ShipToIndicator

string

Indicates if this is a Ship-To site. Y for a Ship-To site, P for the primary Ship-To site, and N for a site that is not a Ship-To site.

StartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this.

Status

string

The status of the record.

TpHeaderId

long

The trading partner header identifier.

TranslatedCustomerName

string

The customer name in the language used at the account site.