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: 30 days sales outstanding
| DATAAREAID   |   PARTITION |   ACCOUNTNUM |   CustCollectionsBIMeasurements_CustTable_FK |       RECID |   CUSTTRANSSYSTEMCURRENCYAMOUNT | OPENSYSTEMCURRENCYAMOUNT   | VOUCHER    | ACCOUNTINGCURRENCY   |   CUSTACCOUNTNUM |   COLLECTIONLETTER_VALUE |   COLLECTIONLETTERCODE_VALUE | COMPANY   |   CREDITMAX | CREDITRATING   |   CROSSRATE | CUSTTRANSOPENRECID   |   CUSTTRANSRECID |   CUSTTRANSTABLEID | DUEDATE                 | GREGORIANDATE           | INVOICE   | CUSTNAME                | OPENAMOUNTMST   |       PARTY |   REASONREFRECID | SYSTEMCURRENCYCODE   |   SYSTEMCURRENCYCREDITMAX | TRANSDATE               |   TRANSTYPE_VALUE |   ISDSO30_VALUE | COLLECTIONLETTER   | COLLECTIONLETTERCODE   | TRANSTYPE   | ISDSO30   |
|:-------------|------------:|-------------:|---------------------------------------------:|------------:|--------------------------------:|:---------------------------|:-----------|:---------------------|-----------------:|-------------------------:|-----------------------------:|:----------|------------:|:---------------|------------:|:---------------------|-----------------:|-------------------:|:------------------------|:------------------------|:----------|:------------------------|:----------------|------------:|-----------------:|:---------------------|--------------------------:|:------------------------|------------------:|----------------:|:-------------------|:-----------------------|:------------|:----------|
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                        -1331.05 |                            | ARPM000015 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637152151 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                        -1113.61 |                            | ARPM000016 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637152152 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                         -160.12 |                            | ARPM000017 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637152153 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                         -353.55 |                            | ARPM000704 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637154113 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                        -1884.66 |                            | ARPM000705 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637154114 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                        -1173.86 |                            | ARPM000706 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637154115 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                        -1209.89 |                            | ARPM000707 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637154116 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                        -1163.64 |                            | ARPM000708 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637154117 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                         -658.2  |                            | ARPM000709 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637154118 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |
| usrt         |  5637144576 |       100001 |                                          282 | 22565422808 |                         -261.98 |                            | ARPM000710 | USD                  |           100001 |                        1 |                            0 | usrt      |           0 |                |         100 |                      |       5637154119 |               9021 | 2015-01-01 00:00:00.000 | 2018-08-28 00:00:00.000 |           | Default Retail Customer |                 | 22565427475 |                0 | USD                  |                         0 | 2015-01-01 00:00:00.000 |                15 |               0 | Yes                | None                   | Payment     | No        |


Table: Activities average days to close
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |       RECID |   Days to close an activity |   Activity number | Company   | Customer account   | Customer name    | Responsible worker   |
|------------:|---------------------------------------------:|------------:|----------------------------:|------------------:|:----------|:-------------------|:-----------------|:---------------------|
|  5637144576 |                                           79 | 68719483245 |                           4 |               345 | usmf      | US-004             | Cave Wholesales  |                      |
|  5637144576 |                                           79 | 68719483243 |                           6 |               343 | usmf      | US-004             | Cave Wholesales  |                      |
|  5637144576 |                                           91 | 22565430750 |                          -1 |               113 | usmf      | US-008             | Sparrow Retail   | Charlie Carson       |
|  5637144576 |                                          132 | 68719484740 |                           3 |                13 | demf      | DE-016             | Southridge Video |                      |


