QIIUB — Data Dictionary

148

Tables total

Central

109

Merchant

Central Database

AI / Agents

dbo.AiCreditAccount

Per-merchant AI credit wallet and balances.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CreditsBalance	Decimal	decimal(12,4)
IsActive	Boolean	bit
IsDeleted	Boolean	bit
MerchantId	Int32	int			✓
MonthlyAllocation	Decimal	decimal(12,4)
MonthlyCreditsUsed	Decimal	decimal(12,4)
MonthlyResetAtUtc	DateTime	datetime2(3)
PlanType	String	varchar(50)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
TotalCreditsAllocated	Decimal	decimal(12,4)
TotalCreditsConsumed	Decimal	decimal(12,4)
TotalCreditsPurchased	Decimal	decimal(12,4)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.AiCreditPlan

Definition of an AI credit plan tier.

Column	Type	Provider	Null	PK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Key	String	varchar(50)
MonthlyCredits	Decimal	decimal(12,4)
Name	String	nvarchar(100)
PublicId	String	varchar(32)
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.AiCreditTransaction

Ledger entry against an AI credit account.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
AccountId	Int32	int			✓
AiRequestLogId	Int64	bigint	✓		✓
Amount	Decimal	decimal(12,4)
BalanceAfter	Decimal	decimal(12,4)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)
IsDeleted	Boolean	bit
MerchantId	Int32	int
Type	String	varchar(20)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UserEmail	String	nvarchar(256)
UserId	String	nvarchar(450)

dbo.AiPrompt

Registered/versioned prompt template (system + user prompt, model, cost).

