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: Account
|   Territory Code Value |   Customer Size Code | Owning Business Unit                 | Owner                                | Originating Lead   |   Annual Revenue | SIC Code   | Market Capitalization   | Parent Account   | Owning User                          | Account Category Code   | Market Capitalization (Base)   | Customer Type Code   |   Address 1: ZIP/Postal Code |   No. of Employees |   Account Rating Code | Address 1: Longitude   |   Annual Revenue (Base) | Created On              | Account Name                  | Address 1: State/Province   | Territory                            |   Account Classification Code |   Business Type Code | Address 1: Country/Region   | Account                              | Address 1: Latitude   | Modified On             |   Industry Code | Category   | Classification   | Account Rating   | Business Type   | Customer Size   | Relationship Type   | Industry          | Territory Code   | Lead Source   | Created Date            |   Days Since Create Date | Modified Date           | Created On Month   |   Created On Month Value | Created On Month Year   |   Created On Month Year Value | Created On Week Number Of Year   | Created On Quarter Of Year   |
|-----------------------:|---------------------:|:-------------------------------------|:-------------------------------------|:-------------------|-----------------:|:-----------|:------------------------|:-----------------|:-------------------------------------|:------------------------|:-------------------------------|:---------------------|-----------------------------:|-------------------:|----------------------:|:-----------------------|------------------------:|:------------------------|:------------------------------|:----------------------------|:-------------------------------------|------------------------------:|---------------------:|:----------------------------|:-------------------------------------|:----------------------|:------------------------|----------------:|:-----------|:-----------------|:-----------------|:----------------|:----------------|:--------------------|:------------------|:-----------------|:--------------|:------------------------|-------------------------:|:------------------------|:-------------------|-------------------------:|:------------------------|------------------------------:|:---------------------------------|:-----------------------------|
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |            60000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        95486 |               4300 |                     1 |                        |                   60000 | 2019-04-23 18:25:24.000 | Adventure Works               | TX                          | 4f21b13b-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | e5a6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:02.000 |               6 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Business Services | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |            10000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        78214 |               6200 |                     1 |                        |                   10000 | 2019-04-23 18:25:24.000 | A. Datum Corporation (sample) | WA                          | 21d85f1c-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | f1a6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:18.000 |               6 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Business Services | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |            20000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        20313 |               6000 |                     1 |                        |                   20000 | 2019-04-23 18:25:24.000 | Litware, Inc. (sample)        | TX                          | 4f21b13b-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | e3a6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:02.000 |              16 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Financial         | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |            10000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        20593 |               2900 |                     1 |                        |                   10000 | 2019-04-23 18:25:24.000 | Blue Yonder Airlines          | KA                          | 4f21b13b-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | e9a6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:03.000 |               7 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Consulting        | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |            90000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        58047 |               4800 |                     1 |                        |                   90000 | 2019-04-23 18:25:24.000 | Alpine Ski House              | TX                          | 21d85f1c-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | efa6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:18.000 |               7 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Consulting        | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |           100000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        90000 |               2900 |                     1 |                        |                  100000 | 2019-04-23 18:25:24.000 | City Power & Light (sample)   | WA                          | 21d85f1c-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | eba6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:17.000 |              30 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Transportation    | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |            60000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        80803 |               1500 |                     1 |                        |                   60000 | 2019-04-23 18:25:24.000 | Contoso Pharmaceuticals       | WA                          | 21d85f1c-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | eda6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:18.000 |              30 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Transportation    | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |            10000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        10032 |               3900 |                     1 |                        |                   10000 | 2019-04-23 18:25:24.000 | Coho Winery                   | CA                          | 21d85f1c-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | f3a6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:18.000 |              30 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Transportation    | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |           100000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        20175 |               9500 |                     1 |                        |                  100000 | 2019-04-23 18:25:23.000 | Fourth Coffee (sample)        | TX                          | 4f21b13b-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | e1a6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:02.000 |              33 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Wholesale         | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |
|                      1 |                    1 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |                    |            80000 |            |                         |                  | 5297c625-2557-4f5f-9f12-615e7a851384 |                         |                                |                      |                        58299 |               2700 |                     1 |                        |                   80000 | 2019-04-23 18:25:24.000 | Fabrikam, Inc.                | TN                          | 4f21b13b-8f5d-ea11-a812-000d3af41119 |                             1 |                    1 | U.S.                        | e7a6480a-f565-e911-a9a9-000d3af4aec4 |                       | 2020-03-03 21:25:03.000 |              33 |            | Default Value    | Default Value    | Default Value   | Default Value   |                     | Wholesale         | Default Value    |               | 2019-04-23 00:00:00.000 |                     1183 | 2020-03-03 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      |


