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.