# Rebate Member Product Aggregate DMO

## Object Properties

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

## Relationships

- **OwnerId** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.
- **ProductId** has a FOREIGNKEY relationship with the [Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productdmo-dmo.md) `Id` field.
- **ProgramRebateTypeId** has a FOREIGNKEY relationship with the [Rebate Program Rebate Type DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-rebateprogramrebatetypedmo-dmo.md) `Id` field.
- **RebateProgramMemberId** has a FOREIGNKEY relationship with the [Rebate Program Member DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-rebateprogrammemberdmo-dmo.md) `Id` field.
- **RebateProgramPayoutPeriodId** has a FOREIGNKEY relationship with the [Rebate Program Payout Period DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-rebateprogrampayoutperioddmo-dmo.md) `Id` field.
- **RollupProgramMemberId** has a FOREIGNKEY relationship with the [Rebate Program Member DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-rebateprogrammemberdmo-dmo.md) `Id` field.
- **TransactionJournalId** has a FOREIGNKEY relationship with the [Loyalty Transaction Journal DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltytransactionjournaldmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedDateTime](#createddatetime)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [GrowthAmount](#growthamount)
- [GrowthAmountPercent](#growthamountpercent)
- [GrowthQuantity](#growthquantity)
- [GrowthQuantityPercent](#growthquantitypercent)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_OwnerId](#kq_ownerid)
- [KQ_ProductId](#kq_productid)
- [KQ_ProgramRebateTypeId](#kq_programrebatetypeid)
- [KQ_RebateProgramMemberId](#kq_rebateprogrammemberid)
- [KQ_RebateProgramPayoutPeriodId](#kq_rebateprogrampayoutperiodid)
- [KQ_RollupProgramMemberId](#kq_rollupprogrammemberid)
- [KQ_TransactionJournalId](#kq_transactionjournalid)
- [LastModifiedDateTime](#lastmodifieddatetime)
- [OwnerId](#ownerid)
- [PriorTotalQuantity](#priortotalquantity)
- [PriorTotalTransactionAmount](#priortotaltransactionamount)
- [ProductAggregateName](#productaggregatename)
- [ProductId](#productid)
- [ProgramRebateTypeId](#programrebatetypeid)
- [RebatePayoutStatus](#rebatepayoutstatus)
- [RebatePayoutStatusMessageText](#rebatepayoutstatusmessagetext)
- [RebateProgramMemberId](#rebateprogrammemberid)
- [RebateProgramPayoutPeriodId](#rebateprogrampayoutperiodid)
- [RollupProgramMemberId](#rollupprogrammemberid)
- [TotalQuantity](#totalquantity)
- [TotalTransactionAmount](#totaltransactionamount)
- [TransactionJournalId](#transactionjournalid)

### cdp_sys_record_currency

- **Field API Name:** `cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System record currency code

### CreatedDateTime

- **Field API Name:** `CreatedDateTime__c`
- **Data Type:** DATETIME
- **Description:** Audit Column

### DataSourceId

- **Field API Name:** `DataSourceId__c`
- **Data Type:** TEXT
- **Description:** Data source identifier

### DataSourceObjectId

- **Field API Name:** `DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** Data source object identifier

### GrowthAmount

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

### GrowthAmountPercent

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

### GrowthQuantity

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

### GrowthQuantityPercent

- **Field API Name:** `GrowthQuantityPercent__c`
- **Data Type:** DOUBLE
- **Description:** The quantity growth in percentage.

### Id

- **Field API Name:** `Id__c`
- **Data Type:** TEXT
- **Description:** Primary Key

### InternalOrganizationId

- **Field API Name:** `InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** Internal organization identifier

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_OwnerId

- **Field API Name:** `KQ_OwnerId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for OwnerId

### KQ_ProductId

- **Field API Name:** `KQ_ProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductId

### KQ_ProgramRebateTypeId

- **Field API Name:** `KQ_ProgramRebateTypeId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProgramRebateTypeId

### KQ_RebateProgramMemberId

- **Field API Name:** `KQ_RebateProgramMemberId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for RebateProgramMemberId

### KQ_RebateProgramPayoutPeriodId

- **Field API Name:** `KQ_RebateProgramPayoutPeriodId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for RebateProgramPayoutPeriodId

### KQ_RollupProgramMemberId

- **Field API Name:** `KQ_RollupProgramMemberId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for RollupProgramMemberId

### KQ_TransactionJournalId

- **Field API Name:** `KQ_TransactionJournalId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for TransactionJournalId

### LastModifiedDateTime

- **Field API Name:** `LastModifiedDateTime__c`
- **Data Type:** DATETIME
- **Description:** Audit Column

### OwnerId

- **Field API Name:** `OwnerId__c`
- **Data Type:** TEXT
- **Description:** Owner of the Aggregate

### PriorTotalQuantity

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

### PriorTotalTransactionAmount

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

### ProductAggregateName

- **Field API Name:** `ProductAggregateName__c`
- **Data Type:** TEXT
- **Description:** Name of the Member Aggregate

### ProductId

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

### ProgramRebateTypeId

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

### RebatePayoutStatus

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

### RebatePayoutStatusMessageText

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

### RebateProgramMemberId

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

### RebateProgramPayoutPeriodId

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

### RollupProgramMemberId

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

### TotalQuantity

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

### TotalTransactionAmount

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

### TransactionJournalId

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