Rebate Program Rbt Typ Src Itm DMO

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

• RebateProgramId has a FOREIGNKEY relationship with the Rebate Program DMO Id field.
• MemberId has a FOREIGNKEY relationship with the Rebate Program Member DMO Id field.
• PeriodId has a FOREIGNKEY relationship with the Rebate Program Payout Period DMO Id field.
• RebateTypeId has a FOREIGNKEY relationship with the Rebate Program Rebate Type DMO Id field.
• BenefitId has a FOREIGNKEY relationship with the Rebate Program Rbt Typ Benefit DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.

• BenefitId
• BenefitName
• BenefitValue
• cdp_sys_record_currency
• CumulativeQualifierValue
• DataSourceId
• DataSourceObjectId
• EffectiveDate
• Id
• InputDate
• InputValue
• InternalOrganizationId
• MemberId
• MemberName
• OutputCreatedDateTime
• ParentReferenceNumber
• PeriodId
• PeriodName
• ProductId
• ProductName
• Reason
• RebateProgramId
• RebateProgramName
• RebateTypeId
• RebateTypeName
• SrcItmName
• Status
• TransactionId
• TransactionNumber
• Value

• Field API Name: std__BenefitId__c
• Data Type: TEXT
• Description: The specific benefit record that applies to this source item. A benefit defines a rate-threshold pair (e.g., 3% rebate for purchases over $10,000). Determines the rate used to compute the rebate value.

• Field API Name: std__BenefitName__c
• Data Type: TEXT
• Description: Denormalized name of the benefit/tier stored on the source item for reporting and audit.

• Field API Name: std__BenefitValue__c
• Data Type: DOUBLE
• Description: Benefit value applied for calculation of the accrued amount.

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__CumulativeQualifierValue__c
• Data Type: DOUBLE
• Description: Running cumulative total of the qualifier value up to and including this source item within the period. Used to evaluate stepped-rate or tiered rebate structures where the rate changes as the member crosses volume thresholds.

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__EffectiveDate__c
• Data Type: DATEONLY
• Description: The business-effective date of the source item when the calculation was done.

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

• Field API Name: std__InputDate__c
• Data Type: DATEONLY
• Description: Input date or activity date of the source transaction.

• Field API Name: std__InputValue__c
• Data Type: DOUBLE
• Description: The raw qualifying value extracted from the source transaction (e.g., net invoice amount, units purchased, or revenue) before any rebate-specific transformations or rate applications.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__MemberId__c
• Data Type: TEXT
• Description: The account (distributor, retailer, or other member) for whom this source item is being processed.

• Field API Name: std__MemberName__c
• Data Type: TEXT
• Description: Denormalized name of the member account stored on the source item for reporting and display.

• Field API Name: std__OutputCreatedDateTime__c
• Data Type: DATETIME
• Description: System-generated timestamp recording when the source item record was created by the rebate engine.

• Field API Name: std__ParentReferenceNumber__c
• Data Type: TEXT
• Description: Reference number of the parent accrual record (Program Rebate Type Accrual/Payout) that this source item belongs to. Used for hierarchical linking, grouping, and reconciliation reporting across source items.

• Field API Name: std__PeriodId__c
• Data Type: TEXT
• Description: The rebate calculation period (e.g., monthly, quarterly, or annual) to which this source item belongs.

• Field API Name: std__PeriodName__c
• Data Type: TEXT
• Description: Denormalized name of the rebate period stored on the source item for reporting.

• Field API Name: std__ProductId__c
• Data Type: TEXT
• Description: The product (SKU or product family) that qualifies for the rebate in this source item.

• Field API Name: std__ProductName__c
• Data Type: TEXT
• Description: Denormalized name of the product stored on the source item for line-item reporting.

• Field API Name: std__Reason__c
• Data Type: TEXT
• Description: A reason code or free-text description indicating why this source item was generated (e.g., Accrual, ChangedInput, ChangedRuleValue, ChangedRuleTimeRange, ChangedRuleValueAndTimeRange, RuleCancellation, TierChange, TierValueChange, TierRangeChange, TierValueAndRangeChange).

• Field API Name: std__RebateProgramId__c
• Data Type: TEXT
• Description: The rebate program under which this source item’s rebate is being calculated.

• Field API Name: std__RebateProgramName__c
• Data Type: TEXT
• Description: Denormalized name of the rebate program stored on the source item for reporting and display.

• Field API Name: std__RebateTypeId__c
• Data Type: TEXT
• Description: The type of rebate that governs how the calculation is performed for this source item. Defines the calculation method such as volume-based, growth-based, flat-rate, or tiered.

• Field API Name: std__RebateTypeName__c
• Data Type: TEXT
• Description: Denormalized name of the rebate type stored on the source item.

• Field API Name: std__SrcItmName__c
• Data Type: TEXT
• Description: Name of the source item record.

• Field API Name: std__Status__c
• Data Type: TEXT
• Description: The current processing status of this source item in the rebate calculation pipeline.

• Field API Name: std__TransactionId__c
• Data Type: TEXT
• Description: Foreign key to the originating source transaction (e.g., invoice, sales order, or credit memo) that generated this rebate source item.

• Field API Name: std__TransactionNumber__c
• Data Type: TEXT
• Description: Human-readable number of the source transaction copied from the transaction record.

• Field API Name: std__Value__c
• Data Type: DOUBLE
• Description: The accrued amount for this source item.