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: Date Table
| Date                    |   Year |   Quarter Number |   Month Number |   Day of Month |   Date Integer | Month Name   | Month & Year   | Quarter & Year   |   Day of Week Number | Day of Week Name   |   Week Number | FY   | Quarter   |
|:------------------------|-------:|-----------------:|---------------:|---------------:|---------------:|:-------------|:---------------|:-----------------|---------------------:|:-------------------|--------------:|:-----|:----------|
| 2018-07-01 00:00:00.000 |   2018 |                3 |              7 |              1 |       20180701 | July         | Jul 2018       | Q3 2018          |                    0 | Sunday             |            27 | FY19 | Q3        |
| 2018-07-02 00:00:00.000 |   2018 |                3 |              7 |              2 |       20180702 | July         | Jul 2018       | Q3 2018          |                    1 | Monday             |            27 | FY19 | Q3        |
| 2018-07-03 00:00:00.000 |   2018 |                3 |              7 |              3 |       20180703 | July         | Jul 2018       | Q3 2018          |                    2 | Tuesday            |            27 | FY19 | Q3        |
| 2018-07-04 00:00:00.000 |   2018 |                3 |              7 |              4 |       20180704 | July         | Jul 2018       | Q3 2018          |                    3 | Wednesday          |            27 | FY19 | Q3        |
| 2018-07-05 00:00:00.000 |   2018 |                3 |              7 |              5 |       20180705 | July         | Jul 2018       | Q3 2018          |                    4 | Thursday           |            27 | FY19 | Q3        |
| 2018-07-06 00:00:00.000 |   2018 |                3 |              7 |              6 |       20180706 | July         | Jul 2018       | Q3 2018          |                    5 | Friday             |            27 | FY19 | Q3        |
| 2018-07-07 00:00:00.000 |   2018 |                3 |              7 |              7 |       20180707 | July         | Jul 2018       | Q3 2018          |                    6 | Saturday           |            27 | FY19 | Q3        |
| 2018-07-08 00:00:00.000 |   2018 |                3 |              7 |              8 |       20180708 | July         | Jul 2018       | Q3 2018          |                    0 | Sunday             |            28 | FY19 | Q3        |
| 2018-07-09 00:00:00.000 |   2018 |                3 |              7 |              9 |       20180709 | July         | Jul 2018       | Q3 2018          |                    1 | Monday             |            28 | FY19 | Q3        |
| 2018-07-10 00:00:00.000 |   2018 |                3 |              7 |             10 |       20180710 | July         | Jul 2018       | Q3 2018          |                    2 | Tuesday            |            28 | FY19 | Q3        |