Column	Type	Provider	Null	PK
Id	Int32	int		✓
AllowedRoles	String	varchar(200)	✓
Category	String	varchar(50)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)	✓
InputTokenCostPer1M	Decimal	decimal(10,4)
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Key	String	varchar(100)
MaxTokens	Int32	int
Model	String	varchar(100)
Name	String	nvarchar(200)
OutputTokenCostPer1M	Decimal	decimal(10,4)
OutputValidation	String	nvarchar(max)	✓
Provider	String	varchar(20)
PublicId	String	varchar(32)
SystemPrompt	String	nvarchar(max)
Temperature	Decimal	decimal(3,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UserPromptTemplate	String	nvarchar(max)
VariableSchema	String	nvarchar(max)	✓

dbo.AiRequestLog

Log of every AI request (tokens, cost, latency, review/flag status).

Column	Type	Provider	Null	PK	FK
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CreditsConsumed	Decimal	decimal(10,4)
ErrorMessage	String	nvarchar(1000)	✓
EstimatedCostUsd	Decimal	decimal(10,6)
FlagReason	String	nvarchar(500)	✓
InputVariables	String	nvarchar(max)
IpAddress	String	varchar(45)	✓
IsBillable	Boolean	bit
IsDeleted	Boolean	bit
IsFlagged	Boolean	bit
LatencyMs	Int64	bigint
MerchantId	Int32	int	✓
Model	String	varchar(100)
Output	String	nvarchar(max)	✓
PartnerId	Int32	int	✓
PromptId	Int32	int			✓
PromptKey	String	varchar(100)
Provider	String	varchar(20)
PublicId	String	varchar(32)
ReviewNotes	String	nvarchar(500)	✓
ReviewedAtUtc	DateTime	datetime2(3)	✓
ReviewedByUserId	String	nvarchar(450)	✓
Status	String	varchar(20)
SystemPromptUsed	String	nvarchar(max)
TokensInput	Int32	int
TokensOutput	Int32	int
TokensTotal	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UserEmail	String	nvarchar(256)
UserId	String	nvarchar(450)
UserPromptResolved	String	nvarchar(max)
UserRole	String	varchar(50)

Audit

dbo.SystemAuditLog

Platform-level audit trail of significant actions.

Column	Type	Provider	Null	PK	FK
Id	Int64	bigint		✓
Action	String	varchar(50)
CreatedAtUtc	DateTime	datetime2(3)
Details	String	nvarchar(max)	✓
EntityId	String	varchar(50)
EntityType	String	varchar(100)
IpAddress	String	varchar(45)	✓
MerchantId	Int32	int	✓		✓
PartnerId	Int32	int	✓		✓
UserId	String	nvarchar(450)	✓		✓

Devices

dbo.DeviceRegistration

A registered POS/terminal device, its activation and IoT identity.

Column	Type	Provider	Null	PK	FK	Enum
Id	Int32	int		✓
ActivatedAtUtc	DateTime	datetime2(3)	✓
ActivationToken	String	varchar(50)	✓
ActivationTokenExpiresUtc	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DeviceCode	String	varchar(50)
DeviceName	String	nvarchar(100)
DeviceTokenHash	Byte[]	varbinary(32)	✓
DeviceType	DeviceType	varchar(20)				DeviceType
FailedActivationAttempts	Int32	int
IoTHubConnectionString	String	varchar(500)	✓
IoTHubDeviceId	String	varchar(200)	✓
IsDeleted	Boolean	bit
LastSeenUtc	DateTime	datetime2(3)	✓
LocationId	Int32	int
MerchantId	Int32	int			✓
PublicId	String	varchar(32)
Status	DeviceStatus	varchar(20)				DeviceStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Identity (framework)

dbo.AspNetRoleClaims

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
ClaimType	String	nvarchar(max)	✓
ClaimValue	String	nvarchar(max)	✓
RoleId	String	nvarchar(450)			✓

dbo.AspNetRoles

Column	Type	Provider	Null	PK
Id	String	nvarchar(450)		✓
ConcurrencyStamp	String	nvarchar(max)	✓
Name	String	nvarchar(256)	✓
NormalizedName	String	nvarchar(256)	✓

dbo.AspNetUserClaims

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
ClaimType	String	nvarchar(max)	✓
ClaimValue	String	nvarchar(max)	✓
UserId	String	nvarchar(450)			✓

dbo.AspNetUserLogins

Column	Type	Provider	Null	PK	FK
LoginProvider	String	nvarchar(450)		✓
ProviderKey	String	nvarchar(450)		✓
ProviderDisplayName	String	nvarchar(max)	✓
UserId	String	nvarchar(450)			✓

dbo.AspNetUserRoles

Column	Type	Provider	Null	PK	FK	Enum
UserId	String	nvarchar(450)		✓	✓
RoleId	String	nvarchar(450)		✓	✓

dbo.AspNetUsers

Column	Type	Provider	Null	PK
Id	String	nvarchar(450)		✓
AccessFailedCount	Int32	int
AvatarUrl	String	nvarchar(500)	✓
ConcurrencyStamp	String	nvarchar(max)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Email	String	nvarchar(256)	✓
EmailConfirmed	Boolean	bit
EmailDomain	String	nvarchar(256)	✓
FirstName	String	nvarchar(50)
IsActive	Boolean	bit
LastLoginUtc	DateTime	datetime2(3)	✓
LastName	String	nvarchar(50)
LockoutEnabled	Boolean	bit
LockoutEnd	DateTimeOffset	datetimeoffset	✓
NormalizedEmail	String	nvarchar(256)	✓
NormalizedUserName	String	nvarchar(256)	✓
PasswordHash	String	nvarchar(max)	✓
PhoneNumber	String	nvarchar(max)	✓
PhoneNumberConfirmed	Boolean	bit
PreferredProvider	String	varchar(50)	✓
RequiresPasswordChange	Boolean	bit
SecurityStamp	String	nvarchar(max)	✓
TwoFactorEnabled	Boolean	bit
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UserName	String	nvarchar(256)	✓

dbo.AspNetUserTokens

Column	Type	Provider	Null	PK	FK
UserId	String	nvarchar(450)		✓	✓
LoginProvider	String	nvarchar(450)		✓
Name	String	nvarchar(450)		✓
Value	String	nvarchar(max)	✓

Identity & Auth

dbo.AuthDomainRoute

Maps an email domain to an auth provider (routing/SSO enforcement).

Column	Type	Provider	PK
Id	Int32	int	✓
CreatedAtUtc	DateTime	datetime2(3)
Domain	String	varchar(256)
IsActive	Boolean	bit
IsEnforced	Boolean	bit
Provider	String	varchar(50)

dbo.ExternalLogin

Linked external identity provider (OAuth) record.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
IsDeleted	Boolean	bit
LinkedAtUtc	DateTime	datetime2(3)
Provider	String	varchar(50)
ProviderDisplayName	String	nvarchar(200)	✓
ProviderKey	String	nvarchar(256)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UserId	String	nvarchar(450)			✓

dbo.HandoffToken

Short-lived token to hand a session across apps/domains.

Column	Type	Provider	Null	PK	Enum
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
ExpiresAtUtc	DateTime	datetime2(3)
IpAddress	String	varchar(45)	✓
IsUsed	Boolean	bit
MerchantPublicId	String	varchar(32)
Reason	SupportSessionReason	varchar(32)			SupportSessionReason
ReasonDetails	String	nvarchar(200)	✓
Token	String	varchar(64)
UsedAtUtc	DateTime	datetime2(3)	✓
UserId	String	nvarchar(450)

dbo.Invitation

Pending invite for a user to join a partner or merchant.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
AcceptedAtUtc	DateTime	datetime2(3)	✓
AcceptedByUserId	String	nvarchar(450)	✓		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Email	String	nvarchar(256)
ExpiresAtUtc	DateTime	datetime2(3)
FirstName	String	nvarchar(100)	✓
InvitedByUserId	String	nvarchar(450)			✓
IsDeleted	Boolean	bit
IsRevoked	Boolean	bit
LastName	String	nvarchar(100)	✓
MerchantId	Int32	int	✓
PartnerId	Int32	int	✓		✓
PublicId	String	varchar(32)
ResendCount	Int32	int
TargetRole	String	varchar(50)
Token	String	varchar(64)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.MagicLinkToken

One-time passwordless email sign-in token.

Column	Type	Provider	Null	PK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
Email	String	nvarchar(256)
ExpiresAtUtc	DateTime	datetime2(3)
IpAddress	String	varchar(45)	✓
IsUsed	Boolean	bit
Token	String	varchar(64)
UsedAtUtc	DateTime	datetime2(3)	✓

auth.RefreshToken

Issued refresh token / session record.

Column	Type	Provider	Null	PK
Id	Int64	bigint		✓
AbsoluteExpiresAtUtc	DateTime	datetime2(3)
Context	String	nvarchar(20)
DeviceLabel	String	nvarchar(100)	✓
ExpiresAtUtc	DateTime	datetime2(3)
GlobalId	Guid	uniqueidentifier
IpAddress	String	nvarchar(45)
IssuedAtUtc	DateTime	datetime2(3)
MerchantPublicId	String	nvarchar(32)	✓
PartnerPublicId	String	nvarchar(32)	✓
ReplacedByTokenHash	Byte[]	binary(32)	✓
RevokedAtUtc	DateTime	datetime2(3)	✓
RevokedReason	String	nvarchar(50)	✓
SessionId	Guid	uniqueidentifier
TokenHash	Byte[]	binary(32)
UserAgent	String	nvarchar(500)
UserId	String	nvarchar(450)

dbo.UserMerchant

Grants a user access to a merchant with a role (multi-tenant membership).

Column	Type	Provider	Null	PK	FK	Enum
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
LastActivatedAtUtc	DateTime	datetime2(3)	✓
MerchantId	Int32	int			✓
Role	UserRole	varchar(20)				UserRole
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UserId	String	nvarchar(450)			✓

Loyalty Groups (cross-merchant)

dbo.GroupLoyaltyAccount

A member's account in a group loyalty program.

Column	Type	Provider	Null	PK	FK	Enum
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GroupLoyaltyProgramId	Int32	int			✓
LifetimePoints	Decimal	decimal(18,2)
MemberEmail	String	nvarchar(200)	✓
MemberName	String	nvarchar(100)
MemberPhone	String	varchar(20)
MerchantGroupId	Int32	int			✓
PointsBalance	Decimal	decimal(18,2)
PublicId	String	varchar(32)
Status	GroupLoyaltyAccountStatus	tinyint				GroupLoyaltyAccountStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.GroupLoyaltyProgram

A loyalty program shared across a merchant group.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
MerchantGroupId	Int32	int			✓
MinPointsToRedeem	Decimal	decimal(18,2)
Name	String	nvarchar(100)
PointsNewActivation	Decimal	decimal(18,2)
PointsPerDollar	Decimal	decimal(18,4)
PublicId	String	varchar(32)
RedemptionRate	Decimal	decimal(18,4)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.GroupLoyaltyProgramMerchant

Which merchants participate in a group program (join).

Column	Type	Provider	PK	FK
Id	Int32	int	✓
GroupLoyaltyProgramId	Int32	int		✓
MerchantId	Int32	int		✓

dbo.GroupLoyaltyTransaction

Points earn/redeem entry across the group.

Column	Type	Provider	Null	PK	FK	Enum
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
EmployeeName	String	nvarchar(100)	✓
GroupLoyaltyAccountId	Int64	bigint			✓
MerchantGroupId	Int32	int
Points	Decimal	decimal(18,2)
Reference	String	nvarchar(50)	✓
SaleAmount	Decimal	decimal(18,2)	✓
SourceLocationName	String	nvarchar(100)
SourceMerchantId	Int32	int			✓
SourceSaleGlobalId	Guid	uniqueidentifier	✓
TransactionType	LoyaltyTransactionType	tinyint				LoyaltyTransactionType

Modules & Features

dbo.MerchantFeatureFlag

Per-merchant feature toggle / override value.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
FeatureKey	String	varchar(100)
IsEnabled	Boolean	bit
MerchantId	Int32	int			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
Value	String	nvarchar(500)	✓

dbo.MerchantModule

Which modules a merchant has activated.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
ActivatedAtUtc	DateTime	datetime2(3)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DeactivatedAtUtc	DateTime	datetime2(3)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
MerchantId	Int32	int			✓
ModuleDefinitionId	Int32	int			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ModuleDefinition

Catalog of platform modules (core + vertical add-ons); seeded.

Column	Type	Provider	Null	PK	Enum
Id	Int32	int		✓
Category	String	varchar(30)
Classification	ModuleClassification	tinyint			ModuleClassification
Code	String	varchar(50)
Description	String	nvarchar(500)
IsCore	Boolean	bit
Name	String	nvarchar(100)
PublicId	String	varchar(32)
SortOrder	Int32	int
VerticalAffinity	IndustryTemplate	tinyint	✓		IndustryTemplate

Notifications

email.EmailEvent

Delivery/engagement event for a sent email (delivered, opened, bounced).

Column	Type	Provider	Null	PK	FK
Id	Int64	bigint		✓
EventType	String	nvarchar(100)
OutboxId	Int64	bigint	✓		✓
ProviderMessageId	String	nvarchar(200)	✓
RawPayload	String	nvarchar(max)
ReceivedAt	DateTime	datetime2(3)

email.EmailOutbox

Queued outbound email pending send (transactional outbox).

Column	Type	Provider	Null	PK	Enum
Id	Int64	bigint		✓
AttemptCount	Int32	int
CreatedAtUtc	DateTime	datetime2(3)
IdempotencyKey	Guid	uniqueidentifier
LastError	String	nvarchar(2000)	✓
MerchantId	Int32	int	✓
NextAttemptAt	DateTime	datetime2(3)
Payload	String	nvarchar(max)
ProviderMessageId	String	nvarchar(200)	✓
Status	EmailOutboxStatus	tinyint			EmailOutboxStatus
UpdatedAtUtc	DateTime	datetime2(3)

dbo.NotificationTemplate

Email/SMS message template, scoped and versioned by channel/language.

Column	Type	Provider	Null	PK	Enum
Id	Int32	int		✓
BodyHtml	String	nvarchar(max)
BodyText	String	nvarchar(max)	✓
Channel	NotificationChannel	tinyint			NotificationChannel
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
IsSystemTemplate	Boolean	bit
Language	String	varchar(10)
Name	String	nvarchar(200)
PublicId	String	varchar(32)
RequiredVariables	String	nvarchar(500)	✓
Scope	TemplateScope	tinyint			TemplateScope
ScopeId	Int32	int	✓
Subject	String	nvarchar(500)	✓
TemplateKey	String	varchar(100)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.NotificationTemplateVersion

Historical version snapshot of a notification template.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
BodyHtml	String	nvarchar(max)
BodyText	String	nvarchar(max)	✓
ChangeReason	String	nvarchar(500)	✓
ChangedAtUtc	DateTime	datetime2(3)
ChangedByUserId	String	nvarchar(450)
Subject	String	nvarchar(500)	✓
TemplateId	Int32	int			✓

Partners & Merchants

dbo.Database

A provisioned SQL database (shared or dedicated) for merchant data.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DatabaseName	String	varchar(100)
DatabaseServerId	Int32	int			✓
ElasticPoolName	String	varchar(100)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
IsProvisioned	Boolean	bit
IsShared	Boolean	bit
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.DatabaseServer

A SQL Server/instance that hosts merchant databases.

Column	Type	Provider	Null	PK
Id	Int32	int		✓
ConnectionTemplate	String	varchar(500)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Provider	String	varchar(20)
PublicId	String	varchar(32)
ServerName	String	varchar(100)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.Merchant

A merchant (business/store operator) onboarded under a partner.

Column	Type	Provider	Null	PK	FK	Enum
Id	Int32	int		✓
City	String	nvarchar(100)	✓
Code	String	varchar(20)
ContactEmail	String	nvarchar(256)	✓
ContactName	String	nvarchar(200)	✓
ContactPhone	String	varchar(20)	✓
CountryCode	String	char(2)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DefaultTimeZoneId	String	varchar(50)
IndustryTemplate	IndustryTemplate	tinyint				IndustryTemplate
IsActive	Boolean	bit
IsDeleted	Boolean	bit
MerchantGroupId	Int32	int	✓		✓
Name	String	nvarchar(100)
Notes	String	nvarchar(2000)	✓
PartnerId	Int32	int			✓
PublicId	String	varchar(32)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.MerchantDatabase

Maps a merchant to the physical Merchant DB that holds its data.

Column	Type	Provider	Null	PK	FK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DatabaseId	Int32	int			✓
IsDeleted	Boolean	bit
MerchantId	Int32	int			✓
PublicId	String	varchar(32)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.MerchantGroup

Groups merchants under one owner for shared loyalty/gift cards.

Column	Type	Provider	Null	PK
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GroupCode	String	varchar(20)
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(200)
PublicId	String	varchar(32)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.Partner

Reseller/channel partner that owns a book of merchants.

Column	Type	Provider	Null	PK
Id	Int32	int		✓
Code	String	varchar(50)
ContactEmail	String	varchar(256)	✓
ContactName	String	nvarchar(200)	✓
ContactPhone	String	varchar(20)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
IsHousePartner	Boolean	bit
Name	String	nvarchar(200)
Notes	String	nvarchar(max)	✓
PublicId	String	varchar(32)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PartnerUser

Links an identity user to a partner with a partner-scoped role.

Column	Type	Provider	Null	PK	FK	Enum
Id	Int32	int		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
PartnerId	Int32	int			✓
Role	PartnerRole	varchar(30)				PartnerRole
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UserId	String	nvarchar(450)			✓

Merchant Database

Accounts Receivable

dbo.Account

A house/charge account (credit terms, balance).

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AccountGroupId	Int64	bigint			✓
AccountNumber	String	varchar(30)
ContactEmail	String	varchar(254)	✓
ContactName	String	nvarchar(150)	✓
ContactPhone	String	varchar(30)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CreditLimit	Decimal	decimal(18,2)
CreditLimitEnforcement	CreditLimitEnforcement	tinyint				CreditLimitEnforcement
CurrentBalance	Decimal	decimal(18,2)
FinanceChargeAnnualRate	Decimal	decimal(7,4)
FinanceChargeCompounding	Boolean	bit
FinanceChargeMinimum	Decimal	decimal(18,2)
GlobalId	Guid	uniqueidentifier
GracePeriodDays	Int32	int
IsDeleted	Boolean	bit
Name	String	nvarchar(150)
PaymentTermsDueDays	Int32	int
PaymentTermsType	PaymentTermsType	tinyint				PaymentTermsType
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Status	AccountStatus	tinyint				AccountStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.AccountContact

A person authorized on an account.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AccountId	Int64	bigint			✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CustomerId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
IsPrimary	Boolean	bit
Role	String	varchar(30)
RowVersion	Byte[]	rowversion
SpendingLimit	Decimal	decimal(18,2)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.AccountGroup

A grouping of accounts with default terms.

Column	Type	Provider	Null	PK	Enum
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
Code	String	varchar(20)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DefaultPaymentTermsDueDays	Int32	int
DefaultPaymentTermsType	PaymentTermsType	tinyint			PaymentTermsType
Description	String	nvarchar(500)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.AccountLedger

A ledger entry (charge/payment) on an account.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AccountId	Int64	bigint			✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CustomerId	Int64	bigint	✓		✓
DueDate	DateOnly	date
EntryType	AccountLedgerEntryType	tinyint				AccountLedgerEntryType
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsOpen	Boolean	bit
IsPositive	Boolean	bit
Notes	String	nvarchar(500)	✓
OrderId	Int64	bigint	✓		✓
PaymentMethodId	Int64	bigint	✓		✓
PostingDate	DateOnly	date
PublicId	String	varchar(32)
ReasonCodeId	Int64	bigint	✓		✓
Reference	String	varchar(100)	✓
RowVersion	Byte[]	rowversion
SaleId	Int64	bigint	✓		✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.AccountLedgerDetail

Application/running-balance detail linking ledger entries.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AccountId	Int64	bigint			✓
AccountLedgerId	Int64	bigint			✓
Amount	Decimal	decimal(18,2)
AppliedAmount	Decimal	decimal(18,2)	✓
AppliedToDetailId	Int64	bigint	✓		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
RowVersion	Byte[]	rowversion
RunningBalance	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.AccountStatement

A generated periodic account statement.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AccountId	Int64	bigint			✓
ClosingBalance	Decimal	decimal(18,2)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
FinanceChargeAmount	Decimal	decimal(18,2)
GeneratedByEmployeeId	Int64	bigint	✓		✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
OpeningBalance	Decimal	decimal(18,2)
PeriodEndDate	DateOnly	date
PeriodStartDate	DateOnly	date
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
StatementDate	DateOnly	date
StatementNumber	Int32	int
Status	AccountStatementStatus	tinyint				AccountStatementStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Audit

dbo.AuditEntry

Per-tenant change-history audit trail.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
Action	String	varchar(10)
ChangedByDisplayName	String	nvarchar(100)	✓
ChangedByUserId	Int32	int	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EntityId	Int64	bigint
EntityType	String	varchar(50)
GlobalId	Guid	uniqueidentifier
IpAddress	String	varchar(45)	✓
IsDeleted	Boolean	bit
NewValuesJson	String	nvarchar(max)	✓
OldValuesJson	String	nvarchar(max)	✓
RowVersion	Byte[]	rowversion
Source	String	varchar(20)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Customers & Loyalty

dbo.Coupon

A coupon code tied to a promotion with usage limits.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Code	String	varchar(50)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CurrentUses	Int32	int
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
MaxUses	Int32	int	✓
PromotionId	Int64	bigint			✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.Customer

A customer record.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AccountNumber	String	varchar(50)
CertExpiryDate	DateTime	datetime2(3)	✓
CertIssuedDate	DateTime	datetime2(3)	✓
CertNumber	String	varchar(50)	✓
Company	String	nvarchar(200)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CustomFields	String	nvarchar(max)
DefaultDiscountPercent	Decimal	decimal(5,2)	✓
Email	String	nvarchar(200)	✓
FirstName	String	nvarchar(100)
GlobalId	Guid	uniqueidentifier
HasConflict	Boolean	bit
IsActive	Boolean	bit
IsDeleted	Boolean	bit
LastName	String	nvarchar(100)
MergedAtUtc	DateTime	datetime2	✓
MergedIntoCustomerId	Int64	bigint	✓
Phone	String	varchar(30)	✓
PriceTierId	Int64	bigint	✓		✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
TaxExempt	Boolean	bit
TaxProfileId	Int64	bigint	✓		✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.CustomerAddress

An address for a customer.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Address1	String	nvarchar(200)	✓
Address2	String	nvarchar(200)	✓
AddressType	String	varchar(20)
City	String	nvarchar(100)	✓
Country	String	char(2)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CustomerId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDefault	Boolean	bit
IsDeleted	Boolean	bit
PostalCode	String	varchar(20)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
State	String	nvarchar(100)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.CustomerStats

Aggregated purchase metrics per customer.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CustomerId	Int64	bigint			✓
FirstVisitUtc	DateTime	datetime2	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LastVisitUtc	DateTime	datetime2	✓
LifetimeValue	Decimal	decimal(18,2)
RowVersion	Byte[]	rowversion
TotalReturns	Decimal	decimal(18,2)
TotalSales	Decimal	decimal(18,2)
TotalVisits	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.GiftCard

A gift card and its balance.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CardNumber	String	varchar(25)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CurrentBalance	Decimal	decimal(18,2)
ExpirationDate	DateOnly	date	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
OriginalAmount	Decimal	decimal(18,2)
ProductId	Int64	bigint	✓		✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Status	GiftCardStatus	tinyint				GiftCardStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.GiftCardActivity

Activity entry against a gift card (issue/redeem/reload).

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ActivityType	GiftCardActivityType	tinyint				GiftCardActivityType
Amount	Decimal	decimal(18,2)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GiftCardId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Notes	String	varchar(200)	✓
RowVersion	Byte[]	rowversion
RunningBalance	Decimal	decimal(18,2)
SaleId	Int64	bigint	✓		✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.LoyaltyAccount

A customer's balance in a loyalty program.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CustomerId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LifetimePoints	Decimal	decimal(18,2)
LoyaltyProgramId	Int64	bigint			✓
PointsBalance	Decimal	decimal(18,2)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Status	LoyaltyAccountStatus	tinyint				LoyaltyAccountStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.LoyaltyProgram

A per-merchant loyalty program config.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
MinPointsToRedeem	Decimal	decimal(18,2)
Name	String	nvarchar(100)
PointsNewActivation	Decimal	decimal(18,2)
PointsPerDollar	Decimal	decimal(18,4)
PublicId	String	varchar(32)
RedemptionRate	Decimal	decimal(18,4)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.LoyaltyTransaction

Points earn/redeem entry.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LoyaltyAccountId	Int64	bigint			✓
Notes	String	nvarchar(500)	✓
Points	Decimal	decimal(18,2)
Reference	String	varchar(100)	✓
RowVersion	Byte[]	rowversion
SaleAmount	Decimal	decimal(18,2)	✓
SaleId	Int64	bigint	✓		✓
TransactionType	LoyaltyTransactionType	tinyint				LoyaltyTransactionType
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.Promotion

A discount/promotion definition.

Column	Type	Provider	Null	PK	Enum
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)	✓
DiscountType	PromotionDiscountType	tinyint			PromotionDiscountType
DiscountValue	Decimal	decimal(18,4)
EndDateUtc	DateTime	datetime2	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(200)
Priority	Int32	int
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
StartDateUtc	DateTime	datetime2	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PromotionRule

