Schema Information

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.

For more information, see SkuVault- Product Details.

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