Schema Information of SkuVault
This topic provides a structured reference to assist you in working with Daton's SkuVault connector and the associated fields and tables.
Schema Information of SkuVault
This topic provides a structured reference to assist you in working with Daton's SkuVault connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the SkuVault 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.
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.
FIELDS
Field Name |
Data Type |
|---|---|
SKU (Primary Key) |
STRING |
value |
RECORD |
