Config Name

Name of different configuration properties.

Values: DataPartitionedForLoad, PrimarySourceAlias, PrimarySourceName, PrimarySourceType, etc. (available as dropdown)

Config Owner

Owner (Extractor name) of the respective configuration properties.

Config Value

Value of the respective configuration properties.

Example: primary source name of an extractor. 

Is Active?

Flag to identify if the current row configuration is active (included in the calculation) or not.

Description

Description of the configuration property, if any.

Country

Country name in full form.

Region

Pre-defined set of regions for Plasma.

Alpha-2 Code

Country Code in 2-character format.

Alpha-3 Code

Country Code in 3-character format.

Name

String value of an operator, such as EQUAL, NOT_EQUAL, IN, NOT_IN, BETWEEN, NOT_NULL, NULL, LESS_THAN, GREATER_THAN, etc.

Value

Respective operator value, such as =, !=, IN, NOT IN, BETWEEN, IS NOT NULL, IS NULL, <, >, etc.

Extractor

Name of the extractor.

Audit Date

DateTime when the message is logged.

Status

Either SUCCESS or ERROR.

Message

Message regarding the number of fetched, processed rows, etc.

Additional Info

Additional info in case of an error or omitted rows.

Omitted Rows

Number of omitted rows.

Sequence Name

Unique name of the sequence (usually the extractor name).

Order

The order in which the particular jobs in a sequence are executed.

Type

Sequence type (DL, CFS, etc.).

Action Name

Name of the job (Label of DL, CFS, etc.).

Status

Status of the sequence (DONE, PROCESSING, ERROR). If empty, this job will be executed next in the order.

Last Run

Last processed run date time.

DL Type

Type of the DL (Calculation, Refresh, etc.).

Dl Target

Target Name of the DL.

Is active

Flag to identify if the current row configuration is active (included in the sequence) or not.

Extractor Name

Unique name of the Extractor, to handle multiple mapping information. Keep this as “Transactions”.

Field Name

Name of the target field.

Is Required?

Flag to identify if the target field is mandatory for the Extractor.

DataType

Data type of the field. For future use.

Default Value

Default value of the field, if any.

Error Message

Error message, if any.

Extractor Name

Unique name of the extractor, to handle multiple mapping information.

Keep this as “Transactions”.

Source Type

Type of the source. Supported types are DS, DM, P, C, PX, CX, PP.

Specify the type of the source (PP stands for CP - Company Parameters)

Source Name

Name of the source. Self-join can be achieved by specifying a different Table Alias.

Specify the name of the source.

Table Alias

Alias of the temporary table.

Specify an alias for the source to easily refer to it in the formula.

Target Field

Name of the Target Field in Plasma.

Specify the target field in Plasma_TX Data Source. The list of allowed values is in the Plasma_Transactions_Extractor_Fields table. The fields with ‘Required' flag set to Y are needed for the Extractor to work, otherwise it throws an error. You can also use temporary fields Temp1…Temp30 to hold values that are not in the target. They can be accessed via a drop-down.

Source Fields

Name(s) of the source fields that are mapped to the target field. Can be multiple fields, separated by a comma without spaces.

Specify the source fields which are mapped from the source. There can be one or many, separated by a comma. It can be empty if the source fields are not needed and the value can be derived directly from the formula.

Formula

Additional formulas to apply to the source fields, such as CONCAT, TO_DATE, DEFAULT, EXPR, DECODE and GROUPBY functions (SUM, AVG, COUNT, MAX, MIN, etc.).

All source fields can be referred to by the format "(<tableAlias>.<sourceField>)".

All target fields can be referred to by the format "(TGT.<targetField>)".

GroupBy formulas – Only when the Group By field is populated and only one source field should be mapped. Available values are SUM, AVG, COUNT, MAX, MIN.

Function formulas – Only when the Group By field is not populated:

• CONCAT – Used to concatenate multiple source/target fields.
  Example: CONCAT((A.Quantity),’_’,(TGT.UOM))

