Explore the Lightspeed Retail (X-Series/Vend) API data model

Pulling data from the Lightspeed Retail (X-Series/Vend) API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SYNCHUB, we not only sync your Lightspeed X-Series API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Browse the data model below, or if you'd prefer, we also have an interactive ERD over here.

AuditLogEvent

Documentation: https://x-series-api.lightspeedhq.com/reference/getauditlogevents

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
CreatedAt	datetime	-	-
UserID	guid	User → ID	3 Dec 2022 After syncing tens of millions of records, we observed this value coming down as 'authome'. We don't feel this warrants changing our data type from GUID, as that would also break the foreign key, but it means non-GUID values like this will be nullified
Type	string	-	-
Action	string	-	-
EntityID	string	-	5 Aug 2020 Foreign key, but refers to different entities based on the type property
IpAddress	string	-	-
UserAgent	string	-	-
OccurredAt	datetime	-	-

Brand

Documentation: https://x-series-api.lightspeedhq.com/reference/listbrands

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
Version	long	-	-

Consignment

Documentation: https://x-series-api.lightspeedhq.com/reference/getconsignments

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	-
DeletedAt	datetime	-	-
Version	long	-	-
OutletID	guid	Outlet → ID	-
DueAt	datetime	-	-
Type	string	-	-
Status	string	-	-
SupplierID	guid	Supplier → ID	-
SourceOutletID	guid	Outlet → ID	-
ConsignmentDate	datetime	-	-
ReceivedAt	datetime	-	-
ShowInactive	boolean	-	-
SupplierInvoice	string	-	-
Reference	string	-	-
TotalCountGain	decimal	-	-
TotalCostGain	decimal	-	-
TotalCountLoss	decimal	-	-
TotalCostLoss	decimal	-	-
ProductCount	decimal	-	-

Customer

Documentation: https://x-series-api.lightspeedhq.com/reference/listcustomers-1

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	23 Apr 2022 known bug This is a known issue acknowledged by Vend. Due to GDPR requirements, if a customer is deleted the updated_at date is also set to '0000-12-30'
DeletedAt	datetime	-	12 Aug 2025 When a customer is deleted, their record is retained for two weeks, so their deletion date can appear in the future (from Vend support team)
Version	long	-	-
CustomerCode	string	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
YearToDate	decimal	-	-
Balance	decimal	-	-
LoyaltyBalance	decimal	-	-
Note	string	-	-
Gender	string	-	-
DateOfBirth	string	-	-
CompanyName	string	-	-
DoNotEmail	boolean	-	-
Phone	string	-	-
Mobile	string	-	-
Fax	string	-	-
Twitter	string	-	-
Website	string	-	-
PhysicalSuburb	string	-	-
PhysicalCity	string	-	-
PhysicalPostcode	string	-	-
PhysicalState	string	-	-
PostalSuburb	string	-	-
PostalCity	string	-	-
PostalState	string	-	-
CustomerGroupID	guid	CustomerGroup → ID	-
EnableLoyalty	boolean	-	-
PostalPostcode	string	-	-
PhysicalAddress1	string	-	-
PhysicalAddress2	string	-	-
PhysicalCountryID	string	-	-
PostalAddress1	string	-	-
PostalAddress2	string	-	-
PostalCountryID	string	-	-
CustomField1	string	-	-
CustomField2	string	-	-
CustomField3	string	-	-
CustomField4	string	-	-

CustomerGroup

Documentation: https://x-series-api.lightspeedhq.com/reference/listcustomergroups

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	-
DeletedAt	datetime	-	-
GroupID	string	-	-
RetailerID	string	-	-
Version	long	-	-

Inventory

Documentation: https://x-series-api.lightspeedhq.com/reference/listinventoryrecords

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
DeletedAt	datetime	-	-
Version	long	-	-
OutletID	guid	Outlet → ID	-
ProductID	guid	Product → ID	-
InventoryLevel	decimal	-	-
CurrentAmount	decimal	-	-
AverageCost	decimal	-	-
ReorderPoint	decimal	-	-
ReorderAmount	decimal	-	-

Outlet

Documentation: https://x-series-api.lightspeedhq.com/reference/listoutlets-1

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
TimeZone	string	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
Version	long	-	-
DefaultTaxID	guid	Tax → ID	-
Currency	string	-	-
CurrencySymbol	string	-	-
DisplayPrices	string	-	-
PhysicalAddress1	string	-	-
PhysicalAddress2	string	-	-
PhysicalSuburb	string	-	-
PhysicalCity	string	-	-
PhysicalPostcode	string	-	-
PhysicalState	string	-	-
PhysicalCountryID	string	-	-

OutletProductTax

