Workflow M3A model configuration

Variable Description Used in space
M3A_CurrExchStartDate The earliest date when an exchange rate is available for each currency code defined in CCURRA. Source
M3A_BudgetVersionDataSet This variable is used to filter the dataset to be retrieved for the Budget Version. Source
M3A_CSA_Translation This variable retrieves translation data depending on the selected user locale. The variable is shared across other spaces using packages. Source
M3A_WhiteSpaceSource

The table name of the XtendM3 custom source for White Space data set.

 Source
M3A_WhiteSpace_StartDate

This variable determines the start date of the date range of the data loaded in the White Space fact.

The solution uses the date in this format: M/D/YYYY.

 Source
M3A_CLM_Language The language code to be filtered for CLM CODE table records that support multi-language. The default value is GB. Source
M3A_CSYTABLanguageCode The language code to be filtered for CSYTAB entries that support multi-language. The default value is 'GB'. Dimension
M3A_ItemName_Config This variable refers to the column used for the Item and Item Name attribute value from the Item dimension. You can use ITDS or FUDS. The default value is ITDS. Dimension
M3A_PeriodTypeFiscal This variable refers to the period type value that represents the Fiscal Period in CSYPER. The default value is 1. Dimension
M3A_PeriodTypeManufacturing This variable refers to the period type value that represents the Manufacturing Period in CSYPER. The default value is 1. Dimension
M3A_PeriodTypeEquipment This variable refers to the period type value that represents the Equipment Period in CSYPER. The default value is 1.
Note: This variable is only available in the Equipment industry package.
 Dimension
M3A_PeriodType1 This variable refers to the period type value that represents the Period Type 1 in CSYPER. The default value is 1. Dimension
M3A_PeriodType2 This variable refers to the period type value that represents the Period Type 2 in CSYPER. The default value is 2. Dimension
M3A_PeriodType3 This variable refers to the period type value that represents the Period Type 3 in CSYPER. The default value is 3. Dimension
M3A_PeriodType4 This variable refers to the period type value that represents the Period Type 4 in CSYPER. The default value is 4. Dimension
M3A_PeriodType5 This variable refers to the period type value that represents the Period Type 5 in CSYPER. The default value is 5. Dimension
M3A_PeriodType9 This variable refers to the period type value that represents the Period Type 9 in CSYPER. The default value is 9. Dimension
M3A_PeriodTypeHRM This variable refers to the period type value that represents the Period Type HRM in CSYPER. The default value is 1. Dimension
M3A_PeriodTypeSales This variable refers to the period type value that represents the Period Type Sales in CSYPER. The default value is 1. Dimension
M3A_SalesBudget_Customer

This variable is used to manipulate which among these dimension sub-elements are created:

  • CUNO - Sub-element for Customer
  • CUST - Sub-element for Statistics Customer
  • CUCL - Sub-element for Customer Group
 Sales Budget
M3A_SalesBudget_Facility

This variable is used to manipulate which among these dimension sub-elements are created:

  • FACI - Sub-element for Facility
  • DIVI - Sub-element for Division
 Sales Budget
M3A_SalesBudget_Item

This variable is used to manipulate which among these dimension sub-elements are created:

  • ITNO - Sub-element for Item
  • ITCL - Sub-element for Product Group
  • ITGR - Sub-element for Item Group
  • STYN - Sub-element for Style
 Sales Budget
M3A_SalesBudget_Logistics

This variable is used to manipulate which among these dimension sub-elements are created:

  • WHLO - Sub-element for Warehouse
  • SDES - Sub-element for Place of Loading
  • CSCD - Sub-element for Country
 Sales Budget
M3A_SalesBudget_IsXLS_Source
This variable is used to determine which source to utilize for the Sales Budget model:
  • 0 - Data Lake by M3 DMP
  • 1 - XLSX by File Upload
 Sales Budget
M3A_SalesBudget_SalesOrganization

This variable is used to manipulate which among these dimension sub-elements are created:

  • SMCD - Sub-element for Salesperson
  • SDEP - Sub-element for Sales Department
 Sales Budget
M3A_FKRReport1 First report configured for Finance Key Ratio in 'Report. Open' (RGS600). The default is M3FKR1. Finance
M3A_FKRReport2 Second report configured for Finance Key Ratio in 'Report. Open' (RGS600). The default is M3FKR2. Finance
M3A_FKRReport3 Third report configured for Finance Key Ratio in 'Report. Open' (RGS600). The default is M3FKR3. Finance
M3A_StandardCost This represents the costing type for standard cost. The variable is used in the Order Costing and Stock Valuation models. The default value is 3. Finance
M3A_StandardStructureType The standard structure type for manufactured items as defined in 'Settings - Product Structures' (CRS787). Finance
M3A_CostAcctgCostCenter This should reflect the Cost Accounting Cost Center specified in 'Settings - Cost Accounting' (CAS900). Finance
M3A_POLineStatus This variable refers to the field representing the status of a purchase order. Valid values are Highest and Lowest. The default value is Lowest that means the Purchase Order model will use the Lowest Status (PUSL) field in MPLINE to reflect the PO status. Setting to Highest will use the Highest Status (PUST) field in MPLINE. Procurement
M3A_PurchasingCostCenter This variable reflects the Purchasing Cost Center specified in 'Settings - Purchasing' (CRS780). Procurement
M3A_ActualCost This represents the costing type for actual cost. The variable is used in the Order Costing model. The default value is 1. Production
M3A_ScrapCost This variable represents the costing type for scrap cost. The variable is used in the Order Costing model. The default value is 4. Production
M3A_StandardCost This variable represents the costing type for standard cost. The variable is used in the Order Costing and Stock Valuation models. The default value is 3. Production
M3A_RentalMetrics_IsRelativeToDate
This variable represents the calculation for the Rental Metrics model:
  • 1 = Calculation starts at the current period
  • 0 = Calculation starts at the current period minus 1

The default value is 1.

 Rental
M3A_RentalMetrics_Category_1_Periods This variable represents the number of periods to compare for Rental Metrics Category 1. The default value is 1. Rental
M3A_RentalMetrics_Category_2_Periods This variable represents the number of periods to compare for Rental Metrics Category 2. The default value is 3. Rental
M3A_RentalMetrics_Category_3_Periods This variable represents the number of periods to compare for Rental Metrics Category 3. The default value is 6. Rental
M3A_RentalMetrics_Category_4_Periods This variable represents the number of periods to compare for Rental Metrics Category 4. The default value is 12. Rental