Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: ACT_Mths
| Actual   | Prior Fcst   | Month   | Previous_Month   |   Mth_No |
|:---------|:-------------|:--------|:-----------------|---------:|
| 0+12     | 12+0         |         |                  |        0 |
| 1+11     | 0+12         | JAN     | JAN              |        1 |
| 2+10     | 1+11         | FEB     | JAN              |        2 |
| 3+9      | 2+10         | MAR     | FEB              |        3 |
| 4+8      | 3+9          | APR     | MAR              |        4 |
| 5+7      | 4+8          | MAY     | APR              |        5 |
| 6+6      | 5+7          | JUN     | MAY              |        6 |
| 7+5      | 6+6          | JUL     | JUN              |        7 |
| 8+4      | 7+5          | AUG     | JUL              |        8 |
| 9+3      | 8+4          | SEP     | AUG              |        9 |


Table: BBP_Mths
| Actual   | Prior Fcst   | Month   | Previous_Month   |   Mth_No |
|:---------|:-------------|:--------|:-----------------|---------:|
| 0+12     | 12+0         |         |                  |        0 |
| 1+11     | 0+12         | JAN     | JAN              |        1 |
| 2+10     | 1+11         | FEB     | JAN              |        2 |
| 3+9      | 2+10         | MAR     | FEB              |        3 |
| 4+8      | 3+9          | APR     | MAR              |        4 |
| 5+7      | 4+8          | MAY     | APR              |        5 |
| 6+6      | 5+7          | JUN     | MAY              |        6 |
| 7+5      | 6+6          | JUL     | JUN              |        7 |
| 8+4      | 7+5          | AUG     | JUL              |        8 |
| 9+3      | 8+4          | SEP     | AUG              |        9 |


Table: Calendar
| Actual   | Prior Fcst   | Month   | Q_Mth1   | Q_Mth2   | Q_Mth3   | QTR   | PMonth   |   Mth_No |
|:---------|:-------------|:--------|:---------|:---------|:---------|:------|:---------|---------:|
| 0+12     | 12+0         |         |          |          |          |       |          |        0 |
| 1+11     | 0+12         | JAN     | Jan_Act  | Feb_Fcst | Mar_Fcst | Q1    | DEC      |        1 |
| 2+10     | 1+11         | FEB     | Jan_Act  | Feb_Act  | Mar_Fcst | Q1    | JAN      |        2 |
| 3+9      | 2+10         | MAR     | Jan_Act  | Feb_Act  | Mar_Act  | Q1    | FEB      |        3 |
| 4+8      | 3+9          | APR     | Apr_Act  | May_Fcst | Jun_Fcst | Q2    | MAR      |        4 |
| 5+7      | 4+8          | MAY     | Apr_Act  | May_Act  | Jun_Fcst | Q2    | APR      |        5 |
| 6+6      | 5+7          | JUN     | Apr_Act  | May_Act  | Jun_Act  | Q2    | MAY      |        6 |
| 7+5      | 6+6          | JUL     | Jul_Act  | Aug_Fcst | Sep_Fcst | Q3    | JUN      |        7 |
| 8+4      | 7+5          | AUG     | Jul_Act  | Aug_Act  | Sep_Fcst | Q3    | JUL      |        8 |
| 9+3      | 8+4          | SEP     | Jul_Act  | Aug_Act  | Sep_Act  | Q3    | AUG      |        9 |


Table: Channel_Grp
|   Index | Channel   | ChannelNew   |
|--------:|:----------|:-------------|
|       1 | All       | AFM          |
|       2 | IAM       | IAM          |
|       3 | OES       | OES          |


Table: Channel_PL
| Channel   |   Indx | Heading     | ChannelNew   |
|:----------|-------:|:------------|:-------------|
| IAM       |      1 | Total - IAM | IAM          |
| OES       |      2 | Total - OES | OES          |
| ALL       |      3 | Total - AFM | AFM          |


