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: Balance Sheet Measures



Table: BankAccounts
|   BankAccount |
|--------------:|
|         80101 |
|         80105 |
|         80106 |
|         80107 |
|         80102 |


Table: centre
|   CentreCode | CentreName     |
|-------------:|:---------------|
|            1 | Administration |
|            2 | FCA Customers  |


Table: Collections
|   SiteSplit |   SheetNumber |   CompanyNo | MachineCode       |   SerialNo | CollectionDate          | CollectionType   |   CollectBy |   FrontMoney |   NettTakings |   OperatorSplit |   ClientSplit |   RentalDue |   RoyaltyDue | Site   | SiteNameCode                         |   TotalShortfall |   TotalTakings |   WeeklyAverageSplit | CustomerCode   | LastCollection          |   MeterMovement | MeterMovement2   |   Difference | NlTransactionKey          |   YY |   mm |
|------------:|--------------:|------------:|:------------------|-----------:|:------------------------|:-----------------|------------:|-------------:|--------------:|----------------:|--------------:|------------:|-------------:|:-------|:-------------------------------------|-----------------:|---------------:|---------------------:|:---------------|:------------------------|----------------:|:-----------------|-------------:|:--------------------------|-----:|-----:|
|      457.4  |      10007425 |           1 | GOLDENLOTTODELPRO |   70000062 | 2019-04-04 00:00:00.000 | Standard         |          10 |            0 |        914.8  |          457.4  |             0 |           0 |            0 | LMR02  | LMRCA Club - Old Trafford            |                0 |          914.8 |               457.4  | LMROT          | 2019-03-28 00:00:00.000 |           17879 |                  |            0 | 10007425-01-NL-Collection | 2020 |    1 |
|      198.85 |      10007438 |           1 | GOLDENLOTTODELPRO |   70000062 | 2019-04-11 00:00:00.000 | Standard         |          10 |            0 |        397.7  |          198.85 |             0 |           0 |            0 | LMR02  | LMRCA Club - Old Trafford            |                0 |          397.7 |               198.85 | LMROT          | 2019-04-04 00:00:00.000 |           21407 |                  |            0 | 10007438-01-NL-Collection | 2020 |    1 |
|       52.5  |      10007433 |           1 | POOLWIN7BLA       |       1017 | 2019-04-05 00:00:00.000 | Standard         |          10 |            0 |        105    |           52.5  |             0 |           0 |            0 | INF01  | Inferno - M20 4WA                    |                0 |          126   |                13.13 | INF01          | 2019-03-08 00:00:00.000 |            1260 |                  |            0 | 10007433-01-NL-Collection | 2020 |    1 |
|      182.85 |      10007435 |           1 | GOLDENLOTTOTEMP   |   70000041 | 2019-04-12 00:00:00.000 | Standard         |          10 |            0 |        365.7  |          182.85 |             0 |           0 |            0 | BRO02  | Broadheath Central Club - Broadheath |                0 |          365.7 |                45.71 | BRO02          | 2019-03-15 00:00:00.000 |            9441 |                  |            0 | 10007435-01-NL-Collection | 2020 |    1 |
|      319.8  |      10007447 |           1 | GOLDENLOTTODELPRO |   70000062 | 2019-04-18 00:00:00.000 | Standard         |          10 |            0 |        639.6  |          319.8  |             0 |           0 |            0 | LMR02  | LMRCA Club - Old Trafford            |                0 |          639.6 |               319.8  | LMROT          | 2019-04-11 00:00:00.000 |           22356 |                  |            0 | 10007447-01-NL-Collection | 2020 |    1 |
|       44.02 |      10007351 |           1 | POOLPRI6WALEL     |   70000058 | 2019-04-18 00:00:00.000 | Standard         |          10 |            0 |        132.08 |           88.06 |             0 |           0 |            0 | HBC01  | Hale Barns Cricket Club - Altrincham |                0 |          158.5 |                 3.69 | HBC01          | 2018-11-02 00:00:00.000 |            1585 |                  |            0 | 10007351-01-NL-Collection | 2020 |    1 |
|       97.75 |      10007525 |           1 | GOLDENLOTTODELPRO |   70000062 | 2019-04-25 00:00:00.000 | Standard         |          10 |            0 |        195.5  |           97.75 |             0 |           0 |            0 | LMR02  | LMRCA Club - Old Trafford            |                0 |          195.5 |                97.75 | LMROT          | 2019-04-18 00:00:00.000 |           21205 |                  |            0 | 10007525-01-NL-Collection | 2020 |    1 |
|      162.08 |      10007527 |           1 | POOLWIN6BEE       |       1010 | 2019-04-24 00:00:00.000 | Standard         |          10 |            0 |        324.17 |          162.09 |             0 |           0 |            0 | ROL01  | Wigan Roller Rink - Wigan            |                0 |          389   |                14.55 | ROL01          | 2019-02-05 00:00:00.000 |             389 |                  |            0 | 10007527-01-NL-Collection | 2020 |    1 |
|      107.85 |      10007607 |           1 | GOLDENLOTTODELPRO |   70000062 | 2019-05-02 00:00:00.000 | Standard         |          10 |            0 |        215.7  |          107.85 |             0 |           0 |            0 | LMR02  | LMRCA Club - Old Trafford            |                0 |          215.7 |               107.85 | LMROT          | 2019-04-25 00:00:00.000 |           16662 |                  |            0 | 10007607-01-NL-Collection | 2020 |    2 |
|       15    |      10007628 |           1 | POOLPRINCE7OAKEL  |   70000060 | 2019-05-02 00:00:00.000 | Standard         |          10 |            0 |         30    |           15    |             0 |           0 |            0 | GIL01  | Gilda Brook Social Club - Manchester |                0 |           36   |                 2.1  | GIL01          | 2019-03-13 00:00:00.000 |             360 |                  |            0 | 10007628-01-NL-Collection | 2020 |    2 |