Table: Activity
| Activity                             | Activity Type Code   | Actual Duration   | Actual End              | Actual Start   | Date Created            |   Instance Type Code | Is Regular Activity   | Last Updated            | Owner                                | Owning Business Unit                 | Owning User                          |   Priority Code | Scheduled Duration   | Due Date   | Start Date   | Date Sent   |   State Code |   Status Code | Subject                       | Regarding                            | Recurring Instance Type   | Priority   | Activity Status   |   Days Since Activity Close Date | Status Reason   | Days To Due Date   | Activity End Date       | Activity End Date Month   |   Activity End Date Month Value | Activity End Date Month Year   |   Activity End Date Month Year Value | Activity End Date Week Numer Of Year   | Activity End Date Quarter Of Year   | Created Date            | Modified Date           | Activity Type     |
|:-------------------------------------|:---------------------|:------------------|:------------------------|:---------------|:------------------------|---------------------:|:----------------------|:------------------------|:-------------------------------------|:-------------------------------------|:-------------------------------------|----------------:|:---------------------|:-----------|:-------------|:------------|-------------:|--------------:|:------------------------------|:-------------------------------------|:--------------------------|:-----------|:------------------|---------------------------------:|:----------------|:-------------------|:------------------------|:--------------------------|--------------------------------:|:-------------------------------|-------------------------------------:|:---------------------------------------|:------------------------------------|:------------------------|:------------------------|:------------------|
| fcde1dd8-965d-ea11-a812-000d3af41119 | opportunityclose     |                   | 2019-09-18 00:00:00.000 |                | 2020-03-03 21:35:07.000 |                    0 | False                 | 2020-03-03 21:35:07.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             2 | Mobile devices                | 832a6950-84f5-e911-a812-000d3af42ac9 | Not Recurring             | Normal     | Completed         |                             1036 | Completed       |                    | 2019-09-18 00:00:00.000 | September                 |                               9 | Sep-2019                       |                               201909 | 38-2019                                | Q3-2019                             | 2020-03-03 00:00:00.000 | 2020-03-03 00:00:00.000 | Opportunity Close |
| 00bb25c6-965d-ea11-a812-000d3af41119 | opportunityclose     |                   | 2019-10-07 00:00:00.000 |                | 2020-03-03 21:34:37.000 |                    0 | False                 | 2020-03-03 21:34:37.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             2 | 250 Teams licenses            | 92be1138-ab6a-e911-a9ab-000d3af4aec4 | Not Recurring             | Normal     | Completed         |                             1017 | Completed       |                    | 2019-10-07 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 41-2019                                | Q4-2019                             | 2020-03-03 00:00:00.000 | 2020-03-03 00:00:00.000 | Opportunity Close |
| 83a75088-4b5a-ea11-a813-000d3af4117b | email                |                   | 2019-10-14 00:00:00.000 |                | 2020-02-28 16:58:27.000 |                    0 | True                  | 2020-02-28 16:58:27.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             4 | Fw: Interested in 3D printers |                                      | Not Recurring             | Normal     | Completed         |                             1010 | Scheduled       |                    | 2019-10-14 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 42-2019                                | Q4-2019                             | 2020-02-28 00:00:00.000 | 2020-02-28 00:00:00.000 | Email             |
| 93a75088-4b5a-ea11-a813-000d3af4117b | email                |                   | 2019-10-14 00:00:00.000 |                | 2020-02-28 16:58:29.000 |                    0 | True                  | 2020-02-28 16:58:29.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             4 | Fw: Interested in 3D printers |                                      | Not Recurring             | Normal     | Completed         |                             1010 | Scheduled       |                    | 2019-10-14 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 42-2019                                | Q4-2019                             | 2020-02-28 00:00:00.000 | 2020-02-28 00:00:00.000 | Email             |
| a4a75088-4b5a-ea11-a813-000d3af4117b | email                |                   | 2019-10-21 00:00:00.000 |                | 2020-02-28 16:58:29.000 |                    0 | True                  | 2020-02-28 16:58:29.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             4 | Making dreams a reality ✨    |                                      | Not Recurring             | Normal     | Completed         |                             1003 | Scheduled       |                    | 2019-10-21 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 43-2019                                | Q4-2019                             | 2020-02-28 00:00:00.000 | 2020-02-28 00:00:00.000 | Email             |
| b0a75088-4b5a-ea11-a813-000d3af4117b | email                |                   | 2019-10-21 00:00:00.000 |                | 2020-02-28 16:58:31.000 |                    0 | True                  | 2020-02-28 16:58:31.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             4 | Interested in 3D Printers     | b1dfc135-e2f3-e911-a812-000d3af42ac9 | Not Recurring             | Normal     | Completed         |                             1003 | Scheduled       |                    | 2019-10-21 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 43-2019                                | Q4-2019                             | 2020-02-28 00:00:00.000 | 2020-02-28 00:00:00.000 | Email             |
| c2a75088-4b5a-ea11-a813-000d3af4117b | email                |                   | 2019-10-21 00:00:00.000 |                | 2020-02-28 16:58:32.000 |                    0 | True                  | 2020-02-28 16:58:32.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             3 | Re: 3D Printers               |                                      | Not Recurring             | Normal     | Completed         |                             1003 | Canceled        |                    | 2019-10-21 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 43-2019                                | Q4-2019                             | 2020-02-28 00:00:00.000 | 2020-02-28 00:00:00.000 | Email             |
| d0a75088-4b5a-ea11-a813-000d3af4117b | email                |                   | 2019-10-21 00:00:00.000 |                | 2020-02-28 16:58:32.000 |                    0 | True                  | 2020-02-28 16:58:32.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             4 | 3D Printers                   |                                      | Not Recurring             | Normal     | Completed         |                             1003 | Scheduled       |                    | 2019-10-21 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 43-2019                                | Q4-2019                             | 2020-02-28 00:00:00.000 | 2020-02-28 00:00:00.000 | Email             |
| dea75088-4b5a-ea11-a813-000d3af4117b | email                |                   | 2019-10-21 00:00:00.000 |                | 2020-02-28 16:58:32.000 |                    0 | True                  | 2020-02-28 16:58:32.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             3 | Re: 3D Printers               |                                      | Not Recurring             | Normal     | Completed         |                             1003 | Canceled        |                    | 2019-10-21 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 43-2019                                | Q4-2019                             | 2020-02-28 00:00:00.000 | 2020-02-28 00:00:00.000 | Email             |
| eba75088-4b5a-ea11-a813-000d3af4117b | email                |                   | 2019-10-21 00:00:00.000 |                | 2020-02-28 16:58:32.000 |                    0 | True                  | 2020-02-28 16:58:32.000 | 5297c625-2557-4f5f-9f12-615e7a851384 | fba4ed00-e763-e911-a993-000d3af4ad22 | 5297c625-2557-4f5f-9f12-615e7a851384 |               1 |                      |            |              |             |            1 |             3 | Re: 3D Printers               |                                      | Not Recurring             | Normal     | Completed         |                             1003 | Canceled        |                    | 2019-10-21 00:00:00.000 | October                   |                              10 | Oct-2019                       |                               201910 | 43-2019                                | Q4-2019                             | 2020-02-28 00:00:00.000 | 2020-02-28 00:00:00.000 | Email             |