Documentation: https://x-series-api.lightspeedhq.com/reference/listoutletproducttaxes

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OutletID	guid	Outlet → ID	-
ProductID	guid	Product → ID	-
DeletedAt	datetime	-	-
Version	long	-	-
TaxID	guid	Tax → ID	-

Payment

Column	Type	Relates to	Notes
RemoteID	string	-	-
SaleRemoteID	string	Sale → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
RegisterID	guid	Register → ID	-
OutletID	guid	Outlet → ID	-
RetailerPaymentTypeID	guid	PaymentMethod → ID	-
Amount	decimal	-	-
PaymentDate	datetime	-	-

PaymentMethod

Documentation: https://x-series-api.lightspeedhq.com/reference/listpaymenttypes-1

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
LedgerCode	string	-	-
Version	long	-	-
TypeID	int	-	-

PriceBook

Documentation: https://x-series-api.lightspeedhq.com/reference/listpricebooks

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	-
DeletedAt	datetime	-	-
Version	long	-	-
OutletID	guid	Outlet → ID	-
CustomerGroupID	guid	CustomerGroup → ID	-
RestrictToPlatformKey	string	-	-
RestrictToPlatformLabel	string	-	-
ValidFrom	datetime	-	-
ValidTo	datetime	-	-
Type	string	-	-

PriceBookProduct

Documentation: https://x-series-api.lightspeedhq.com/reference/listpricebookproducts

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
ProductID	guid	Product → ID	24 Nov 2021 known bug We have observed NULL values coming down for product_id and price_book_id
PriceBookID	guid	PriceBook → ID	24 Nov 2021 known bug We have observed NULL values coming down for product_id and price_book_id
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	-
DeletedAt	datetime	-	-
Version	long	-	-
Price	decimal	-	-
LoyaltyValue	decimal	-	-
MinUnits	decimal	-	-
MaxUnits	decimal	-	-
DefaultDisplayPrice	decimal	-	-
RetailPrice	decimal	-	-
Discount	decimal	-	-
Adjustment	decimal	-	-
AdjustmentType	string	-	-
Rounding	string	-	-
TaxID	guid	Tax → ID	-

Product

Documentation: https://x-series-api.lightspeedhq.com/reference/listproducts-2

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
Description	string	-	-
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	-
DeletedAt	datetime	-	-
Version	long	-	-
VariantParentID	guid	Product → ID	-
VariantName	string	-	-
Handle	string	-	-
Sku	string	-	-
SupplierCode	string	-	-
HasInventory	boolean	-	-
IsComposite	boolean	-	-
ImageUrl	string	-	-
Source	string	-	-
AccountCode	string	-	-
AccountCodePurchase	string	-	-
SupplyPrice	decimal	-	-
HasVariants	boolean	-	-
PriceIncludingTax	decimal	-	-
PriceExcludingTax	decimal	-	-
LoyaltyAmount	decimal	-	-
SupplierID	guid	Supplier → ID	-
ProductTypeID	guid	ProductType → ID	-
BrandID	guid	Brand → ID	-
IsActive	boolean	-	24 Oct 2023 This is_active field is no longer documented, however it is returned in the payload. The documentation appears to support an 'active' field which presumably supercedes it. In all testing, both values are identical.
Code	string	-	-
Price	decimal	-	-
ProductCategoryID	guid	ProductCategory → ID	15 May 2025 This property is not documented

ProductCategory

Documentation: https://x-series-api.lightspeedhq.com/reference/listproductcategories

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
RootCategoryID	guid	ProductCategory → ID	-
ParentCategoryID	guid	ProductCategory → ID	-
LeafCategory	boolean	-	-
PayloadID	string	-	-

ProductType

Documentation: https://x-series-api.lightspeedhq.com/reference/listproducttypes

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
Version	long	-	-

Promotion

Documentation: https://x-series-api.lightspeedhq.com/reference/listpromotions

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Description	string	-	-
StartTime	datetime	-	-
EndTime	datetime	-	-
ConditionType	string	-	-
ConditionQuantity	decimal	-	-
ActionType	string	-	-
ActionValue	decimal	-	-
LoyaltyMultiplier	decimal	-	-
Status	string	-	-
UsePromoCode	boolean	-	-
PromoCodeSummaryTotalPromoCode	decimal	-	-
PromoCodeSummaryRedeemedAmount	decimal	-	-
ShowPotential	boolean	-	-

Register

Documentation: https://x-series-api.lightspeedhq.com/reference/listregisters

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
Version	long	-	-
OutletID	guid	Outlet → ID	-
AskForNoteOnSave	int	-	-
PrintNoteOnReceipt	boolean	-	-
AskForUserOnSale	boolean	-	-
ShowDiscountsOnReceipts	boolean	-	-
PrintReceipt	boolean	-	-
EmailReceipt	boolean	-	-
InvoicePrefix	string	-	-
InvoiceSuffix	string	-	-
InvoiceSequence	int	-	-
ButtonLayoutID	guid	-	-
IsOpen	boolean	-	-
IsQuickKeysEnabled	boolean	-	-
RegisterOpenTime	datetime	-	-
RegisterCloseTime	datetime	-	-
RegisterOpenSequenceID	guid	-	-
CashManagedPaymentTypeID	guid	-	-
SalePrefix	string	-	-
ReturnPrefix	string	-	-
RemoteSiteID	string	-	-
Code	string	-	-

