RebateMemberProductAggregate

Stores the post calculation summary of journal transactions by member, period, and rebate type. For example, ABC enterprises for May 2021 against Vol Rebate on Radius category, did a total quantity of 150 units and transaction amount of $80,000. This object is available in API version 65.0 and later.

Supported Calls

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()

Fields

AggregateReferenceNumber

Type: string
Properties: Create, Filter, Group, idLookup, Nillable, Sort, Update
Description: A unique reference number of the aggregate record that’s assigned by the Data Processing Engine when generating Rebate Program Member Aggregate records. This reference number can be used to relate Rebate Member Aggregate Item records to the aggregate record.

Available in API version 54.0 and later.

GrowthAmount

Type: currency
Properties: Create, Filter, Nillable, Sort, Update
Description: The difference between the total amount and the prior amount in the rebate aggregate.

GrowthAmountPercent

Type: double
Properties: Create, Filter, Nillable, Sort, Update
Description: The difference between the total amount and the prior amount in percentage in the rebate aggregate.

GrowthQuantity

Type: double
Properties: Create, Filter, Nillable, Sort, Update
Description: The difference between the total quantity and the previous quantity in the transaction journal associated with the rebate aggregate.

GrowthQuantityPercent

Type: double
Properties: Create, Filter, Nillable, Sort, Update
Description: The quantity growth in percentage.

LastReferencedDate

Type: dateTime
Properties: Filter, Nillable, Sort
Description: The timestamp when the current user last accessed this record indirectly, for example, through a list view or related record.

LastViewedDate

Type: dateTime
Properties: Filter, Nillable, Sort
Description: The timestamp when the current user last viewed this record or list view. If this value is null, and LastReferenceDate is not null, the user accessed this record or list view indirectly.

Name

Type: string
Properties: Autonumber, Defaulted on create, Filter, idLookup, Sort
Description: Name of the rebate member product aggregate.

OwnerId

Type: reference
Properties: Create, Defaulted on create, Filter, Group, Sort, Update
Description: ID of the owner of this object.

This field is a polymorphic relationship field.
Relationship Name: Owner
Relationship Type: Lookup
Refers To: Group, User

PriorTotalQuantity

Type: double
Properties: Create, Filter, Nillable, Sort, Update
Description: The quantity in the corresponding payout period of the previous rebate cycle.

PriorTotalTransactionAmount

Type: currency
Properties: Create, Filter, Nillable, Sort, Update
Description: The total transaction amount corresponding to the prior period.

ProductId

Type: reference
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: The product associated with the rebate aggregation.

ProgramRebateTypeId

Type: reference
Properties: Create, Filter, Group, Sort, Update
Description: The program rebate type associated with the rebate aggregation.

RebatePayoutStatus

Type: picklist
Properties: Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update
Description: The status of the aggregate rebate payout to the member.
Default value: InProgress
Possible values:
- Error
- InProgress
- Success

RebatePayoutStatusMessage

Type: string
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: The status message of the aggregate rebate payout to the member.

RebateProgramMemberId

Type: reference
Properties: Create, Filter, Group, Sort, Update
Description: The rebate program member associated with the rebate aggregation.

RebateProgramPayoutPeriodId

Type: reference
Properties: Create, Filter, Group, Sort, Update
Description: The rebate program payout period associated with the rebate aggregation.

RollupProgramMemberId

Type: reference
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: The immediate parent account in the hierarchy of the account (rebate program member) associated with the product aggregate. This field is available in API version 52.0 and later.

This is a relationship field.
Relationship Name: RollupProgramMember
Relationship Type: Lookup
Refers To: RebateProgramMember

TotalQuantity

Type: double
Properties: Create, Filter, Nillable, Sort, Update
Description: The sum of values in transaction journal quantity fields associated with the rebate aggregation.

TotalTransactionAmount

Type: currency
Properties: Create, Filter, Nillable, Sort, Update
Description: The sum of values in transaction journal transaction amount fields associated with the rebate aggregation.

TransactionJournalId

Type: reference
Properties: Create, Filter, Group, Nillable, Sort, Update
Description: The transaction journal associated with the program rebate type.