Table: Business Unit
| State/Province   | Name           | Division   | City   | Business Unit                        | Address 1: Latitude   | Address 1: Longitude   | ZIP/Postal Code   | Country/Region   | Is Disabled   |
|:-----------------|:---------------|:-----------|:-------|:-------------------------------------|:----------------------|:-----------------------|:------------------|:-----------------|:--------------|
|                  | salesbenchmark |            |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                       |                        |                   |                  | False         |


Table: Date
| Date                    |   Day Of Month |   Month Number Of Year |   Year |   Day Number Of Week | Quarter Of Year   | Month Name   | Day Name   | Is Today   | Week Ending             | Week Number Of Year   | Is Last 7 Days   | Is Last 30 Days   | Is Last 90 Days   | Is Last 180 Days   | Is Last 365 Days   | Is Next 90 Days   |   Fiscal Year | Fiscal Quarter Year   |   Fiscal Month Year | Is Current Fiscal Quarter   | Is Current Fiscal Month   | Is Current Week   | Is Current Month   | Is Current Fiscal Year   | Month Year   |   Month Year (Number) |
|:------------------------|---------------:|-----------------------:|-------:|---------------------:|:------------------|:-------------|:-----------|:-----------|:------------------------|:----------------------|:-----------------|:------------------|:------------------|:-------------------|:-------------------|:------------------|--------------:|:----------------------|--------------------:|:----------------------------|:--------------------------|:------------------|:-------------------|:-------------------------|:-------------|----------------------:|
| 2017-07-01 00:00:00.000 |              1 |                      7 |   2017 |                    7 | Q3-2017           | July         | Saturday   | False      | 2017-07-01 00:00:00.000 | 26-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-02 00:00:00.000 |              2 |                      7 |   2017 |                    1 | Q3-2017           | July         | Sunday     | False      | 2017-07-08 00:00:00.000 | 27-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-03 00:00:00.000 |              3 |                      7 |   2017 |                    2 | Q3-2017           | July         | Monday     | False      | 2017-07-08 00:00:00.000 | 27-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-04 00:00:00.000 |              4 |                      7 |   2017 |                    3 | Q3-2017           | July         | Tuesday    | False      | 2017-07-08 00:00:00.000 | 27-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-05 00:00:00.000 |              5 |                      7 |   2017 |                    4 | Q3-2017           | July         | Wednesday  | False      | 2017-07-08 00:00:00.000 | 27-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-06 00:00:00.000 |              6 |                      7 |   2017 |                    5 | Q3-2017           | July         | Thursday   | False      | 2017-07-08 00:00:00.000 | 27-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-07 00:00:00.000 |              7 |                      7 |   2017 |                    6 | Q3-2017           | July         | Friday     | False      | 2017-07-08 00:00:00.000 | 27-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-08 00:00:00.000 |              8 |                      7 |   2017 |                    7 | Q3-2017           | July         | Saturday   | False      | 2017-07-08 00:00:00.000 | 27-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-09 00:00:00.000 |              9 |                      7 |   2017 |                    1 | Q3-2017           | July         | Sunday     | False      | 2017-07-15 00:00:00.000 | 28-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |
| 2017-07-10 00:00:00.000 |             10 |                      7 |   2017 |                    2 | Q3-2017           | July         | Monday     | False      | 2017-07-15 00:00:00.000 | 28-2017               | False            | False             | False             | False              | False              | False             |          2017 | Q3-2017               |              201707 | False                       | False                     | False             | False              | False                    | Jul-2017     |                201707 |