Table: Dim_Hierarchy
| Sno   | Top_Level_Description    | Sub_Level_Description     | Third_Level_Description   | Fouth_Level_Description   | ln_grp_description         |   Exclusions% |   Index |   NWC_Flag |
|:------|:-------------------------|:--------------------------|:--------------------------|:--------------------------|:---------------------------|--------------:|--------:|-----------:|
| a1    | a. TOTAL SALES           | 1. TOTAL SALES            | OTHER OUTSIDE SALES       | OTHER OUTSIDE SALES       | a1.OTHER OUTSIDE SALES     |             1 |       1 |          0 |
| a2    | a. TOTAL SALES           | 1. TOTAL SALES            | ALLIED SALES              | ALLIED SALES              | a2.ALLIED SALES            |             1 |       2 |          0 |
| a3    | a. TOTAL SALES           | 1. TOTAL SALES            | TOTAL SALES               | TOTAL SALES               | a3.TOTAL SALES             |             1 |       3 |          0 |
| a4    | b. FACTORY COST OF SALES | 2. TOTAL MATERIAL         | ALLIED MATERIAL           | ALLIED MATERIAL           | a4.ALLIED MATERIAL         |             1 |       4 |          0 |
| a5    | b. FACTORY COST OF SALES | 2. TOTAL MATERIAL         | OUTSIDE MATERIAL          | OUTSIDE MATERIAL          | a5.OUTSIDE MATERIAL        |             1 |       5 |          0 |
| a6    | b. FACTORY COST OF SALES | 2. TOTAL MATERIAL         | TOTAL MATERIAL            | TOTAL MATERIAL            | a6.TOTAL MATERIAL          |             1 |       6 |          0 |
| a7    | b. FACTORY COST OF SALES | 3. MATERIAL FREIGHT TOTAL | INBOUND FREIGHT NORMAL    | INBOUND FREIGHT NORMAL    | a7.INBOUND FREIGHT NORMAL  |             1 |       7 |          0 |
| a8    | b. FACTORY COST OF SALES | 3. MATERIAL FREIGHT TOTAL | INBOUND FREIGHT PREMIUM   | INBOUND FREIGHT PREMIUM   | a8.INBOUND FREIGHT PREMIUM |             1 |       8 |          0 |
| a9    | b. FACTORY COST OF SALES | 3. MATERIAL FREIGHT TOTAL | ALLIED FREIGHT NORMAL     | ALLIED FREIGHT NORMAL     | a9.ALLIED FREIGHT NORMAL   |             1 |       9 |          0 |
| b1    | b. FACTORY COST OF SALES | 3. MATERIAL FREIGHT TOTAL | ALLIED FREIGHT PREMIUM    | ALLIED FREIGHT PREMIUM    | b1.ALLIED FREIGHT PREMIUM  |             1 |      10 |          0 |


Table: FCST_Mths
| Actual   | Prior Fcst   | Month   | Previous_Month   |   Mth_No |
|:---------|:-------------|:--------|:-----------------|---------:|
| 0+12     | 12+0         |         |                  |        0 |
| 1+11     | 0+12         | JAN     | JAN              |        1 |
| 2+10     | 1+11         | FEB     | JAN              |        2 |
| 3+9      | 2+10         | MAR     | FEB              |        3 |
| 4+8      | 3+9          | APR     | MAR              |        4 |
| 5+7      | 4+8          | MAY     | APR              |        5 |
| 6+6      | 5+7          | JUN     | MAY              |        6 |
| 7+5      | 6+6          | JUL     | JUN              |        7 |
| 8+4      | 7+5          | AUG     | JUL              |        8 |
| 9+3      | 8+4          | SEP     | AUG              |        9 |


Table: Grp_Summary
| Grp_Id   | Grp_SNo   | Report_Heading           | Itm_Grp                     |   Index |   Ord_No |   NWC_Flag |
|:---------|:----------|:-------------------------|:----------------------------|--------:|---------:|-----------:|
| a3       | a         | TOTAL SALES              | a. TOTAL SALES              |       1 |        0 |          0 |
| e6       | b         | FACTORY COST OF SALES    | b. FACTORY COST OF SALES    |       2 |        0 |          0 |
| l7       | c         | GROSS MARGIN             | c. GROSS MARGIN             |       3 |        0 |          0 |
| l8       | d         | % TO  SALES              | d.       % TO  SALES        |       4 |        1 |          0 |
| j4       | e         | WAREHOUSE & DISTRIBUTION | e. WAREHOUSE & DISTRIBUTION |       5 |        0 |          0 |
| h9       | f         | ENGINEERING EXPENSE      | f. ENGINEERING EXPENSE      |       6 |        0 |          0 |
| l4       | g         | OTHER COST OF GOODS SOLD | g. OTHER COST OF GOODS SOLD |       7 |        0 |          0 |
| l5       | h         | TOTAL COST OF GOODS SOLD | h. TOTAL COST OF GOODS SOLD |       8 |        0 |          0 |
| e7       | i         | CONTRIBUTION MARGIN      | i. CONTRIBUTION MARGIN      |       9 |        0 |          0 |
| e8       | j         | %  TO  SALES             | j.       %  TO  SALES       |      10 |        1 |          0 |


