Customer Account Site Use
The customer account site use view object contains 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 purposes.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerAcctSiteUseExtractPVO
Primary Keys : SiteUseId
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 use descriptive flexfield. |
| Attribute10 | A segment for the customer account site use descriptive flexfield. |
| Attribute11 | A segment for the customer account site use descriptive flexfield. |
| Attribute12 | A segment for the customer account site use descriptive flexfield. |
| Attribute13 | A segment for the customer account site use descriptive flexfield. |
| Attribute14 | A segment for the customer account site use descriptive flexfield. |
| Attribute15 | A segment for the customer account site use descriptive flexfield. |
| Attribute16 | A segment for the customer account site use descriptive flexfield. |
| Attribute17 | A segment for the customer account site use descriptive flexfield. |
| Attribute18 | A segment for the customer account site use descriptive flexfield. |
| Attribute19 | A segment for the customer account site use descriptive flexfield. |
| Attribute2 | A segment for the customer account site use descriptive flexfield. |
| Attribute20 | A segment for the customer account site use descriptive flexfield. |
| Attribute21 | A segment for the customer account site use descriptive flexfield. |
| Attribute22 | A segment for the customer account site use descriptive flexfield. |
| Attribute23 | A segment for the customer account site use descriptive flexfield. |
| Attribute24 | A segment for the customer account site use descriptive flexfield. |
| Attribute25 | A segment for the customer account site use descriptive flexfield. |
| Attribute26 | A segment for the customer account site use descriptive flexfield. |
| Attribute27 | A segment for the customer account site use descriptive flexfield. |
| Attribute28 | A segment for the customer account site use descriptive flexfield. |
| Attribute29 | A segment for the customer account site use descriptive flexfield. |
| Attribute3 | A segment for the customer account site use descriptive flexfield. |
| Attribute30 | A segment for the customer account site use descriptive flexfield. |
| Attribute4 | A segment for the customer account site use descriptive flexfield. |
| Attribute5 | A segment for the customer account site use descriptive flexfield. |
| Attribute6 | A segment for the customer account site use descriptive flexfield. |
| Attribute7 | A segment for the customer account site use descriptive flexfield. |
| Attribute8 | A segment for the customer account site use descriptive flexfield. |
| Attribute9 | A segment for the customer account site use descriptive flexfield. |
| AttributeCategory | The context name for the customer account site use descriptive flexfield. |
| AttributeDate1 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate10 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate11 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate12 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate2 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate3 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate4 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate5 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate6 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate7 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate8 | A date segment for the customer account site use descriptive flexfield. |
| AttributeDate9 | A date segment for the customer account site use descriptive flexfield. |
| AttributeNumber1 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber10 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber11 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber12 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber2 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber3 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber4 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber5 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber6 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber7 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber8 | A number segment for the customer account site use descriptive flexfield. |
| AttributeNumber9 | A number segment for the customer account site use descriptive flexfield. |
| BillToSiteUseId | The unique identifier of the bill-to site use. |
| 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. |
| CustAcctSiteId | The identifier for the customer account site. Foreign key to the HZ_CUST_ACCT_SITES_ALL table. |
| EndDate | The date from which this site use is no longer valid. |
| FinchrgReceivablesTrxId | Identifies receivables activity that are used for finance charges. |
| GsaIndicator | Indicates whether this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that aren't served by the GSA. |
| LastAccrueChargeDate | The last date that accrued finance charges were computed for this site. |
| LastUnaccrueChargeDate | The last date that unaccrued finance charges were computed for this site. |
| 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. |
| Location | The site use identifier. |
| OrigSystemReference | The identifier for the record from the original system. |
| PaymentTermId | The payment term identifier. |
| PrimaryFlag | Indicates if this site is the primary site for this customer account. Y for the primary customer account site. N for other customer account sites. |
| SecondLastAccrueChargeDate | The next-to-last date that accrued finance charges were computed for this site. |
| SecondLastUnaccrueChrgDate | The next-to-last date that unaccrued finance charges were computed for this site. |
| 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. |
| SicCode | The standard Industry Classification (SIC) code. |
| SiteUseCode | The business purpose assigned to customer site account, such as Bill-To, Market, and Statements. |
| SiteUseId | The site use identifier, primary key. |
| SortPriority | The sort priority information. |
| StartDate | Start date from which this site use is valid. |
| Status | The status of the record. |
| TaxClassification | Classifies Bill-To site to tax group codes. Foreign key to the AR_LOOKUPS table (AR_TAX_CLASSIFICATION) used in AR_VAT_TAX (TAX_CLASSIFICATION) indexes. |
| TaxCode | The tax code associated with this site. |
| TaxHeaderLevelFlag | Used by Oracle Sales Compensation. |
| TaxReference | The taxpayer identification number. |
| TaxRoundingRule | The tax rounding rule information. |
| TerritoryId | The territory identifier. |