Table: Lead
| Topic                                        | City   | Address 2: Country/Region   | Modified On             | Address 2: City   | Budget Amount (Base)   | Est. Value (deprecated)   | Budeget Status   |   State Code | Est. Close Date   | Lead Source Code   | Sales Stage Value   | Initial Communication Code   | Est. Value (Base)   | Budget Amount   |   Industry Code | Country/Region   | Created On              | Account   | SIC Code   | Need Code   | ZIP/Postal Code   | State/Province   | Purchase Process Code   | Owner                                | No. of Employees   | Company Name   | Name                | Qualifying Opportunity   | Address 2: Longitude   | Address 1: Latitude   | Address 2: Latitude   | Decision Maker?   | Purchase Timeframe Code   | Address 2: ZIP/Postal Code   |   Lead Quality Code |   Priority Code | Created By Id                        | Source Campaign   |   Sales Stage Code Value | Lead                                 |   Status Reason Id | Owning User                          | Annual Revenue   | Merged   | Customer   | Address 2: State/Province   | Evaluate Fit   | Est. Value   | Address 1: Longitude   | Parent Account for lead   | Owning Business Unit                 | Confirm Interest   | Annual Revenue (Base)   | Budget   | Industry   | Initial Communication   | Rating   | Lead Source   | Need   | Priority      | Purchase Process   | Purchase Timeframe   | Sales Stage   | Sales Stage Code   | Status Reason   | Status   | Created Date            | Created On Date         | Modified Date           |   Days Since Created Date | Created On Month   |   Created On Month Value | Created On Month Year   |   Created On Month Year Value | Created On Week Number Of Year   | Created On Quarter Of Year   | Created By     |
|:---------------------------------------------|:-------|:----------------------------|:------------------------|:------------------|:-----------------------|:--------------------------|:-----------------|-------------:|:------------------|:-------------------|:--------------------|:-----------------------------|:--------------------|:----------------|----------------:|:-----------------|:------------------------|:----------|:-----------|:------------|:------------------|:-----------------|:------------------------|:-------------------------------------|:-------------------|:---------------|:--------------------|:-------------------------|:-----------------------|:----------------------|:----------------------|:------------------|:--------------------------|:-----------------------------|--------------------:|----------------:|:-------------------------------------|:------------------|-------------------------:|:-------------------------------------|-------------------:|:-------------------------------------|:-----------------|:---------|:-----------|:----------------------------|:---------------|:-------------|:-----------------------|:--------------------------|:-------------------------------------|:-------------------|:------------------------|:---------|:-----------|:------------------------|:---------|:--------------|:-------|:--------------|:-------------------|:---------------------|:--------------|:-------------------|:----------------|:---------|:------------------------|:------------------------|:------------------------|--------------------------:|:-------------------|-------------------------:|:------------------------|------------------------------:|:---------------------------------|:-----------------------------|:---------------|
| Likes contoso products                       |        |                             | 2020-03-03 21:14:56.000 |                   |                        |                           |                  |            0 |                   |                    |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:26.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Rene Counts         |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 887ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     |               |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| Follow-up regarding our promotions           |        |                             | 2020-03-03 21:14:56.000 |                   |                        |                           |                  |            0 |                   |                    |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:27.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Millicent Vong      |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 8a7ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     |               |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| Store is expanding                           |        |                             | 2020-03-03 21:14:56.000 |                   |                        |                           |                  |            0 |                   | 7                  |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:27.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Jeri Garcia         |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 8c7ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     | Trade Show    |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| Mailed a personal interest card back         |        |                             | 2020-03-03 21:14:56.000 |                   |                        |                           |                  |            0 |                   | 7                  |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:27.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Clement Stubberod   |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 8e7ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     | Trade Show    |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| New store opened this year - need follow up  |        |                             | 2020-03-03 21:14:56.000 |                   |                        |                           |                  |            0 |                   | 7                  |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:27.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Teddy Anderson      |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 907ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     | Trade Show    |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| Interested in online stores                  |        |                             | 2020-03-03 21:14:56.000 |                   |                        |                           |                  |            0 |                   |                    |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:27.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Marylou Campbell    |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 927ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     |               |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| Good prospect for products                   |        |                             | 2020-03-03 21:14:55.000 |                   |                        |                           |                  |            0 |                   |                    |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:28.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Deborah Houston     |                          |                        |                       |                       | True              |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 947ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     |               |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| Interested in our latest offerings           |        |                             | 2020-03-03 21:14:55.000 |                   |                        |                           |                  |            0 |                   |                    |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:28.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Lindsay Komashinsky |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 967ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     |               |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| New store opened this year - needs follow up |        |                             | 2020-03-03 21:14:55.000 |                   |                        |                           |                  |            0 |                   | 4                  |                     |                              |                     |                 |              33 |                  | 2019-04-23 22:05:28.000 |           |            |             |                   |                  |                         | f487f7c5-1166-e911-a993-000d3af4ad22 |                    |                | Jamal McKay         |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                   |                        1 | 9a7ac7dc-1366-e911-a9b4-000d3af45737 |                  1 | f487f7c5-1166-e911-a993-000d3af4ad22 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     | Partner       |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1184 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                          | Q2-2019                      | Elvia Atkinson |
| Good prospect for products                   |        |                             | 2020-03-03 21:14:55.000 |                   |                        |                           |                  |            0 |                   | 9                  |                     |                              |                     |                 |              33 |                  | 2019-04-29 18:36:01.000 |           |            |             |                   |                  |                         | d95ccace-a06a-e911-a9b7-000d3af45737 |                    |                | Deborah Houston     |                          |                        |                       |                       | False             |                           |                              |                   2 |               1 | 5297c625-2557-4f5f-9f12-615e7a851384 |                   |                        1 | d0064196-ad6a-e911-a990-000d3af4affa |                  1 | d95ccace-a06a-e911-a9b7-000d3af45737 |                  | False    |            |                             | False          |              |                        |                           | fba4ed00-e763-e911-a993-000d3af4ad22 | False              |                         |          | Wholesale  |                         | Warm     | Word of Mouth |        | Default Value |                    |                      |               | Default Value      | New             | Open     | 2019-04-29 00:00:00.000 | 2019-04-29 00:00:00.000 | 2020-03-03 00:00:00.000 |                      1178 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      | John Peltier   |