Table: Company
| PiWebCustomerID   |   CompanyNumber | CompanyName              | NextYearEnd             |
|:------------------|----------------:|:-------------------------|:------------------------|
| M0002             |               1 | Manco Automatics Ltd     | 2020-03-31 00:00:00.000 |
| M0002             |              55 | Chris And Derek Car Park | 2020-03-31 00:00:00.000 |


Table: Customer
| CustomerCode   | CustomerName            | CustomerEmail   | BreweryCode   |
|:---------------|:------------------------|:----------------|:--------------|
| ABU01          | Abu Balqiisa            |                 |               |
| AOM01          | AOM School              |                 |               |
| BIR01          | Birchwood College       |                 |               |
| BOR01          | Borough Social Club     |                 |               |
| BRO01          | Brookdale Golf Club     |                 |               |
| BRO02          | Broadheath Central Club |                 |               |
| BRO03          | Brown Cow               |                 |               |
| COU01          | The Courtyard           |                 |               |
| CRO01          | Crown Inn               |                 |               |
| CRO02          | Crosby Social Club      |                 |               |


Table: Date
| Date                    | Calendar Year   | Month Name   |   Month Number | Weekday   |   Weekday number | Quarter   |
|:------------------------|:----------------|:-------------|---------------:|:----------|-----------------:|:----------|
| 2018-01-01 00:00:00.000 | CY 2018         | January      |              1 | Monday    |                2 | Q1        |
| 2018-01-02 00:00:00.000 | CY 2018         | January      |              1 | Tuesday   |                3 | Q1        |
| 2018-01-03 00:00:00.000 | CY 2018         | January      |              1 | Wednesday |                4 | Q1        |
| 2018-01-04 00:00:00.000 | CY 2018         | January      |              1 | Thursday  |                5 | Q1        |
| 2018-01-05 00:00:00.000 | CY 2018         | January      |              1 | Friday    |                6 | Q1        |
| 2018-01-06 00:00:00.000 | CY 2018         | January      |              1 | Saturday  |                7 | Q1        |
| 2018-01-07 00:00:00.000 | CY 2018         | January      |              1 | Sunday    |                1 | Q1        |
| 2018-01-08 00:00:00.000 | CY 2018         | January      |              1 | Monday    |                2 | Q1        |
| 2018-01-09 00:00:00.000 | CY 2018         | January      |              1 | Tuesday   |                3 | Q1        |
| 2018-01-10 00:00:00.000 | CY 2018         | January      |              1 | Wednesday |                4 | Q1        |


