> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/data-integrations/setup-guides/retail-integrations/amazon-vendor-central/transformation-configuration-setup/vendor-sales-and-inventory-report.md).

# Vendor Sales & Inventory Report

This pages provides instructions on what transform code should be added to a script manifest file to transform Amazon Vendor Central Sales & Inventory data into the Unified Order Schema (UOS)

## Overview

The Daasity transformation code maps data from the Amazon Vendor Central schema into the Unified Order Schema (UOS)

## Feature Dependencies

You must have enabled our [Code Repository](/technical-docs/transform-code/code-repository.md) feature in order to both access the Daasity transformation code as well as modify a Script Manifest File enabling this code to execute

We recommend you review the [Transformation Configuration](/technical-docs/workflows-and-scheduling/script-manifest-yaml-files.md) section of our Help documentation to familiarize yourself with our workflow engine and script manifest files.

## Script Manifest File (YML)

### Upstream Transformation Dependencies

{% hint style="danger" %}
This code is dependent on the following integration being installed:

* Amazon Vendor Central

This code block is dependent on the following upstream code blocks being implemented:

* [Initialization](/technical-docs/transform-code/transform-code/initialization-code.md)
  {% endhint %}

### Transformation Code Requirements

To enable the data transformation from the Amazon Vendor Central schema into UOS, the following code must be run in a workflow:

```
  uos_amazon_vendor_central:
    integrations:
      - amazon_vendor_central
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0001_UOS_BAS_update_integration_mapping.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0100_UOS_BAS_locations.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0102_UOS_BAS_customers.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0103_UOS_BAS_products.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0104_UOS_BAS_product_variants.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0105_UOS_BAS_orders.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0106_UOS_BAS_order_line_items.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0113_UOS_BAS_fulfillments.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0114_UOS_BAS_order_item_fulfillments.sql"
      - "github://platform-sql-shared/scripts/datamart/03_uos/amazon_vendor_central/0115_UOS_BAS_current_inventory_levels.sql"
      - "github://platform-sql-internal/scripts/datamart/03_uos/amazon_vendor_central/0116_UOS_BAS_sales_report.sql"
```

### Unified Order Schema

Code to populate the UOS tables:

* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0001_UOS_BAS_update_integration_mapping.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0100_UOS_BAS_locations.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0102_UOS_BAS_customers.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0103_UOS_BAS_products.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0104_UOS_BAS_product_variants.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0105_UOS_BAS_orders.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0106_UOS_BAS_order_line_items.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0113_UOS_BAS_fulfillments.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0114_UOS_BAS_order_item_fulfillments.sql>
* <https://github.com/Daasity/platform-sql-shared/blob/master/scripts/datamart/03_uos/amazon_vendor_central/0115_UOS_BAS_current_inventory_levels.sql>