A condition/reward rule within a promotion.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
FreeQuantity	Int32	int	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
PromotionId	Int64	bigint			✓
RequiredQuantity	Int32	int	✓
RowVersion	Byte[]	rowversion
TargetId	Int64	bigint	✓
TargetType	PromotionTargetType	tinyint				PromotionTargetType
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Employees & Time

dbo.Employee

An employee/POS operator with PIN and security level.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DefaultCommissionPercent	Decimal	decimal(5,2)	✓
Email	String	nvarchar(200)	✓
EmployeeCode	String	varchar(50)
FirstName	String	nvarchar(100)
GlobalId	Guid	uniqueidentifier
HireDate	DateTime	datetime2(3)
IsActive	Boolean	bit
IsDeleted	Boolean	bit
LastName	String	nvarchar(100)
Phone	String	nvarchar(30)	✓
PinEncrypted	Byte[]	varbinary(64)	✓
PinHash	String	varchar(128)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
SecurityLevel	Int32	int
TerminationDate	DateTime	datetime2(3)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.EmployeeRole

An employee's role at a location.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EmployeeId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
RoleName	String	nvarchar(50)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.JobRole

A pay/job role for an employee at a location.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Code	String	varchar(30)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EmployeeId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
Name	String	nvarchar(100)
PayRate	Decimal	decimal(18,2)	✓
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TimeBreak