Table: NlControlCodes
|   Profit |   Input Vat |   Output Vat |   Purchase Ledger |   Sales Ledger |
|---------:|------------:|-------------:|------------------:|---------------:|
|    90199 |       80117 |        90117 |             90111 |          80111 |


Table: NlTransactionsArchive
|   Company |   Cost centre |   Nominal Code | Source   | Supplier   | Customer   | Type name   |   YY |   mm | Date                    |      Ref |   Amount |
|----------:|--------------:|---------------:|:---------|:-----------|:-----------|:------------|-----:|-----:|:------------------------|---------:|---------:|
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-01 00:00:00.000 | 10006301 |    12.62 |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-01 00:00:00.000 | 10006302 |    17.54 |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-01 00:00:00.000 | 10006303 |    21.02 |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-03 00:00:00.000 | 10006283 |     8.25 |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-03 00:00:00.000 | 10006284 |    58.46 |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-03 00:00:00.000 | 10006285 |    83.88 |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-03 00:00:00.000 | 10006311 |     4.4  |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-03 00:00:00.000 | 10006317 |    22.82 |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-04 00:00:00.000 | 10006274 |    19.16 |
|         1 |             1 |          90117 | NL       |            |            | Collection  | 2019 |    1 | 2018-04-04 00:00:00.000 | 10006277 |    27.52 |


Table: NlTransactionsPosted
|   Company |   Cost centre |   Nominal Code | Source   | Type name   | Date                    |   YY |   mm |      Ref | Supplier   | Customer   |   Amount | Nl Transaction Key         |   PeriodKey |
|----------:|--------------:|---------------:|:---------|:------------|:------------------------|-----:|-----:|---------:|:-----------|:-----------|---------:|:---------------------------|------------:|
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-01 00:00:00.000 | 2019 |    1 | 10006301 |            |            |    12.62 | 10006301--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-01 00:00:00.000 | 2019 |    1 | 10006302 |            |            |    17.54 | 10006302--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-01 00:00:00.000 | 2019 |    1 | 10006303 |            |            |    21.02 | 10006303--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-03 00:00:00.000 | 2019 |    1 | 10006283 |            |            |     8.25 | 10006283--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-03 00:00:00.000 | 2019 |    1 | 10006284 |            |            |    58.46 | 10006284--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-03 00:00:00.000 | 2019 |    1 | 10006285 |            |            |    83.88 | 10006285--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-03 00:00:00.000 | 2019 |    1 | 10006311 |            |            |     4.4  | 10006311--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-03 00:00:00.000 | 2019 |    1 | 10006317 |            |            |    22.82 | 10006317--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-04 00:00:00.000 | 2019 |    1 | 10006274 |            |            |    19.16 | 10006274--01-NL-Collection |    20190001 |
|         1 |             1 |          90117 | NL       | Collection  | 2018-04-04 00:00:00.000 | 2019 |    1 | 10006277 |            |            |    27.52 | 10006277--01-NL-Collection |    20190001 |


Table: NominalCode
|   NominalCode | NominalDescription        |    NominalGroupType |    NominalGroupTenCode |
|--------------:|:--------------------------|--------------------:|-----------------------:|
|         10000 | Cost of spares & cd's     |                   1 |                   1000 |
|         10001 | Equipment spares & repair |                   1 |                   1000 |
|         10002 | Records & CD's            |                   1 |                   1000 |
|         10003 | Equipment Hire Charge     |                   1 |                   1000 |
|         10004 | Machines For Sale         |                   1 |                   1000 |
|         10005 | Gaming M/c Updates        |                   1 |                   1000 |
|         10010 | Salaried staff costs      |                   1 |                   1001 |
|         10011 | Salaries                  |                   1 |                   1001 |
|         10012 | NI on salaries            |                   1 |                   1001 |
|         10013 | PAYE on salaries          |                   1 |                   1001 |


