Versions Compared

Version Old Version 3 New Version 4
Changes made by

Ondřej Tesař

Ondřej Tesař

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


The following table shows a list of all configuration parameters stored in SC_AdvancedConfiguration:

Name

Description

Values

Condition Type can be overwritten?

sourceType

Type of source data.

Select one of these options:

  • DM – Datamart

  • DS – Data Source

 (tick)

sourceName

Name of the source used to query and allocate the compensation value.

(tick)

pricingDateFieldName

Contains a pricing date in the Source Name.

(tick)

customerIDFieldName

Contains a customer ID in the Source Name.

(tick)

productIDFieldName

Contains a product ID in the Source Name.

(tick)

productNameFieldName

Contains a product name. It is used for the Transaction List report only.

baselineFieldName

The field name of a Value Base field is used to calculate the base value. In most cases, it will be a revenue or margin field; in some cases it can be volume. This depends on the used Condition Type.

(tick)

invoicePriceFieldName

Contains an Invoice Price in the Source Name. It is used for the Adjustments

(tick)

quantityFieldName

Contains a Quantity in the Source Name. It is used for the Adjustments

(tick)

marginFieldName

Contains a Margin in the Source Name. It is used for the Adjustments

(tick)

sellerIDFieldName

Contains an identification of a sales agent.

(tick)

currencyFieldName

Contains the main Source Name (DM or DS) currency.

payoutDays

Number of days after the end date of the payment period when the payout happens.

(tick)

paymentPeriod

Sets a frequency of payouts. The user can specify it also on a Line Item level.

Select one of these options:

  • Monthly

  • Quarterly

  • Semi-Annually

  • Annually

(tick)

quotaFor

The target defined on the line item is evaluated for each payment period (see paymentPeriod) or for the whole plan duration.

Select one of these options:

  • Payment Period – Gets a base value for every period, then compares and calculates the compensation.

  • Plan Duration – Gets a base value for the whole plan duration, then compares and calculates the compensation.

(tick)

depositScheme

Parameter providing guidance on compensation accumulation across payment periods.

If "quotaFor" is "Plan duration", you need to define how to calculate the compensation value:

  • Non-Cumulative – The compensation value is calculated for the current period based on a cumulation of the base value, then divided by the number of periods (12 months or 4 quarters, 2 for semi-annually, 1 year).

  • Cumulative – The same as with calculation of Non-Cumulative above, but the compensation value of the previous period is excluded.

(tick)

...