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. |