# Inventory Planner

Snapshot

| Features                        | Details                                                          |
| ------------------------------- | ---------------------------------------------------------------- |
| Release Status                  | Released                                                         |
| Source API Version              |                                                                  |
| Table Selection                 | Yes                                                              |
| Column Selection                | Yes                                                              |
| Edit Integration                | Yes                                                              |
| Replication Type Selection      | No                                                               |
| Authentication Parameters       | <p>Inventory Planner API Key<br>Inventory Planner Account ID</p> |
| Replication Type                | Key based Replication                                            |
| Replication Key                 | NA                                                               |
| Suggested Replication Frequency | 24 hrs                                                           |

| Tables/APIs Supported |   |
| --------------------- | - |
| Variants              |   |

### Integrate Inventory Planner with Daton

1. Signin to Daton
2. Select Impact from Integrations page
3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
4. Provide your Inventory Planner API key, Inventory Planner Account ID\
   [Click here](https://help.inventory-planner.com/en/articles/674662-inventory-planner-public-apis#authorization) to learn more about API key and Account ID
5. After providing the details to authorize Daton to periodically extract data from Inventory Planner.
6. Post successful authentication you will be prompted to choose from the list of available tables
7. Then select all required fields for each table
8. Submit the integration.

### Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2. Users would be able to edit/pause/re-activate/delete integration anytime
3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

### Inventory Planner Data

**Variants**

Purpose: Retrieve a list of all Variants

Source API Documentation: <https://help.inventory-planner.com/en/articles/6852616-inventory-planner-reports-api>

Replication: Key-Based Replication

Replication Key: NA

**Fields**

| FullName                                                           | DataType   |
| ------------------------------------------------------------------ | ---------- |
| connections                                                        | RECORD     |
| warehouse                                                          | RECORD     |
| removed                                                            | BOOLEAN    |
| sku                                                                | STRING     |
| in\_stock                                                          | NUMERIC    |
| cost                                                               | NUMERIC    |
| retail\_value                                                      | NUMERIC    |
| gross\_retail\_value                                               | NUMERIC    |
| replenishment                                                      | NUMERIC    |
| purchase\_orders\_qty                                              | NUMERIC    |
| id                                                                 | STRING     |
| created\_at                                                        | TIMESTAMP  |
| updated\_at                                                        | TIMESTAMP  |
| version                                                            | NUMERIC    |
| first\_order\_date                                                 | DATE       |
| last\_order\_date                                                  | DATE       |
| orders\_by\_month                                                  | RECORD     |
| revenue\_by\_month                                                 | RECORD     |
| total\_revenue                                                     | NUMERIC    |
| total\_sales                                                       | NUMERIC    |
| total\_sales\_cost                                                 | NUMERIC    |
| lead\_time                                                         | NUMERIC    |
| review\_period                                                     | NUMERIC    |
| avg\_lead\_time                                                    | NUMERIC    |
| first\_received\_qty                                               | NUMERIC    |
| last\_received\_qty                                                | NUMERIC    |
| po\_cost                                                           | NUMERIC    |
| po\_retail\_value                                                  | NUMERIC    |
| purchase\_orders\_qty\_bundles                                     | NUMERIC    |
| purchase\_orders\_qty\_for\_bundles                                | NUMERIC    |
| purchase\_orders\_qty\_in\_bundles                                 | NUMERIC    |
| transfer\_cost\_in                                                 | NUMERIC    |
| transfer\_cost\_out                                                | NUMERIC    |
| age                                                                | RECORD     |
| cur\_sales                                                         | NUMERIC    |
| first\_30\_days\_sales                                             | NUMERIC    |
| forecast\_by\_period                                               | RECORD     |
| forecast\_description                                              | RECORD     |
| forecast\_revenue                                                  | RECORD     |
| cur\_forecasted\_stock                                             | NUMERIC    |
| forecast\_wholesale                                                | NUMERIC    |
| forecasted\_lost\_revenue\_velocity\_days\_of\_stock               | NUMERIC    |
| forecasted\_lost\_sales\_lead\_time                                | NUMERIC    |
| forecasted\_profit                                                 | NUMERIC    |
| oos                                                                | NUMERIC    |
| overstocked\_cost                                                  | NUMERIC    |
| overstocked\_units                                                 | NUMERIC    |
| overstocked\_value                                                 | NUMERIC    |
| overstocked\_variants                                              | NUMERIC    |
| replenishment\_cost\_value                                         | NUMERIC    |
| replenishment\_retail\_value                                       | NUMERIC    |
| sells\_out\_in\_first                                              | NUMERIC    |
| to\_order                                                          | NUMERIC    |
| to\_order\_cost                                                    | NUMERIC    |
| to\_order\_gross                                                   | NUMERIC    |
| to\_order\_profit                                                  | NUMERIC    |
| cost\_price                                                        | NUMERIC    |
| wholesale\_orders\_by\_month                                       | RECORD     |
| forecasted\_stockouts\_dos                                         | NUMERIC    |
| min\_stock                                                         | NUMERIC    |
| forecasted\_lost\_sales\_lead\_time\_bn                            | BIGNUMERIC |
| returns\_units\_by\_month                                          | RECORD     |
| replenish\_date                                                    | DATE       |
| landing\_cost\_price                                               | NUMERIC    |
| forecasted\_lost\_revenue\_velocity\_days\_of\_stock\_bn           | BIGNUMERIC |
| connections.removed                                                | BOOLEAN    |
| connections.title                                                  | STRING     |
| connections.sku                                                    | STRING     |
| connections.barcode                                                | STRING     |
| connections.price                                                  | NUMERIC    |
| connections.regular\_price                                         | NUMERIC    |
| connections.brand                                                  | STRING     |
| connections.image                                                  | STRING     |
| connections.product\_type                                          | STRING     |
| connections.product\_id                                            | NUMERIC    |
| connections.product\_title                                         | STRING     |
| connections.published                                              | BOOLEAN    |
| connections.inventory\_management                                  | BOOLEAN    |
| connections.created\_at\_time                                      | NUMERIC    |
| connections.updated\_at\_time                                      | NUMERIC    |
| connections.vendors                                                | RECORD     |
| connections.vendors.cost\_price                                    | NUMERIC    |
| connections.vendors.cost\_price\_list                              | RECORD     |
| connections.vendors.cost\_price\_list.usd                          | NUMERIC    |
| connections.vendors.vendor\_reference                              | STRING     |
| connections.vendors.vendor                                         | STRING     |
| connections.vendors.cost\_price\_currency                          | STRING     |
| connections.linked\_by                                             | STRING     |
| connections.price\_account                                         | NUMERIC    |
| connections.regular\_price\_account                                | NUMERIC    |
| connections.connection\_main                                       | BOOLEAN    |
| connections.id                                                     | STRING     |
| connections.connection\_id                                         | STRING     |
| connections.options                                                | RECORD     |
| connections.options.flavor                                         | STRING     |
| connections.options.title                                          | STRING     |
| connections.options.gtin\_\_case\_                                 | STRING     |
| warehouse.warehouse                                                | STRING     |
| warehouse.cost                                                     | NUMERIC    |
| warehouse.retail\_value                                            | NUMERIC    |
| warehouse.gross\_retail\_value                                     | NUMERIC    |
| warehouse.lead\_time                                               | NUMERIC    |
| warehouse.review\_period                                           | NUMERIC    |
| warehouse.po\_cost                                                 | NUMERIC    |
| warehouse.po\_retail\_value                                        | NUMERIC    |
| warehouse.purchase\_orders\_qty                                    | NUMERIC    |
| warehouse.purchase\_orders\_qty\_bundles                           | NUMERIC    |
| warehouse.purchase\_orders\_qty\_for\_bundles                      | NUMERIC    |
| warehouse.purchase\_orders\_qty\_in\_bundles                       | NUMERIC    |
| warehouse.transfer\_cost\_in                                       | NUMERIC    |
| warehouse.transfer\_cost\_out                                      | NUMERIC    |
| warehouse.age                                                      | RECORD     |
| warehouse.age.qty                                                  | RECORD     |
| warehouse.age.qty.\_\_\_\_30\_days                                 | NUMERIC    |
| warehouse.age.qty.\_1\_\_\_60\_days                                | NUMERIC    |
| warehouse.age.qty.\_1\_\_\_90\_days                                | NUMERIC    |
| warehouse.age.qty.\_1\_\_\_120\_days                               | NUMERIC    |
| warehouse.age.qty.\_20\_\_\_180\_days                              | NUMERIC    |
| warehouse.age.qty.\_80\_\_\_365\_days                              | NUMERIC    |
| warehouse.age.qty.\_\_365\_days                                    | NUMERIC    |
| warehouse.age.qty.\_                                               | NUMERIC    |
| warehouse.age.cost                                                 | RECORD     |
| warehouse.age.cost.\_\_\_\_30\_days                                | NUMERIC    |
| warehouse.age.cost.\_1\_\_\_60\_days                               | NUMERIC    |
| warehouse.age.cost.\_1\_\_\_90\_days                               | NUMERIC    |
| warehouse.age.cost.\_1\_\_\_120\_days                              | NUMERIC    |
| warehouse.age.cost.\_20\_\_\_180\_days                             | NUMERIC    |
| warehouse.age.cost.\_80\_\_\_365\_days                             | NUMERIC    |
| warehouse.age.cost.\_\_365\_days                                   | NUMERIC    |
| warehouse.age.cost.\_                                              | NUMERIC    |
| warehouse.age.retail                                               | RECORD     |
| warehouse.age.retail.\_\_\_\_30\_days                              | NUMERIC    |
| warehouse.age.retail.\_1\_\_\_60\_days                             | NUMERIC    |
| warehouse.age.retail.\_1\_\_\_90\_days                             | NUMERIC    |
| warehouse.age.retail.\_1\_\_\_120\_days                            | NUMERIC    |
| warehouse.age.retail.\_20\_\_\_180\_days                           | NUMERIC    |
| warehouse.age.retail.\_80\_\_\_365\_days                           | NUMERIC    |
| warehouse.age.retail.\_\_365\_days                                 | NUMERIC    |
| warehouse.cur\_sales                                               | NUMERIC    |
| warehouse.first\_30\_days\_sales                                   | NUMERIC    |
| warehouse.forecast\_by\_period                                     | RECORD     |
| warehouse.forecast\_by\_period.\_021                               | RECORD     |
| warehouse.forecast\_by\_period.\_021.\_                            | NUMERIC    |
| warehouse.forecast\_by\_period.\_021.\_0                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_021.\_1                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_021.\_2                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_022                               | RECORD     |
| warehouse.forecast\_by\_period.\_022.\_                            | NUMERIC    |
| warehouse.forecast\_by\_period.\_022.\_0                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_022.\_1                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_022.\_2                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_023                               | RECORD     |
| warehouse.forecast\_by\_period.\_023.\_                            | NUMERIC    |
| warehouse.forecast\_by\_period.\_023.\_0                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_023.\_1                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_023.\_2                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_023.\_\_bn                        | BIGNUMERIC |
| warehouse.forecast\_by\_period.\_023.\_0\_bn                       | BIGNUMERIC |
| warehouse.forecast\_by\_period.\_023.\_1\_bn                       | BIGNUMERIC |
| warehouse.forecast\_by\_period.\_023.\_2\_bn                       | BIGNUMERIC |
| warehouse.forecast\_by\_period.\_024                               | RECORD     |
| warehouse.forecast\_by\_period.\_024.\_                            | NUMERIC    |
| warehouse.forecast\_by\_period.\_024.\_0                           | NUMERIC    |
| warehouse.forecast\_by\_period.\_024.\_\_bn                        | BIGNUMERIC |
| warehouse.forecast\_by\_period.\_024.\_0\_bn                       | BIGNUMERIC |
| warehouse.forecast\_description                                    | RECORD     |
| warehouse.forecast\_description.method                             | STRING     |
| warehouse.forecast\_description.oos\_management                    | BOOLEAN    |
| warehouse.forecast\_description.sales\_velocity30                  | NUMERIC    |
| warehouse.forecast\_description.sales\_velocity1                   | NUMERIC    |
| warehouse.forecast\_description.total\_sales                       | NUMERIC    |
| warehouse.forecast\_description.excluded\_sales                    | NUMERIC    |
| warehouse.forecast\_description.total\_days                        | NUMERIC    |
| warehouse.forecast\_description.total\_days\_sales                 | NUMERIC    |
| warehouse.forecast\_description.total\_days\_oos                   | NUMERIC    |
| warehouse.forecast\_description.excluded\_days                     | NUMERIC    |
| warehouse.forecast\_description.sales\_from                        | STRING     |
| warehouse.forecast\_description.sales\_to                          | STRING     |
| warehouse.forecast\_description.trend                              | STRING     |
| warehouse.forecast\_description.trend\_num                         | NUMERIC    |
| warehouse.forecast\_description.trend\_months                      | NUMERIC    |
| warehouse.forecast\_description.short\_sales\_history              | BOOLEAN    |
| warehouse.forecast\_description.excluded\_periods                  | RECORD     |
| warehouse.forecast\_description.excluded\_periods.from             | STRING     |
| warehouse.forecast\_description.excluded\_periods.to               | STRING     |
| warehouse.forecast\_description.excluded\_periods.days             | NUMERIC    |
| warehouse.forecast\_description.excluded\_periods.sales            | NUMERIC    |
| warehouse.forecast\_description.messages                           | RECORD     |
| warehouse.forecast\_description.messages.title                     | STRING     |
| warehouse.forecast\_description.messages.column1                   | STRING     |
| warehouse.forecast\_description.messages.column2                   | STRING     |
| warehouse.forecast\_description.included\_periods                  | RECORD     |
| warehouse.forecast\_description.included\_periods.from             | STRING     |
| warehouse.forecast\_description.included\_periods.to               | STRING     |
| warehouse.forecast\_description.included\_periods.days             | NUMERIC    |
| warehouse.forecast\_description.included\_periods.sales            | NUMERIC    |
| warehouse.forecast\_description.included\_periods.warehouse        | STRING     |
| warehouse.forecast\_description.sales\_velocity1\_bn               | BIGNUMERIC |
| warehouse.forecast\_description.sales\_velocity30\_bn              | BIGNUMERIC |
| warehouse.forecast\_revenue                                        | RECORD     |
| warehouse.forecast\_revenue.\_021                                  | RECORD     |
| warehouse.forecast\_revenue.\_021.\_                               | NUMERIC    |
| warehouse.forecast\_revenue.\_021.\_0                              | NUMERIC    |
| warehouse.forecast\_revenue.\_021.\_1                              | NUMERIC    |
| warehouse.forecast\_revenue.\_021.\_2                              | NUMERIC    |
| warehouse.forecast\_revenue.\_022                                  | RECORD     |
| warehouse.forecast\_revenue.\_022.\_                               | NUMERIC    |
| warehouse.forecast\_revenue.\_022.\_0                              | NUMERIC    |
| warehouse.forecast\_revenue.\_022.\_1                              | NUMERIC    |
| warehouse.forecast\_revenue.\_022.\_2                              | NUMERIC    |
| warehouse.forecast\_revenue.\_023                                  | RECORD     |
| warehouse.forecast\_revenue.\_023.\_                               | NUMERIC    |
| warehouse.forecast\_revenue.\_023.\_0                              | NUMERIC    |
| warehouse.forecast\_revenue.\_023.\_1                              | NUMERIC    |
| warehouse.forecast\_revenue.\_023.\_2                              | NUMERIC    |
| warehouse.forecast\_revenue.\_024                                  | RECORD     |
| warehouse.forecast\_revenue.\_024.\_                               | NUMERIC    |
| warehouse.forecast\_revenue.\_024.\_0                              | NUMERIC    |
| warehouse.cur\_forecasted\_stock                                   | NUMERIC    |
| warehouse.forecast\_wholesale                                      | NUMERIC    |
| warehouse.forecasted\_lost\_revenue\_velocity\_days\_of\_stock     | NUMERIC    |
| warehouse.forecasted\_lost\_sales\_lead\_time                      | NUMERIC    |
| warehouse.forecasted\_profit                                       | NUMERIC    |
| warehouse.oos                                                      | NUMERIC    |
| warehouse.overstocked\_cost                                        | NUMERIC    |
| warehouse.overstocked\_units                                       | NUMERIC    |
| warehouse.overstocked\_value                                       | NUMERIC    |
| warehouse.overstocked\_variants                                    | NUMERIC    |
| warehouse.replenishment                                            | NUMERIC    |
| warehouse.replenishment\_cost\_value                               | NUMERIC    |
| warehouse.replenishment\_retail\_value                             | NUMERIC    |
| warehouse.sells\_out\_in\_first                                    | NUMERIC    |
| warehouse.first\_order\_date                                       | DATE       |
| warehouse.last\_order\_date                                        | DATE       |
| warehouse.total\_revenue                                           | NUMERIC    |
| warehouse.total\_sales                                             | NUMERIC    |
| warehouse.total\_sales\_cost                                       | NUMERIC    |
| warehouse.to\_order                                                | NUMERIC    |
| warehouse.to\_order\_cost                                          | NUMERIC    |
| warehouse.to\_order\_gross                                         | NUMERIC    |
| warehouse.to\_order\_profit                                        | NUMERIC    |
| warehouse.cost\_price                                              | NUMERIC    |
| warehouse.forecasted\_stockouts\_dos                               | NUMERIC    |
| warehouse.min\_stock                                               | NUMERIC    |
| warehouse.replenish\_date                                          | DATE       |
| warehouse.in\_stock                                                | NUMERIC    |
| warehouse.avg\_lead\_time                                          | NUMERIC    |
| warehouse.first\_received\_qty                                     | NUMERIC    |
| warehouse.last\_received\_qty                                      | NUMERIC    |
| warehouse.orders\_by\_month                                        | RECORD     |
| warehouse.orders\_by\_month.\_020                                  | RECORD     |
| warehouse.orders\_by\_month.\_020.\_                               | NUMERIC    |
| warehouse.orders\_by\_month.\_020.\_0                              | NUMERIC    |
| warehouse.orders\_by\_month.\_020.\_1                              | NUMERIC    |
| warehouse.orders\_by\_month.\_020.\_2                              | NUMERIC    |
| warehouse.orders\_by\_month.\_021                                  | RECORD     |
| warehouse.orders\_by\_month.\_021.\_                               | NUMERIC    |
| warehouse.orders\_by\_month.\_021.\_0                              | NUMERIC    |
| warehouse.orders\_by\_month.\_021.\_1                              | NUMERIC    |
| warehouse.orders\_by\_month.\_021.\_2                              | NUMERIC    |
| warehouse.orders\_by\_month.\_022                                  | RECORD     |
| warehouse.orders\_by\_month.\_022.\_                               | NUMERIC    |
| warehouse.orders\_by\_month.\_022.\_0                              | NUMERIC    |
| warehouse.orders\_by\_month.\_022.\_1                              | NUMERIC    |
| warehouse.orders\_by\_month.\_022.\_2                              | NUMERIC    |
| warehouse.orders\_by\_month.\_023                                  | RECORD     |
| warehouse.orders\_by\_month.\_023.\_                               | NUMERIC    |
| warehouse.revenue\_by\_month                                       | RECORD     |
| warehouse.revenue\_by\_month.\_020                                 | RECORD     |
| warehouse.revenue\_by\_month.\_020.\_                              | NUMERIC    |
| warehouse.revenue\_by\_month.\_020.\_0                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_020.\_1                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_020.\_2                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_021                                 | RECORD     |
| warehouse.revenue\_by\_month.\_021.\_                              | NUMERIC    |
| warehouse.revenue\_by\_month.\_021.\_0                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_021.\_1                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_021.\_2                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_022                                 | RECORD     |
| warehouse.revenue\_by\_month.\_022.\_                              | NUMERIC    |
| warehouse.revenue\_by\_month.\_022.\_0                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_022.\_1                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_022.\_2                             | NUMERIC    |
| warehouse.revenue\_by\_month.\_023                                 | RECORD     |
| warehouse.revenue\_by\_month.\_023.\_                              | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month                             | RECORD     |
| warehouse.wholesale\_orders\_by\_month.\_020                       | RECORD     |
| warehouse.wholesale\_orders\_by\_month.\_020.\_                    | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_020.\_0                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_020.\_1                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_020.\_2                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_021                       | RECORD     |
| warehouse.wholesale\_orders\_by\_month.\_021.\_                    | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_021.\_0                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_021.\_1                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_021.\_2                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_022                       | RECORD     |
| warehouse.wholesale\_orders\_by\_month.\_022.\_                    | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_022.\_0                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_022.\_1                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_022.\_2                   | NUMERIC    |
| warehouse.wholesale\_orders\_by\_month.\_023                       | RECORD     |
| warehouse.wholesale\_orders\_by\_month.\_023.\_                    | NUMERIC    |
| warehouse.forecasted\_lost\_revenue\_velocity\_days\_of\_stock\_bn | BIGNUMERIC |
| warehouse.returns\_units\_by\_month                                | RECORD     |
| warehouse.returns\_units\_by\_month.\_020                          | RECORD     |
| warehouse.returns\_units\_by\_month.\_020.\_1                      | NUMERIC    |
| warehouse.returns\_units\_by\_month.\_020.\_                       | NUMERIC    |
| warehouse.returns\_units\_by\_month.\_020.\_0                      | NUMERIC    |
| warehouse.landing\_cost\_price                                     | NUMERIC    |
| warehouse.forecasted\_lost\_sales\_lead\_time\_bn                  | BIGNUMERIC |
| orders\_by\_month.\_020                                            | RECORD     |
| orders\_by\_month.\_020.\_                                         | NUMERIC    |
| orders\_by\_month.\_020.\_0                                        | NUMERIC    |
| orders\_by\_month.\_020.\_1                                        | NUMERIC    |
| orders\_by\_month.\_020.\_2                                        | NUMERIC    |
| orders\_by\_month.\_021                                            | RECORD     |
| orders\_by\_month.\_021.\_                                         | NUMERIC    |
| orders\_by\_month.\_021.\_0                                        | NUMERIC    |
| orders\_by\_month.\_021.\_1                                        | NUMERIC    |
| orders\_by\_month.\_021.\_2                                        | NUMERIC    |
| orders\_by\_month.\_022                                            | RECORD     |
| orders\_by\_month.\_022.\_                                         | NUMERIC    |
| orders\_by\_month.\_022.\_0                                        | NUMERIC    |
| orders\_by\_month.\_022.\_1                                        | NUMERIC    |
| orders\_by\_month.\_022.\_2                                        | NUMERIC    |
| orders\_by\_month.\_023                                            | RECORD     |
| orders\_by\_month.\_023.\_                                         | NUMERIC    |
| revenue\_by\_month.\_020                                           | RECORD     |
| revenue\_by\_month.\_020.\_                                        | NUMERIC    |
| revenue\_by\_month.\_020.\_0                                       | NUMERIC    |
| revenue\_by\_month.\_020.\_1                                       | NUMERIC    |
| revenue\_by\_month.\_020.\_2                                       | NUMERIC    |
| revenue\_by\_month.\_021                                           | RECORD     |
| revenue\_by\_month.\_021.\_                                        | NUMERIC    |
| revenue\_by\_month.\_021.\_0                                       | NUMERIC    |
| revenue\_by\_month.\_021.\_1                                       | NUMERIC    |
| revenue\_by\_month.\_021.\_2                                       | NUMERIC    |
| revenue\_by\_month.\_022                                           | RECORD     |
| revenue\_by\_month.\_022.\_                                        | NUMERIC    |
| revenue\_by\_month.\_022.\_0                                       | NUMERIC    |
| revenue\_by\_month.\_022.\_1                                       | NUMERIC    |
| revenue\_by\_month.\_022.\_2                                       | NUMERIC    |
| revenue\_by\_month.\_023                                           | RECORD     |
| revenue\_by\_month.\_023.\_                                        | NUMERIC    |
| age.qty                                                            | RECORD     |
| age.qty.\_                                                         | NUMERIC    |
| age.cost                                                           | RECORD     |
| age.cost.\_                                                        | NUMERIC    |
| forecast\_by\_period.\_023                                         | RECORD     |
| forecast\_by\_period.\_023.\_                                      | NUMERIC    |
| forecast\_by\_period.\_023.\_0                                     | NUMERIC    |
| forecast\_by\_period.\_023.\_1                                     | NUMERIC    |
| forecast\_by\_period.\_023.\_2                                     | NUMERIC    |
| forecast\_by\_period.\_023.\_\_bn                                  | BIGNUMERIC |
| forecast\_by\_period.\_023.\_0\_bn                                 | BIGNUMERIC |
| forecast\_by\_period.\_023.\_1\_bn                                 | BIGNUMERIC |
| forecast\_by\_period.\_023.\_2\_bn                                 | BIGNUMERIC |
| forecast\_by\_period.\_024                                         | RECORD     |
| forecast\_by\_period.\_024.\_                                      | NUMERIC    |
| forecast\_by\_period.\_024.\_0                                     | NUMERIC    |
| forecast\_by\_period.\_024.\_\_bn                                  | BIGNUMERIC |
| forecast\_by\_period.\_024.\_0\_bn                                 | BIGNUMERIC |
| forecast\_description.method                                       | STRING     |
| forecast\_description.oos\_management                              | BOOLEAN    |
| forecast\_description.sales\_velocity30                            | NUMERIC    |
| forecast\_description.sales\_velocity1                             | NUMERIC    |
| forecast\_description.total\_sales                                 | NUMERIC    |
| forecast\_description.excluded\_sales                              | NUMERIC    |
| forecast\_description.total\_days                                  | NUMERIC    |
| forecast\_description.total\_days\_sales                           | NUMERIC    |
| forecast\_description.total\_days\_oos                             | NUMERIC    |
| forecast\_description.excluded\_days                               | NUMERIC    |
| forecast\_description.excluded\_periods                            | RECORD     |
| forecast\_description.excluded\_periods.from                       | STRING     |
| forecast\_description.excluded\_periods.to                         | STRING     |
| forecast\_description.excluded\_periods.days                       | NUMERIC    |
| forecast\_description.excluded\_periods.sales                      | NUMERIC    |
| forecast\_description.messages                                     | RECORD     |
| forecast\_description.messages.title                               | STRING     |
| forecast\_description.messages.column1                             | STRING     |
| forecast\_description.messages.column2                             | STRING     |
| forecast\_description.sales\_from                                  | STRING     |
| forecast\_description.sales\_to                                    | STRING     |
| forecast\_description.trend                                        | STRING     |
| forecast\_description.trend\_num                                   | NUMERIC    |
| forecast\_description.trend\_months                                | NUMERIC    |
| forecast\_description.short\_sales\_history                        | BOOLEAN    |
| forecast\_description.sales\_velocity1\_bn                         | BIGNUMERIC |
| forecast\_description.included\_periods                            | RECORD     |
| forecast\_description.included\_periods.from                       | STRING     |
| forecast\_description.included\_periods.to                         | STRING     |
| forecast\_description.included\_periods.days                       | NUMERIC    |
| forecast\_description.included\_periods.sales                      | NUMERIC    |
| forecast\_description.sales\_velocity30\_bn                        | BIGNUMERIC |
| forecast\_revenue.\_023                                            | RECORD     |
| forecast\_revenue.\_023.\_                                         | NUMERIC    |
| forecast\_revenue.\_023.\_0                                        | NUMERIC    |
| forecast\_revenue.\_023.\_1                                        | NUMERIC    |
| forecast\_revenue.\_023.\_2                                        | NUMERIC    |
| forecast\_revenue.\_024                                            | RECORD     |
| forecast\_revenue.\_024.\_                                         | NUMERIC    |
| forecast\_revenue.\_024.\_0                                        | NUMERIC    |
| wholesale\_orders\_by\_month.\_020                                 | RECORD     |
| wholesale\_orders\_by\_month.\_020.\_                              | NUMERIC    |
| wholesale\_orders\_by\_month.\_020.\_0                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_020.\_1                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_020.\_2                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_021                                 | RECORD     |
| wholesale\_orders\_by\_month.\_021.\_                              | NUMERIC    |
| wholesale\_orders\_by\_month.\_021.\_0                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_021.\_1                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_021.\_2                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_022                                 | RECORD     |
| wholesale\_orders\_by\_month.\_022.\_                              | NUMERIC    |
| wholesale\_orders\_by\_month.\_022.\_0                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_022.\_1                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_022.\_2                             | NUMERIC    |
| wholesale\_orders\_by\_month.\_023                                 | RECORD     |
| wholesale\_orders\_by\_month.\_023.\_                              | NUMERIC    |
| returns\_units\_by\_month.\_020                                    | RECORD     |
| returns\_units\_by\_month.\_020.\_1                                | NUMERIC    |
| returns\_units\_by\_month.\_020.\_                                 | NUMERIC    |
| returns\_units\_by\_month.\_020.\_0                                | NUMERIC    |