Table: Grp_Sumry_Rep
| Item_No   | AccountGroup        |   Index |   ColourBackground | PL_Map   | AccountGroup2        | Acct_Heading                 |
|:----------|:--------------------|--------:|-------------------:|:---------|:---------------------|:-----------------------------|
| 1a        | External Sales      |       1 |                  3 | a3       | External Sales       | Sales (USD $M)               |
| 2a        | Gross Margin        |       2 |                  1 | e7       | Gross Margin         | Gross Margin (USD $M)        |
| 2b        | Gross Margin%       |       3 |                  0 | e8       | Gross Margin%        | Gross Margin% (%)            |
| 3a        | Engineering         |       4 |                  0 | h9       | Engineering          | Engineering                  |
| 3b        | W&D                 |       5 |                  0 | j4       | W&D                  | W&D                          |
| 3c        | OCOGS               |       6 |                  0 | l4       | OCOGS                | OCOGS (USD $M)               |
| 3         | Total COGS          |       7 |                  0 | l5       | Total COGS           | TOTAL COGS (USD $M)          |
| 4a        | Contribution Margin |       8 |                  1 | l7       | Contribution Margin  | Contribution Margin (USD $M) |
| 4b        | % of Sales          |       9 |                  0 | l8       | Contribution Margin% | Contribution Margin% (%)     |
| 5a        | Sales & Marketing   |      10 |                  0 | n8       | Sales & Marketing    | Sales & Marketing            |


Table: Logistics_
| GrpId   | GrpSNo   |   Index | Reporting_Headers       |   Ord_No | New_Reporting_Headers   |   New_Reporting_Headers sort |
|:--------|:---------|--------:|:------------------------|---------:|:------------------------|-----------------------------:|
| a3      | a        |       1 | TOTAL SALES             |        0 | External Sales          |                            1 |
| a7      | b        |       2 | INBOUND FREIGHT NORMAL  |        0 | Inbound Freight         |                            2 |
| a8      | c        |       3 | INBOUND FREIGHT PREMIUM |        0 | Inbound Freight         |                            2 |
| l6      | d        |       4 | % TO SALES              |        1 | % TO SALES              |                            3 |
| b2      | e        |       5 | CUSTOMS                 |        0 | Duty                    |                            4 |
| b3      | f        |       6 | CLEARNANCE FEES         |        0 | Duty                    |                            4 |
| b4      | g        |       7 | BROKERAGE FEES          |        0 | Duty                    |                            4 |
| l8      | h        |       8 | % TO  SALES             |        1 | % TO  SALES             |                            5 |
| i5      | i        |       9 | FACILITIES COST         |        0 | Warehousing - Fixed     |                            6 |
| i6      | j        |      10 | 3-PL  FIXED COST        |        0 | Warehousing - Fixed     |                            6 |


Table: Measure_Slicer
| Measure   | Report_Description   |
|:----------|:---------------------|
| $ Values  | Diesel               |
| % Values  | Eng Mgmt & Elect     |


Table: Measure_Slicer4
| Measure   | Report_Description        |   Sno |
|:----------|:--------------------------|------:|
| Monthly   | Monthly Variance Report   |     1 |
| YTD       | YTD Variance Report       |     6 |
| FY        | Full Year Variance Report |     7 |
| Q1        | Quarter1 Variance Report  |     2 |
| Q2        | Quarter2 Variance Report  |     3 |
| Q3        | Quarter3 Variance Report  |     4 |
| Q4        | Quarter4 Variance Report  |     5 |


Table: Measure_Slicer_2
| Measure           | Report_Description                    | Quarterly_Rep_Heading                           |   SNo |
|:------------------|:--------------------------------------|:------------------------------------------------|------:|
| Current Fcst      | Current Forecast vs Current Forecast  | Current Forecast Quarterly Report Breakdown     |     1 |
| Prior Fcst        | Prior Forecast vs Current Forecast    | Prior Forecast Quarterly Report Breakdown       |     2 |
| Budget(BBP)       | Budget vs Current Forecast            | Budget Provision Quarterly Report Breakdown     |     3 |
| Prior Year Actual | Prior Year Actual vs Current Forecast | Previous Year Actual Quarterly Report Breakdown |     4 |


