Tax dataset

Tax dataset for the Markdown & Promotions module, holding VAT rates per product and location.

The Tax dataset holds VAT rates for each product at each location. It provides the tax context used to compute net values in markdown and promotion analysis.

Purpose

The Markdown & Promotions module uses the Tax dataset to:

• Provide VAT rates by product and location
• Support accurate net value and margin calculations

Required fields

About the Constraint column: every field listed must be provided in your data. Non-null means its value cannot be null; Nullable means the value may be sent as null (or left blank in your source). Primary key, Unique, and Foreign key describe the field's role in the data model; a Primary key is always non-null.

Field	Description	Type	Constraint
created_at	Timestamp when the record was created.	timestamp	Primary key
location_id	Unique identifier for the store or location.	string	Primary key Foreign key to location
product_id	Unique identifier for the product SKU.	string	Primary key Foreign key to product
updated_at	Timestamp when the record was last updated.	timestamp	Nullable
vat	VAT rate applied to the product at the location.	float	Nullable

Usage notes

• Product and location identifiers must align with the Products and Locations datasets.
• Rates should reflect the tax applicable at the associated location.

Why this dataset matters

Accurate tax rates ensure value and margin calculations reflect net figures, which matters for discount-depth and margin guardrails.