Table: Aging
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |       RECID |   Aged balances | Company   | Customer account   | Aging periods   | Customer name            |   Aging period definitions |
|------------:|---------------------------------------------:|------------:|----------------:|:----------|:-------------------|:----------------|:-------------------------|---------------------------:|
|  5637144576 |                                           72 | 22565424276 |          268.13 | usmf      | US-001             | 180 and over    | Contoso Retail San Diego |               30_60_90_180 |
|  5637144576 |                                           72 | 22565424273 |          321.75 | usmf      | US-001             | 30 days         | Contoso Retail San Diego |               30_60_90_180 |
|  5637144576 |                                           78 | 22565424276 |        67814.2  | usmf      | US-003             | 180 and over    | Forest Wholesales        |               30_60_90_180 |
|  5637144576 |                                           79 | 22565424272 |         1040    | usmf      | US-004             | Current         | Cave Wholesales          |               30_60_90_180 |
|  5637144576 |                                           91 | 22565424276 |         3195    | usmf      | US-008             | 180 and over    | Sparrow Retail           |               30_60_90_180 |
|  5637144576 |                                           91 | 22565424272 |         1836.74 | usmf      | US-008             | Current         | Sparrow Retail           |               30_60_90_180 |
|  5637144576 |                                           92 | 22565424272 |         2000    | usmf      | US-009             | Current         | Owl Wholesales           |               30_60_90_180 |
|  5637144576 |                                           95 | 22565424272 |       531250    | usmf      | US-010             | Current         | Sunset Wholesales        |               30_60_90_180 |
|  5637144576 |                                           99 | 22565424274 |        25000    | usmf      | US-012             | 60 days         | Contoso Retail New York  |               30_60_90_180 |
|  5637144576 |                                          117 | 22565424272 |       159375    | usmf      | US-015             | Current         | Contoso Retail Chicago   |               30_60_90_180 |


Table: Balance due
|   PARTITION |       RECID |   Balance due | Company   | Due date                | Customer account   | Customer name            |   Key |
|------------:|------------:|--------------:|:----------|:------------------------|:-------------------|:-------------------------|------:|
|  5637144576 | 35637233233 |        268.13 | usmf      | 2017-01-31 00:00:00.000 | US-001             | Contoso Retail San Diego |    72 |
|  5637144576 | 68719530561 |         20    | usmf      | 2017-07-22 00:00:00.000 | US-001             | Contoso Retail San Diego |    72 |
|  5637144576 | 68719529204 |        321.75 | usmf      | 2017-06-10 00:00:00.000 | US-001             | Contoso Retail San Diego |    72 |
|  5637144576 |  5637222579 |      67814.2  | usmf      | 2017-02-10 00:00:00.000 | US-003             | Forest Wholesales        |    78 |
|  5637144576 | 68719530562 |         20    | usmf      | 2017-08-26 00:00:00.000 | US-003             | Forest Wholesales        |    78 |
|  5637144576 | 68719524561 |       1040    | usmf      | 2018-01-19 00:00:00.000 | US-004             | Cave Wholesales          |    79 |
|  5637144576 | 68719529203 |       3195    | usmf      | 2016-12-21 00:00:00.000 | US-008             | Sparrow Retail           |    91 |
|  5637144576 |  5637151670 |        247.06 | usmf      | 2017-07-20 00:00:00.000 | US-008             | Sparrow Retail           |    91 |
|  5637144576 |  5637151675 |        252    | usmf      | 2017-08-19 00:00:00.000 | US-008             | Sparrow Retail           |    91 |
|  5637144576 |  5637151680 |        257.04 | usmf      | 2017-09-19 00:00:00.000 | US-008             | Sparrow Retail           |    91 |


Table: Case average closed time
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |       RECID |   Average days close |   Case ID | Company   | Customer account   | Customer name            | Responsible worker   |
|------------:|---------------------------------------------:|------------:|---------------------:|----------:|:----------|:-------------------|:-------------------------|:---------------------|
|  5637144576 |                                          132 | 68719479013 |                    9 |         5 | demf      | DE-016             | Southridge Video         |                      |
|  5637144576 |                                           79 | 68719477511 |                   13 |        18 | usmf      | US-004             | Cave Wholesales          |                      |
|  5637144576 |                                           72 | 68719477513 |                    5 |        20 | usmf      | US-001             | Contoso Retail San Diego |                      |