• TO_DATE – Used to convert text to a date format.
  Example: TO_DATE((A.Date),’yyyy/MM/dd’)

• DEFAULT – Used to default a field when it is null.
  Example: If A.Rate is null, default it to 1.25.
  DEFAULT((A.Rate),1.25)

• EXPR – Used to handle mathematical expressions such as addition, subtraction, etc. Also assigns a default value.
  Example: EXPR((A.Price)+(A.Surcharge)-((TGT.Cost)*(A.Quantity)))
  Example: For constants: EXPR(‘EUR’)

• DECODE – Used to add procedural if-else logic. If A.SalesRep = ‘John’, return 1, else if ‘Payne’, return 2, else return 3.
  Example: DECODE((A.SalesRep), ‘John’, 1, ‘Payne’, 2, 3)

Specify a formula/expression if any calculation needs to be done on the source fields and/or target fields.

All fields should be prefixed with tableAlias, delimited with a dot (.) and wrapped in braces ( ). Below are the available formulas.

Group By

Name(s) of the GROUPBY fields when the formula applied is of the GROUPBY function. Can be multiple names separated by a comma without spaces. 

Available values are SUM, AVG, COUNT, MAX, MIN.

Specify the groupBy field when the groupBy formula is used. Can be one or many, separated by a comma.

Joining Key

Name of the Joining Source's field. (Always LEFT join is applied on Source to Joining Source.) It is in the format "<tableAlias>.<sourceField>".

When there are multiple sources, specify which key joins the two sources, referred to by the format <tableAlias>.<sourceField>. Also the operator should be provided. The sources are all joined using LEFT_JOIN, so it is important to identify primary source, so that all data from primary source will be extracted even if the other sources do not have joining key data.

IsActive?

Flag to identify if the current row mapping is active (included in the calculation) or not.

Should be “Y”. Else the mapping row will not be visible to the Extractor.

Operator

Operator to be used for either JoiningKey or Filter. Supported types are EQUAL, NOT_EQUAL, IN, NOT_IN, BETWEEN, NOT_NULL, NULL, LESS_THAN, GREATER_THAN, etc.

The operator should be provided in two cases (but not both cases at once):

• when Joining Key is specified

• when Filter is specified

Filter

Additional filter that can be applied on the source data.

Specify a value if any filtering needs to be done on the source field values. Works with operators.

Seed for Masking

Seed value to mask the target field's value in the target. Only applicable when target field is of the String type.

Specify a seed if the target field’s value needs to be masked in the target DS. Only applicable when the target field is of the String type. The seed can be any string.

Sequence Name

Unique name of the sequence (usually the extractor name).

Order

The order in which the particular jobs in a sequence are executed.

Type

Sequence type (DL, CFS, etc.).

Action Name

Name of the job (Label of DL, CFS, etc.).

Status

Status of the sequence (DONE, PROCESSING, ERROR). If empty, this job will be executed next in the order.

Last Run

Last processed run date time.

DL Type

Type of the DL (Calculation, Refresh, etc.).

Dl Target

Target Name of the DL.

Is active

Flag to identify if the current row configuration is active (included in the sequence) or not.

Quote Type

{quote type}

Specifies the quote type.

Mapping Field

{name of the column in the target of Quote Extractor (Plasma_Quotes DS)}

Target field – specifies the column in the target for which the extraction has to be done.

Expression

{key for data extraction}

Specifies the key to get the data. Can be specified using dots and brackets expression.

Configuration Type

calculation
constant
default

• calculation type – Returns the calculated value from the expression using the FormularEvaluator library. The calculation type is calculated after all data are extracted from the quotes. 

• constant type – Returns the defined value.

• default type – Returns the value for the given field from standard mapping defined in the mapping field and expression.

Extract Level

Q
QLI 
QLI_INPUT 
QLI_OUTPUT
QLI_OUTPUT_SUFFIX
W 
QH_INPUT
QH_OUTPUT
QH_OUTPUT_SUFFIX

