Input Layer
Prepare inputs for the accrual engine by using the data lake objects (DLOs) and fields of the layer.
Required Editions
Available in: Lightning Experience Available in: Enterprise and Unlimited Editions where Trade Promotion Management, Data Cloud, and CRM Analytics are enabled |
DLO: Accrualrule_ingest__dll
| ID | Id__c | Text | Unique ID for this record | 9ec5bc22-7041-4b9a-9428-25d1e07f195a |
| UsageTag | UsageTag__c | Text | Use case identifier. Records with different UsageTag don't interact with each other. | TPMAccrual_0001 |
| reference_date | reference_date__c | Date | The date that the accrual engine considers as the current date for calculation. | 2025-10-01 |
| accrualrulemetaname | accrualrulemetaname__c | Text | Name of the accrualrulemeta. | VolumeRebate |
| Account | Account__c | Text | The associated Account ID. | 001Ws00004LVgxhIAD |
| Product | Product__c | Text | The associated Product ID. | 01tTC000000EViHYAW |
| Source1 | Source1__c | Text | The associated Source1 ID. For TPM, Source1 is the Promotion ID. | a2YNW0000004Dwm2AE |
| Source2 | Source2__c | Text | The associated Source2 ID. For TPM, Source2 is the Tactic ID. | a38TC0000001WlpYAE |
| Anchor1 | Anchor1__c | Text | The associated Anchor1. This field isn’t used for TPM. | |
| Anchor2 | Anchor2__c | Text | The associated Anchor2. This field isn’t used for TPM. | |
| Anchor3 | Anchor3__c | Text | The associated Anchor3. This field isn’t used for TPM. | |
| DateFrom | DateFrom__c | Date | The date from which this rule applies. | 2025-09-01 |
| DateThru | DateThru__c | Date | The date until which this rule applies. | 2025-09-30 |
| EffectiveDate | EffectiveDate__c | Date | For rules of type LumpSum_EffectiveDate, the effective date of the rule. | 2025-09-01 |
| Status | Status__c | Text | The status of the rule. Possible values are Closed or Committed. | Closed |
| Value | Value__c | Number | The value of the rule. | 10000 |
| BaselineDateFrom | BaselineDateFrom__c | Date | For growth programs, the start date to calculate the baseline value. | 2025-08-01 |
| BaselineDateThru | BaselineDateThru__c | Date | For growth programs, the end date to calculate the baseline value. | 2025-08-31 |
| TierDateFrom | TierDateFrom__c | Date | Start date override when calculating tiers. Defaults to DateFrom if you don’t enter a value. | 2025-09-01 |
| TierDateThru | TierDateThru__c | Date | End date override when calculating tiers. Defaults to DateThru if you don’t enter a value. | 2025-09-30 |
DLO: Accrualinput_ingest__dll
| ID | Id__c | Text | Unique ID for the accrual input record. | 7ee5bbcb-546b-42f9-9d72-50d10c51d283 |
| Account | Account__c | Text | Account ID associated with the input. This value is matched with accrual rules based on accrualinputanchor configuration. | 001Ws00004LVgxhIAD |
| Product | Product__c | Text | Product ID associated with this input. This value is matched with accrual rules based on accrualinputanchor configuration. | 01tTC000000EViHYAW |
| Anchor1 | Anchor1__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| Anchor2 | Anchor2__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| Anchor3 | Anchor3__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| DateFrom | DateFrom__c | Date | Start date of the input period. | 2025-09-01 |
| DateThru | DateThru__c | Date | End date of the input period. | 2025-09-30 |
| Day[1-31] | Day1__c | Number | Input value for that specific day of the month. | 100 |
| LastModified | LastModified__c | DateTime | Timestamp when this input record was last modified | 2025-08-25T08:27:02.734Z |
| Code | Code__c | Text | Code of the accrualinputmeta. | SHIP |
| UsageTag | UsageTag__c | Text | Use case identifier. Records with different UsageTag don't interact with each other. | TPMAccrual_0001 |
| SfdcOrganizationId | SfdcOrganizationId__c | Text | Salesforce Organization ID. | 00DTC000004e31h |
DLO: Accrualtier_ingest__dll
| ID | Id__c | Text | Unique ID of the tier. | 1ded1695-4eec-464c-a667-236fbcd569fe |
| accrualrule | accrualrule__c | Text | Reference to the relevant accrualrule. | d1f39a75-9544-4604-b1a0-2f5e7a0cae72 |
| FromValue | FromValue__c | Number | Aggregated amount of the tier input after which the tier is applied. | 50000 |
| ToValue | ToValue__c | Number | Aggregated amount of the tier input after which this tier doesn’t apply. | 100000 |
| Value | Value__c | Number | Value of the rule for the tier. | 0.3 |
DLO: Accrualinput_day_ingest__dll
| ID | Id__c | Text | Unique ID for the input, and to help process the input changes. | 36e05f90-28f5-464c-b975-ce136037e35d |
| LastModified | LastModified__c | DateTime | Timestamp when the input was last modified. | 2025-08-25T08:27:02.734Z |
| SfdcOrganizationId | SfdcOrganizationId__c | Text | Salesforce Organization ID. | 00DTC000004e31h |
| UsageTag | UsageTag__c | Text | Use case identifier. | TPMAccrual_0001 |
| Account | Account__c | Text | Account ID associated with this input. Based on the anchor configuration, this field is optional. | 001TC00000996ygYAA |
| Product | Product__c | Text | The associated Product ID. Based on the anchor configuration, this field is optional. | 01tTC000003XTZrYAO |
| Anchor1 | Anchor1__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| Anchor2 | Anchor2__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| Anchor3 | Anchor3__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| InputDate | InputDate__c | Date | The date on which you provide the input. | 2025-08-25 |
| Code | Code__c | Text | Measure code for the input. | SHIP |
| Value | Value__c | Number | Amount for the input. | 10 |
DLO: Accrualclaim_ingest__dll
| ID | Id__c | Text | Unique ID for the accrual claim record. | 8c1a997f-2cfb-4e1b-ae5d-3b394580c9ec |
| accrualclaimmetaname | accrualclaimmetaname__c | Text | Name of the accrualclaimmeta used for the claim. | PaidAmount |
| UsageTag | UsageTag__c | Text | Use case identifier. Records with different UsageTag don’t interact with each other. | TPMAccrual_0001 |
| Account | Account__c | Text | The associated Account ID that is used for matching based on accrualclaimanchor configuration. | 001Ws00004LVgxhIAD |
| Product | Product__c | Text | The associated Product ID that is used for matching based on accrualclaimanchor configuration. | 01tTC000000EViHYAW |
| Source1 | Source1__c | Text | The associated Source1 ID that is used to match based on accrualclaimanchor configuration. For example, Promotion ID in TPM. | a2YNW0000004Dwm2AE |
| Source2 | Source2__c | Text | The associated Source1 ID that is used to match based on accrualclaimanchor configuration. For example, Tactic ID in TPM. | a38TC0000001WlpYAE |
| Anchor1 | Anchor1__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| Anchor2 | Anchor2__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| Anchor3 | Anchor3__c | Text | Generic anchor to match with accrual rule. This field is optional and is used based on accrualinputanchor configuration. | |
| CreatedDateTime | CreatedDateTime__c | DateTime | Timestamp when this claim record was created. | 2025-09-15T10:30:00.000Z |
| EffectiveDate | EffectiveDate__c | Date | The date on which this claim is effective. | 2025-09-15 |
| Status | Status__c | Text | The status of the claim. For example, Approved or Paid. | Paid |
| Value | Value__c | Number | The amount paid for this claim. This amount is used in reconciliation during rule closure. | 1000 |
| SfdcOrganizationId | SfdcOrganizationId__c | Text | Salesforce Organization ID. | 00DTC000004e31h |
Did this article solve your issue?
Let us know so we can improve!