A break within a time entry.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
BreakEndUtc	DateTime	datetime2(3)	✓
BreakStartUtc	DateTime	datetime2(3)
BreakType	BreakType	tinyint				BreakType
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DurationMinutes	Int32	int
GlobalId	Guid	uniqueidentifier
IsAutoClosed	Boolean	bit
IsDeleted	Boolean	bit
Notes	String	nvarchar(500)	✓
RowVersion	Byte[]	rowversion
Source	String	varchar(20)
TimeEntryId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TimeEntry

A clock-in/clock-out time record.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AdjustedByEmployeeId	Int64	bigint	✓
BreakMinutes	Int32	int
ClockInPhotoOverrideByEmployeeId	Int64	bigint	✓
ClockInPhotoOverrideReason	String	nvarchar(120)	✓
ClockInPhotoUrl	String	nvarchar(500)	✓
ClockInUtc	DateTime	datetime2(3)
ClockOutPhotoOverrideByEmployeeId	Int64	bigint	✓
ClockOutPhotoOverrideReason	String	nvarchar(120)	✓
ClockOutPhotoUrl	String	nvarchar(500)	✓
ClockOutUtc	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EmployeeId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
JobRoleId	Int64	bigint	✓		✓
LocationId	Int64	bigint			✓
Notes	String	nvarchar(500)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Source	String	varchar(20)
Status	TimeEntryStatus	tinyint				TimeEntryStatus
TotalHours	Decimal	decimal(8,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Inventory & Adjustments

dbo.InventoryAdjustment

A stock adjustment document.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AdjustmentDate	DateTime	datetime2(3)
ClosedByEmployeeId	Int64	bigint	✓
ClosedDate	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DocumentNumber	String	varchar(20)
EmployeeId	Int64	bigint	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
Notes	String	nvarchar(500)	✓
PublicId	String	varchar(32)
ReasonCodeId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
Status	AdjustmentStatus	tinyint				AdjustmentStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.InventoryAdjustmentLine

A variant's quantity change within an adjustment.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
InventoryAdjustmentId	Int64	bigint			✓
IsDeleted	Boolean	bit
LineNumber	Int32	int
Notes	String	nvarchar(200)	✓
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
QuantityChange	Decimal	decimal(10,4)
RowVersion	Byte[]	rowversion
UnitCost	Decimal	decimal(18,4)
UnitPrice	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.InventoryMovement

Append-only ledger of every stock movement.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DocumentNumber	String	varchar(20)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
MovementType	MovementType	tinyint				MovementType
ProductVariantId	Int64	bigint			✓
Quantity	Decimal	decimal(18,4)
ReferenceId	Int64	bigint	✓
ReferenceType	String	varchar(20)	✓
RowVersion	Byte[]	rowversion
UnitCost	Decimal	decimal(18,4)
UnitPrice	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.LocationProduct

Per-location stock, cost, price and reorder settings for a variant.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Cost	Decimal	decimal(18,4)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
LastReceivedDate	DateTime	datetime2(3)	✓
LastSoldDate	DateTime	datetime2(3)	✓
LocationId	Int64	bigint			✓
Price	Decimal	decimal(18,2)	✓
PriceChangedDate	DateTime	datetime2(3)	✓
ProductVariantId	Int64	bigint			✓
QuantityOnHand	Decimal	decimal(18,4)
QuantityReserved	Decimal	decimal(18,4)
ReorderPoint	Decimal	decimal(18,4)
RestockLevel	Decimal	decimal(18,4)
RowVersion	Byte[]	rowversion
TaxGroupId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.StockCount

A physical inventory count document.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ClosedByEmployeeId	Int64	bigint	✓
ClosedDate	DateTime	datetime2(3)	✓
CountDate	DateTime	datetime2(3)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DocumentNumber	String	varchar(20)
EmployeeId	Int64	bigint	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
Notes	String	nvarchar(500)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Status	StockCountStatus	tinyint				StockCountStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.StockCountItem

A counted variant line (counted vs system qty).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CountedQuantity	Decimal	decimal(18,4)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
StockCountId	Int64	bigint			✓
SystemQuantity	Decimal	decimal(18,4)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
Variance	Decimal	decimal(18,4)

Labels & Printing

dbo.LabelSize

Physical label stock dimensions (preset or custom).

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GapMm	Decimal	decimal(8,2)
GlobalId	Guid	uniqueidentifier
HeightMm	Decimal	decimal(8,2)
IsActive	Boolean	bit
IsDeleted	Boolean	bit
IsPreset	Boolean	bit
Name	String	nvarchar(100)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
WidthMm	Decimal	decimal(8,2)

dbo.LabelTemplate

Printable label layout bound to a label size.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDefault	Boolean	bit
IsDeleted	Boolean	bit
LabelSizeId	Int64	bigint			✓
Name	String	nvarchar(100)
PrinterLanguage	PrinterLanguage	tinyint				PrinterLanguage
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
TemplateBody	String	nvarchar(max)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PrintJob

A label print job and its progress.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CompletedAtUtc	DateTime	datetime2	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LabelTemplateId	Int64	bigint			✓
LocationId	Int64	bigint			✓
PrintedCount	Int32	int
RowVersion	Byte[]	rowversion
Status	PrintJobStatus	tinyint				PrintJobStatus
TotalLabels	Int32	int
TriggeredBy	PrintJobTrigger	tinyint				PrintJobTrigger
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Locations, Terminals & Settings

dbo.Location

A physical store/location.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Address1	String	nvarchar(200)	✓
Address2	String	nvarchar(200)	✓
City	String	nvarchar(100)	✓
Country	String	char(2)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DefaultCurrencyId	Int64	bigint	✓		✓
DefaultTaxGroupId	Int64	bigint			✓
DefaultTimeZoneId	String	varchar(50)	✓
Email	String	nvarchar(200)	✓
GlobalId	Guid	uniqueidentifier
InitializedAtUtc	DateTime	datetime2(3)	✓
InitializedByUserId	String	nvarchar(450)	✓
InitializedFromLocationId	Int64	bigint	✓		✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
LocationType	String	varchar(20)
Name	String	nvarchar(100)
Phone	String	varchar(30)	✓
PostalCode	String	varchar(20)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
State	String	nvarchar(100)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.LocationGroup

A named group of locations.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.LocationGroupMember

Membership of a location in a group (join).

Column	Type	Provider	PK	FK
MerchantId	Int32	int	✓	✓
Id	Int64	bigint	✓
CreatedAtUtc	DateTime	datetime2(3)
LocationGroupId	Int64	bigint		✓
LocationId	Int64	bigint		✓

dbo.LocationSetting

Key/value setting scoped to a location.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
LocationId	Int64	bigint			✓
SettingKey	String	varchar(100)
SettingValue	String	nvarchar(max)	✓
UpdatedAtUtc	DateTime	datetime2(3)

dbo.MerchantSetting

Key/value setting scoped to the merchant.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
SettingKey	String	varchar(100)
SettingValue	String	nvarchar(max)	✓
UpdatedAtUtc	DateTime	datetime2(3)

dbo.Terminal

A POS terminal/register at a location.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
Model	String	nvarchar(100)	✓
Name	String	nvarchar(100)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
SerialNumber	String	varchar(50)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TerminalSetting

Key/value setting scoped to a terminal.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
SettingKey	String	varchar(100)
SettingValue	String	nvarchar(max)	✓
TerminalId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)

