# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the [SkuVault](https://www.bing.com/ck/a?!&\&p=4a575c2c826d228dJmltdHM9MTY5ODE5MjAwMCZpZ3VpZD0xMDE1YWEzZC0zYWYyLTZjNzMtMGY5NS1iOTU1M2I0MDZkOTYmaW5zaWQ9NTIwNQ\&ptn=3\&hsh=3\&fclid=1015aa3d-3af2-6c73-0f95-b9553b406d96\&psq=Skuvault\&u=a1aHR0cHM6Ly9hcHAuc2t1dmF1bHQuY29tL2FjY291bnQvbG9naW4\&ntb=1) connector:

* Product Details 
* Inventory By Location

### Product Details

This API provides product details, specifically for individual products. The response not only includes product information but also provides product quantities.

For more information, see [SkuVault- Product Details](https://dev.skuvault.com/reference/getproducts).

**FIELDS**

| Field Name             | Data Type |
| ---------------------- | --------- |
| **Id** *(Primary Key)* | STRING    |
| Code                   | STRING    |
| Sku                    | STRING    |
| PrimarySku             | STRING    |
| PartNumber             | STRING    |
| Description            | STRING    |
| ShortDescription       | STRING    |
| LongDescription        | STRING    |
| Cost                   | NUMERIC   |
| RetailPrice            | NUMERIC   |
| SalePrice              | NUMERIC   |
| WeightValue            | STRING    |
| WeightUnit             | STRING    |
| ReorderPoint           | NUMERIC   |
| Brand                  | STRING    |
| Supplier               | STRING    |
| SupplierInfo           | RECORD    |
| Classification         | STRING    |
| QuantityOnHand         | NUMERIC   |
| QuantityOnHold         | NUMERIC   |
| QuantityPicked         | NUMERIC   |
| QuantityPending        | NUMERIC   |
| QuantityAvailable      | NUMERIC   |
| QuantityIncoming       | NUMERIC   |
| QuantityInbound        | NUMERIC   |
| QuantityTransfer       | NUMERIC   |
| QuantityInStock        | NUMERIC   |
| QuantityTotalFBA       | NUMERIC   |
| CreatedDateUtc         | TIMESTAMP |
| ModifiedDateUtc        | TIMESTAMP |
| Attributes             | RECORD    |
| VariationParentSku     | STRING    |
| IsAlternateSKU         | BOOLEAN   |
| IsAlternateCode        | BOOLEAN   |
| MOQ                    | NUMERIC   |
| MOQInfo                | STRING    |
| IncrementalQuantity    | NUMERIC   |
| DisableQuantitySync    | BOOLEAN   |
| IsSerialized           | BOOLEAN   |
| Client                 | STRING    |
| CanBeUsedForLots       | BOOLEAN   |

### Inventory By Location

This API request provides information about the location and warehouse associated with each product.

For more information, see [SkuVault- Inventory By Location](https://dev.skuvault.com/reference/getinventorybylocation).

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| **SKU** *(Primary Key)* | STRING    |
| value                   | RECORD    |