Table: Period_Slicer
| Measure   | Report_Description        |   Sno |
|:----------|:--------------------------|------:|
| Monthly   | Monthly Variance Report   |     1 |
| YTD       | YTD Variance Report       |     6 |
| FY        | Full Year Variance Report |     7 |
| Q1        | Quarter1 Variance Report  |     2 |
| Q2        | Quarter2 Variance Report  |     3 |
| Q3        | Quarter3 Variance Report  |     4 |
| Q4        | Quarter4 Variance Report  |     5 |


Table: PL
| Line_Item_Code   | Line_Item_Description    |   Jan_CM_Fcst |   Feb_CM_Fcst |   Mar_CM_Fcst |   Apr_CM_Fcst |   May_CM_Fcst |   Jun_CM_Fcst |   Jul_CM_Fcst |   Aug_CM_Fcst |   Sep_CM_Fcst |   Oct_CM_Fcst |   Nov_CM_Fcst |   Dec_CM_Fcst |   Q1_CM_Fcst |   Q2_CM_Fcst |   Q3_CM_Fcst |   Q4_CM_Fcst |   FY_CM_Fcst |   CM_CM_Fcst |   YTD_CM_Fcst |   Jan_PM_Fcst |   Feb_PM_Fcst |   Mar_PM_Fcst |   Apr_PM_Fcst |   May_PM_Fcst |   Jun_PM_Fcst |   Jul_PM_Fcst |   Aug_PM_Fcst |   Sep_PM_Fcst |   Oct_PM_Fcst |   Nov_PM_Fcst |   Dec_PM_Fcst |   Q1_PM_Fcst |   Q2_PM_Fcst |   Q3_PM_Fcst |   Q4_PM_Fcst |   FY_PM_Fcst |   CM_PM_Fcst |   YTD_PM_Fcst |   Jan_BBP |   Feb_BBP |   Mar_BBP |   Apr_BBP |   May_BBP |   Jun_BBP |   Jul_BBP |   Aug_BBP |   Sep_BBP |   Oct_BBP |   Nov_BBP |   Dec_BBP |   Q1_BBP |   Q2_BBP |   Q3_BBP |   Q4_BBP |   FY_BBP |   CM_BBP |   YTD_BBP |   Jan_PY_Act |   Feb_PY_Act |   Mar_PY_Act |   Apr_PY_Act |   May_PY_Act |   Jun_PY_Act |   Jul_PY_Act |   Aug_PY_Act |   Sep_PY_Act |   Oct_PY_Act |   Nov_PY_Act |   Dec_PY_Act |   Q1_PY_Act |   Q2_PY_Act |   Q3_PY_Act |   Q4_PY_Act |   FY_PY_Act |   CM_PY_Act |   YTD_PY_Act | Region   | Channel   |   C_Year |   P_Year | C_Month   | SNO   |   Chkfmt | PLP_NO   | PLP_GRP         |
|:-----------------|:-------------------------|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|--------------:|----------:|----------:|----------:|----------:|----------:|----------:|----------:|----------:|----------:|----------:|----------:|----------:|---------:|---------:|---------:|---------:|---------:|---------:|----------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|-------------:|------------:|------------:|------------:|------------:|------------:|------------:|-------------:|:---------|:----------|---------:|---------:|:----------|:------|---------:|:---------|:----------------|
| 1c               | ALLIED SALES (see below) |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | a2    |        3 |          | NA1+11OESa22020 |
| 3c               | ALLIED FREIGHT NORMAL    |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | a9    |        3 |          | NA1+11OESa92020 |
| 3d               | ALLIED FREIGHT PREMIUM   |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | b1    |        3 |          | NA1+11OESb12020 |
| 3h               | OTHER                    |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | b5    |        3 |          | NA1+11OESb52020 |
| 4a               | SALARIES/WAGES           |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | b8    |        3 |          | NA1+11OESb82020 |
| 4b               | BENEFITS                 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | b9    |        3 |          | NA1+11OESb92020 |
|                  | SUBTOTAL-PEOPLE COSTS    |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | c1    |        3 |          | NA1+11OESc12020 |
| 4c               | INDIRECT MATERIAL        |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | c2    |        3 |          | NA1+11OESc22020 |
| 4d               | INSURANCE/TAXES/RENT/D&A |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | c3    |        3 |          | NA1+11OESc32020 |
| 4e               | TRAVEL                   |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |            0 |            0 |            0 |            0 |            0 |            0 |             0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |         0 |        0 |        0 |        0 |        0 |        0 |        0 |         0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |            0 |           0 |           0 |           0 |           0 |           0 |           0 |            0 | NA       | OES       |     2020 |     2019 | 1+11      | c4    |        3 |          | NA1+11OESc42020 |