Orders & Quotes

dbo.Order

A quote/order/layaway that can convert to a sale.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
BalanceDue	Decimal	decimal(18,2)
ConvertedSaleId	Int64	bigint	✓		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CustomerId	Int64	bigint	✓		✓
DepositTotal	Decimal	decimal(18,2)
DueDate	DateTime	datetime2(3)	✓
EmployeeId	Int64	bigint	✓
ExpiresAtUtc	DateTime	datetime2(3)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsSynced	Boolean	bit
LocationId	Int64	bigint			✓
Notes	String	nvarchar(500)	✓
OrderDateUtc	DateTime	datetime2(3)
OrderNumber	String	varchar(50)
OrderType	OrderType	tinyint				OrderType
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Status	OrderStatus	tinyint				OrderStatus
SubTotal	Decimal	decimal(18,2)
TaxTotal	Decimal	decimal(18,2)
Total	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.OrderHistory

Status/action history for an order.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Action	String	nvarchar(50)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EmployeeId	Int64	bigint	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Notes	String	nvarchar(500)	✓
OrderId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.OrderLineItem

A line on an order.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DiscountAmount	Decimal	decimal(18,2)
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LineNumber	Int32	int
LineTotal	Decimal	decimal(18,2)
Notes	String	nvarchar(200)	✓
OrderId	Int64	bigint			✓
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
Quantity	Decimal	decimal(18,4)
RowVersion	Byte[]	rowversion
UnitPrice	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.OrderPayment

A deposit/payment recorded against an order.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Amount	Decimal	decimal(18,2)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Notes	String	nvarchar(200)	✓
OrderId	Int64	bigint			✓
PaymentDateUtc	DateTime	datetime2(3)
PaymentMethodId	Int64	bigint			✓
ReferenceNumber	String	nvarchar(100)	✓
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Pricing, Barcodes & Cost

dbo.CostChange

Audit of product cost changes over time.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ChangeType	CostChangeType	tinyint				CostChangeType
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EmployeeId	Int64	bigint	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
NewCost	Decimal	decimal(18,4)
Notes	String	nvarchar(200)	✓
OldCost	Decimal	decimal(18,4)
ProductVariantId	Int64	bigint			✓
ReferenceId	Int64	bigint	✓
ReferenceType	String	varchar(20)	✓
RowVersion	Byte[]	rowversion
SupplierId	Int64	bigint	✓		✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PriceChange

A (approvable) batch price change document.

Column	Type	Provider	Null	PK	Enum
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
AppliedDate	DateTime	datetime2(3)	✓
ApprovedByEmployeeId	Int64	bigint	✓
ApprovedDate	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByEmployeeId	Int64	bigint	✓
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(200)
DocumentNumber	String	varchar(20)
EffectiveDate	DateTime	datetime2(3)
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsGlobal	Boolean	bit
Notes	String	nvarchar(500)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Status	PriceChangeStatus	tinyint			PriceChangeStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PriceChangeLine

A variant's old/new price within a price change.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Multiplier	Decimal	decimal(8,4)	✓
NewPrice	Decimal	decimal(18,2)	✓
OldPrice	Decimal	decimal(18,2)
PriceChangeId	Int64	bigint			✓
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PriceChangeLocation

Restricts a price change to specific locations (join).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
PriceChangeId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PriceTier

A named customer/price tier.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
Code	String	varchar(20)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ProductBarcode

Additional barcodes mapped to a variant.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Barcode	String	varchar(50)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsPrimary	Boolean	bit
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ProductPrice

Tier-specific price for a variant.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Price	Decimal	decimal(18,2)
PriceTierId	Int64	bigint			✓
ProductVariantId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Product & Catalog

dbo.Category

Product category, optionally hierarchical.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
ParentCategoryId	Int64	bigint	✓		✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.KitComponent

Component line of a kit/bundle product.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ComponentPrice	Decimal	decimal(18,2)	✓
ComponentProductVariantId	Int64	bigint			✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
ProductId	Int64	bigint			✓
Quantity	Decimal	decimal(18,4)
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.Product

Sellable/stockable product master (the catalog head).

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AllowFractionalQty	Boolean	bit
BundleType	BundleType	tinyint				BundleType
CanBeSold	Boolean	bit
CategoryId	Int64	bigint	✓		✓
CommissionMode	CommissionMode	tinyint	✓			CommissionMode
CommissionValue	Decimal	decimal(18,4)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CustomFields	String	nvarchar(max)
Description	String	nvarchar(2000)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsEbtEligible	Boolean	bit
LockQuantityAtPos	Boolean	bit
MSRP	Decimal	decimal(18,2)	✓
Name	String	nvarchar(200)
PromptVariantAtPos	Boolean	bit
PublicId	String	varchar(32)
RequiresManualPrice	Boolean	bit
RowVersion	Byte[]	rowversion
SellingUoMId	Int64	bigint	✓		✓
Status	ProductStatus	tinyint				ProductStatus
StockingUoMId	Int64	bigint	✓		✓
TagAlongProductId	Int64	bigint	✓		✓
TagAlongQuantity	Decimal	decimal(10,3)	✓
TareWeight	Decimal	decimal(10,3)	✓
TareWeightPercent	Decimal	decimal(5,2)	✓
TaxGroupId	Int64	bigint	✓		✓
TrackInventory	Boolean	bit
TrackSerialNumbers	Boolean	bit
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UseComponentPrice	Boolean	bit

dbo.ProductAlert

POS alert/prompt attached to a product (age check, message).

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AlertType	AlertType	tinyint				AlertType
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Message	String	nvarchar(500)	✓
MinimumAge	Byte	tinyint	✓
ProductId	Int64	bigint			✓
PublicId	String	varchar(32)
RequireAcknowledgement	Boolean	bit
RowVersion	Byte[]	rowversion
Title	String	nvarchar(100)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ProductCategory

Additional product-to-category memberships (join).

Column	Type	Provider	PK	FK
MerchantId	Int32	int	✓	✓
ProductId	Int64	bigint	✓	✓
CategoryId	Int64	bigint	✓	✓
SortOrder	Int32	int

dbo.ProductImage

Image attached to a product.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AltText	String	nvarchar(200)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsPrimary	Boolean	bit
ProductId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
Url	String	nvarchar(500)

dbo.ProductOption

An option/axis (e.g. Size, Color) for a product's variants.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
ProductId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ProductOptionValue

A value within a product option (e.g. Small, Red).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
ProductOptionId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
Value	String	nvarchar(100)

dbo.ProductSaleWindow

Time/day windows restricting when a product can be sold.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DaysOfWeek	Byte	tinyint	✓
EndUtc	DateTime	datetime2(3)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
ProductId	Int64	bigint			✓
Reason	String	nvarchar(200)	✓
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
StartUtc	DateTime	datetime2(3)	✓
TimeEnd	TimeOnly	time	✓
TimeStart	TimeOnly	time	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
WindowType	SaleWindowType	tinyint				SaleWindowType

dbo.ProductVariant

A specific sellable variant of a product (SKU-level).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Barcode	String	varchar(50)	✓
Cost	Decimal	decimal(18,4)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
ImageUrl	String	nvarchar(500)	✓
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Price	Decimal	decimal(18,2)
PriceLowerBound	Decimal	decimal(18,2)	✓
PriceUpperBound	Decimal	decimal(18,2)	✓
ProductId	Int64	bigint			✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Sku	String	varchar(50)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
Weight	Decimal	decimal(18,4)	✓

dbo.ProductVariantOptionValue

Maps a variant to its chosen option values (join).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
ProductOptionValueId	Int64	bigint			✓
ProductVariantId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ProductWebListing

E-commerce listing/sync state for a product on a platform.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
ExternalProductId	String	varchar(100)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LastSyncError	String	nvarchar(500)	✓
LastSyncedUtc	DateTime	datetime2(3)	✓
Metafields	String	nvarchar(max)	✓
OnlineDescription	String	nvarchar(max)	✓
Platform	WebPlatform	tinyint				WebPlatform
ProductId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
Slug	String	varchar(200)
SyncStatus	WebListingSyncStatus	tinyint	✓			WebListingSyncStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Purchasing, Suppliers & Receiving

dbo.Distribution

Distributes a received shipment across locations.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ClosedByEmployeeId	Int64	bigint	✓
ClosedDate	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DistributionDate	DateTime	datetime2(3)
DocumentNumber	String	varchar(20)
EmployeeId	Int64	bigint	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Notes	String	nvarchar(500)	✓
PublicId	String	varchar(32)
PurchaseReceiptId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
SourceLocationId	Int64	bigint			✓
Status	DistributionStatus	tinyint				DistributionStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.DistributionAllocation