Table: Collection letter amounts
|   PARTITION |   COLLECTIONLETTERCODE_VALUE |       RECID |   Collection letter amount | Company   | Transaction date        | Customer account   | Customer name            | Due date                |   Transactions with collection letter code | Collection letter code   |
|------------:|-----------------------------:|------------:|---------------------------:|:----------|:------------------------|:-------------------|:-------------------------|:------------------------|-------------------------------------------:|:-------------------------|
|  5637144576 |                            3 | 35637233233 |                   268.13   | usmf      | 2017-01-21 00:00:00.000 | US-001             | Contoso Retail San Diego | 2017-01-31 00:00:00.000 |                                         72 | CollectionLetter3        |
|  5637144576 |                            2 | 68719530561 |                    20      | usmf      | 2017-05-22 00:00:00.000 | US-001             | Contoso Retail San Diego | 2017-07-22 00:00:00.000 |                                         72 | CollectionLetter2        |
|  5637144576 |                            2 | 68719529204 |                   321.75   | usmf      | 2017-06-10 00:00:00.000 | US-001             | Contoso Retail San Diego | 2017-06-10 00:00:00.000 |                                         72 | CollectionLetter2        |
|  5637144576 |                            4 |  5637222579 |                 67814.2    | usmf      | 2016-12-27 00:00:00.000 | US-003             | Forest Wholesales        | 2017-02-10 00:00:00.000 |                                         78 | CollectionLetter4        |
|  5637144576 |                            2 | 68719530562 |                    20      | usmf      | 2017-05-22 00:00:00.000 | US-003             | Forest Wholesales        | 2017-08-26 00:00:00.000 |                                         78 | CollectionLetter2        |
|  5637144576 |                            2 | 68719529213 |                 25000      | usmf      | 2017-05-11 00:00:00.000 | US-012             | Contoso Retail New York  | 2017-05-11 00:00:00.000 |                                         99 | CollectionLetter2        |
|  5637144576 |                            2 | 68719530563 |                    20      | usmf      | 2017-05-22 00:00:00.000 | US-012             | Contoso Retail New York  | 2017-07-22 00:00:00.000 |                                         99 | CollectionLetter2        |
|  5637144576 |                            3 |  5637187478 |                    27.3973 | demf      | 2016-10-31 00:00:00.000 | DE-012             | Litware Retail           | 2016-10-31 00:00:00.000 |                                        144 | CollectionLetter3        |
|  5637144576 |                            3 |  5637187483 |                    41.0959 | demf      | 2016-11-30 00:00:00.000 | DE-012             | Litware Retail           | 2016-11-30 00:00:00.000 |                                        144 | CollectionLetter3        |
|  5637144576 |                            1 |  5637149092 |                259155      | demf      | 2016-11-25 00:00:00.000 | DE-015             | Adventure Works          | 2016-11-25 00:00:00.000 |                                        133 | CollectionLetter1        |


Table: Collection status
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |   RECID |   Transaction balance | Company   | Customer account   | Customer name            | Collection status     | Due date                | Transaction date        |
|------------:|---------------------------------------------:|--------:|----------------------:|:----------|:-------------------|:-------------------------|:----------------------|:------------------------|:------------------------|
|  5637144576 |                                          132 |    1010 |             299287    | demf      | DE-016             | Southridge Video         | Disputed              | 2016-12-05 00:00:00.000 | 2016-11-25 00:00:00.000 |
|  5637144576 |                                           72 |    1010 |                268.13 | usmf      | US-001             | Contoso Retail San Diego | Promise to pay broken | 2017-01-31 00:00:00.000 | 2017-01-21 00:00:00.000 |
|  5637144576 |                                           91 |    1010 |               3195    | usmf      | US-008             | Sparrow Retail           | Disputed              | 2016-12-21 00:00:00.000 | 2016-12-21 00:00:00.000 |
|  5637144576 |                                          123 |    1010 |              31800    | usmf      | US-018             | Contoso Retail Detroit   | Promised to pay       | 2017-04-10 00:00:00.000 | 2017-04-10 00:00:00.000 |