Table: Product_Grp
| Product                            |   Indx | Product2                           | Prd           |
|:-----------------------------------|-------:|:-----------------------------------|:--------------|
| Diesel                             |      1 | Diesel                             | DIESEL        |
| Eng Mgmt & Elect                   |      2 | Eng Mgmt & Elect                   | EM&ELEC       |
| Gas / Petrol                       |      3 | Gas / Petrol                       | GAS           |
| Maintenance & Other                |      4 | Maintenance & Other                | MAINT         |
| S&S / Braking                      |      6 | S&S / Braking                      | S&S/BRAKING   |
| Test Equip, Diagnostics & Training |      5 | Test Equip, Diagnostics & Training | TEST          |
| Sweeps                             |      7 | Sweeps                             | SWEEPS        |
| Total                              |      8 | Total                              | TOTAL PRODUCT |


Table: Profitability_Consolidation
| Item_No   | AccountGroup        | Product   | Region   | Period   | Channel   |   Year | Month   |   Profit |   Chkfmt | Month (groups)   |   %Sales |   %Sales2 |   Index | Fcst_Type   | Grp              |
|:----------|:--------------------|:----------|:---------|:---------|:----------|-------:|:--------|---------:|---------:|:-----------------|---------:|----------:|--------:|:------------|:-----------------|
| 1a        | External Sales      | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         1 |       2 | PY_Act      | AFM12+0IAM1a2019 |
| 2a        | Gross Margin        | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM2a2019 |
| 2b        | % of Sales          | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM2b2019 |
| 3a        | Engineering         | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM3a2019 |
| 3b        | W&D                 | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM3b2019 |
| 3c        | OCOGS               | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM3c2019 |
| 3         | Total COGS          | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM32019  |
| 4a        | Contribution Margin | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM4a2019 |
| 4b        | % of Sales          | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM4b2019 |
| 5a        | Sales & Marketing   | Sweeps    | AFM      | 12+0     | IAM       |   2019 | FULL    |        0 |        2 | FULL             |        0 |         0 |       2 | PY_Act      | AFM12+0IAM5a2019 |


Table: Region_Grp
| Region            |
|:------------------|
| AFM               |
| AP                |
| EMEA              |
| NA                |
| SA                |
| Sales & Marketing |


Table: Region_PL
| Region   |   Indx |
|:---------|-------:|
| NA       |      2 |
| AP       |      3 |
| SA       |      4 |
| EMEA     |      1 |
| AFM      |      5 |


Table: SelMth
| Actual   | Month   | Prior Fcst   | MthYTD    | Q1   | Q2   | Q3   | Q4   | FY   |   Mth_No | Prior_Mth   |
|:---------|:--------|:-------------|:----------|:-----|:-----|:-----|:-----|:-----|---------:|:------------|
| 0+12     |         | 12+0         | YTD       | Q1   | Q2   | Q3   | Q4   | FY   |        0 | FULL        |
| 1+11     | JAN     | 0+12         | JAN   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        1 | JAN         |
| 2+10     | FEB     | 1+11         | FEB   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        2 | JAN         |
| 3+9      | MAR     | 2+10         | MAR   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        3 | FEB         |
| 4+8      | APR     | 3+9          | APR   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        4 | MAR         |
| 5+7      | MAY     | 4+8          | MAY   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        5 | APR         |
| 6+6      | JUN     | 5+7          | JUN   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        6 | MAY         |
| 7+5      | JUL     | 6+6          | JUL   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        7 | JUN         |
| 8+4      | AUG     | 7+5          | AUG   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        8 | JUL         |
| 9+3      | SEP     | 8+4          | SEP   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        9 | AUG         |


