Transaction Lookup (PriceSettingConfig)

Key

Transaction Source

Defines where data about transactions are stored.

Condition

*

Condition is not needed here. Leave it at the default value (= *).

Type

Leave blank.

Source

• Datamart

• Datasource

• PX

Type of the table where transactions are stored.

Source Table

{name of the table with transactions}

Source Field

{name of the column with the invoice price}

Used for turnover calculation.

Source Field 2

{name of the column with the quantity field}

Used for volume calculation.

Source Field 3

{name of the column with SKU}

Only PX has a default SKU, so we require SKUs for all tables for consistency.

Source Field 4

{name of the column with the date for the invoice}

 The column must be of the Date type.

Source Field 5

{name of the column with the currency}

Invoice price currency

Source Field 6

{name of the column with minimum value of aggregated data}

Only for pre-aggregated PX Source

Source Field 7

{name of the column with maximum value of aggregated data}

Only for pre-aggregated PX Source

Source Field 8

{name of the column with average value of aggregated data}

Only for pre-aggregated PX Source