Table: NominalCodeGroups
|   TypeCode | TransactionType     |
|-----------:|:--------------------|
|          0 | Sales               |
|          1 | Costs               |
|          2 | Income              |
|          3 | Expenditure         |
|          4 | Project Income      |
|          5 | Project Costs       |
|          6 | Project Assets      |
|          7 | Project Liabilities |
|          8 | Assets              |
|          9 | Liabilities         |


Table: NominalCodeGroupTen
|   NominalGroupTenCode | NominalGroupTenDescription   |
|----------------------:|:-----------------------------|
|                     1 | Sales of services            |
|                     2 | Sundry sales                 |
|                  1000 | Cost of spares & cd's        |
|                  1001 | Salaried staff costs         |
|                  1002 | Wages costs                  |
|                  1003 | Premises costs               |
|                  1004 | Heat & light                 |
|                  1005 | Motor & travelling           |
|                  1006 | Communication costs          |
|                  1007 | Print Postage Stationery     |


Table: NominalTemplate
|   ReportID |   Sequence |   NominalCode | Type   | Description               | CalcLine1   | Op1   | CalcLine2   | Op2   | CalcLine3   | Op3   | CalcLine4   |
|-----------:|-----------:|--------------:|:-------|:--------------------------|:------------|:------|:------------|:------|:------------|:------|:------------|
|          1 |         30 |         00000 | Data   | Machine Income            |             |       |             |       |             |       |             |
|          1 |         40 |         00001 | Data   | Machine Shares            |             |       |             |       |             |       |             |
|          1 |         50 |         00002 | Data   | Machine Rent              |             |       |             |       |             |       |             |
|          1 |         60 |         00003 | Data   | Gaming Software           |             |       |             |       |             |       |             |
|          1 |         70 |         00005 | Data   | Sales of goods            |             |       |             |       |             |       |             |
|          1 |        100 |         00010 | Data   | Sales of services         |             |       |             |       |             |       |             |
|          1 |        110 |         00010 | Data   | Sales of services         |             |       |             |       |             |       |             |
|          1 |        120 |         00011 | Data   | Service sales             |             |       |             |       |             |       |             |
|          1 |        130 |         00012 | Data   | Machine Sales - Non Stock |             |       |             |       |             |       |             |
|          1 |        160 |         00020 | Data   | Sundry ncome              |             |       |             |       |             |       |             |


Table: PeriodTable
|   YY |   mm |   PeriodKey |   Sort |
|-----:|-----:|------------:|-------:|
| 2020 |    1 |   2.02e+07  |      2 |
| 2019 |    1 |   2.019e+07 |      2 |
| 2020 |    2 |   2.02e+07  |      3 |
| 2019 |    2 |   2.019e+07 |      3 |
| 2020 |    3 |   2.02e+07  |      4 |
| 2019 |    3 |   2.019e+07 |      4 |
| 2020 |    4 |   2.02e+07  |      5 |
| 2019 |    4 |   2.019e+07 |      5 |
| 2020 |    5 |   2.02e+07  |      6 |
| 2019 |    5 |   2.019e+07 |      6 |


Table: PeriodTableSort
|   mm |   sort |
|-----:|-------:|
|    0 |      1 |
|    1 |      2 |
|    2 |      3 |
|    3 |      4 |
|    4 |      5 |
|    5 |      6 |
|    6 |      7 |
|    7 |      8 |
|    8 |      9 |
|    9 |     10 |