Table: Opportunity
| Identify Customer Contacts   | Actual Revenue   | Final Proposal Ready   | Account                              | Owner                                | Identify Sales Team   | Modified On             | Sales Stage Id   | Actual Close Date       | Present Final Proposal   | Actual Revenue (Base)   |   Total Detail Amount | Develop Proposal   | Pipeline Phase   |   Status Code |   Sales Stage Code | Opportunity Discount Amount   |   Opportunity Rating Code | Budget Amount   | Probability   | Budget Status Id   |   Total Discount Amount |   Est. Revenue (Base) | Created On              | Estimated Close Date    | Need Id   |   Total Discount Amount (Base) |   Total Detail Amount (Base) | Potential Customer                   | Originating Lead   | Purchase Process Id   | Opportunity Discount (%)   | Complete Internal Review   |   Est. Revenue |   Priority Code | Source Campaign   |   Total Amount | Owning Business Unit                 | Opportunity Discount Amount (Base)   | Purchase Timeframe Id   | Budget Amount (Base)   | Revenue   |   Total Amount (Base) |   State Code | Identify Competitors   | Opportunity                          | Owning User                          | Topic                                                                                     | Timeline Id   | Budget   | Need   | Rating   | Priority      | Purchase Process   | Purchase Timeframe   | Sales Stage   | Process Code   | Timeline   | Status   | Status Reason   | Close Date              | Created On Month   |   Created On Month Value | Created On Month Year   |   Created On Month Year Value | Creaed On Week Number Of Year   | Created On Quarter Of Year   | Created Date            | Modified Date           | Days Since Closed Date   |   Days Since Created Date | Account Name            |
|:-----------------------------|:-----------------|:-----------------------|:-------------------------------------|:-------------------------------------|:----------------------|:------------------------|:-----------------|:------------------------|:-------------------------|:------------------------|----------------------:|:-------------------|:-----------------|--------------:|-------------------:|:------------------------------|--------------------------:|:----------------|:--------------|:-------------------|------------------------:|----------------------:|:------------------------|:------------------------|:----------|-------------------------------:|-----------------------------:|:-------------------------------------|:-------------------|:----------------------|:---------------------------|:---------------------------|---------------:|----------------:|:------------------|---------------:|:-------------------------------------|:-------------------------------------|:------------------------|:-----------------------|:----------|----------------------:|-------------:|:-----------------------|:-------------------------------------|:-------------------------------------|:------------------------------------------------------------------------------------------|:--------------|:---------|:-------|:---------|:--------------|:-------------------|:---------------------|:--------------|:---------------|:-----------|:---------|:----------------|:------------------------|:-------------------|-------------------------:|:------------------------|------------------------------:|:--------------------------------|:-----------------------------|:------------------------|:------------------------|:-------------------------|--------------------------:|:------------------------|
| False                        |                  | False                  | f3a6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-04-23 22:35:02.000 |                  |                         | False                    |                         |                     0 | False              | 1-Qualify        |             1 |                  1 |                               |                         1 |                 | 80            |                    |                       0 |                 25000 | 2019-04-23 00:00:00.000 | 2019-10-25 00:00:00.000 |           |                              0 |                            0 | f3a6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          25000 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            0 | False                  | 98b3dd01-1866-e911-a9b4-000d3af45737 | f487f7c5-1166-e911-a993-000d3af4ad22 | New order for our online products                                                         |               |          |        | Hot      | Default Value |                    |                      |               | Default Value  |            | Open     | In Progress     | 2019-10-25 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 |                          |                      1184 | Coho Winery             |
| False                        |                  | False                  | e9a6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-04-29 18:38:42.000 |                  |                         | False                    |                         |                     0 | False              | 1-Qualify        |             1 |                  1 |                               |                         1 |                 |               |                    |                       0 |                 25000 | 2019-04-23 00:00:00.000 | 2019-07-22 00:00:00.000 |           |                              0 |                            0 | e9a6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          25000 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            0 | False                  | 9ab3dd01-1866-e911-a9b4-000d3af45737 | f487f7c5-1166-e911-a993-000d3af4ad22 | Needs to restock their supply of Product SKU AX305; will purchase at least 25-50          |               |          |        | Hot      | Default Value |                    |                      |               | Default Value  |            | Open     | In Progress     | 2019-07-22 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-23 00:00:00.000 | 2019-04-29 00:00:00.000 |                          |                      1184 | Blue Yonder Airlines    |
| False                        | 30000            | False                  | efa6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-04-23 22:35:13.000 | 3                | 2019-04-23 00:00:00.000 | False                    | 30000                   |                     0 | False              | 1-Qualify        |             3 |                  1 |                               |                         1 |                 |               |                    |                       0 |                 30000 | 2019-04-23 00:00:00.000 | 2019-08-24 00:00:00.000 |           |                              0 |                            0 | efa6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          30000 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            1 | False                  | 9cb3dd01-1866-e911-a9b4-000d3af45737 | f487f7c5-1166-e911-a993-000d3af4ad22 | Very likely will order 18 Product SKU JJ202 this year (sample)                            |               |          |        | Hot      | Default Value |                    |                      | Close         | Default Value  |            | Won      | Won             | 2019-04-23 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 1184                     |                      1184 | Alpine Ski House        |
| False                        |                  | False                  | e7a6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-05-01 17:12:47.000 |                  |                         | False                    |                         |                     0 | False              | 1-Qualify        |             1 |                  1 |                               |                         1 |                 | 90            |                    |                       0 |                 10000 | 2019-04-23 00:00:00.000 | 2019-05-24 00:00:00.000 |           |                              0 |                            0 | e7a6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          10000 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            0 | False                  | 49ea057d-1266-e911-a993-000d3af4ad22 | f487f7c5-1166-e911-a993-000d3af4ad22 | 6 orders of Product SKU JJ202                                                             |               |          |        | Hot      | Default Value |                    |                      |               | Default Value  |            | Open     | In Progress     | 2019-05-24 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-23 00:00:00.000 | 2019-05-01 00:00:00.000 |                          |                      1184 | Fabrikam, Inc.          |
| False                        | 25000            | False                  | e9a6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-04-23 22:35:20.000 | 3                | 2019-04-23 00:00:00.000 | False                    | 25000                   |                     0 | False              | 3-Propose        |             3 |                  1 |                               |                         1 |                 |               |                    |                       0 |                 25000 | 2019-04-23 00:00:00.000 | 2019-07-22 00:00:00.000 |           |                              0 |                            0 | e9a6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          25000 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            1 | False                  | 4bea057d-1266-e911-a993-000d3af4ad22 | f487f7c5-1166-e911-a993-000d3af4ad22 | Needs to restock their supply of Product SKU AX305; will purchase at least 25-50 (sample) |               |          |        | Hot      | Default Value |                    |                      | Close         | Default Value  |            | Won      | Won             | 2019-04-23 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 1184                     |                      1184 | Blue Yonder Airlines    |
| False                        | 0                | False                  | efa6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-05-01 17:10:46.000 | 3                | 2019-05-01 00:00:00.000 | False                    | 0                       |                     0 | False              | 2-Develop        |             5 |                  1 |                               |                         1 |                 |               |                    |                       0 |                     0 | 2019-04-23 00:00:00.000 | 2019-08-24 00:00:00.000 |           |                              0 |                            0 | efa6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |              0 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | True      |                     0 |            2 | False                  | 4dea057d-1266-e911-a993-000d3af4ad22 | f487f7c5-1166-e911-a993-000d3af4ad22 | Very likely will order 18 Product SKU JJ202 this year                                     |               |          |        | Hot      | Default Value |                    |                      | Close         | Default Value  |            | Lost     | Out-Sold        | 2019-05-01 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-23 00:00:00.000 | 2019-05-01 00:00:00.000 | 1176                     |                      1184 | Alpine Ski House        |
| False                        | 26000            | False                  | eda6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-04-23 22:35:26.000 | 3                | 2019-04-23 00:00:00.000 | False                    | 26000                   |                     0 | False              | 2-Develop        |             3 |                  1 |                               |                         1 |                 | 95            |                    |                       0 |                 26000 | 2019-04-23 00:00:00.000 | 2019-09-27 00:00:00.000 |           |                              0 |                            0 | eda6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          26000 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            1 | False                  | 4fea057d-1266-e911-a993-000d3af4ad22 | f487f7c5-1166-e911-a993-000d3af4ad22 | They sell many of the same items that we do - need to follow up (sample)                  |               |          |        | Hot      | Default Value |                    |                      | Close         | Default Value  |            | Won      | Won             | 2019-04-23 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-23 00:00:00.000 | 2019-04-23 00:00:00.000 | 1184                     |                      1184 | Contoso Pharmaceuticals |
| False                        |                  | False                  | f3a6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-04-25 17:08:08.000 |                  |                         | False                    |                         |                     0 | False              | 1-Qualify        |             1 |                  1 |                               |                         1 |                 | 80            |                    |                       0 |                 25000 | 2019-04-23 00:00:00.000 | 2019-10-25 00:00:00.000 |           |                              0 |                            0 | f3a6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          25000 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            0 | False                  | 51ea057d-1266-e911-a993-000d3af4ad22 | f487f7c5-1166-e911-a993-000d3af4ad22 | Will be ordering about 110 items of all types                                             |               |          |        | Hot      | Default Value |                    |                      |               | Default Value  |            | Open     | In Progress     | 2019-10-25 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-23 00:00:00.000 | 2019-04-25 00:00:00.000 |                          |                      1184 | Coho Winery             |
| False                        |                  | False                  | efa6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-04-25 17:27:08.000 |                  |                         | False                    |                         |                     0 | False              | 1-Qualify        |             1 |                  1 |                               |                         1 |                 |               |                    |                       0 |                 33897 | 2019-04-25 00:00:00.000 | 2019-08-24 00:00:00.000 |           |                              0 |                            0 | efa6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          33897 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            0 | False                  | bc4ac751-7f67-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | 100 laptops                                                                               |               |          |        | Hot      | Default Value |                    |                      |               | Default Value  |            | Open     | In Progress     | 2019-08-24 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-25 00:00:00.000 | 2019-04-25 00:00:00.000 |                          |                      1182 | Alpine Ski House        |
| False                        |                  | False                  | eda6480a-f565-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | False                 | 2019-04-25 17:27:10.000 |                  |                         | False                    |                         |                     0 | False              | 1-Qualify        |             1 |                  1 |                               |                         1 |                 | 95            |                    |                       0 |                 26000 | 2019-04-25 00:00:00.000 | 2019-09-27 00:00:00.000 |           |                              0 |                            0 | eda6480a-f565-e911-a9a9-000d3af4aec4 |                    |                       |                            | False                      |          26000 |               1 |                   |              0 | fba4ed00-e763-e911-a993-000d3af4ad22 |                                      |                         |                        | False     |                     0 |            0 | False                  | be4ac751-7f67-e911-a9a9-000d3af4aec4 | f487f7c5-1166-e911-a993-000d3af4ad22 | 125 service licenses                                                                      |               |          |        | Hot      | Default Value |                    |                      |               | Default Value  |            | Open     | In Progress     | 2019-09-27 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 17-2019                         | Q2-2019                      | 2019-04-25 00:00:00.000 | 2019-04-25 00:00:00.000 |                          |                      1182 | Contoso Pharmaceuticals |