Sale

Documentation: https://x-series-api.lightspeedhq.com/reference/listsales

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	-
DeletedAt	datetime	-	-
Version	long	-	-
OutletID	guid	Outlet → ID	-
RegisterID	guid	Register → ID	-
UserID	guid	User → ID	-
CustomerID	guid	Customer → ID	-
InvoiceNumber	string	-	-
Status	string	-	-
State	string	-	-
Note	string	-	-
ShortCode	string	-	-
ReturnFor	guid	-	-
TotalPrice	decimal	-	-
TotalTax	decimal	-	-
TotalLoyalty	decimal	-	-
SaleDate	datetime	-	-
ReceiptNumber	string	-	-
TotalPriceIncl	decimal	-	-
AccountsTransactionID	string	-	-
Source	string	-	-
SourceID	string	-	-
Tip	decimal	-	-
Total	decimal	-	-
Tax	decimal	-	-
RemoteSiteID	string	-	-
RemoteStaffMemberID	string	-	-
SaleID	string	-	-
PriceVariation	decimal	-	-
IsRefund	boolean	-	-

SaleFulfillment

Documentation: https://x-series-api.lightspeedhq.com/reference/getfulfillmentsbysaleid

Column	Type	Relates to	Notes
RemoteID	string	-	-
SaleRemoteID	string	Sale → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	15 Sep 2020 Returns as a string, presumably to account for varying formats of third-party fulfillment services
SaleID	guid	Sale → ID	-
CreatedAt	datetime	-	-
OutletID	guid	Outlet → ID	-
UserID	guid	User → ID	-
Status	string	-	-

SaleItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
SaleRemoteID	string	Sale → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Number	int	-	-
Quantity	decimal	-	-
Notes	string	-	-
UnitPrice	decimal	-	-
UnitTax	decimal	-	-
PriceVariation	decimal	-	-
UnitPriceGross	decimal	-	-
LineTotalExTax	decimal	-	-
LineTotalTax	decimal	-	-
SaleID	guid	Sale → ID	-
ProductID	guid	Product → ID	-
TaxID	guid	Tax → ID	-
LoyaltyValue	decimal	-	-
Note	string	-	-
PriceSet	boolean	-	-
Status	string	-	-
Sequence	int	-	-
UnitCost	decimal	-	-
UnitDiscount	decimal	-	-
UnitLoyaltyValue	decimal	-	-
TotalCost	decimal	-	-
TotalDiscount	decimal	-	-
TotalLoyaltyValue	decimal	-	-
TotalPrice	decimal	-	-
TotalTax	decimal	-	-
IsReturn	boolean	-	-
LineItemsIncludeTax	boolean	-	-

SaleItemPromotion

Column	Type	Relates to	Notes
RemoteID	string	-	-
SaleItemRemoteID	string	SaleItem → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
SaleItemID	guid	SaleItem → ID	-
PromotionID	long	Promotion → ID	-
Amount	decimal	-	-
PromoCode	string	-	-
PromoCodeID	string	-	-

SerialNumber

Documentation: https://x-series-api.lightspeedhq.com/reference/get-serialnumbers

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Code	string	-	-
ProductID	guid	Product → ID	-
OutletID	guid	Outlet → ID	-
SaleID	guid	Sale → ID	-
LineItemID	guid	SaleItem → ID	-
Version	long	-	-

Supplier

Documentation: https://x-series-api.lightspeedhq.com/reference/listsuppliers

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
Description	string	-	-
DeletedAt	datetime	-	-
Version	long	-	-
Source	string	-	-

Tag

Documentation: https://x-series-api.lightspeedhq.com/reference/listtags

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
Version	long	-	-

Tax

Documentation: https://x-series-api.lightspeedhq.com/reference/listtaxes-1

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
Version	long	-	-
IsDefault	boolean	-	-
DisplayName	string	-	-

User

Documentation: https://x-series-api.lightspeedhq.com/reference/listusers

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	-
DeletedAt	datetime	-	-
FirstName	string	-	-
LastName	string	-	-
AvatarURL	string	-	-
FullName	string	-	-
Version	long	-	-
Username	string	-	-
DisplayName	string	-	-
Email	string	-	-
EmailVerifiedAt	datetime	-	-
AccountType	string	-	-
SeenAt	datetime	-	-
TargetDaily	decimal	-	-
TargetWeekly	decimal	-	-
TargetMonthly	decimal	-	-
IsPrimaryUser	boolean	-	-
ImageSource	string	-	-

