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.