Table: OpportunityProduct
|   Amount |   Amount (Base) | Created On              |   Extended Amount |   Extended Amount (Base) | Manual Discount Amount   | Manual Discount Amount (Base)   | Modified On             | Opportunity                          |   Price Per Unit |   Price Per Unit (Base) | Write-In Product   | Existing Product                     |   Product Type Code |   Quantity |   Volume Discount |   Volume Discount (Base) | Product type    | Created Date            | Modified Date           | Created On Month   |   Created On Month Value | Created On Month Year   |   Created On Month Year Value | Created On Week Number Of Year   | Created On Quarter Of Year   |
|---------:|----------------:|:------------------------|------------------:|-------------------------:|:-------------------------|:--------------------------------|:------------------------|:-------------------------------------|-----------------:|------------------------:|:-------------------|:-------------------------------------|--------------------:|-----------:|------------------:|-------------------------:|:----------------|:------------------------|:------------------------|:-------------------|-------------------------:|:------------------------|------------------------------:|:---------------------------------|:-----------------------------|
|      133 |             133 | 2019-05-01 05:30:09.000 |               133 |                      133 |                          |                                 | 2019-05-01 05:30:10.000 | 9cbd1138-ab6a-e911-a9ab-000d3af4aec4 |              133 |                     133 |                    | b15c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      115 |             115 | 2019-05-01 05:30:33.000 |               115 |                      115 |                          |                                 | 2019-05-01 05:30:34.000 | 9cbd1138-ab6a-e911-a9ab-000d3af4aec4 |              115 |                     115 |                    | bb5c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      133 |             133 | 2019-05-01 05:41:40.000 |               133 |                      133 |                          |                                 | 2019-05-01 05:41:41.000 | bcbe1138-ab6a-e911-a9ab-000d3af4aec4 |              133 |                     133 |                    | b15c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      115 |             115 | 2019-05-01 05:42:01.000 |               115 |                      115 |                          |                                 | 2019-05-01 05:42:01.000 | bcbe1138-ab6a-e911-a9ab-000d3af4aec4 |              115 |                     115 |                    | bb5c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      133 |             133 | 2019-05-01 02:09:12.000 |               133 |                      133 |                          |                                 | 2019-05-01 02:09:13.000 | 04bf1138-ab6a-e911-a9ab-000d3af4aec4 |              133 |                     133 |                    | b15c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      115 |             115 | 2019-05-01 02:09:30.000 |               115 |                      115 |                          |                                 | 2019-05-01 02:09:30.000 | 04bf1138-ab6a-e911-a9ab-000d3af4aec4 |              115 |                     115 |                    | bb5c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      133 |             133 | 2019-05-01 05:09:19.000 |               133 |                      133 |                          |                                 | 2019-05-01 05:09:20.000 | 2cbe1138-ab6a-e911-a9ab-000d3af4aec4 |              133 |                     133 |                    | b15c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      115 |             115 | 2019-05-01 05:09:54.000 |               115 |                      115 |                          |                                 | 2019-05-01 05:09:55.000 | 2cbe1138-ab6a-e911-a9ab-000d3af4aec4 |              115 |                     115 |                    | bb5c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      133 |             133 | 2019-05-01 05:34:51.000 |               133 |                      133 |                          |                                 | 2019-05-01 05:34:52.000 | eb693486-916b-e911-a9b7-000d3af45737 |              133 |                     133 |                    | b15c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |
|      115 |             115 | 2019-05-01 05:35:19.000 |               115 |                      115 |                          |                                 | 2019-05-01 05:35:19.000 | eb693486-916b-e911-a9b7-000d3af45737 |              115 |                     115 |                    | bb5c5010-f565-e911-a9a9-000d3af4aec4 |                   1 |          1 |                 0 |                        0 | Sales Inventory | 2019-04-30 00:00:00.000 | 2019-04-30 00:00:00.000 | April              |                        4 | Apr-2019                |                        201904 | 18-2019                          | Q2-2019                      |