Table: SelMth2
| Actual   | Month   | Prior Fcst   | MthYTD    | Q1   | Q2   | Q3   | Q4   | FY   |   Mth_No | Prior_Mth   |
|:---------|:--------|:-------------|:----------|:-----|:-----|:-----|:-----|:-----|---------:|:------------|
| 0+12     |         | 12+0         | YTD       | Q1   | Q2   | Q3   | Q4   | FY   |        0 | FULL        |
| 1+11     | JAN     | 0+12         | JAN   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        1 | JAN         |
| 2+10     | FEB     | 1+11         | FEB   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        2 | JAN         |
| 3+9      | MAR     | 2+10         | MAR   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        3 | FEB         |
| 4+8      | APR     | 3+9          | APR   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        4 | MAR         |
| 5+7      | MAY     | 4+8          | MAY   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        5 | APR         |
| 6+6      | JUN     | 5+7          | JUN   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        6 | MAY         |
| 7+5      | JUL     | 6+6          | JUL   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        7 | JUN         |
| 8+4      | AUG     | 7+5          | AUG   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        8 | JUL         |
| 9+3      | SEP     | 8+4          | SEP   YTD | Q1   | Q2   | Q3   | Q4   | FY   |        9 | AUG         |


Table: SelMth3
| Actual   | Prior Fcst   | Month   | Previous_Month   |   Mth_No |
|:---------|:-------------|:--------|:-----------------|---------:|
| 0+12     | 12+0         |         |                  |        0 |
| 1+11     | 0+12         | JAN     | JAN              |        1 |
| 2+10     | 1+11         | FEB     | JAN              |        2 |
| 3+9      | 2+10         | MAR     | FEB              |        3 |
| 4+8      | 3+9          | APR     | MAR              |        4 |
| 5+7      | 4+8          | MAY     | APR              |        5 |
| 6+6      | 5+7          | JUN     | MAY              |        6 |
| 7+5      | 6+6          | JUL     | JUN              |        7 |
| 8+4      | 7+5          | AUG     | JUL              |        8 |
| 9+3      | 8+4          | SEP     | AUG              |        9 |


Table: SelMth4
| Actual   | Prior Fcst   | Month   | Previous_Month   |   Mth_No |
|:---------|:-------------|:--------|:-----------------|---------:|
| 0+12     | 12+0         |         |                  |        0 |
| 1+11     | 0+12         | JAN     | JAN              |        1 |
| 2+10     | 1+11         | FEB     | JAN              |        2 |
| 3+9      | 2+10         | MAR     | FEB              |        3 |
| 4+8      | 3+9          | APR     | MAR              |        4 |
| 5+7      | 4+8          | MAY     | APR              |        5 |
| 6+6      | 5+7          | JUN     | MAY              |        6 |
| 7+5      | 6+6          | JUL     | JUN              |        7 |
| 8+4      | 7+5          | AUG     | JUL              |        8 |
| 9+3      | 8+4          | SEP     | AUG              |        9 |


Table: SelMth_Current
| Actual   | Prior Fcst   | Month   | Previous_Month   |   Mth_No |
|:---------|:-------------|:--------|:-----------------|---------:|
| 0+12     | 12+0         |         |                  |        0 |
| 1+11     | 0+12         | JAN     | JAN              |        1 |
| 2+10     | 1+11         | FEB     | JAN              |        2 |
| 3+9      | 2+10         | MAR     | FEB              |        3 |
| 4+8      | 3+9          | APR     | MAR              |        4 |
| 5+7      | 4+8          | MAY     | APR              |        5 |
| 6+6      | 5+7          | JUN     | MAY              |        6 |
| 7+5      | 6+6          | JUL     | JUN              |        7 |
| 8+4      | 7+5          | AUG     | JUL              |        8 |
| 9+3      | 8+4          | SEP     | AUG              |        9 |


Table: SelMth_Prior
| Actual   | Prior Fcst   | Month   | Previous_Month   |   Mth_No |
|:---------|:-------------|:--------|:-----------------|---------:|
| 0+12     | 12+0         |         |                  |        0 |
| 1+11     | 0+12         | JAN     | JAN              |        1 |
| 2+10     | 1+11         | FEB     | JAN              |        2 |
| 3+9      | 2+10         | MAR     | FEB              |        3 |
| 4+8      | 3+9          | APR     | MAR              |        4 |
| 5+7      | 4+8          | MAY     | APR              |        5 |
| 6+6      | 5+7          | JUN     | MAY              |        6 |
| 7+5      | 6+6          | JUL     | JUN              |        7 |
| 8+4      | 7+5          | AUG     | JUL              |        8 |
| 9+3      | 8+4          | SEP     | AUG              |        9 |