Table: Customer dimension
|   PARTITION |   BLOCKED_VALUE |   ROW_UNIQUEKEY |       RECID | Customer account   | Company   |   Customer group | Credit rating   | Country/Region   | County   | State   | City              | District   | Zip/Postal code   | Company1   | Blocked   |
|------------:|----------------:|----------------:|------------:|:-------------------|:----------|-----------------:|:----------------|:-----------------|:---------|:--------|:------------------|:-----------|:------------------|:-----------|:----------|
|  5637144576 |               0 |             171 | 22565427660 | GB_SI_019          | gbsi      |               20 |                 | GBR              |          |         | Gloucestershire   |            |                   | gbsi       | No        |
|  5637144576 |               0 |             175 | 22565427644 | GB_SI_003          | gbsi      |               20 |                 | GBR              |          |         | London            |            |                   | gbsi       | No        |
|  5637144576 |               0 |             176 | 22565427646 | GB_SI_005          | gbsi      |               20 |                 | GBR              |          |         | Maidenhead        |            |                   | gbsi       | No        |
|  5637144576 |               0 |             181 | 22565427655 | GB_SI_014          | gbsi      |               20 |                 | GBR              |          |         | Basingstoke Hants |            |                   | gbsi       | No        |
|  5637144576 |               0 |             185 | 22565427666 | GB_SI_025          | gbsi      |               20 |                 | GBR              |          |         | West Sussex       |            |                   | gbsi       | No        |
|  5637144576 |               0 |             214 | 22565427643 | GB_SI_002          | gbsi      |               20 |                 | GBR              |          | EN      | London            |            |                   | gbsi       | No        |
|  5637144576 |               0 |             215 | 22565427645 | GB_SI_004          | gbsi      |               20 |                 | GBR              |          | EN      | London            |            |                   | gbsi       | No        |
|  5637144576 |               0 |             217 | 22565427651 | GB_SI_010          | gbsi      |               20 |                 | GBR              |          | EN      | Warrington        |            |                   | gbsi       | No        |
|  5637144576 |               0 |             219 | 22565427656 | GB_SI_015          | gbsi      |               20 |                 | GBR              |          | EN      | Lancaster         |            |                   | gbsi       | No        |
|  5637144576 |               0 |             225 | 22565427669 | GB_SI_028          | gbsi      |               20 |                 | GBR              |          | EN      | London            |            |                   | gbsi       | No        |


Table: Customers on credit
|   CustCollectionsBIMeasurements_CustTable_FK | Customer account   |   Credit limit | Credit rating   | Company   | Customer name            | Balance       | Credit remaining   |
|---------------------------------------------:|:-------------------|---------------:|:----------------|:----------|:-------------------------|:--------------|:-------------------|
|                                           89 | US-007             |         400000 | Good            | usmf      | Desert Wholesales        |               |                    |
|                                           91 | US-008             |          20000 | Poor            | usmf      | Sparrow Retail           | 5031.74       | 14968.26           |
|                                           95 | US-010             |         400000 | Excellent       | usmf      | Sunset Wholesales        | 531250        | -131250            |
|                                           97 | US-011             |         400000 | Good            | usmf      | Contoso Retail Dallas    |               |                    |
|                                           72 | US-001             |         500000 | Excellent       | usmf      | Contoso Retail San Diego | 341.75        | 499658.25          |
|                                           78 | US-003             |         400000 | Good            | usmf      | Forest Wholesales        | 67834.18      | 332165.82          |
|                                          131 | US-023             |         250000 | Good            | usmf      | Shrike Retail            | 573.02        | 249426.98          |
|                                          108 | US-026             |         100000 | Poor            | usmf      | Maple Company            | 2549.84       | 97450.16           |
|                                          133 | DE-015             |         205479 | Good            | demf      | Adventure Works          | 259155.068493 | -53675.61644       |
|                                          132 | DE-016             |         273973 | Good            | demf      | Southridge Video         | 299286.958904 | -25314.35617       |


Table: Customers on hold
| DATAAREAID   |   PARTITION | ACCOUNTNUM   |   CustCollectionsBIMeasurements_CustTable_FK | CUSTOMERNAME      | BLOCKSTATUS   |   BLOCKED_VALUE |       RECID |
|:-------------|------------:|:-------------|---------------------------------------------:|:------------------|:--------------|----------------:|------------:|
| usmf         |  5637144576 | US-041       |                                          262 | Dolphin Wholesale | All           |               2 | 22565430655 |


Table: Customers over credit limit
|   CustCollectionsBIMeasurements_CustTable_FK | Customer account   |   Credit limit | Credit rating   | Company   | Customer name           |   Balance |   Amount over credit limit |   Credit remaining |
|---------------------------------------------:|:-------------------|---------------:|:----------------|:----------|:------------------------|----------:|---------------------------:|-------------------:|
|                                           95 | US-010             |         400000 | Excellent       | usmf      | Sunset Wholesales       |    531250 |                   131250   |          -131250   |
|                                          133 | DE-015             |         205479 | Good            | demf      | Adventure Works         |    259155 |                    53675.6 |           -53675.6 |
|                                          132 | DE-016             |         273973 | Good            | demf      | Southridge Video        |    299287 |                    25314.4 |           -25314.4 |
|                                          130 | US-022             |         150000 | Good            | usmf      | Contoso Retail Virginia |    200000 |                    50000   |           -50000   |
|                                          117 | US-015             |         100000 | Good            | usmf      | Contoso Retail Chicago  |    159375 |                    59375   |           -59375   |
|                                          112 | US-024             |         250000 | Good            | usmf      | Yellow Square           |    316500 |                    66500   |           -66500   |