Table: PlInvoiceHeader
|   Company | SupplierCode   | InvCn   | InvoiceDate             |   InvoiceNo |   Period |   Year | GrossInvoiceAmount   |   VatAmount |   OutstandingBalance | NL Transaction Key     |
|----------:|:---------------|:--------|:------------------------|------------:|---------:|-------:|:---------------------|------------:|---------------------:|:-----------------------|
|         1 | BAR01          | C/N     | 2019-04-05 00:00:00.000 |    20008823 |        1 |   2020 |                      |      -65.27 |                    0 | 20008823-01-PL-Invoice |
|         1 | BAR01          | C/N     | 2019-04-16 00:00:00.000 |    20008941 |        1 |   2020 |                      |     -246.26 |                    0 | 20008941-01-PL-Invoice |
|         1 | BAR01          | INV     | 2019-04-26 00:00:00.000 |    20009041 |        1 |   2020 |                      |      618    |                    0 | 20009041-01-PL-Invoice |
|         1 | BAR01          | INV     | 2019-05-09 00:00:00.000 |    20009042 |        2 |   2020 |                      |      362.38 |                    0 | 20009042-01-PL-Invoice |
|         1 | BAR01          | INV     | 2019-05-13 00:00:00.000 |    20009064 |        2 |   2020 |                      |      382.62 |                    0 | 20009064-01-PL-Invoice |
|         1 | BAR01          | INV     | 2019-05-15 00:00:00.000 |    20009070 |        2 |   2020 |                      |      379.82 |                    0 | 20009070-01-PL-Invoice |
|         1 | BAR01          | C/N     | 2019-05-17 00:00:00.000 |    20009071 |        2 |   2020 |                      |     -240    |                    0 | 20009071-01-PL-Invoice |
|         1 | BAR01          | INV     | 2019-05-20 00:00:00.000 |    20009073 |        2 |   2020 |                      |      215.1  |                    0 | 20009073-01-PL-Invoice |
|         1 | BAR01          | INV     | 2019-05-20 00:00:00.000 |    20009075 |        2 |   2020 |                      |      281.26 |                    0 | 20009075-01-PL-Invoice |
|         1 | BAR01          | C/N     | 2019-05-22 00:00:00.000 |    20009077 |        2 |   2020 |                      |     -327.38 |                    0 | 20009077-01-PL-Invoice |


Table: Sites
| SiteNameCode                         | SiteCode   | RegionCode   | AreaCode   | PostCode   | BreweryHouseCode   |   CentreCode | Collection   |   Collector | CustomerCode   | Engineer   | IOASite   | LocalAuthorityCode   | Rep   | SiteTypeCode   | TradeTypeCode   | SiteStartDate   | SiteCeasedDate   | SiteStatus   |
|:-------------------------------------|:-----------|:-------------|:-----------|:-----------|:-------------------|-------------:|:-------------|------------:|:---------------|:-----------|:----------|:---------------------|:------|:---------------|:----------------|:----------------|:-----------------|:-------------|
| Abu Balqiisa - Moss Side             | safe       | GM           |            | M14 4TS    |                    |            1 | 28           |         010 | ABU01          |            | no        |                      | 011   | TAKE           | K               |                 |                  | Inactive     |
| AOM School - Sale                    | AOM01      | GM           |            | M33 5BP    |                    |            1 | 90           |         010 | AOM01          |            | no        |                      | 011   |                | O               |                 |                  | Active       |
| Bandar Adan - Manchester             | BAN01      | GM           |            | M14 4TS    |                    |            2 |              |         010 | BAN01          | 011        | no        |                      | 011   | TAKE           | K               |                 |                  | Inactive     |
| Birchwood College - Birchwood        | BIR01      | GM           |            | WA3 7PT    |                    |            1 | 90           |         010 | BIR01          | 011        | no        |                      | 011   | SCHOO          | E               |                 |                  | Active       |
| Borough Social Club - Swinton        | BOR01      | GM           |            | M27 6BU    |                    |            2 | 7            |         010 | BOR01          |            | no        |                      |       |                | O               |                 |                  | Active       |
| Brookdale Golf Club - Failsworth     | BRO01      | GM           | M60        | M35 9WQ    |                    |            1 | 56           |         010 | BRO01          |            | no        |                      | 011   | SCLUB          | C               |                 |                  | Inactive     |
| Broadheath Central Club - Broadheath | BRO02      | GM           |            | WA14 5DX   |                    |            2 | 28           |         010 | BRO02          |            | no        |                      |       | SCLUB          | C               |                 |                  | Active       |
| Brown Cow - Bury                     | BRO03      | GM           |            | BL8 1DA    |                    |            1 | 28           |         010 | BRO03          |            | no        |                      |       |                |                 |                 |                  | Active       |
| Courtyard - Manchester               | COU01      | GM           |            | M1 5SH     |                    |            2 | 4            |         010 | COU01          | 011        | no        |                      | 011   | NIGHT          |                 |                 |                  | Active       |
| Crown Inn - Chadderton               | CRO01      | GM           |            | OL9 9LR    |                    |            2 | 28           |         010 | CRO01          |            | no        |                      |       |                |                 |                 |                  | Active       |