Table: Item Master
|   Item Master ID |   Item Number | Description                    | UOM   | Inventory Type   |   Shelf Life | Price   | Inspection Code   | Serial Control   | Lot Control   |   Warehouse ID | Cycle Count Class   | Last Count Date         | Class ID   | Pick Location   | Verification Flag   |           UPC |   Unit Weight |   Tare Weight | Haz Material   | Inventory Category   | Inventory Class   |   Unit Volume |   Nested Volume | Pick Put ID   | Length   | Width   | Height   | Audit Required   | Expiration Date Control   |   Display Item Number |   Client Code |   Slack Time |   Slack Days |   Slack Additional % | Cross Dock   | Purchased UOM   |   Purchased UOM Conversion Factor | PO Divisor   |   PO Divisor Conversion Factor | Buying Multiple   |   Buying Multiple Conversion Factor | Max Pack Qty   | Wh-Item ID   |
|-----------------:|--------------:|:-------------------------------|:------|:-----------------|-------------:|:--------|:------------------|:-----------------|:--------------|---------------:|:--------------------|:------------------------|:-----------|:----------------|:--------------------|--------------:|--------------:|--------------:|:---------------|:---------------------|:------------------|--------------:|----------------:|:--------------|:---------|:--------|:---------|:-----------------|:--------------------------|----------------------:|--------------:|-------------:|-------------:|---------------------:|:-------------|:----------------|----------------------------------:|:-------------|-------------------------------:|:------------------|------------------------------------:|:---------------|:-------------|
|             2308 |         10079 | PRINTER DRUM FOR BROTHER 8460  | EACH  | FG               |            0 |         | N                 | N                | N             |           1133 |                     | 2018-06-06 11:15:21.250 | HIGH VALUE |                 | N                   |  801509147100 |             0 |             0 | 0              | SUPPLY               | CP                |             0 |               0 | Default       |          |         |          | N                | N                         |                 10079 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 |                | 1133-10079   |
|             2309 |         10080 | PRINTER DRUM FOR BROTHER 8480  | EACH  | FG               |            0 |         | N                 | N                | N             |           1133 |                     | 2018-06-06 11:15:21.250 | HIGH VALUE |                 | N                   |  801509158458 |             0 |             0 | 0              | SUPPLY               | CP                |             0 |               0 | Default       |          |         |          | N                | N                         |                 10080 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 |                | 1133-10080   |
|             2310 |         10081 | PRINTER DRUM FOR BROTHER 8510  | EACH  | FG               |            0 |         | N                 | N                | N             |           1133 |                     | 2018-06-06 11:15:21.250 | HIGH VALUE |                 | N                   |  801509218398 |             0 |             0 | 0              | SUPPLY               | CP                |             0 |               0 | Default       |          |         |          | N                | N                         |                 10081 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 |                | 1133-10081   |
|             2311 |         10082 | TONER CART FOR BROTHER 5700DN  | EACH  | FG               |            0 |         | N                 | N                | N             |           1133 |                     | 2018-06-06 11:15:21.250 | HIGH VALUE |                 | N                   |  012502642497 |             0 |             0 | 0              | SUPPLY               | CP                |             0 |               0 | Default       |          |         |          | N                | N                         |                 10082 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 |                | 1133-10082   |
|             2312 |         10083 | TONER CART FOR BROTHER 8460DN  | EACH  | FG               |            0 |         | N                 | N                | N             |           1133 |                     | 2018-06-06 11:15:21.250 | HIGH VALUE |                 | N                   |  801509160321 |             0 |             0 | 0              | SUPPLY               | CP                |             0 |               0 | Default       |          |         |          | N                | N                         |                 10083 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 |                | 1133-10083   |
|             2313 |         10084 | TONER CART FOR BROTHER 8480DN  | EACH  | FG               |            0 |         | N                 | N                | N             |           1133 |                     | 2018-06-06 11:15:21.250 | HIGH VALUE |                 | N                   | 2116570034685 |             0 |             0 | 0              | SUPPLY               | CP                |             0 |               0 | Default       |          |         |          | N                | N                         |                 10084 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 |                | 1133-10084   |
|             2314 |         10085 | TONER CART FOR BROTHER 8510DN  | EACH  | FG               |            0 |         | N                 | N                | N             |           1133 |                     | 2018-06-06 11:15:21.250 | HIGH VALUE |                 | N                   |  801509218275 |             0 |             0 | 0              | SUPPLY               | CP                |             0 |               0 | Default       |          |         |          | N                | N                         |                 10085 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 |                | 1133-10085   |
|             2315 |         10086 | TONER DRUM FOR BROTHER 5700    | EACH  | FG               |            0 |         | N                 | N                | N             |           1133 |                     | 2018-06-06 11:15:21.250 | HIGH VALUE |                 | N                   |  012502642527 |             0 |             0 | 0              | SUPPLY               | CP                |             0 |               0 | Default       |          |         |          | N                | N                         |                 10086 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 |                | 1133-10086   |
|             2316 |         10087 | FLOWERS ROLLER GRILL WHITE BUN | EACH  | FG               |            0 | 0       | N                 | N                | F             |           1133 |                     | 2018-06-06 11:15:21.250 | AMBIENT    |                 | N                   |  070210006444 |             0 |             0 |                | BRDTRY               | PTS               |             0 |               0 | Default       | 0        | 0       | 0        | N                | Y                         |                 10087 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 | 108            | 1133-10087   |
|             2317 |         10088 | FLOWERS ROLLER GRILL WHEAT BUN | EACH  | FG               |            0 | 0       | N                 | N                | F             |           1133 |                     | 2018-06-06 11:15:21.250 | AMBIENT    |                 | N                   |   72250024594 |             0 |             0 |                | BRDTRY               | PTS               |             0 |               0 | Default       | 0        | 0       | 0        | N                | Y                         |                 10088 |          1133 |            0 |            0 |                    0 | N            | EACH            |                                 1 | EACH         |                              1 | EACH              |                                   1 | 108            | 1133-10088   |


Table: Key Measures
| Column   |
|----------|