Q – quote data
QLI – quote line item data
QLI_INPUT – quote line item input data
QLI_OUTPUT – quote line item output data
QLI_OUTPUT_SUFFIX – quote line item output suffix
W – quote workflow data
QH_INPUT – quote header input
QH_OUTPUT – quote header output
QH_OUTPUT_SUFFIX – quote output suffix

Default Value

{default value of given field}

Specifies the default value if the result is not found (optional).

Extractor Name

Unique name of the Extractor, to handle multiple mapping information. Keep this as “Quotes”.

Field Name

Name of the target field.

Is Required?

Flag to identify if the target field is mandatory for the Extractor.

DataType

Data type of the field. For future use.

Default Value

Default value of the field (optional).

Error Message

Error message (optional).

Extractor Name

Unique name of the extractor, to handle multiple mapping information.

Keep this as “Quotes”.

Source Type

Type of the source. Supported types are DS, DM, P, C, PX, CX, PP.

Specify the type of the source. (PP stands for CP - Company Parameters)

Source Name

Name of the source. Self-join can be achieved by specifying a different Table Alias.

Specify the name of the source.

Table Alias

Alias of the temporary table.

Specify an alias for the source to easily refer to it in the formula.

Target Field

Name of the Target Field in Plasma.

Specify the target field in Plasma_Quotes Data Source. The list of allowed values is in the Plasma_Quotes_Enrichment_Fields table. The fields with ‘Required' flag set to Y are needed for the Extractor to work, otherwise it throws an error. You can also use temporary fields Temp1…Temp30 to hold values that are not in the target. They can be accessed via a drop-down.

Source Fields

Name(s) of the source fields that are mapped to the target field. Can be multiple fields, separated by a comma without spaces.

Specify the source fields which are mapped from the source. There can be one or many, separated by a comma. It can be empty if the source fields are not needed and the value can be derived directly from the formula.

Formula

Additional formulas to apply on the source fields, such as CONCAT, TO_DATE, DEFAULT, EXPR, DECODE and GROUPBY functions (SUM, AVG, COUNT, MAX, MIN, etc.).

All source fields can be referred to by the format "(<tableAlias>.<sourceField>)".

All target fields can be referred to by the format "(TGT.<targetField>)".

GroupBy formulas – Only when the Group By field is populated and only one source field should be mapped. Available values are SUM, AVG, COUNT, MAX, MIN.

Function formulas – Only when the Group By field is not populated:

• CONCAT – Used to concatenate multiple source/target fields.
  Example: CONCAT((A.Quantity),’_’,(TGT.UOM))

• TO_DATE – Used to convert text to a date format.
  Example: TO_DATE((A.Date),’yyyy/MM/dd’)

• DEFAULT – Used to default a field when it is null.
  Example: If A.Rate is null, default it to 1.25.
  DEFAULT((A.Rate),1.25)

• EXPR – Used to handle mathematical expressions such as addition, subtraction, etc. Also assigns a default value.
  Example: EXPR((A.Price)+(A.Surcharge)-((TGT.Cost)*(A.Quantity)))
  Example: For constants: EXPR(‘EUR’)

• DECODE – Used to add procedural if-else logic. If A.SalesRep = ‘John’, return 1, else if ‘Payne’, return 2, else return 3.
  Example: DECODE((A.SalesRep), ‘John’, 1, ‘Payne’, 2, 3)

Specify a formula/expression if any calculation needs to be done on the source fields and/or target fields.

All fields should be prefixed with tableAlias, delimited with a dot (.) and wrapped in braces ( ). Below are the available formulas.

Group By

Name(s) of the GROUPBY fields when the formula applied is of the GROUPBY function. Can be multiple names separated by a comma without spaces. 

Available values are SUM, AVG, COUNT, MAX, MIN.

Specify the groupBy field when the groupBy formula is used. Can be one or many, separated by a comma.

Joining Key

Name of the Joining Source's field. (LEFT join is always applied on Source to Joining Source.) It is in the format "<tableAlias>.<sourceField>".