Allocation of a distribution line to a destination location.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AcknowledgedByEmployeeId	Int64	bigint	✓
AcknowledgedDate	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DistributionLineId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
Quantity	Decimal	decimal(10,4)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.DistributionLine

A variant line to be distributed.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
AllocatedQuantity	Decimal	decimal(10,4)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DistributionId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
PurchaseReceiptLineId	Int64	bigint	✓		✓
RowVersion	Byte[]	rowversion
TotalQuantity	Decimal	decimal(10,4)
UnitCost	Decimal	decimal(18,4)
UnitPrice	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ProductSupplier

Supplier sourcing info for a product (cost, SKU, pack size).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsPrimary	Boolean	bit
MinimumOrder	Decimal	decimal(18,4)	✓
ProductId	Int64	bigint			✓
PurchasingUoMId	Int64	bigint	✓		✓
RowVersion	Byte[]	rowversion
SupplierCost	Decimal	decimal(18,4)	✓
SupplierId	Int64	bigint			✓
SupplierSku	String	varchar(50)	✓
UnitsPerPurchaseUoM	Decimal	decimal(18,6)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PurchaseOrder

A purchase order to a supplier.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ClosedByEmployeeId	Int64	bigint	✓
ClosedDate	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DocumentNumber	String	varchar(20)
EmployeeId	Int64	bigint	✓
ExpectedDate	DateTime	datetime2(3)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
Notes	String	nvarchar(500)	✓
OrderDate	DateTime	datetime2(3)
PublicId	String	varchar(32)
QuantityInvoiced	Decimal	decimal(18,4)
QuantityToInvoice	Decimal	decimal(18,4)
RowVersion	Byte[]	rowversion
Status	PurchaseOrderStatus	tinyint				PurchaseOrderStatus
SubTotal	Decimal	decimal(18,2)
SupplierId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PurchaseOrderLine

An ordered variant line on a PO.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LineNumber	Int32	int
LineTotal	Decimal	decimal(18,2)
Notes	String	nvarchar(200)	✓
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
PurchaseOrderId	Int64	bigint			✓
PurchasingUoMId	Int64	bigint	✓		✓
QuantityInvoiced	Decimal	decimal(10,4)
QuantityOrdered	Decimal	decimal(10,4)
QuantityReceived	Decimal	decimal(10,4)
QuantityToInvoice	Decimal	decimal(10,4)
QuantityToReceive	Decimal	decimal(10,4)
RowVersion	Byte[]	rowversion
UnitCost	Decimal	decimal(18,4)
UnitsPerPurchaseUoM	Decimal	decimal(10,4)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PurchaseReceipt

Goods-received document (optionally against a PO).

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ClosedByEmployeeId	Int64	bigint	✓
ClosedDate	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DocumentNumber	String	varchar(20)
EmployeeId	Int64	bigint	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
Notes	String	nvarchar(500)	✓
PublicId	String	varchar(32)
PurchaseOrderId	Int64	bigint	✓		✓
ReceiptDate	DateTime	datetime2(3)
RowVersion	Byte[]	rowversion
Status	PurchaseReceiptStatus	tinyint				PurchaseReceiptStatus
SupplierId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PurchaseReceiptLine

A received variant line.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LineNumber	Int32	int
Notes	String	nvarchar(200)	✓
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
PurchaseOrderLineId	Int64	bigint	✓		✓
PurchaseReceiptId	Int64	bigint			✓
PurchasingUoMId	Int64	bigint	✓		✓
QuantityInStockingUoM	Decimal	decimal(10,4)
QuantityReceived	Decimal	decimal(10,4)
RowVersion	Byte[]	rowversion
UnitCost	Decimal	decimal(18,4)
UnitPrice	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.Supplier

A vendor/supplier master.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
AccountNumber	String	varchar(50)	✓
Address1	String	nvarchar(200)	✓
Address2	String	nvarchar(60)	✓
City	String	nvarchar(100)	✓
Country	String	char(2)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
Notes	String	nvarchar(1000)	✓
Phone	String	varchar(16)	✓
PostalCode	String	varchar(20)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
State	String	nvarchar(100)	✓
TaxNumber	String	varchar(30)	✓
Terms	String	nvarchar(50)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
Website	String	nvarchar(255)	✓

dbo.SupplierContact

A contact person at a supplier.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Email	String	varchar(255)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
IsPrimary	Boolean	bit
Name	String	nvarchar(120)
Ordinal	Int32	int
Phone	String	varchar(16)	✓
PhoneExt	String	varchar(10)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
SupplierId	Int64	bigint			✓
Title	String	nvarchar(120)	✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Reference / Lookup

dbo.Currency

A currency the merchant transacts in.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CurrencyCode	String	varchar(3)
DecimalPlaces	Int32	int
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
Symbol	String	nvarchar(5)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.CustomFieldDefinition

Defines a custom field for an entity type.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DataType	String	varchar(20)
DefaultValue	String	nvarchar(500)	✓
EntityType	String	varchar(50)
FieldKey	String	varchar(50)
FieldName	String	nvarchar(100)
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsRequired	Boolean	bit
IsSearchable	Boolean	bit
Module	String	varchar(50)	✓
Options	String	nvarchar(max)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.DocumentSequence

Per-merchant document-number generator.

Column	Type	Provider	PK
MerchantId	Int32	int	✓
Id	Int32	int	✓
DocumentType	String	varchar(20)
NextNumber	Int32	int
PadLength	Int32	int
Prefix	String	varchar(10)

dbo.ExchangeRate

A dated FX rate between two currencies.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EffectiveDate	DateOnly	date
FromCurrencyId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Rate	Decimal	decimal(18,6)
RowVersion	Byte[]	rowversion
Source	String	varchar(50)
ToCurrencyId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ReasonCode

A reusable reason code (voids, adjustments, movements).

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
Code	String	varchar(30)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
ReasonType	String	varchar(30)
RequiresNote	Boolean	bit
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ReportPin

A pinned/favorite report for quick access in the portal Reports area (team-wide when UserId is null, personal otherwise; Position orders them).

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Position	Int32	int
PublicId	String	varchar(32)
ReportKey	String	nvarchar(64)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
UserId	String	nvarchar(450)	✓

dbo.UnitOfMeasure

A unit of measure (each, case, lb, etc.).

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
Code	String	varchar(10)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DecimalPlaces	Int32	int
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(50)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.UnitOfMeasureConversion

Conversion factor between two units (optionally product-specific).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ConversionFactor	Decimal	decimal(18,6)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
FromUoMId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
ProductId	Int64	bigint	✓
RowVersion	Byte[]	rowversion
ToUoMId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Sales & Transactions

dbo.DailySales

Pre-aggregated (summarized) daily sales totals by dimension/location.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DimensionId	Int64	bigint
DimensionType	String	varchar(30)
DiscountTotal	Decimal	decimal(18,2)
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
ItemCount	Int32	int
LocationId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
SaleDate	DateTime	date
TaxTotal	Decimal	decimal(18,2)
Total	Decimal	decimal(18,2)
TransactionCount	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.PaymentMethod

A configured tender type.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
Code	String	varchar(30)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
OpensCashDrawer	Boolean	bit
PaymentType	String	varchar(30)
RequiresChange	Boolean	bit
RowVersion	Byte[]	rowversion
SortOrder	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ReturnTracking

Links a return line back to the original sold line and quantities.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
OriginalSaleLineItemId	Int64	bigint			✓
PublicId	String	varchar(32)
QuantityReturned	Decimal	decimal(18,4)
QuantitySold	Decimal	decimal(18,4)
ReturnLocationId	Int64	bigint	✓		✓
ReturnSaleLineItemId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.Sale

A completed POS sale/return transaction.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CashierEmployeeId	Int64	bigint	✓
ChangeDue	Decimal	decimal(18,2)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CurrencyId	Int64	bigint	✓		✓
CustomerCertExpiryDate	DateTime	datetime2(3)	✓
CustomerCertNumber	String	varchar(50)	✓
CustomerId	Int64	bigint	✓		✓
DiscountTotal	Decimal	decimal(18,2)
ExchangeRateUsed	Decimal	decimal(18,6)	✓
ForeignCurrencyTotal	Decimal	decimal(18,2)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsSynced	Boolean	bit
LocationId	Int64	bigint			✓
OriginalSaleId	Int64	bigint	✓		✓
PublicId	String	varchar(32)
ReasonCodeId	Int64	bigint	✓
RowVersion	Byte[]	rowversion
SaleDateUtc	DateTime	datetime2(3)
SaleNumber	String	varchar(50)
SaleType	String	varchar(20)
SalesRepEmployeeId	Int64	bigint	✓
ShiftId	Int64	bigint			✓
Status	String	varchar(20)
Subtotal	Decimal	decimal(18,2)
TaxTotal	Decimal	decimal(18,2)
TerminalId	Int64	bigint			✓
Total	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
VoidComment	String	nvarchar(500)	✓