Table: PO Detail
| PO-Item ID     |   Warehouse ID |   PO Number |   Line Number |   Schedule Number |   Item Number |   Qty Ordered | Order UOM   | Vendor Item Number   | Delivery Date & Time    | Location ID   | Earliest Ship Date      | Latest Ship Date        | Earliest Delivery Date   | Latest Delivery Date    | Delivery Date           | Delivery Time           | Wh-Item ID   |
|:---------------|---------------:|------------:|--------------:|------------------:|--------------:|--------------:|:------------|:---------------------|:------------------------|:--------------|:------------------------|:------------------------|:-------------------------|:------------------------|:------------------------|:------------------------|:-------------|
| 00002795-10065 |           1145 |        2795 |             5 |                 5 |         10065 |           216 | EACH        | 25083                | 2019-02-08 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-08 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10065   |
| 00002825-10065 |           1145 |        2825 |             5 |                 5 |         10065 |           117 | EACH        | 25083                | 2019-02-11 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-11 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10065   |
| 00002851-10065 |           1145 |        2851 |             5 |                 5 |         10065 |           135 | EACH        | 25083                | 2019-02-13 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-13 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10065   |
| 00002891-10296 |           1145 |        2891 |             5 |                 5 |         10296 |           260 | EACH        | 25101                | 2019-02-15 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-15 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10296   |
| 00002920-10118 |           1145 |        2920 |             5 |                 5 |         10118 |           150 | EACH        | 332RTMCO27310        | 2019-02-16 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-16 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10118   |
| 00002929-10065 |           1145 |        2929 |             5 |                 5 |         10065 |           126 | EACH        | 25083                | 2019-02-18 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-18 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10065   |
| 00002945-10118 |           1145 |        2945 |             5 |                 5 |         10118 |           248 | EACH        | 332RTMCO27310        | 2019-02-18 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-18 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10118   |
| 00002955-10065 |           1145 |        2955 |             5 |                 5 |         10065 |            81 | EACH        | 25083                | 2019-02-20 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-20 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10065   |
| 00002964-10118 |           1145 |        2964 |             5 |                 5 |         10118 |           222 | EACH        | 332RTMCO27310        | 2019-02-20 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-20 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10118   |
| 00002994-10065 |           1145 |        2994 |             5 |                 5 |         10065 |           162 | EACH        | 25083                | 2019-02-22 00:00:00.000 |               | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000 | 1900-01-01 00:00:00.000  | 1900-01-01 00:00:00.000 | 2019-02-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1145-10065   |


Table: PO Master
|   PO Number |   Type ID |   Vendor Code | Create Date             |   Warehouse ID | Status   |   Display PO Number |   Client Code | Ship From Name   | Ship From Address   | Ship From Address 2   | Ship From City   | Ship From Date   |   Ship From Postal Code | Ship From Country   |   Ship From Phone | Ship From Fax   |   PO ID |
|------------:|----------:|--------------:|:------------------------|---------------:|:---------|--------------------:|--------------:|:-----------------|:--------------------|:----------------------|:-----------------|:-----------------|------------------------:|:--------------------|------------------:|:----------------|--------:|
|    00002392 |        65 |        348312 | 2019-01-08 14:19:25.360 |           1100 | C        |            00002392 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6086 |
|    00002412 |        65 |        348312 | 2019-01-09 14:49:40.320 |           1100 | C        |            00002412 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6105 |
|    00002433 |        65 |        348312 | 2019-01-10 14:04:49.676 |           1100 | C        |            00002433 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6121 |
|    00002446 |        65 |        348312 | 2019-01-11 14:19:59.510 |           1100 | C        |            00002446 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6134 |
|    00002453 |        65 |        348312 | 2019-01-12 14:05:10.640 |           1100 | C        |            00002453 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6142 |
|    00002459 |        65 |        348312 | 2019-01-13 14:20:20.103 |           1100 | C        |            00002459 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6146 |
|    00002472 |        65 |        348312 | 2019-01-14 14:35:28.200 |           1100 | C        |            00002472 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6158 |
|    00002500 |        65 |        348312 | 2019-01-15 14:05:40.653 |           1100 | C        |            00002500 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6184 |
|    00002514 |        65 |        348312 | 2019-01-16 14:20:54.330 |           1100 | C        |            00002514 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6198 |
|    00002540 |        65 |        348312 | 2019-01-17 14:21:03.796 |           1100 | C        |            00002540 |          1100 | FRESHONE DD      | 400 N ST PAUL       | SUITE 1216            | DALLAS           | TX               |                   75201 |                     |        6828319756 |                 |    6216 |


