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