Table: SlInvoiceHeader
|   Company | CustomerCode   | SiteCode   | InvCn   | InvoiceDate             |   InvoiceNo |   Period |   Year | OrderNumber   |   GrossInvoiceAmount |   VatAmount |   NetInvoiceAmount |   OutstandingBalance | NL Transaction Key     |
|----------:|:---------------|:-----------|:--------|:------------------------|------------:|---------:|-------:|:--------------|---------------------:|------------:|-------------------:|---------------------:|:-----------------------|
|         1 | C3KHO          | C3KHOMID01 | INV     | 2019-04-16 00:00:00.000 |    30002298 |        1 |   2020 |               |              2162.1  |      360.35 |            1801.75 |                    0 | 30002298-01-SL-Invoice |
|         1 | C3KHO          | C3KHOPRN01 | INV     | 2019-04-16 00:00:00.000 |    30002299 |        1 |   2020 |               |               290.1  |       48.35 |             241.75 |                    0 | 30002299-01-SL-Invoice |
|         1 | C3KHO          | C3KHOTRA01 | INV     | 2019-04-16 00:00:00.000 |    30002300 |        1 |   2020 |               |               997.2  |      166.2  |             831    |                    0 | 30002300-01-SL-Invoice |
|         1 | C3KHO          | C3KHOWKN01 | INV     | 2019-04-16 00:00:00.000 |    30002301 |        1 |   2020 |               |               378    |       63    |             315    |                    0 | 30002301-01-SL-Invoice |
|         1 | C3KHO          | C3KHOSPK01 | INV     | 2019-04-16 00:00:00.000 |    30002302 |        1 |   2020 |               |               462.66 |       77.11 |             385.55 |                    0 | 30002302-01-SL-Invoice |
|         1 | C3KHO          | C3KHOHUY01 | INV     | 2019-04-16 00:00:00.000 |    30002303 |        1 |   2020 |               |               396    |       66    |             330    |                    0 | 30002303-01-SL-Invoice |
|         1 | C3KHO          | C3KHOCLY01 | INV     | 2019-04-18 00:00:00.000 |    30002304 |        1 |   2020 |               |               622.94 |      103.82 |             519.12 |                    0 | 30002304-01-SL-Invoice |
|         1 | C3KHO          | C3KHOMID01 | INV     | 2019-04-18 00:00:00.000 |    30002305 |        1 |   2020 |               |               768    |      128    |             640    |                    0 | 30002305-01-SL-Invoice |
|         1 | C3KHO          | C3KHOKIR01 | INV     | 2019-04-18 00:00:00.000 |    30002307 |        1 |   2020 |               |               168    |       28    |             140    |                    0 | 30002307-01-SL-Invoice |
|         1 | C3KHO          | C3KHOMID01 | INV     | 2019-04-30 00:00:00.000 |    30002309 |        1 |   2020 |               |               948    |      158    |             790    |                    0 | 30002309-01-SL-Invoice |


Table: Supplier
|   SupplierCompany | SupplierCode   | SupplierName                 | SupplierEmail   |
|------------------:|:---------------|:-----------------------------|:----------------|
|                 1 | DLS01          | Data Leisure Sales Ltd       |                 |
|                 1 | ADE01          | Adelante Software Ltd        |                 |
|                 1 | PHH01          | Arval PHH Vehicle Management |                 |
|                 1 | AST01          | Astra Games Ltd              |                 |
|                 1 | AZT01          | Aztec Coin Equipment Ltd     |                 |
|                 1 | CBS01          | CBS Ltd                      |                 |
|                 1 | CPC01          | CPC Ltd                      |                 |
|                 1 | FIM01          | First Internet Marketing Ltd |                 |
|                 1 | HMR01          | HM Revenue & Customs         |                 |
|                 1 | INT01          | Intuit UK Ltd                |                 |

 