dbo.SaleLineItem

A line on a sale (sale or return).

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CommissionAmount	Decimal	decimal(18,2)	✓
CommissionPercent	Decimal	decimal(5,2)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DiscountAmount	Decimal	decimal(18,2)
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsReturn	Boolean	bit
LineTotal	Decimal	decimal(18,2)
ProductVariantId	Int64	bigint			✓
Quantity	Decimal	decimal(18,4)
ReasonCodeId	Int64	bigint	✓
RowVersion	Byte[]	rowversion
SaleId	Int64	bigint			✓
SalesRepEmployeeId	Int64	bigint	✓
TagAlongFromLineId	Int64	bigint	✓		✓
TaxClassification	TaxClassification	tinyint				TaxClassification
TaxHolidayCode	String	varchar(50)	✓
TaxHolidayId	Int64	bigint	✓		✓
TaxOverrideNotes	String	nvarchar(500)	✓
TaxOverrideReasonCodeCode	String	varchar(50)	✓
TaxOverrideReasonCodeId	Int64	bigint	✓		✓
UnitPrice	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.SalePayment

A tender applied to a sale.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Amount	Decimal	decimal(18,2)
ChangeGiven	Decimal	decimal(18,2)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
PaymentMethodId	Int64	bigint			✓
ReferenceNumber	String	varchar(100)	✓
RowVersion	Byte[]	rowversion
SaleId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.SaleTax

Tax breakdown captured per sale/line.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
RowVersion	Byte[]	rowversion
SaleId	Int64	bigint			✓
SaleLineItemId	Int64	bigint	✓		✓
TaxAmount	Decimal	decimal(18,2)
TaxRateCode	String	varchar(50)
TaxRateId	Int64	bigint			✓
TaxRateName	String	nvarchar(100)
TaxRateValue	Decimal	decimal(8,6)
TaxableAmount	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Shifts, Cash & Reconciliation

dbo.CashMovement

Cash in/out (pay-in, pay-out, drop) during a shift.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Amount	Decimal	decimal(18,2)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EmployeeId	Int64	bigint	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
MovementType	CashMovementType	tinyint				CashMovementType
Notes	String	nvarchar(500)	✓
ReasonCodeId	Int64	bigint	✓
Recipient	String	nvarchar(200)	✓
RowVersion	Byte[]	rowversion
ShiftId	Int64	bigint			✓
ShiftSegmentId	Int64	bigint	✓		✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.NonSaleEvent

Non-sale register events (no-sale, drawer open).

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Comment	String	nvarchar(500)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EmployeeId	Int64	bigint	✓
EventType	NonSaleEventType	tinyint				NonSaleEventType
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
PublicId	String	varchar(32)
ReasonCodeId	Int64	bigint	✓
RowVersion	Byte[]	rowversion
ShiftId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.Shift

A cashier/register shift with reconciliation totals.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
BlindClosedAtUtc	DateTime	datetime2(3)	✓
BusinessDate	DateOnly	date
CardTotal	Decimal	decimal(18,2)
CashTotal	Decimal	decimal(18,2)
ClosedAtUtc	DateTime	datetime2(3)	✓
ClosedByEmployeeId	Int64	bigint	✓		✓
ClosingAmount	Decimal	decimal(18,2)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
CurrentTerminalId	Int64	bigint	✓		✓
CustomerCount	Int32	int
DiscountTotal	Decimal	decimal(18,2)
DroppedTotal	Decimal	decimal(18,2)
EmployeeId	Int64	bigint			✓
ExpectedAmount	Decimal	decimal(18,2)	✓
ExportedAtUtc	DateTime	datetime2(3)	✓
GlobalId	Guid	uniqueidentifier
IsBlindClose	Boolean	bit
IsDeleted	Boolean	bit
IsExported	Boolean	bit
IsSynced	Boolean	bit
LocationId	Int64	bigint			✓
MergedAtUtc	DateTime	datetime2(3)	✓
MergedIntoShiftId	Int64	bigint	✓		✓
NetSalesTotal	Decimal	decimal(18,2)
NoSaleCount	Int32	int
OpenedAtUtc	DateTime	datetime2(3)
OpeningAmount	Decimal	decimal(18,2)	✓
OtherTenderTotal	Decimal	decimal(18,2)
OverShortAmount	Decimal	decimal(18,2)	✓
PaidOutTotal	Decimal	decimal(18,2)
PublicId	String	varchar(32)
ReturnsTotal	Decimal	decimal(18,2)
RowVersion	Byte[]	rowversion
SalesTotal	Decimal	decimal(18,2)
ShiftNumber	String	varchar(50)
SourceId	String	varchar(50)	✓
SourceSystem	SourceSystem	tinyint				SourceSystem
Status	ShiftStatus	tinyint				ShiftStatus
TaxTotal	Decimal	decimal(18,2)
TransactionCount	Int32	int
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
VoidCount	Int32	int

dbo.ShiftCount

A counted tender total vs expected for a shift.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CountType	CountType	tinyint				CountType
CountedAmount	Decimal	decimal(18,2)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
ExpectedAmount	Decimal	decimal(18,2)
ForeignCurrencyAmount	Decimal	decimal(18,2)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
PaymentMethodId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
ShiftId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓
Variance	Decimal	decimal(18,2)

dbo.ShiftSegment

A continuous segment of a shift on a terminal.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
EndReason	SegmentEndReason	tinyint				SegmentEndReason
EndedAtUtc	DateTime	datetime2(3)	✓
EndingCashAmount	Decimal	decimal(18,2)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
IsSynced	Boolean	bit
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
SequenceNumber	Int16	smallint
ShiftId	Int64	bigint			✓
StartedAtUtc	DateTime	datetime2(3)
StartingCashAmount	Decimal	decimal(18,2)	✓
TerminalId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.ShiftTaxTotal

Tax collected during a shift by rate.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
RowVersion	Byte[]	rowversion
ShiftId	Int64	bigint			✓
TaxAmount	Decimal	decimal(18,2)
TaxRateId	Int64	bigint			✓
TaxableAmount	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Sync

dbo.DeviceSyncState

Per-device, per-entity high-water mark for offline sync.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DeviceRegistrationId	Int32	int
EntityType	String	varchar(100)
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LastPullRowVersion	Byte[]	varbinary(8)
LastPullUtc	DateTime	datetime2(3)
LastPushUtc	DateTime	datetime2(3)	✓
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.SyncCommand

A command queued for delivery to a device.

Column	Type	Provider	Null	PK	Enum
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CommandType	String	varchar(50)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DeliveredAtUtc	DateTime	datetime2(3)	✓
DeviceCode	String	varchar(50)	✓
DeviceRegistrationId	Int32	int	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Payload	String	nvarchar(max)	✓
RowVersion	Byte[]	rowversion
Status	SyncCommandStatus	tinyint			SyncCommandStatus
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.SyncLog

A record of a device sync session.

Column	Type	Provider	Null	PK	Enum
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CompletedAtUtc	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DeviceCode	String	varchar(50)
DeviceRegistrationId	Int32	int
EntitiesPulled	Int32	int
EntitiesPushed	Int32	int
ErrorMessage	String	nvarchar(500)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
RowVersion	Byte[]	rowversion
Status	SyncLogStatus	tinyint			SyncLogStatus
SyncType	SyncType	tinyint			SyncType
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Tax Engine

dbo.CustomerTaxProfile

A tax treatment profile (e.g. exempt) assignable to customers.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
PublicId	String	varchar(32)
RequiresCert	Boolean	bit
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.CustomerTaxProfileMap

Remaps a source tax group to a target group for a profile.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
FromTaxGroupId	Int64	bigint	✓		✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
RowVersion	Byte[]	rowversion
TaxProfileId	Int64	bigint			✓
ToTaxGroupId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TaxGroup

A named group of tax rates applied together.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(500)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(100)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TaxGroupRate

Membership of a tax rate in a tax group (join, ordered).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Priority	Int32	int
RowVersion	Byte[]	rowversion
TaxGroupId	Int64	bigint			✓
TaxRateId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TaxHoliday

A tax-holiday period that switches items to another tax group.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
Code	String	varchar(50)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
Description	String	nvarchar(1000)	✓
EndUtc	DateTime	datetime2(3)
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsDeleted	Boolean	bit
Name	String	nvarchar(200)
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
StartUtc	DateTime	datetime2(3)
TimeZone	String	varchar(100)
ToTaxGroupId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TaxHolidayCategory

Categories included in a tax holiday, with price cap.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CategoryId	Int64	bigint			✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
MaxUnitPrice	Decimal	decimal(18,2)	✓
RowVersion	Byte[]	rowversion
TaxHolidayId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TaxHolidayLocation

Locations where a tax holiday applies (join).

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
TaxHolidayId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TaxHolidayProduct

Products included in a tax holiday, with price cap.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
MaxUnitPrice	Decimal	decimal(18,2)	✓
ProductId	Int64	bigint			✓
RowVersion	Byte[]	rowversion
TaxHolidayId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TaxRate

