Customer Accounts
The customer account view object contains information about customer accounts, or business relationships that the deploying company establishes with a party of type Organization or Person. It provides business relationships and how transactions are conducted in the relationship. Since a party can have multiple customer accounts, this view might contain several records for a single party. For example, an individual person can establish a personal account, family account, and a professional account for a consulting practice.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerAccountExtractPVO
Primary Keys : CustAccountId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
AccountEstablishedDate | The date when the customer account was originally established through either an Oracle Application or a legacy system. |
AccountName | The description chosen by external party. It can be entered internally on behalf of the customer. |
AccountNumber | The account number. |
AccountTerminationDate | The date when the customer account was originally terminated through either an Oracle Application or a legacy system. |
ArrivalsetsIncludeLinesFlag | Indicates whether lines include arrival sets. Y for lines included on arrival sets, N for lines not automatically included in arrival sets. |
Attribute1 | A segment for the customer account descriptive flexfield. |
Attribute10 | A segment for the customer account descriptive flexfield. |
Attribute11 | A segment for the customer account descriptive flexfield. |
Attribute12 | A segment for the customer account descriptive flexfield. |
Attribute13 | A segment for the customer account descriptive flexfield. |
Attribute14 | A segment for the customer account descriptive flexfield. |
Attribute15 | A segment for the customer account descriptive flexfield. |
Attribute16 | A segment for the customer account descriptive flexfield. |
Attribute17 | A segment for the customer account descriptive flexfield. |
Attribute18 | A segment for the customer account descriptive flexfield. |
Attribute19 | A segment for the customer account descriptive flexfield. |
Attribute2 | A segment for the customer account descriptive flexfield. |
Attribute20 | A segment for the customer account descriptive flexfield. |
Attribute21 | A segment for the customer account descriptive flexfield. |
Attribute22 | A segment for the customer account descriptive flexfield. |
Attribute23 | A segment for the customer account descriptive flexfield. |
Attribute24 | A segment for the customer account descriptive flexfield. |
Attribute25 | A segment for the customer account descriptive flexfield. |
Attribute26 | A segment for the customer account descriptive flexfield. |
Attribute27 | A segment for the customer account descriptive flexfield. |
Attribute28 | A segment for the customer account descriptive flexfield. |
Attribute29 | A segment for the customer account descriptive flexfield. |
Attribute3 | A segment for the customer account descriptive flexfield. |
Attribute30 | A segment for the customer account descriptive flexfield. |
Attribute4 | A segment for the customer account descriptive flexfield. |
Attribute5 | A segment for the customer account descriptive flexfield. |
Attribute6 | A segment for the customer account descriptive flexfield. |
Attribute7 | A segment for the customer account descriptive flexfield. |
Attribute8 | A segment for the customer account descriptive flexfield. |
Attribute9 | A segment for the customer account descriptive flexfield. |
AttributeCategory | The context name segment for the customer account descriptive flexfield. |
AttributeDate1 | A date segment for the customer account descriptive flexfield. |
AttributeDate10 | A date segment for the customer account descriptive flexfield. |
AttributeDate11 | A date segment for the customer account descriptive flexfield. |
AttributeDate12 | A date segment for the customer account descriptive flexfield. |
AttributeDate2 | A date segment for the customer account descriptive flexfield. |
AttributeDate3 | A date segment for the customer account descriptive flexfield. |
AttributeDate4 | A date segment for the customer account descriptive flexfield. |
AttributeDate5 | A date segment for the customer account descriptive flexfield. |
AttributeDate6 | A date segment for the customer account descriptive flexfield. |
AttributeDate7 | A date segment for the customer account descriptive flexfield. |
AttributeDate8 | A date segment for the customer account descriptive flexfield. |
AttributeDate9 | A date segment for the customer account descriptive flexfield. |
AttributeNumber1 | A number segment for the customer account descriptive flexfield. |
AttributeNumber10 | A number segment for the customer account descriptive flexfield. |
AttributeNumber11 | A number segment for the customer account descriptive flexfield. |
AttributeNumber12 | A number segment for the customer account descriptive flexfield. |
AttributeNumber2 | A number segment for the customer account descriptive flexfield. |
AttributeNumber3 | A number segment for the customer account descriptive flexfield. |
AttributeNumber4 | A number segment for the customer account descriptive flexfield. |
AttributeNumber5 | A number segment for the customer account descriptive flexfield. |
AttributeNumber6 | A number segment for the customer account descriptive flexfield. |
AttributeNumber7 | A number segment for the customer account descriptive flexfield. |
AttributeNumber8 | A number segment for the customer account descriptive flexfield. |
AttributeNumber9 | A number segment for the customer account descriptive flexfield. |
AutopayFlag | Indicates autopay is enabled. |
Comments | The comments for the record. |
CoterminateDayMonth | Identifies the date when services ordered by the customer will end. Values for this column will take the form DD-MON. |
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 | The unique identifier for the account created for a party. This is a primary key. |
CustomerClassCode | The customer class identifier. For example, an account created for a reseller or educational customers would have a customer_class_code as reseller or education. |
CustomerType | The receivables lookup code for the CUSTOMER_TYPE attribute. I for internal customers, R for revenue generating external customers. |
DateTypePreference | The preference for ship or arrival dates. |
DepositRefundMethod | The refund method. |
HeldBillExpirationDate | The held bill expiration date. |
HoldBillFlag | Indicates whether the bill receivable should be held or not. If the value is True, then the bill receivables should be held. |
LastBatchId | The last active batch. |
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. |
NpaNumber | Identifies an account with a Number Plan Area (NPA) used in telecommunications. |
OrigSystemReference | The identifier for the record from the original system. |
PartyId | The unique identifier of the contact party. |
SellingPartyId | Identifier of the party entering a business relationship as a seller. A selling party can be an individual or an organization. The Selling Party represents the external facing organization with which the customer is doing business, and isn't necessarily a Legal Entity or Operating Unit. |
SourceCode | The promotion that was used to make the party a customer. |
Status | The status of the record. Lookup code for CODE_STATUS. |
StatusUpdateDate | The last status update date. |
TaxCode | The tax code for the customer. |
TaxHeaderLevelFlag | Indicate whether item is tax header or a line item. Y for records that are headers for tax purposes, N for records that are lines. |
TaxRoundingRule | The tax amount rounding rule. |