tables: name: Balance Sheet Measures
data: Balance Sheet Measures.csv
name: BankAccounts
data: BankAccounts.csv
name: centre
data: centre.csv
name: Collections
data: Collections.csv
name: Company
data: Company.csv
name: Customer
data: Customer.csv
name: Date
data: Date.csv
name: NlControlCodes
data: NlControlCodes.csv
name: NlTransactionsArchive
data: NlTransactionsArchive.csv
name: NlTransactionsPosted
data: NlTransactionsPosted.csv
name: NominalCode
data: NominalCode.csv
name: NominalCodeGroups
data: NominalCodeGroups.csv
name: NominalCodeGroupTen
data: NominalCodeGroupTen.csv
name: NominalTemplate
data: NominalTemplate.csv
name: PeriodTable
data: PeriodTable.csv
name: PeriodTableSort
data: PeriodTableSort.csv
name: PlInvoiceHeader
data: PlInvoiceHeader.csv
name: Sites
data: Sites.csv
name: SlInvoiceHeader
data: SlInvoiceHeader.csv
name: Supplier
data: Supplier.csv
label: NlTransactionsPosted
Nominal Code
NominalCode
NominalCode
NlTransactionsPosted
Cost centre
centre
CentreCode
SlInvoiceHeader
CustomerCode
Customer
CustomerCode
NominalCode
 NominalGroupTenCode
NominalCodeGroupTen
NominalGroupTenCode
PlInvoiceHeader
SupplierCode
Supplier
SupplierCode
Collections
SiteNameCode
Sites
SiteNameCode
BankAccounts
BankAccount
NominalCode
NominalCode
NlTransactionsPosted
Company
Company
CompanyNumber
NominalCode
 NominalGroupType
NominalCodeGroups
TypeCode
NlTransactionsPosted
Customer
Customer
CustomerCode
NlTransactionsPosted
PeriodKey
PeriodTable
PeriodKey
output: {
    "joins": [
        {
            "from_table": "NlTransactionsPosted",
            "from_column": "Nominal Code",
            "to_table": "NominalCode",
            "to_column": "NominalCode"
        },
        {
            "from_table": "NlTransactionsPosted",
            "from_column": "Cost centre",
            "to_table": "centre",
            "to_column": "CentreCode"
        },
        {
            "from_table": "SlInvoiceHeader",
            "from_column": "CustomerCode",
            "to_table": "Customer",
            "to_column": "CustomerCode"
        },
        {
            "from_table": "NominalCode",
            "from_column": " NominalGroupTenCode",
            "to_table": "NominalCodeGroupTen",
            "to_column": "NominalGroupTenCode"
        },
        {
            "from_table": "PlInvoiceHeader",
            "from_column": "SupplierCode",
            "to_table": "Supplier",
            "to_column": "SupplierCode"
        },
        {
            "from_table": "Collections",
            "from_column": "SiteNameCode",
            "to_table": "Sites",
            "to_column": "SiteNameCode"
        },
        {
            "from_table": "BankAccounts",
            "from_column": "BankAccount",
            "to_table": "NominalCode",
            "to_column": "NominalCode"
        },
        {
            "from_table": "NlTransactionsPosted",
            "from_column": "Company",
            "to_table": "Company",
            "to_column": "CompanyNumber"
        },
        {
            "from_table": "NominalCode",
            "from_column": " NominalGroupType",
            "to_table": "NominalCodeGroups",
            "to_column": "TypeCode"
        },
        {
            "from_table": "NlTransactionsPosted",
            "from_column": "Customer",
            "to_table": "Customer",
            "to_column": "CustomerCode"
        },
        {
            "from_table": "NlTransactionsPosted",
            "from_column": "PeriodKey",
            "to_table": "PeriodTable",
            "to_column": "PeriodKey"
        }
    ]
}