An individual tax rate.

Column	Type	Provider	Null	PK
MerchantId	Int32	int		✓
Id	Int64	bigint		✓
Code	String	varchar(50)
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsActive	Boolean	bit
IsCompounding	Boolean	bit
IsDeleted	Boolean	bit
IsIncludedInPrice	Boolean	bit
Name	String	nvarchar(100)
PublicId	String	varchar(32)
Rate	Decimal	decimal(8,6)
RowVersion	Byte[]	rowversion
ShowOnReceipt	Boolean	bit
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Transfers

dbo.TransferConfirmation

A ship/receive confirmation event against a transfer.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ConfirmationDate	DateTime	datetime2(3)
ConfirmationType	TransferConfirmationType	tinyint				TransferConfirmationType
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DocumentNumber	String	nvarchar(20)
EmployeeId	Int64	bigint	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LocationId	Int64	bigint			✓
Notes	String	nvarchar(500)	✓
PublicId	String	varchar(32)
RowVersion	Byte[]	rowversion
TransferOrderId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TransferConfirmationLine

Per-line quantity delta within a confirmation.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
PublicId	String	varchar(32)
QuantityDamagedDelta	Decimal	decimal(10,4)
QuantityDelta	Decimal	decimal(10,4)
RowVersion	Byte[]	rowversion
TransferConfirmationId	Int64	bigint			✓
TransferOrderLineId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TransferOrder

An inter-location stock transfer document.

Column	Type	Provider	Null	PK	FK	Enum
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
ClosedByEmployeeId	Int64	bigint	✓
ClosedDate	DateTime	datetime2(3)	✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
DocumentNumber	String	varchar(20)
FromLocationId	Int64	bigint			✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
Notes	String	nvarchar(500)	✓
PublicId	String	varchar(32)
ReceivedDate	DateTime	datetime2(3)	✓
RequestDate	DateTime	datetime2(3)
RequestedByEmployeeId	Int64	bigint	✓
RowVersion	Byte[]	rowversion
ShippedDate	DateTime	datetime2(3)	✓
Status	TransferOrderStatus	tinyint				TransferOrderStatus
ToLocationId	Int64	bigint			✓
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

dbo.TransferOrderLine

A variant line on a transfer, with staged quantities.

Column	Type	Provider	Null	PK	FK
MerchantId	Int32	int		✓	✓
Id	Int64	bigint		✓
CreatedAtUtc	DateTime	datetime2(3)
CreatedByUserId	String	nvarchar(450)	✓
GlobalId	Guid	uniqueidentifier
IsDeleted	Boolean	bit
LineNumber	Int32	int
ProductVariantId	Int64	bigint			✓
PublicId	String	varchar(32)
QuantityDamaged	Decimal	decimal(10,4)
QuantityReceived	Decimal	decimal(10,4)
QuantityRequested	Decimal	decimal(10,4)
QuantityShipped	Decimal	decimal(10,4)
RowVersion	Byte[]	rowversion
TransferOrderId	Int64	bigint			✓
UnitCost	Decimal	decimal(18,4)
UnitPrice	Decimal	decimal(18,2)
UpdatedAtUtc	DateTime	datetime2(3)
UpdatedByUserId	String	nvarchar(450)	✓

Enums

AccountLedgerEntryType

Charge = 0
Payment = 1
CreditMemo = 2
DebitMemo = 3
FinanceCharge = 4

AccountStatementStatus

Draft = 0
Sent = 1
Paid = 2
Overdue = 3

AccountStatus

Active = 0
Suspended = 1
Closed = 2

AdjustmentStatus

Draft = 0
Completed = 1
Cancelled = 2

AlertType

AgeVerification = 0
Warning = 1
Info = 2

BreakType

Paid = 0
Unpaid = 1

BundleType

None = 0
Kit = 1
Assembly = 2
Matrix = 3
LotMatrix = 4

CashMovementType

CashDrop = 1
PayIn = 2
PayOut = 3
DrawerCount = 4
DrawerHandoff = 5

CommissionMode

None = 0
PercentOfSale = 1
PercentOfProfit = 2
FixedAmount = 3

CostChangeType

SupplierIncrease = 0
SupplierDecrease = 1
ManualAdjustment = 2
ReceivingVariance = 3

CountType

EndOfShift = 0
TerminalHandoff = 1
ManagerCount = 2

CreditLimitEnforcement

Warn = 0
Block = 1
None = 2

DeviceStatus

Pending = 0
Active = 1
Disabled = 2
Revoked = 3

DeviceType

POS = 0
Kiosk = 1

DistributionStatus

Draft = 0
Allocated = 1
Shipped = 2
Completed = 3
Cancelled = 4

EmailOutboxStatus

Pending = 0
Dispatching = 1
Sent = 2
Failed = 3
Dead = 4

GiftCardActivityType

Activation = 0
Reload = 1
Redemption = 2
Adjustment = 3
Expiration = 4

GiftCardStatus

Active = 0
Inactive = 1
Expired = 2

GroupLoyaltyAccountStatus

Active = 0
Inactive = 1
Expired = 2

IndustryTemplate

Shop = 0
Pharmacy = 1
Hardware = 2

LoyaltyAccountStatus

Active = 0
Inactive = 1
Expired = 2

LoyaltyTransactionType

Earn = 0
Redeem = 1
Adjust = 2
Void = 3
Expire = 4

ModuleClassification

Core = 0
Vertical = 1
AddOn = 2

MovementType

Sale = 0
Return = 1
Receipt = 2
Adjustment = 3
TransferOut = 4
TransferIn = 5
Count = 6
Distribution = 7

NonSaleEventType

NoSale = 0
Aborted = 1
XReport = 2
ZReport = 3
ZZReport = 4
BlindCloseout = 5

NotificationChannel

Email = 0
Sms = 1
Push = 2

OrderStatus

Draft = 0
Confirmed = 1
InProgress = 2
ReadyForPickup = 3
Completed = 4
Cancelled = 5

OrderType

Quote = 0
LayawayOrder = 1
BackOrder = 2
WorkOrder = 3
SpecialOrder = 4

PartnerRole

PartnerAdmin = 0
PartnerSupport = 1

PaymentTermsType

DueOnReceipt = 0
NetDays = 1
EndOfMonth = 2

PriceChangeStatus

Draft = 0
PendingApproval = 1
Approved = 2
Applied = 3
Cancelled = 4
Rejected = 5

PrinterLanguage

Zpl = 0
Tspl = 1

PrintJobStatus

Pending = 0
Printing = 1
Completed = 2
Failed = 3

PrintJobTrigger

Manual = 0
Receiving = 1
PriceChange = 2

ProductStatus

Draft = 0
Active = 1
Inactive = 2

PromotionDiscountType

Percent = 0
FixedAmount = 1
BuyXGetY = 2
FixedPrice = 3

PromotionTargetType

Product = 0
Category = 1
Sale = 2

PurchaseOrderStatus

Draft = 0
Submitted = 1
PartiallyReceived = 2
FullyReceived = 3
Closed = 4
Cancelled = 5

PurchaseReceiptStatus

Draft = 0
Completed = 1
Cancelled = 2

SaleWindowType

Available = 1
Blocked = 2

SegmentEndReason

Active = 0
Moved = 1
LoggedOut = 2
IdleTimeout = 3
ManagerOverride = 4
ShiftClosed = 5
Merged = 6

ShiftStatus

Open = 1
Suspended = 2
PendingCount = 3
Closed = 4
Merged = 5
Voided = 6

SourceSystem

NativeQIIUB = 0
ImportTool = 1

StockCountStatus

InProgress = 0
Completed = 1
Cancelled = 2

SupportSessionReason

SupportTicket = 0
BugInvestigation = 1
Onboarding = 2
Billing = 3
DataCorrection = 4
Compliance = 5
Training = 6
Other = 7

SyncCommandStatus

Pending = 0
Delivered = 1
Failed = 2

SyncLogStatus

Started = 0
Completed = 1
Failed = 2

SyncType

Pull = 0
Push = 1
Full = 2

TaxClassification

Taxed = 0
Exempt = 1
Waived = 2
Mapped = 3

TemplateScope

Platform = 0
Partner = 1
Merchant = 2

TimeEntryStatus

Open = 0
Closed = 1
Adjusted = 2

TransferConfirmationType

Shipped = 0
Received = 1
PartialReceived = 2
Rejected = 3

TransferOrderStatus

Draft = 0
Submitted = 1
Shipped = 2
InTransit = 3
PartiallyReceived = 4
Received = 5
Closed = 6
Cancelled = 7

UserRole

SystemAdmin = 0
Admin = 1
Manager = 2
Cashier = 3

WebListingSyncStatus

Pending = 0
Synced = 1
Error = 2
Disabled = 3

WebPlatform

Qiiub = 0
Shopify = 1
BigCommerce = 2
WooCommerce = 3

No sections match the current search and filters.