Table: Product
| Name                                               | Parent                               | List Price   | List Price (Base)   | Product                              | Product Id                                         |   Product Structure Code |   Product Type Code |   Status | Product Structure   | Product Type    |
|:---------------------------------------------------|:-------------------------------------|:-------------|:--------------------|:-------------------------------------|:---------------------------------------------------|-------------------------:|--------------------:|---------:|:--------------------|:----------------|
| Cups                                               |                                      |              |                     | afcb325a-2f1c-ea11-a810-000d3af42ac9 | 34324                                              |                        1 |                   1 |        0 | Product             | Sales Inventory |
| Office 365 Suite (sample)                          |                                      |              |                     | 9b5c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 Suite (sample)                          |                        2 |                   1 |        0 | Product Family      | Sales Inventory |
| Office 365 for Small Business (sample)             | 9b5c5010-f565-e911-a9a9-000d3af4aec4 |              |                     | 9d5c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 for Small Business (sample)             |                        3 |                   1 |        0 | Product Bundle      | Sales Inventory |
| Office 365 for Small Business Premium (sample)     | 9b5c5010-f565-e911-a9a9-000d3af4aec4 |              |                     | 9f5c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 for Small Business Premium (sample)     |                        3 |                   1 |        0 | Product Bundle      | Sales Inventory |
| Office 365 for Midsize Business (sample)           | 9b5c5010-f565-e911-a9a9-000d3af4aec4 |              |                     | a15c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 for Midsize Business (sample)           |                        3 |                   1 |        0 | Product Bundle      | Sales Inventory |
| Office 365 for Enterprise (sample)                 | 9b5c5010-f565-e911-a9a9-000d3af4aec4 |              |                     | a35c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 for Enterprise (sample)                 |                        3 |                   1 |        0 | Product Bundle      | Sales Inventory |
| Office 365 and CRM Online: Small Business (sample) |                                      |              |                     | a55c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 and CRM Online: Small Business (sample) |                        3 |                   1 |        0 | Product Bundle      | Sales Inventory |
| Office 365 and CRM Online: Midsize (sample)        |                                      |              |                     | a75c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 and CRM Online: Midsize (sample)        |                        3 |                   1 |        0 | Product Bundle      | Sales Inventory |
| Office 365 and CRM Online: Enterprise (sample)     |                                      |              |                     | a95c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 and CRM Online: Enterprise (sample)     |                        3 |                   1 |        0 | Product Bundle      | Sales Inventory |
| Office 365 Service (sample)                        |                                      |              |                     | ab5c5010-f565-e911-a9a9-000d3af4aec4 | Office 365 Service (sample)                        |                        2 |                   1 |        0 | Product Family      | Sales Inventory |


Table: Territory
| Territory                            | Name       |
|:-------------------------------------|:-----------|
| db0c2804-8f5d-ea11-a812-000d3af41119 | East Coast |
| 21d85f1c-8f5d-ea11-a812-000d3af41119 | West Coast |
| 4f21b13b-8f5d-ea11-a812-000d3af41119 | Mid-West   |
| aab3cf58-8f5d-ea11-a812-000d3af41119 | EMEA       |
| 361d0809-905d-ea11-a812-000d3af41119 | APAC       |


