Customer Account Sites
The customer account site view object contains all customer account sites across all operating units. Customer account sites are customer account addresses with which the deploying company does business. One customer account can have multiple customer account sites, and customer account sites for one customer account can belong to multiple operating units.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerAccountSiteExtractPVO
Primary Keys : CustAcctSiteId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| Attribute1 | A segment for the customer account site descriptive flexfield. |
| Attribute10 | A segment for the customer account site descriptive flexfield. |
| Attribute11 | A segment for the customer account site descriptive flexfield. |
| Attribute12 | A segment for the customer account site descriptive flexfield. |
| Attribute13 | A segment for the customer account site descriptive flexfield. |
| Attribute14 | A segment for the customer account site descriptive flexfield. |
| Attribute15 | A segment for the customer account site descriptive flexfield. |
| Attribute16 | A segment for the customer account site descriptive flexfield. |
| Attribute17 | A segment for the customer account site descriptive flexfield. |
| Attribute18 | A segment for the customer account site descriptive flexfield. |
| Attribute19 | A segment for the customer account site descriptive flexfield. |
| Attribute2 | A segment for the customer account site descriptive flexfield. |
| Attribute20 | A segment for the customer account site descriptive flexfield. |
| Attribute21 | A segment for the customer account site descriptive flexfield. |
| Attribute22 | A segment for the customer account site descriptive flexfield. |
| Attribute23 | A segment for the customer account site descriptive flexfield. |
| Attribute24 | A segment for the customer account site descriptive flexfield. |
| Attribute25 | A segment for the customer account site descriptive flexfield. |
| Attribute26 | A segment for the customer account site descriptive flexfield. |
| Attribute27 | A segment for the customer account site descriptive flexfield. |
| Attribute28 | A segment for the customer account site descriptive flexfield. |
| Attribute29 | A segment for the customer account site descriptive flexfield. |
| Attribute3 | A segment for the customer account site descriptive flexfield. |
| Attribute30 | A segment for the customer account site descriptive flexfield. |
| Attribute4 | A segment for the customer account site descriptive flexfield. |
| Attribute5 | A segment for the customer account site descriptive flexfield. |
| Attribute6 | A segment for the customer account site descriptive flexfield. |
| Attribute7 | A segment for the customer account site descriptive flexfield. |
| Attribute8 | A segment for the customer account site descriptive flexfield. |
| Attribute9 | A segment for the customer account site descriptive flexfield. |
| AttributeCategory | The context name for the customer account site descriptive flexfield. |
| AttributeDate1 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate10 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate11 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate12 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate2 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate3 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate4 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate5 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate6 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate7 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate8 | A date segment for the customer account site descriptive flexfield. |
| AttributeDate9 | A date segment for the customer account site descriptive flexfield. |
| AttributeNumber1 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber10 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber11 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber12 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber2 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber3 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber4 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber5 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber6 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber7 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber8 | A number segment for the customer account site descriptive flexfield. |
| AttributeNumber9 | A number segment for the customer account site descriptive flexfield. |
| BillToFlag | Indicates whether 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 isn't a Bill-To site. |
| CreatedBy | The user who created the record. |
| CreatedByModule | The module through which the record was created. |
| CreationDate | The date and time of creating the record. |
| CustAccountId | Identifier for a customer account. Foreign key to the customer account view object. |
| CustAcctSiteId | The customer site identifier. This is a primary key. |
| CustomerCategoryCode | The user-definable category. The lookup type is ADDRESS_CATEGORY. |
| EceTpLocationCode | Stores the EDI location code. It should be unique for a customer. The column accepts free-form text. |
| EndDate | The date from which this site is no longer valid. |
| KeyAccountFlag | The key account for sales representatives. |
| Language | The operating language for account sites. |
| LastUpdateDate | The date and time of last update of the record. |
| LastUpdateLogin | The login of the user who last updated the record. |
| LastUpdatedBy | The user who last updated the record. |
| MarketFlag | Indicates whether this is a Marketing site. Y for a marketing site, P for the primary marketing site, and N for a site that's not a marketing site. |
| OrigSystemReference | The identifier for the record from the original system. |
| PartySiteId | The identifier for a party site. It's the foreign key to the party site view. |
| SetId | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they're used to filter reference data in transactional UIs. |
| ShipToFlag | 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 isn't a Ship-To site. |
| StartDate | The start date from which this site is valid for use. |
| Status | The status of the record. Receivables lookup code for CODE_STATUS. |
| TpHeaderId | The trading partner header identifier. |
| TranslatedCustomerName | The customer name in the language used at the account site. |