When there are multiple sources, specify which key joins the two sources, referred to by the format <tableAlias>.<sourceField>. Also the operator should be provided. The sources are all joined using LEFT_JOIN, so it is important to identify a primary source, so that all data from the primary source are extracted even if the other sources do not have joining key data.

IsActive?

Flag to identify if the current row mapping is active (included in the calculation) or not.

Should be “Y”. Else the mapping row will not be visible to the Extractor.

Operator

Operator to be used for either JoiningKey or Filter. Supported types are EQUAL, NOT_EQUAL, IN, NOT_IN, BETWEEN, NOT_NULL, NULL, LESS_THAN, GREATER_THAN, etc.

The operator should be provided in two cases (but not both cases at once):

• when Joining Key is specified

• when Filter is specified

Filter

Additional filter that can be applied on the source data.

Specify a value if any filtering needs to be done on the source field values. Works with operators.

Seed for Masking

Seed value to mask the target field's value in the target. Only applicable when target field is of the String type.

Specify a seed if the target field’s value needs to be masked in the target DS. Only applicable when the target field is of the String type. The seed can be any string.

Sequence Name

Unique name of sequence (usually the Extractor name).

Order

The order in which the particular jobs in a sequence are executed.

Type

Sequence type (DL, CFS, etc.).

Action Name

Name of the job (Label of DL, CFS, etc.)

Status

Status of the sequence (DONE, PROCESSING, ERROR). If empty, this job will be executed next in the order.

Last Run

Last processed run date time.

DL Type

Type of the DL (Calculation, Refresh, etc.).

Dl Target

Target name of the DL.

Is active

Flag to identify if the current row configuration is active (included in the sequence) or not.

Unique Id of the Harvester to handle multiple mapping information.

Name of the Harvester.

Description of the Harvester.

Name of the source Datamart (for example Plasma_Output_Transactions).

Name of the destination Data Source (usually Harvester Data Source).

Bound Partition name of the source.

Unique Id of the Harvester to match with the Dem_Entity field of the Plasma_Entities Data Source.

Flag to identify if the current row mapping is active (included in the calculation) or not.

Last processed date is automatically populated if the Harvester is run. It can be configured as FromDate to filter data.

ToDate to filter data.

Size of the batch that retrieves the data from the source partitions.

Additional filter that can be applied on the source data. The filter is in the Map format.

Example:

Field Name

Name of the target field.

Is Required?

Flag to identify if the target field is mandatory for the Harvester.

DataType

Data type of the field. For future use.

Default Value

Default value of the field (optional).

Error Message

Error message (optional).

Unique Id of the Harvester to map back to Harvester_Mapping.

Start time of the Harvester.

End time of the Harvester.

Time taken in minutes.

Fetched rows.

Processed rows.

Omitted rows.

Either SUCCESS or ERROR.

Log message in case of an error.

HTTP response code in case of an error.

Sequence Name

Unique name of the sequence (usually the Extractor name).

Order

The order in which the particular jobs in a sequence are executed.

Type

Sequence type (DL, CFS, etc.).

Action Name

Name of the job (Label of DL, CFS, etc.).

Status

Status of the sequence (DONE, PROCESSING, ERROR). If empty, then this job will be executed next in the order.

Last Run

Last processed run date time.

DL Type

Type of the DL (Calculation, Refresh, etc.).

Dl Target

Target name of the DL.

Is active

Flag to identify if the current row configuration is active (included in the sequence) or not.

Id of the bound partition Harvester.

Name of the bound partition.

Y/N flag showing if the data was loaded.

Y/N flag showing if the data was refreshed.

Day of the week chosen for the refresh.

Hour slot chosen for the refresh.

Name of the configuration.

Example: MonthsToCompare

Value of the configuration.

Example: 12

Unique Id of the Margin Tracker.

Audit time of the Margin Tracker.

Either SUCCESS or FAILURE.

Message of the audit.