Table: Expected payments
|   CustCollectionsBIMeasurements_CustTable_FK |   RECID |   Expected payment amount | Company   | Expected payment date   | Customer account   | Customer name    | Invoice number   |
|---------------------------------------------:|--------:|--------------------------:|:----------|:------------------------|:-------------------|:-----------------|:-----------------|
|                                          261 |    1010 |                  1388.28  | mymf      | 2019-05-08 00:00:00.000 | MY-004             | Otter Wholesales | MYMF-000001      |
|                                          258 |    1010 |                  1034.53  | mymf      | 2019-05-10 00:00:00.000 | MY-001             | Royal Orchid     | MYMF-000003      |
|                                          260 |    1010 |                 55800     | mymf      | 2019-05-10 00:00:00.000 | MY-003             | Orchid shoppers  |                  |
|                                          261 |    1010 |                  1208.62  | mymf      | 2019-05-15 00:00:00.000 | MY-004             | Otter Wholesales | MYMF-000002      |
|                                          258 |    1010 |                  3448.44  | mymf      | 2019-05-16 00:00:00.000 | MY-001             | Royal Orchid     | MYMF-000002      |
|                                          261 |    1010 |                  1388.28  | mymf      | 2019-05-20 00:00:00.000 | MY-004             | Otter Wholesales | MYMF-000004      |
|                                          258 |    1010 |                  3448.44  | mymf      | 2019-05-21 00:00:00.000 | MY-001             | Royal Orchid     | MYMF-000003      |
|                                          261 |    1010 |                  1486.72  | mymf      | 2019-05-21 00:00:00.000 | MY-004             | Otter Wholesales | GST-AR-000001    |
|                                          258 |    1010 |                 -3448.44  | mymf      | 2019-05-22 00:00:00.000 | MY-001             | Royal Orchid     | GST-AR-000002    |
|                                          258 |    1010 |                   586.235 | mymf      | 2019-05-23 00:00:00.000 | MY-001             | Royal Orchid     | GST-AR-000003    |


Table: Open activities
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |   CATEGORY_VALUE |       RECID |   Activity number | Company   | Customer account   | Customer name           | Responsible worker   | Purpose                            | Type       | Start date              | End date                | Category    |
|------------:|---------------------------------------------:|-----------------:|------------:|------------------:|:----------|:-------------------|:------------------------|:---------------------|:-----------------------------------|:-----------|:------------------------|:------------------------|:------------|
|  5637144576 |                                          133 |                0 | 68719484738 |                11 | demf      | DE-015             | Adventure Works         |                      | Phone call for collections         | Phone call | 2017-06-01 16:00:00.000 | 2017-06-13 17:00:00.000 | Appointment |
|  5637144576 |                                          132 |                1 | 68719483996 |                 6 | demf      | DE-016             | Southridge Video        |                      | Follow up on Disputed              |            | 2017-12-06 08:00:00.000 | 2017-12-07 08:00:00.000 | Task        |
|  5637144576 |                                          123 |                1 | 68719483988 |               361 | usmf      | US-018             | Contoso Retail Detroit  |                      | Follow up on Promised to pay       |            | 2017-08-23 07:00:00.000 | 2017-08-24 07:00:00.000 | Task        |
|  5637144576 |                                           91 |                1 | 68719483992 |               365 | usmf      | US-008             | Sparrow Retail          |                      | Follow up on Disputed              |            | 2017-05-23 07:00:00.000 | 2017-05-24 07:00:00.000 | Task        |
|  5637144576 |                                           91 |                1 | 52565445381 |               328 | usmf      | US-008             | Sparrow Retail          |                      | Followup on lost checks            | Follow-up  | 2017-01-22 08:00:00.000 | 2017-01-22 08:00:00.000 | Task        |
|  5637144576 |                                           87 |                1 | 68719483246 |               346 | usmf      | US-006             | Contoso Retail Portland |                      | Followup on overdue transactions   | Email      | 2017-05-19 07:00:00.000 | 2017-05-19 07:00:00.000 | Task        |
|  5637144576 |                                           85 |                1 | 68719484739 |                12 | demf      | DE-011             | Northwind Traders       |                      | Collect INV10000161                | Email      | 2017-05-23 07:00:00.000 | 2017-05-23 07:00:00.000 | Task        |
|  5637144576 |                                           84 |                1 | 68719484737 |                10 | demf      | DE-010             | A.Datum Corporation     |                      | Collect overdue balances           | Email      | 2017-07-04 07:00:00.000 | 2017-07-12 07:00:00.000 | Task        |
|  5637144576 |                                           79 |                1 | 68719483260 |               358 | usmf      | US-004             | Cave Wholesales         |                      | Follow up on Promise to pay broken |            | 2017-05-19 07:00:00.000 | 2017-05-20 07:00:00.000 | Task        |
|  5637144576 |                                           78 |                0 | 68719483257 |               355 | usmf      | US-003             | Forest Wholesales       |                      | Follow up on Promised to pay       |            | 2017-09-25 07:00:00.000 | 2017-09-26 07:00:00.000 | Appointment |