Table: PO Receipt
|   Receipt Identity |   Receipt ID |   Vendor Code |   PO Number | Receipt Date & Time     | SCAC Code   | Status   |   Item Number | Lot Number   |   Line Number |   Schedule Number |   Qty Received |   Qty Damaged | HU ID   | Fork ID   | Tran Status   | Receipt UOM   |   Warehouse ID | Hold Reason ID   | PO-Item ID     | Receipt Date            | Receipt Time            | Wh-Item ID   |
|-------------------:|-------------:|--------------:|------------:|:------------------------|:------------|:---------|--------------:|:-------------|--------------:|------------------:|---------------:|--------------:|:--------|:----------|:--------------|:--------------|---------------:|:-----------------|:---------------|:------------------------|:------------------------|:-------------|
|              29227 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10296 |              |             8 |                 8 |           1080 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10296 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10296   |
|              29228 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10054 |              |             6 |                 6 |           1080 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10054 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10054   |
|              29230 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10067 |              |            10 |                10 |           1296 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10067 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10067   |
|              29240 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10059 |              |             7 |                 7 |           3240 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10059 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10059   |
|              29243 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10060 |              |             9 |                 9 |           1296 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10060 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10060   |
|              29245 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10058 |              |             4 |                 4 |            486 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10058 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10058   |
|              29246 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10064 |              |             2 |                 2 |           1080 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10064 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10064   |
|              29259 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10065 |              |             5 |                 5 |            486 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10065 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10065   |
|              29262 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10057 |              |             3 |                 3 |            486 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10057 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10057   |
|              29266 |         2417 |        195226 |        3905 | 2019-04-22 00:00:00.000 | USS         | C        |         10056 |              |             1 |                 1 |            648 |             0 |         | GROJAS    | H             |               |           1137 |                  | 00003905-10056 | 2019-04-22 00:00:00.000 | 1899-12-30 00:00:00.000 | 1137-10056   |


Table: Vendor
|   Vendor ID |   Vendor Code | Vendor Name                    |
|------------:|--------------:|:-------------------------------|
|        1156 |        194537 | ARIZONA TEA DD                 |
|        1157 |        195690 | LBP MANUFACTURING INC          |
|        1158 |        313495 | FAYGO BEVERAGES INC            |
|        1159 |        313496 | TRIPP DISTRIBUTORS dba NOVAMAX |
|        1160 |        316899 | TONE PRODUCTS                  |
|        1161 |        317495 | REFRESCO GROUP N.V.            |
|        1162 |        321569 | BORDEN DAIRY  GA               |
|        1163 |        331965 | DADE PAPER & BAG CO.           |
|        1164 |        337985 | LOTUS VAPING TECHNOLOGIES LLC  |
|        1165 |        339700 | FLEXPRINT, INC.                |

 


tables: name: Date Table
data: Date Table.csv
name: Item Master
data: Item Master.csv
name: Key Measures
data: Key Measures.csv
name: PO Detail
data: PO Detail.csv
name: PO Master
data: PO Master.csv
name: PO Receipt
data: PO Receipt.csv
name: Vendor
data: Vendor.csv
label: PO Detail
PO Number
PO Master
PO Number
PO Receipt
Receipt Date
Date Table
Date
PO Detail
Wh-Item ID
Item Master
Wh-Item ID
PO Receipt
PO-Item ID
PO Detail
PO-Item ID
PO Receipt
Vendor Code
Vendor
Vendor Code
output: {
    "joins": [
        {
            "from_table": "PO Detail",
            "from_column": "PO Number",
            "to_table": "PO Master",
            "to_column": "PO Number"
        },
        {
            "from_table": "PO Receipt",
            "from_column": "Receipt Date",
            "to_table": "Date Table",
            "to_column": "Date"
        },
        {
            "from_table": "PO Detail",
            "from_column": "Wh-Item ID",
            "to_table": "Item Master",
            "to_column": "Wh-Item ID"
        },
        {
            "from_table": "PO Receipt",
            "from_column": "PO-Item ID",
            "to_table": "PO Detail",
            "to_column": "PO-Item ID"
        },
        {
            "from_table": "PO Receipt",
            "from_column": "Vendor Code",
            "to_table": "Vendor",
            "to_column": "Vendor Code"
        }
    ]
}