Party Usage Assignments
The party usage assignment view object stores information about party usage assignments.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.PartyUsageAssignmentExtractPVO
Primary Keys : PartyUsgAssignmentId
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 party usage assignment descriptive flexfield. |
| Attribute10 | A segment for the party usage assignment descriptive flexfield. |
| Attribute11 | A segment for the party usage assignment descriptive flexfield. |
| Attribute12 | A segment for the party usage assignment descriptive flexfield. |
| Attribute13 | A segment for the party usage assignment descriptive flexfield. |
| Attribute14 | A segment for the party usage assignment descriptive flexfield. |
| Attribute15 | A segment for the party usage assignment descriptive flexfield. |
| Attribute16 | A segment for the party usage assignment descriptive flexfield. |
| Attribute17 | A segment for the party usage assignment descriptive flexfield. |
| Attribute18 | A segment for the party usage assignment descriptive flexfield. |
| Attribute19 | A segment for the party usage assignment descriptive flexfield. |
| Attribute2 | A segment for the party usage assignment descriptive flexfield. |
| Attribute20 | A segment for the party usage assignment descriptive flexfield. |
| Attribute21 | A segment for the party usage assignment descriptive flexfield. |
| Attribute22 | A segment for the party usage assignment descriptive flexfield. |
| Attribute23 | A segment for the party usage assignment descriptive flexfield. |
| Attribute24 | A segment for the party usage assignment descriptive flexfield. |
| Attribute25 | A segment for the party usage assignment descriptive flexfield. |
| Attribute26 | A segment for the party usage assignment descriptive flexfield. |
| Attribute27 | A segment for the party usage assignment descriptive flexfield. |
| Attribute28 | A segment for the party usage assignment descriptive flexfield. |
| Attribute29 | A segment for the party usage assignment descriptive flexfield. |
| Attribute3 | A segment for the party usage assignment descriptive flexfield. |
| Attribute30 | A segment for the party usage assignment descriptive flexfield. |
| Attribute4 | A segment for the party usage assignment descriptive flexfield. |
| Attribute5 | A segment for the party usage assignment descriptive flexfield. |
| Attribute6 | A segment for the party usage assignment descriptive flexfield. |
| Attribute7 | A segment for the party usage assignment descriptive flexfield. |
| Attribute8 | A segment for the party usage assignment descriptive flexfield. |
| Attribute9 | A segment for the party usage assignment descriptive flexfield. |
| AttributeCategory | A context name for the party usage assignment descriptive flexfield. |
| Comments | The comments entered by the user about the party usage assignment. |
| CompetitorFlag | Indicates if the party usage is assigned to competitor or not. If party_usage_code is COMPETITOR then Y, else N. |
| ContactFlag | Indicates if the party usage is assigned to customer contact or not. If party_usage_code is CUSTOMER_CONTACT then Y, else N. |
| CreatedBy | The user who created the record. |
| CreatedByModule | The module through which the record was created. |
| CreationDate | The date and time when the record was created |
| CustomerFlag | Indicates if the party usage assigned to customer or not. If party_usage_code is CUSTOMER then Y, else N. |
| CustomerSinceDt | The start date for customer. If party_usage_code is CUSTOMER, then it's CREATION_DATE, else it's NULL. |
| EffectiveEndDate | The date when the validity of the party usage assignment ends. |
| EffectiveStartDate | The date when the validity of the party usage assignment starts. |
| HrEmployeeFlag | Indicates if the party usage is assigned to HR employee or not. If party_usage_code is HR_EMPLOYEE then Y, else N. |
| LastUpdateDate | The date and time when the record was last updated |
| LastUpdateLogin | The login of the user who last updated the record. |
| LastUpdatedBy | The user who last updated the record. |
| LegalEntityFlag | Indicates if the party usage is assigned to legal entity or not. If party_usage_code is LEGAL_ENTITY then Y, else N. |
| ManufacturerFlag | Indicates if the party usage is assigned to manufacture or not. If party_usage_code is MANUFACTURER then Y, else N. |
| OrgContactFlag | Indicates if the party usage is assigned to org contact or not. If party_usage_code is ORG_CONTACT then Y, else N. |
| OwnerTableId | The owner table name which can be used to identify a party usage assignment. |
| OwnerTableName | The owner table ID which can be used to identify a party usage assignment. |
| PartyId | The unique identifier of party that the party usage is assigned to. |
| PartyUsageCode | The code that identifies the party usage. |
| PartyUsgAssignmentId | The unique identifier for a party usage assignment. This is a primary key. |
| ProspectFlag | Indicates whether the party usage is assigned to prospect or not. If party_usage_code is PROSPECT then Y, else N. |
| SalesAccountFlag | Indicates whether the party usage is assigned to sales account or not. If party_usage_code is SALES_ACCOUNT then Y, else N. |
| SalesProspectFlag | Indicates whether the party usage is assigned to sales prospect or not. If party_usage_code is SALES_PROSPECT then Y, else N. |
| SalesReferenceFlag | Indicates whether the party usage is assigned to sales reference or not. If party_usage_code is SALES_REFERENCE then Y, else N. |
| SalesaccntSinceDt | The start date for sales account. If party_usage_code is SALES_ACCOUNT, then it's CREATION_DATE, else it's NULL. |
| StatusFlag | The record status used to soft delete the record. The accepted values are A for active and I for inactive. The default value is A. |
| SupplierContactFlag | Indicates whether the party usage is assigned to supplier contact or not. If party_usage_code is SUPPLIER_CONTACT then Y, else N. |
| SupplierFlag | Indicates whether the party usage is assigned to supplier or not. If party_usage_code is SUPPLIER then Y, else N. |
| SupplierSinceDt | The start date for supplier. If party_usage_code is SUPPLIER, then it's CREATION_DATE, else it's NULL. |