Table: SelYr
|   Year |
|-------:|
|   2019 |
|   2020 |
|   2021 |


Table: SelYr2
|   Year |
|-------:|
|   2019 |
|   2020 |
|   2021 |


Table: Year_Grp
|   Year |
|-------:|
|   2019 |
|   2020 |
|   2021 |


Table: Yr_PLP
|   Year |
|-------:|
|   2019 |
|   2020 |
|   2021 |

 


tables: name: ACT_Mths
data: ACT_Mths.csv
name: BBP_Mths
data: BBP_Mths.csv
name: Calendar
data: Calendar.csv
name: Channel_Grp
data: Channel_Grp.csv
name: Channel_PL
data: Channel_PL.csv
name: Dim_Hierarchy
data: Dim_Hierarchy.csv
name: FCST_Mths
data: FCST_Mths.csv
name: Grp_Summary
data: Grp_Summary.csv
name: Grp_Sumry_Rep
data: Grp_Sumry_Rep.csv
name: Logistics_
data: Logistics_.csv
name: Measure_Slicer
data: Measure_Slicer.csv
name: Measure_Slicer4
data: Measure_Slicer4.csv
name: Measure_Slicer_2
data: Measure_Slicer_2.csv
name: Period_Slicer
data: Period_Slicer.csv
name: PL
data: PL.csv
name: Product_Grp
data: Product_Grp.csv
name: Profitability_Consolidation
data: Profitability_Consolidation.csv
name: Region_Grp
data: Region_Grp.csv
name: Region_PL
data: Region_PL.csv
name: SelMth
data: SelMth.csv
name: SelMth2
data: SelMth2.csv
name: SelMth3
data: SelMth3.csv
name: SelMth4
data: SelMth4.csv
name: SelMth_Current
data: SelMth_Current.csv
name: SelMth_Prior
data: SelMth_Prior.csv
name: SelYr
data: SelYr.csv
name: SelYr2
data: SelYr2.csv
name: Year_Grp
data: Year_Grp.csv
name: Yr_PLP
data: Yr_PLP.csv
label: SelMth3
Mth_No
Calendar
Mth_No
Grp_Sumry_Rep
Item_No
Profitability_Consolidation
Item_No
Profitability_Consolidation
Channel
Channel_Grp
Channel
Grp_Summary
Index
Dim_Hierarchy
Index
Period_Slicer
Measure
Measure_Slicer4
Measure
PL
Region
Region_PL
Region
PL
Channel
Channel_PL
Channel
Logistics_
GrpId
Dim_Hierarchy
Sno
PL
SNO
Logistics_
GrpId
output: {
    "joins": [
        {
            "from_table": "SelMth3",
            "from_column": "Mth_No",
            "to_table": "Calendar",
            "to_column": "Mth_No"
        },
        {
            "from_table": "Grp_Sumry_Rep",
            "from_column": "Item_No",
            "to_table": "Profitability_Consolidation",
            "to_column": "Item_No"
        },
        {
            "from_table": "Profitability_Consolidation",
            "from_column": "Channel",
            "to_table": "Channel_Grp",
            "to_column": "Channel"
        },
        {
            "from_table": "Grp_Summary",
            "from_column": "Index",
            "to_table": "Dim_Hierarchy",
            "to_column": "Index"
        },
        {
            "from_table": "Period_Slicer",
            "from_column": "Measure",
            "to_table": "Measure_Slicer4",
            "to_column": "Measure"
        },
        {
            "from_table": "PL",
            "from_column": "Region",
            "to_table": "Region_PL",
            "to_column": "Region"
        },
        {
            "from_table": "PL",
            "from_column": "Channel",
            "to_table": "Channel_PL",
            "to_column": "Channel"
        },
        {
            "from_table": "Logistics_",
            "from_column": "GrpId",
            "to_table": "Dim_Hierarchy",
            "to_column": "Sno"
        },
        {
            "from_table": "PL",
            "from_column": "SNO",
            "to_table": "Logistics_",
            "to_column": "GrpId"
        }
    ]
}