Other variables

Variable	Description	Used in space
`M3A_CustomExtractStartDate`	This overrides the value of the calculated next extraction start date when performing an incremental load. The solution uses the date and time in this format: M/D/YYYY hh:mm:ss.	Source
`M3A_ExtractDomain`	The domain where you will perform an initial or incremental load.	Source
`M3A_ExtractSubDomain`	The sub-domain where you will perform an initial or incremental load.	Source
`M3A_ExtractEndDate`	The date and time to stop extracting data.	Source
`M3A_ExtractJobStreamId`	A unique identifier, this allows for multiple different job streams. The current implementation does not support this. For now, do not change this variable.	Source
`M3A_ExtractStartDate`	The date and time to start extracting data.	Source
`M3A_SF_DeletedFlagValue`	This contains the value used in the Security Filter property of the [deleted] field that indicates whether a record has been deleted in M3 (true) or not (false). The default value is false.	Source
`M3A_CurrentPeriod_FiscalPeriod`	This contains the current fiscal year period that serves as the default value for the Fiscal Period filter.	Consumer
`M3A_CurrentPeriod_FiscalYear`	This contains the current fiscal year that serves as the default value for the Fiscal Year filter.	Consumer
`M3A_Default_Division_Company`	This contains the top company that is not NULL. This is used as the default value for the Company filter that is from the Division hierarchy.	Consumer
`M3A_Default_Division_Division`	This contains the top division that is not NULL. This is used as the default value for the Division filter.	Consumer
`M3A_Default_Facility_Company`	This contains the top company that is not NULL. This is used as the default value for the Company filter that is from the Facility hierarchy.	Consumer
`M3A_Default_TimeWeek`	This contains the current week of year that serves as the default value for the Week of Year filter.	Consumer
`M3A_Default_TimeWeekYear`	This contains the current week year that serves as the default value for the Week/Year filter.	Consumer
`M3A_Default_TimeYear`	This contains the current year that serves as the default value for the Year filter.	Consumer
`M3A_Default_TimeYearMonth`	This contains the current year or month that serves as the default value for the Year/Month filter.	Consumer

M3A_CustomExtractStartDate

This overrides the value of the calculated next extraction start date when performing an incremental load.

The solution uses the date and time in this format: M/D/YYYY hh:mm:ss.

Source

M3A_ExtractDomain

The domain where you will perform an initial or incremental load.

Source

M3A_ExtractSubDomain

The sub-domain where you will perform an initial or incremental load.

Source

M3A_ExtractEndDate

The date and time to stop extracting data.

Source

M3A_ExtractJobStreamId

A unique identifier, this allows for multiple different job streams. The current implementation does not support this. For now, do not change this variable.

Source

M3A_ExtractStartDate

The date and time to start extracting data.

Source

M3A_SF_DeletedFlagValue

This contains the value used in the Security Filter property of the [deleted] field that indicates whether a record has been deleted in M3 (true) or not (false). The default value is false.

Source

M3A_CurrentPeriod_FiscalPeriod

This contains the current fiscal year period that serves as the default value for the Fiscal Period filter.

Consumer

M3A_CurrentPeriod_FiscalYear

This contains the current fiscal year that serves as the default value for the Fiscal Year filter.

Consumer

M3A_Default_Division_Company

This contains the top company that is not NULL. This is used as the default value for the Company filter that is from the Division hierarchy.

Consumer

M3A_Default_Division_Division

This contains the top division that is not NULL. This is used as the default value for the Division filter.

Consumer

M3A_Default_Facility_Company

This contains the top company that is not NULL. This is used as the default value for the Company filter that is from the Facility hierarchy.

Consumer

M3A_Default_TimeWeek

This contains the current week of year that serves as the default value for the Week of Year filter.

Consumer

M3A_Default_TimeWeekYear

This contains the current week year that serves as the default value for the Week/Year filter.

Consumer

M3A_Default_TimeYear

This contains the current year that serves as the default value for the Year filter.

Consumer

M3A_Default_TimeYearMonth

This contains the current year or month that serves as the default value for the Year/Month filter.

Consumer