Table: Open cases
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |       RECID |   Case ID | Company   | Account number   | Customer name              | Responsible worker   | Description               |
|------------:|---------------------------------------------:|------------:|----------:|:----------|:-----------------|:---------------------------|:---------------------|:--------------------------|
|  5637144576 |                                           84 | 68719479010 |         2 | demf      | DE-010           | A.Datum Corporation        |                      | Collections               |
|  5637144576 |                                          133 | 68719479011 |         3 | demf      | DE-015           | Adventure Works            |                      | Collections               |
|  5637144576 |                                           85 | 68719479012 |         4 | demf      | DE-011           | Northwind Traders          |                      | Collections               |
|  5637144576 |                                           91 |  5637146094 |        14 | usmf      | US-008           | Sparrow Retail             |                      | Payment lost in mail      |
|  5637144576 |                                          105 | 68719477510 |        17 | usmf      | US-027           | Birch Company              |                      | Collect overdue 1/21/2017 |
|  5637144576 |                                           71 | 68719477512 |        19 | usmf      | DE-001           | Contoso Europe             |                      | Collect overdue balance   |
|  5637144576 |                                           75 | 68719477514 |        21 | usmf      | US-002           | Contoso Retail Los Angeles |                      | Dispute case              |
|  5637144576 |                                           78 | 68719477515 |        22 | usmf      | US-003           | Forest Wholesales          |                      | Collect                   |
|  5637144576 |                                          123 | 68719478260 |        23 | usmf      | US-018           | Contoso Retail Detroit     |                      | Collections               |


Table: Open collection letters
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |   COLLECTIONLETTERCODE_VALUE |       RECID |   Collection letters | Company   | Customer account   | Customer name          | Print date              | Collection letter date   | Collection letter code   |
|------------:|---------------------------------------------:|-----------------------------:|------------:|---------------------:|:----------|:-------------------|:-----------------------|:------------------------|:-------------------------|:-------------------------|
|  5637144576 |                                          123 |                            1 | 68719476758 |                   18 | usmf      | US-018             | Contoso Retail Detroit | 1900-01-01 00:00:00.000 | 2017-07-01 00:00:00.000  | CollectionLetter1        |
|  5637144576 |                                          108 |                            1 | 68719476759 |                   19 | usmf      | US-026             | Maple Company          | 1900-01-01 00:00:00.000 | 2017-07-01 00:00:00.000  | CollectionLetter1        |


Table: Open interest notes
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |       RECID |   Interest note | Company   | Customer account   | Customer name   | From date               | To date                 |
|------------:|---------------------------------------------:|------------:|----------------:|:----------|:-------------------|:----------------|:------------------------|:------------------------|
|  5637144576 |                                           80 | 68719477511 |               0 | usmf      | US-004             | Cave Wholesales | 2016-10-25 00:00:00.000 | 2016-10-28 00:00:00.000 |


Table: Sales on hold
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |      RECID |   Sales ID | Company   | Customer account   | Customer name   | Reason code   |
|------------:|---------------------------------------------:|-----------:|-----------:|:----------|:-------------------|:----------------|:--------------|
|  5637144576 |                                          105 | 5637146853 |        724 | usmf      | US-027             | Birch Company   |               |