Table: User
| Address 1: Latitude   | Employee   | Territory                            | City   | Business Unit                        | Address 1: Longitude   | User Id                              | Country/Region   | Manager   | Full Name          | Modified On             | Created On              | State/Province   | Is Disabled   |   Access Mode |
|:----------------------|:-----------|:-------------------------------------|:-------|:-------------------------------------|:-----------------------|:-------------------------------------|:-----------------|:----------|:-------------------|:------------------------|:------------------------|:-----------------|:--------------|--------------:|
|                       |            | 361d0809-905d-ea11-a812-000d3af41119 |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | b5712009-a5f1-e911-a819-000d3af4117b |                  |           | Nancy Anderson     | 2020-03-03 20:46:46.000 | 2019-10-18 12:44:39.000 |                  | False         |             0 |
|                       |            | 361d0809-905d-ea11-a812-000d3af41119 |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | f07fcc32-a16a-e911-a9ac-000d3af451d6 |                  |           | Rosetta Howell     | 2020-03-03 20:46:38.000 | 2019-04-29 17:07:02.000 |                  | False         |             0 |
|                       |            | 4f21b13b-8f5d-ea11-a812-000d3af41119 |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | a00e8063-a06a-e911-a9b7-000d3af45737 |                  |           | Lee Wallin         | 2020-03-03 20:41:14.000 | 2019-04-29 17:01:15.000 |                  | False         |             0 |
|                       |            | 4f21b13b-8f5d-ea11-a812-000d3af41119 |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | ec044387-a06a-e911-a9b7-000d3af45737 |                  |           | Glenda McDaniel    | 2020-03-03 20:40:57.000 | 2019-04-29 17:02:12.000 |                  | False         |             0 |
|                       |            | 361d0809-905d-ea11-a812-000d3af41119 |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | 3a3206ab-a06a-e911-a9b7-000d3af45737 |                  |           | Morris Barden      | 2020-03-03 20:46:53.000 | 2019-04-29 17:03:12.000 |                  | False         |             0 |
|                       |            | db0c2804-8f5d-ea11-a812-000d3af41119 |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | d95ccace-a06a-e911-a9b7-000d3af45737 |                  |           | Christine Lynn     | 2020-03-03 20:39:33.000 | 2019-04-29 17:04:12.000 |                  | False         |             0 |
|                       |            |                                      |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | acd43128-a16a-e911-a9b7-000d3af45737 |                  |           | Isabelle Rasmussen | 2019-05-28 15:50:32.000 | 2019-04-29 17:06:43.000 |                  | False         |             0 |
|                       |            |                                      |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | c5678e0a-906b-e911-a9b7-000d3af45737 |                  |           | Dionne Parsons     | 2019-05-28 15:50:34.000 | 2019-04-30 21:36:44.000 |                  | False         |             0 |
|                       |            | 21d85f1c-8f5d-ea11-a812-000d3af41119 |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | a02f3ef3-a06a-e911-a992-000d3af45a1b |                  |           | Josefa Vargas      | 2020-03-03 20:40:19.000 | 2019-04-29 17:05:22.000 |                  | False         |             0 |
|                       |            | db0c2804-8f5d-ea11-a812-000d3af41119 |        | fba4ed00-e763-e911-a993-000d3af4ad22 |                        | f487f7c5-1166-e911-a993-000d3af4ad22 |                  |           | Elvia Atkinson     | 2020-03-03 20:39:28.000 | 2019-04-23 21:50:23.000 |                  | False         |             0 |

 


tables: name: Account
data: Account.csv
name: Activity
data: Activity.csv
name: Business Unit
data: Business Unit.csv
name: Date
data: Date.csv
name: Lead
data: Lead.csv
name: Opportunity
data: Opportunity.csv
name: OpportunityProduct
data: OpportunityProduct.csv
name: Product
data: Product.csv
name: Territory
data: Territory.csv
name: User
data: User.csv
label: Account
Territory
Territory
Territory
OpportunityProduct
Existing Product
Product
Product
OpportunityProduct
Opportunity
Opportunity
Opportunity
User
Business Unit
Business Unit
Business Unit
Activity
Owning User
User
User Id
Activity
Activity End Date
Date
Date
Opportunity
Owning User
User
User Id
Opportunity
Account
Account
Account
Opportunity
Originating Lead
Lead
Lead
Opportunity
Close Date
Date
Date
output: {
    "joins": [
        {
            "from_table": "Account",
            "from_column": "Territory",
            "to_table": "Territory",
            "to_column": "Territory"
        },
        {
            "from_table": "OpportunityProduct",
            "from_column": "Existing Product",
            "to_table": "Product",
            "to_column": "Product"
        },
        {
            "from_table": "OpportunityProduct",
            "from_column": "Opportunity",
            "to_table": "Opportunity",
            "to_column": "Opportunity"
        },
        {
            "from_table": "User",
            "from_column": "Business Unit",
            "to_table": "Business Unit",
            "to_column": "Business Unit"
        },
        {
            "from_table": "Activity",
            "from_column": "Owning User",
            "to_table": "User",
            "to_column": "User Id"
        },
        {
            "from_table": "Activity",
            "from_column": "Activity End Date",
            "to_table": "Date",
            "to_column": "Date"
        },
        {
            "from_table": "Opportunity",
            "from_column": "Owning User",
            "to_table": "User",
            "to_column": "User Id"
        },
        {
            "from_table": "Opportunity",
            "from_column": "Account",
            "to_table": "Account",
            "to_column": "Account"
        },
        {
            "from_table": "Opportunity",
            "from_column": "Originating Lead",
            "to_table": "Lead",
            "to_column": "Lead"
        },
        {
            "from_table": "Opportunity",
            "from_column": "Close Date",
            "to_table": "Date",
            "to_column": "Date"
        }
    ]
}