Rebate Member Product Aggregate DMO

Object API Name: RebateMemberProductAggregate_std__dlm
Category: Unassigned
Availability: Available in 262 and later versions
Primary Key Field: Id

• OwnerId has a FOREIGNKEY relationship with the User DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• ProgramRebateTypeId has a FOREIGNKEY relationship with the Rebate Program Rebate Type DMO Id field.
• RebateProgramMemberId has a FOREIGNKEY relationship with the Rebate Program Member DMO Id field.
• RebateProgramPayoutPeriodId has a FOREIGNKEY relationship with the Rebate Program Payout Period DMO Id field.
• RollupProgramMemberId has a FOREIGNKEY relationship with the Rebate Program Member DMO Id field.
• TransactionJournalId has a FOREIGNKEY relationship with the Loyalty Transaction Journal DMO Id field.

• cdp_sys_record_currency
• CreatedDateTime
• DataSourceId
• DataSourceObjectId
• GrowthAmount
• GrowthAmountPercent
• GrowthQuantity
• GrowthQuantityPercent
• Id
• InternalOrganizationId
• KQ_Id
• KQ_OwnerId
• KQ_ProductId
• KQ_ProgramRebateTypeId
• KQ_RebateProgramMemberId
• KQ_RebateProgramPayoutPeriodId
• KQ_RollupProgramMemberId
• KQ_TransactionJournalId
• LastModifiedDateTime
• OwnerId
• PriorTotalQuantity
• PriorTotalTransactionAmount
• ProductAggregateName
• ProductId
• ProgramRebateTypeId
• RebatePayoutStatus
• RebatePayoutStatusMessageText
• RebateProgramMemberId
• RebateProgramPayoutPeriodId
• RollupProgramMemberId
• TotalQuantity
• TotalTransactionAmount
• TransactionJournalId

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System record currency code

• Field API Name: CreatedDateTime__c
• Data Type: DATETIME
• Description: Audit Column

• Field API Name: DataSourceId__c
• Data Type: TEXT
• Description: Data source identifier

• Field API Name: DataSourceObjectId__c
• Data Type: TEXT
• Description: Data source object identifier

• Field API Name: GrowthAmount__c
• Data Type: CURRENCY
• Description: In the transaction journal associated with the rebate aggregate, the difference between the total transaction amount and the previous transaction amount.

• Field API Name: GrowthAmountPercent__c
• Data Type: DOUBLE
• Description: The transaction growth amount in percentage.

• Field API Name: GrowthQuantity__c
• Data Type: DOUBLE
• Description: In the transaction journal associated with the rebate aggregate, the difference between the total quantity and the previous quantity.

• Field API Name: GrowthQuantityPercent__c
• Data Type: DOUBLE
• Description: The quantity growth in percentage.

• Field API Name: Id__c
• Data Type: TEXT
• Description: Primary Key

• Field API Name: InternalOrganizationId__c
• Data Type: TEXT
• Description: Internal organization identifier

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_OwnerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OwnerId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: KQ_ProgramRebateTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProgramRebateTypeId

• Field API Name: KQ_RebateProgramMemberId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RebateProgramMemberId

• Field API Name: KQ_RebateProgramPayoutPeriodId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RebateProgramPayoutPeriodId

• Field API Name: KQ_RollupProgramMemberId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RollupProgramMemberId

• Field API Name: KQ_TransactionJournalId__c
• Data Type: TEXT
• Description: Key Qualifier system field for TransactionJournalId

• Field API Name: LastModifiedDateTime__c
• Data Type: DATETIME
• Description: Audit Column

• Field API Name: OwnerId__c
• Data Type: TEXT
• Description: Owner of the Aggregate

• Field API Name: PriorTotalQuantity__c
• Data Type: DOUBLE
• Description: The quantity in the corresponding payout period of the previous rebate cycle.

• Field API Name: PriorTotalTransactionAmount__c
• Data Type: CURRENCY
• Description: The transaction amount in the corresponding payout period of the previous rebate cycle.

• Field API Name: ProductAggregateName__c
• Data Type: TEXT
• Description: Name of the Member Aggregate

• Field API Name: ProductId__c
• Data Type: TEXT
• Description: The product associated with the rebate aggregation.

• Field API Name: ProgramRebateTypeId__c
• Data Type: TEXT
• Description: The program rebate type associated with the rebate aggregation.

• Field API Name: RebatePayoutStatus__c
• Data Type: TEXT
• Description: Aggregate payout status of Rebates payout processing job

• Field API Name: RebatePayoutStatusMessageText__c
• Data Type: TEXT
• Description: Aggregate payout status message of Rebates payout processing job

• Field API Name: RebateProgramMemberId__c
• Data Type: TEXT
• Description: The rebate program member associated with the rebate aggregation.

• Field API Name: RebateProgramPayoutPeriodId__c
• Data Type: TEXT
• Description: The rebate program payout period associated with the rebate aggregation.

• Field API Name: RollupProgramMemberId__c
• Data Type: TEXT
• Description: The immediate parent account in the hierarchy of the account (rebate program member) associated with the product aggregate.

• Field API Name: TotalQuantity__c
• Data Type: DOUBLE
• Description: The sum of values in transaction journal quantity fields associated with the rebate aggregation.

• Field API Name: TotalTransactionAmount__c
• Data Type: CURRENCY
• Description: The sum of values in transaction journal transaction amount fields associated with the rebate aggregation.

• Field API Name: TransactionJournalId__c
• Data Type: TEXT
• Description: The transaction journal associated with the program rebate type.