Table: Write-off
|   PARTITION |   CustCollectionsBIMeasurements_CustTable_FK |       RECID |   Write off amount | Company   | Customer account   | Transaction date        | Customer name         | Reason code   | Reson comment              |   Main account |
|------------:|---------------------------------------------:|------------:|-------------------:|:----------|:-------------------|:------------------------|:----------------------|:--------------|:---------------------------|---------------:|
|  5637144576 |                                           95 | 68719529063 |   283051           | usmf      | US-010             | 2017-05-18 00:00:00.000 | Sunset Wholesales     | GOODWILL      | Goodwill                   |         618700 |
|  5637144576 |                                           97 | 68719529064 |   690244           | usmf      | US-011             | 2017-05-18 00:00:00.000 | Contoso Retail Dallas | GOODWILL      | Goodwill                   |         618700 |
|  5637144576 |                                           89 | 68719529061 |   347702           | usmf      | US-007             | 2017-05-18 00:00:00.000 | Desert Wholesales     | WRITEOFF      | Write-off customer balance |         618170 |
|  5637144576 |                                           91 | 68719529062 |   551461           | usmf      | US-008             | 2017-05-18 00:00:00.000 | Sparrow Retail        | WRITEOFF      | Write-off customer balance |         618170 |
|  5637144576 |                                           85 | 68719530044 |   447673           | demf      | DE-011             | 2017-05-22 00:00:00.000 | Northwind Traders     | OTHER         | Other                      |         618900 |
|  5637144576 |                                          143 | 68719530048 |   778111           | demf      | DE-013             | 2017-05-22 00:00:00.000 | Trey Wholesales       | OTHER         | Other                      |         618900 |
|  5637144576 |                                           84 | 68719530041 |        1.64871e+06 | demf      | DE-010             | 2017-05-22 00:00:00.000 | A.Datum Corporation   | QUALITY       | Quality                    |         618170 |
|  5637144576 |                                          144 | 68719530052 |        1.11194e+06 | demf      | DE-012             | 2017-05-22 00:00:00.000 | Litware Retail        | QUALITY       | Quality                    |         618170 |
|  5637144576 |                                          134 | 68719530046 |   608619           | demf      | DE-014             | 2017-05-22 00:00:00.000 | World Wide Importers  | QUALITY       | Quality                    |         618170 |

 


tables: name: 30 days sales outstanding
data: 30 days sales outstanding.csv
name: Activities average days to close
data: Activities average days to close.csv
name: Aging
data: Aging.csv
name: Balance due
data: Balance due.csv
name: Case average closed time
data: Case average closed time.csv
name: Collection letter amounts
data: Collection letter amounts.csv
name: Collection status
data: Collection status.csv
name: Customer dimension
data: Customer dimension.csv
name: Customers on credit
data: Customers on credit.csv
name: Customers on hold
data: Customers on hold.csv
name: Customers over credit limit
data: Customers over credit limit.csv
name: Expected payments
data: Expected payments.csv
name: Open activities
data: Open activities.csv
name: Open cases
data: Open cases.csv
name: Open collection letters
data: Open collection letters.csv
name: Open interest notes
data: Open interest notes.csv
name: Sales on hold
data: Sales on hold.csv
name: Write-off
data: Write-off.csv
label: Open activities
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Open collection letters
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Aging
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Case average closed time
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Expected payments
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Open interest notes
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Open cases
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Write-off
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Collection status
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Sales on hold
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Customers on hold
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Activities average days to close
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
30 days sales outstanding
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Customers over credit limit
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Customers on credit
CustCollectionsBIMeasurements_CustTable_FK
Customer dimension
ROW_UNIQUEKEY
Collection letter amounts
Customer name
Customers on credit
Customer name
output: {
    "joins": [
        {
            "from_table": "Open activities",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Open collection letters",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Aging",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Case average closed time",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Expected payments",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Open interest notes",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Open cases",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Write-off",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Collection status",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Sales on hold",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Customers on hold",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Activities average days to close",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "30 days sales outstanding",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Customers over credit limit",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Customers on credit",
            "from_column": "CustCollectionsBIMeasurements_CustTable_FK",
            "to_table": "Customer dimension",
            "to_column": "ROW_UNIQUEKEY"
        },
        {
            "from_table": "Collection letter amounts",
            "from_column": "Customer name",
            "to_table": "Customers on credit",
            "to_column": "Customer name"
        }
    ]
}