ProductVariant

Documentation: https://x-series-api.lightspeedhq.com/reference/listvariantattributes

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
DeletedAt	datetime	-	-
DefaultValue	string	-	-
IsDeprecated	boolean	-	-

ConsignmentProductBatch

Column	Type	Relates to	Notes
RemoteID	string	-	-
ConsignmentRemoteID	string	Consignment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ConsignmentID	guid	Consignment → ID	-
ProductID	guid	Product → ID	-
LineNumber	int	-	-
CreatedAt	datetime	-	-
UpdatedAt	datetime	-	-
DeletedAt	datetime	-	-
ProductSku	string	-	6 Jul 2020 Although the product_sku shows in the web interface, it's always null in API calls
Count	decimal	-	-
Received	decimal	-	-
Cost	decimal	-	-
IsIncluded	boolean	-	-
Status	string	-	-
Version	string	-	-

ProductVariantValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductRemoteID	string	Product → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProductID	guid	Product → ID	-
ProductVariantID	guid	ProductVariant → ID	-
Value	string	-	-

ProductTag

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductRemoteID	string	Product → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TagID	guid	Tag → ID	-
ProductID	guid	Product → ID	-

ProductCode

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductRemoteID	string	Product → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProductID	guid	Product → ID	-
LineNumber	int	-	-
Type	string	-	-
Code	string	-	-

PromotionConditionInclude

Column	Type	Relates to	Notes
RemoteID	string	-	-
PromotionRemoteID	string	Promotion → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PromotionID	long	Promotion → ID	-
Value	guid	-	2 Mar 2021 The unique ID of whatever the field is. For example if field = 'product_id' then this is the particular product GUID
Field	string	-	-
ProductID	guid	Product → ID	-
BrandID	guid	Brand → ID	-
SupplierID	guid	Supplier → ID	-
TagID	guid	Tag → ID	-
TypeID	guid	ProductType → ID	-
VariantParentID	guid	Product → ID	-

PromotionConditionExclude

Column	Type	Relates to	Notes
RemoteID	string	-	-
PromotionRemoteID	string	Promotion → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PromotionID	long	Promotion → ID	-
Value	guid	-	2 Mar 2021 The unique ID of whatever the field is. For example if field = 'product_id' then this is the particular product GUID
Field	string	-	-
ProductID	guid	Product → ID	-
BrandID	guid	Brand → ID	-
SupplierID	guid	Supplier → ID	-
TagID	guid	Tag → ID	-
TypeID	guid	ProductType → ID	-
VariantParentID	guid	Product → ID	-

PromotionActionInclude

Column	Type	Relates to	Notes
RemoteID	string	-	-
PromotionRemoteID	string	Promotion → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PromotionID	long	Promotion → ID	-
Value	guid	-	2 Mar 2021 The unique ID of whatever the field is. For example if field = 'product_id' then this is the particular product GUID
Field	string	-	-
ProductID	guid	Product → ID	-
BrandID	guid	Brand → ID	-
SupplierID	guid	Supplier → ID	-
TagID	guid	Tag → ID	-
TypeID	guid	ProductType → ID	-
VariantParentID	guid	Product → ID	-

PromotionActionExclude

Column	Type	Relates to	Notes
RemoteID	string	-	-
PromotionRemoteID	string	Promotion → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PromotionID	long	Promotion → ID	-
Value	guid	-	2 Mar 2021 The unique ID of whatever the field is. For example if field = 'product_id' then this is the particular product GUID
Field	string	-	-
ProductID	guid	Product → ID	-
BrandID	guid	Brand → ID	-
SupplierID	guid	Supplier → ID	-
TagID	guid	Tag → ID	-
TypeID	guid	ProductType → ID	-
VariantParentID	guid	Product → ID	-

PromotionOutlet

Column	Type	Relates to	Notes
RemoteID	string	-	-
PromotionRemoteID	string	Promotion → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PromotionID	long	Promotion → ID	-
OutletID	guid	Outlet → ID	-

PromotionChannel

Column	Type	Relates to	Notes
RemoteID	string	-	-
PromotionRemoteID	string	Promotion → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PromotionID	long	Promotion → ID	-
ChannelName	string	-	-

PromotionCustomerGroup

Column	Type	Relates to	Notes
RemoteID	string	-	-
PromotionRemoteID	string	Promotion → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PromotionID	long	Promotion → ID	-
CustomerGroupID	guid	CustomerGroup → ID	-

TaxRate

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaxRemoteID	string	Tax → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	guid	-	-
Name	string	-	-
TaxID	guid	Tax → ID	-
Rate	decimal	-	-
DisplayName	string	-	-