French Fragrance Product Operations and Sales Analytics Set (WW)
CPGPRF935· 2.0M records · 46 tables · v1.5.0 · Updated 2026-08-18
Retail Fragrance Consumer Products Dataset API
Overview
CPGPRF935 connects a fictional French fragrance business to an auditable commercial and operating chain across Europe, North America, the Middle East and Asia. Product launches follow fragrance research stage gates, jurisdiction-specific cosmetic filings, supplier terms, bill-of-materials cost and external contract manufacturing in France, Italy or China. Batch quality release, lot expiry, FEFO inventory, country and channel pricing, customer orders, returns, marketing and sales-team performance feed product, division and company profitability. Historical records are synthetic calibrations, current-period records are synthetic estimates and later periods are synthetic forecasts. Public regulatory and economic sources provide methodology anchors only; they do not make any generated entity, product, person, identifier or transaction real.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
ROSEVANTHE CITRUS VEILVXL-F02fine fragrance
1.6MUnits sold
USD 65MNet sales
58.2%Margin
USD 40.20Unit price
Units, thousandsProductionSalesInventory
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| fr_fragrance_products | 42 |
| fr_fragrance_years | 12 |
| fr_fragrance_periods | 144 |
| fr_fragrance_countries | 26 |
| fr_fragrance_economic_indices_monthly | 3,744 |
| fr_fragrance_company_groups | 1 |
| fr_fragrance_legal_entities | 9 |
| fr_fragrance_business_divisions | 8 |
| fr_fragrance_brands | 4 |
| fr_fragrance_facilities | 5 |
| fr_fragrance_sales_channels | 8 |
| fr_fragrance_routes_to_market | 26 |
| fr_fragrance_sales_territories | 26 |
| fr_fragrance_sales_teams | 26 |
| fr_fragrance_salespeople | 78 |
| fr_fragrance_salesperson_assignments | 78 |
| fr_fragrance_customers | 52 |
| fr_fragrance_suppliers | 8 |
| fr_fragrance_materials | 12 |
| fr_fragrance_supplier_contracts | 12 |
| fr_fragrance_research_programmes | 42 |
| fr_fragrance_product_media | 42 |
| fr_fragrance_bill_of_materials | 336 |
| fr_fragrance_research_costs_monthly | 733 |
| fr_fragrance_regulatory_filings | 336 |
| fr_fragrance_patent_assets | 28 |
| fr_fragrance_product_market_entries | 336 |
| fr_fragrance_price_lists_monthly | 22,908 |
| fr_fragrance_marketing_campaigns | 40 |
| fr_fragrance_marketing_spend_monthly | 120 |
| fr_fragrance_product_cost_standards_monthly | 3,000 |
| fr_fragrance_production_batches | 2,948 |
| fr_fragrance_quality_tests | 8,844 |
| fr_fragrance_inventory_lots | 2,948 |
| fr_fragrance_sales_orders | 286,974 |
| fr_fragrance_sales_order_lines | 742,092 |
| fr_fragrance_sales_returns | 94,867 |
| fr_fragrance_expiry_disposals | 4 |
| fr_fragrance_inventory_movements | 781,969 |
| fr_fragrance_inventory_monthly | 3,168 |
| fr_fragrance_salesperson_performance_monthly | 6,422 |
| fr_fragrance_product_market_financials_monthly | 22,589 |
| fr_fragrance_division_financials_monthly | 1,152 |
| fr_fragrance_company_financials_monthly | 144 |
| fr_fragrance_company_financials_annual | 12 |
| fr_fragrance_methodology_sources | 29 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
70%
Loading diagram
Schema
Every table ships with typed columns, referential integrity, and documentation.
fr_fragrance_products· Rows: 42
| Column | Type | Description |
|---|---|---|
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_products. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_products. |
| brand_id | varchar(8) | Stable identifier for brand; use it for the joins declared for fr_fragrance_products. |
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_products. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_products. |
| research_id | varchar(16) | Stable identifier for research; use it for the joins declared for fr_fragrance_products. |
| product_code | varchar(16) | Controlled or synthetic code for product. |
+16 more columns in fr_fragrance_products. The full schema ships with the download.
fr_fragrance_years· Rows: 12
| Column | Type | Description |
|---|---|---|
| year_id | varchar(8) | Stable identifier for year; use it for the joins declared for fr_fragrance_years. |
| calendar_year | integer | Calendar year for the fr_fragrance_years record. |
| period_start | date | Period start for the fr_fragrance_years record. |
| period_end | date | Period end for the fr_fragrance_years record. |
| source_status | varchar(40) | Evidence status for the row: modelled historical, modelled current year or modelled forecast. |
fr_fragrance_periods· Rows: 144
| Column | Type | Description |
|---|---|---|
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_periods. |
| year_id | varchar(8) | Stable identifier for year; use it for the joins declared for fr_fragrance_periods. |
| calendar_year | integer | Calendar year for the fr_fragrance_periods record. |
| month_number | varchar(8) | Month number for the fr_fragrance_periods record. |
| month_name | varchar(16) | Human-readable month name. |
| quarter_number | varchar(8) | Quarter number for the fr_fragrance_periods record. |
| period_start | date | Period start for the fr_fragrance_periods record. |
+4 more columns in fr_fragrance_periods. The full schema ships with the download.
fr_fragrance_countries· Rows: 26
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_countries. |
| country_code | varchar(8) | Controlled or synthetic code for country. |
| country_name | varchar(32) | Human-readable country name. |
| market_region | varchar(24) | Market region for the fr_fragrance_countries record. |
| currency_code | varchar(8) | Controlled or synthetic code for currency. |
| reporting_currency_code | varchar(8) | Controlled or synthetic code for reporting currency. |
| vat_or_sales_tax_pct | numeric(5,1) | vat or sales tax expressed as a percentage. |
+4 more columns in fr_fragrance_countries. The full schema ships with the download.
fr_fragrance_economic_indices_monthly· Rows: 3,744
| Column | Type | Description |
|---|---|---|
| econ_id | varchar(24) | Stable identifier for econ; use it for the joins declared for fr_fragrance_economic_indices_monthly. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_economic_indices_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_economic_indices_monthly. |
| consumer_price_index | numeric(9,4) | consumer price index as a modeled index used by the deterministic methodology. |
| producer_price_index | numeric(9,4) | producer price index as a modeled index used by the deterministic methodology. |
| wage_cost_index | numeric(9,4) | wage cost index as a modeled index used by the deterministic methodology. |
| energy_cost_index | numeric(9,4) | energy cost index as a modeled index used by the deterministic methodology. |
+7 more columns in fr_fragrance_economic_indices_monthly. The full schema ships with the download.
fr_fragrance_company_groups· Rows: 1
| Column | Type | Description |
|---|---|---|
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_company_groups. |
| group_code | varchar(8) | Controlled or synthetic code for group. |
| group_name | varchar(40) | Human-readable group name. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_company_groups. |
| headquarters_city | varchar(16) | Headquarters city for the fr_fragrance_company_groups record. |
| product_domain | varchar(48) | Product domain for the fr_fragrance_company_groups record. |
| founding_year | integer | Founding year for the fr_fragrance_company_groups record. |
+7 more columns in fr_fragrance_company_groups. The full schema ships with the download.
fr_fragrance_legal_entities· Rows: 9
| Column | Type | Description |
|---|---|---|
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_legal_entities. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_legal_entities. |
| entity_code | varchar(16) | Controlled or synthetic code for entity. |
| entity_name | varchar(48) | Human-readable entity name. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_legal_entities. |
| city_name | varchar(16) | Human-readable city name. |
| entity_role | varchar(48) | Entity role for the fr_fragrance_legal_entities record. |
+6 more columns in fr_fragrance_legal_entities. The full schema ships with the download.
fr_fragrance_business_divisions· Rows: 8
| Column | Type | Description |
|---|---|---|
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for fr_fragrance_business_divisions. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_business_divisions. |
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_business_divisions. |
| division_code | varchar(16) | Controlled or synthetic code for division. |
| division_name | varchar(48) | Human-readable division name. |
| division_type | varchar(32) | Division type for the fr_fragrance_business_divisions record. |
| region_name | varchar(24) | Human-readable region name. |
+4 more columns in fr_fragrance_business_divisions. The full schema ships with the download.
fr_fragrance_brands· Rows: 4
| Column | Type | Description |
|---|---|---|
| brand_id | varchar(8) | Stable identifier for brand; use it for the joins declared for fr_fragrance_brands. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_brands. |
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_brands. |
| brand_code | varchar(16) | Controlled or synthetic code for brand. |
| brand_name | varchar(16) | Human-readable brand name. |
| brand_positioning | varchar(80) | Brand positioning for the fr_fragrance_brands record. |
| target_consumer_segment | varchar(32) | Target consumer segment for the fr_fragrance_brands record. |
+4 more columns in fr_fragrance_brands. The full schema ships with the download.
fr_fragrance_facilities· Rows: 5
| Column | Type | Description |
|---|---|---|
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_facilities. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_facilities. |
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_facilities. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_facilities. |
| facility_code | varchar(16) | Controlled or synthetic code for facility. |
| facility_name | varchar(48) | Human-readable facility name. |
| city_name | varchar(16) | Human-readable city name. |
+9 more columns in fr_fragrance_facilities. The full schema ships with the download.
fr_fragrance_sales_channels· Rows: 8
| Column | Type | Description |
|---|---|---|
| channel_id | varchar(8) | Stable identifier for channel; use it for the joins declared for fr_fragrance_sales_channels. |
| channel_code | varchar(8) | Controlled or synthetic code for channel. |
| channel_name | varchar(48) | Human-readable channel name. |
| channel_group | varchar(24) | Channel group for the fr_fragrance_sales_channels record. |
| customer_type | varchar(40) | Customer type for the fr_fragrance_sales_channels record. |
| standard_margin_pct | integer | standard margin expressed as a percentage. |
| payment_terms_days | integer | payment terms measured in calendar days. |
+2 more columns in fr_fragrance_sales_channels. The full schema ships with the download.
fr_fragrance_routes_to_market· Rows: 26
| Column | Type | Description |
|---|---|---|
| route_id | varchar(16) | Stable identifier for route; use it for the joins declared for fr_fragrance_routes_to_market. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_routes_to_market. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_routes_to_market. |
| channel_id | varchar(8) | Stable identifier for channel; use it for the joins declared for fr_fragrance_routes_to_market. |
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_routes_to_market. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_routes_to_market. |
| route_code | varchar(24) | Controlled or synthetic code for route. |
+8 more columns in fr_fragrance_routes_to_market. The full schema ships with the download.
fr_fragrance_sales_territories· Rows: 26
| Column | Type | Description |
|---|---|---|
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for fr_fragrance_sales_territories. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_sales_territories. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for fr_fragrance_sales_territories. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_sales_territories. |
| territory_code | varchar(8) | Controlled or synthetic code for territory. |
| territory_name | varchar(48) | Human-readable territory name. |
| market_region | varchar(24) | Market region for the fr_fragrance_sales_territories record. |
+4 more columns in fr_fragrance_sales_territories. The full schema ships with the download.
fr_fragrance_sales_teams· Rows: 26
| Column | Type | Description |
|---|---|---|
| team_id | varchar(16) | Stable identifier for team; use it for the joins declared for fr_fragrance_sales_teams. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_sales_teams. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for fr_fragrance_sales_teams. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for fr_fragrance_sales_teams. |
| team_code | varchar(16) | Controlled or synthetic code for team. |
| team_name | varchar(32) | Human-readable team name. |
| sales_model | varchar(24) | sales model as the monetary measure defined for the fr_fragrance_sales_teams record. |
+5 more columns in fr_fragrance_sales_teams. The full schema ships with the download.
fr_fragrance_salespeople· Rows: 78
| Column | Type | Description |
|---|---|---|
| person_id | varchar(16) | Stable identifier for person; use it for the joins declared for fr_fragrance_salespeople. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_salespeople. |
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_salespeople. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_salespeople. |
| employee_code | varchar(16) | Controlled or synthetic code for employee. |
| salesperson_name | varchar(32) | Human-readable salesperson name. |
| role_title | varchar(40) | Role title for the fr_fragrance_salespeople record. |
+9 more columns in fr_fragrance_salespeople. The full schema ships with the download.
fr_fragrance_salesperson_assignments· Rows: 78
| Column | Type | Description |
|---|---|---|
| assign_id | varchar(16) | Stable identifier for assign; use it for the joins declared for fr_fragrance_salesperson_assignments. |
| person_id | varchar(16) | Stable identifier for person; use it for the joins declared for fr_fragrance_salesperson_assignments. |
| team_id | varchar(16) | Stable identifier for team; use it for the joins declared for fr_fragrance_salesperson_assignments. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for fr_fragrance_salesperson_assignments. |
| assignment_role | varchar(40) | Assignment role for the fr_fragrance_salesperson_assignments record. |
| assignment_start | date | Assignment start for the fr_fragrance_salesperson_assignments record. |
| assignment_end | date | Assignment end for the fr_fragrance_salesperson_assignments record. |
+3 more columns in fr_fragrance_salesperson_assignments. The full schema ships with the download.
fr_fragrance_customers· Rows: 52
| Column | Type | Description |
|---|---|---|
| customer_id | varchar(16) | Stable identifier for customer; use it for the joins declared for fr_fragrance_customers. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_customers. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_customers. |
| channel_id | varchar(8) | Stable identifier for channel; use it for the joins declared for fr_fragrance_customers. |
| route_id | varchar(16) | Stable identifier for route; use it for the joins declared for fr_fragrance_customers. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for fr_fragrance_customers. |
| customer_code | varchar(16) | Controlled or synthetic code for customer. |
+8 more columns in fr_fragrance_customers. The full schema ships with the download.
fr_fragrance_suppliers· Rows: 8
| Column | Type | Description |
|---|---|---|
| supplier_id | varchar(8) | Stable identifier for supplier; use it for the joins declared for fr_fragrance_suppliers. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_suppliers. |
| supplier_code | varchar(16) | Controlled or synthetic code for supplier. |
| supplier_name | varchar(48) | Human-readable supplier name. |
| supplier_type | varchar(32) | Supplier type for the fr_fragrance_suppliers record. |
| qualification_status | varchar(16) | qualification status in the controlled vocabulary documented by the dataset. |
| qualified_from | date | qualified from as an ISO 8601 calendar date. |
+5 more columns in fr_fragrance_suppliers. The full schema ships with the download.
fr_fragrance_materials· Rows: 12
| Column | Type | Description |
|---|---|---|
| material_id | varchar(8) | Stable identifier for material; use it for the joins declared for fr_fragrance_materials. |
| material_code | varchar(32) | Controlled or synthetic code for material. |
| material_name | varchar(48) | Human-readable material name. |
| material_group | varchar(16) | Material group for the fr_fragrance_materials record. |
| material_subgroup | varchar(32) | Material subgroup for the fr_fragrance_materials record. |
| unit_of_measure | varchar(16) | Unit of measure for the fr_fragrance_materials record. |
| quality_grade | varchar(32) | Quality grade for the fr_fragrance_materials record. |
+6 more columns in fr_fragrance_materials. The full schema ships with the download.
fr_fragrance_supplier_contracts· Rows: 12
| Column | Type | Description |
|---|---|---|
| contract_id | varchar(16) | Stable identifier for contract; use it for the joins declared for fr_fragrance_supplier_contracts. |
| supplier_id | varchar(8) | Stable identifier for supplier; use it for the joins declared for fr_fragrance_supplier_contracts. |
| material_id | varchar(8) | Stable identifier for material; use it for the joins declared for fr_fragrance_supplier_contracts. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_supplier_contracts. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_supplier_contracts. |
| contract_code | varchar(40) | Controlled or synthetic code for contract. |
| contract_name | varchar(88) | Human-readable contract name. |
+12 more columns in fr_fragrance_supplier_contracts. The full schema ships with the download.
fr_fragrance_research_programmes· Rows: 42
| Column | Type | Description |
|---|---|---|
| research_id | varchar(16) | Stable identifier for research; use it for the joins declared for fr_fragrance_research_programmes. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_research_programmes. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for fr_fragrance_research_programmes. |
| programme_code | varchar(16) | Controlled or synthetic code for programme. |
| programme_name | varchar(64) | Human-readable programme name. |
| research_type | varchar(40) | Research type for the fr_fragrance_research_programmes record. |
| intended_product_category | varchar(32) | Intended product category for the fr_fragrance_research_programmes record. |
+8 more columns in fr_fragrance_research_programmes. The full schema ships with the download.
fr_fragrance_product_media· Rows: 42
| Column | Type | Description |
|---|---|---|
| media_id | varchar(16) | Stable identifier for media; use it for the joins declared for fr_fragrance_product_media. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_product_media. |
| image_file | varchar(32) | Dataset-relative path to the linked product image. |
| image_format | varchar(16) | Image format for the fr_fragrance_product_media record. |
| image_width_px | integer | Image width px for the fr_fragrance_product_media record. |
| image_height_px | integer | Image height px for the fr_fragrance_product_media record. |
| background_mode | varchar(24) | Image background treatment, with transparent used for catalogue cutouts. |
+5 more columns in fr_fragrance_product_media. The full schema ships with the download.
fr_fragrance_bill_of_materials· Rows: 336
| Column | Type | Description |
|---|---|---|
| bom_item_id | varchar(16) | Stable identifier for bom item; use it for the joins declared for fr_fragrance_bill_of_materials. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_bill_of_materials. |
| material_id | varchar(8) | Stable identifier for material; use it for the joins declared for fr_fragrance_bill_of_materials. |
| bom_version | varchar(16) | Bom version for the fr_fragrance_bill_of_materials record. |
| component_sequence | integer | Component sequence for the fr_fragrance_bill_of_materials record. |
| cost_bucket | varchar(24) | cost bucket as the monetary measure defined for the fr_fragrance_bill_of_materials record. |
| quantity_per_unit | numeric(9,6) | Quantity per unit for the fr_fragrance_bill_of_materials record. |
+5 more columns in fr_fragrance_bill_of_materials. The full schema ships with the download.
fr_fragrance_research_costs_monthly· Rows: 733
| Column | Type | Description |
|---|---|---|
| rd_cost_id | varchar(16) | Stable identifier for rd cost; use it for the joins declared for fr_fragrance_research_costs_monthly. |
| research_id | varchar(16) | Stable identifier for research; use it for the joins declared for fr_fragrance_research_costs_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_research_costs_monthly. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for fr_fragrance_research_costs_monthly. |
| cost_category | varchar(48) | cost category as the monetary measure defined for the fr_fragrance_research_costs_monthly record. |
| accounting_treatment | varchar(40) | Management and statutory accounting classification applied to the research or development cost. |
| direct_labour_usd | numeric(9,2) | direct labour in United States dollars. |
+7 more columns in fr_fragrance_research_costs_monthly. The full schema ships with the download.
fr_fragrance_regulatory_filings· Rows: 336
| Column | Type | Description |
|---|---|---|
| filing_id | varchar(16) | Stable identifier for filing; use it for the joins declared for fr_fragrance_regulatory_filings. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_regulatory_filings. |
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_regulatory_filings. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_regulatory_filings. |
| filing_code | varchar(40) | Controlled or synthetic code for filing. |
| filing_name | varchar(80) | Human-readable filing name. |
| filing_type | varchar(24) | Filing type for the fr_fragrance_regulatory_filings record. |
+12 more columns in fr_fragrance_regulatory_filings. The full schema ships with the download.
fr_fragrance_patent_assets· Rows: 28
| Column | Type | Description |
|---|---|---|
| patent_id | varchar(16) | Stable identifier for patent; use it for the joins declared for fr_fragrance_patent_assets. |
| research_id | varchar(16) | Stable identifier for research; use it for the joins declared for fr_fragrance_patent_assets. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_patent_assets. |
| entity_id | varchar(8) | Stable identifier for entity; use it for the joins declared for fr_fragrance_patent_assets. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_patent_assets. |
| patent_code | varchar(24) | Controlled or synthetic code for patent. |
| patent_name | varchar(80) | Human-readable patent name. |
+10 more columns in fr_fragrance_patent_assets. The full schema ships with the download.
fr_fragrance_product_market_entries· Rows: 336
| Column | Type | Description |
|---|---|---|
| entry_id | varchar(16) | Stable identifier for entry; use it for the joins declared for fr_fragrance_product_market_entries. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_product_market_entries. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_product_market_entries. |
| route_id | varchar(16) | Stable identifier for route; use it for the joins declared for fr_fragrance_product_market_entries. |
| filing_id | varchar(16) | Stable identifier for filing; use it for the joins declared for fr_fragrance_product_market_entries. |
| market_entry_code | varchar(16) | Controlled or synthetic code for market entry. |
| market_entry_name | varchar(64) | Human-readable market entry name. |
+6 more columns in fr_fragrance_product_market_entries. The full schema ships with the download.
fr_fragrance_price_lists_monthly· Rows: 22,908
| Column | Type | Description |
|---|---|---|
| price_id | varchar(24) | Stable identifier for price; use it for the joins declared for fr_fragrance_price_lists_monthly. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_price_lists_monthly. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_price_lists_monthly. |
| channel_id | varchar(8) | Stable identifier for channel; use it for the joins declared for fr_fragrance_price_lists_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_price_lists_monthly. |
| price_currency_code | varchar(8) | Controlled or synthetic code for price currency. |
| list_price_local | numeric(10,2) | list price in the row currency. |
+8 more columns in fr_fragrance_price_lists_monthly. The full schema ships with the download.
fr_fragrance_marketing_campaigns· Rows: 40
| Column | Type | Description |
|---|---|---|
| campaign_id | varchar(16) | Stable identifier for campaign; use it for the joins declared for fr_fragrance_marketing_campaigns. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_marketing_campaigns. |
| brand_id | varchar(8) | Stable identifier for brand; use it for the joins declared for fr_fragrance_marketing_campaigns. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_marketing_campaigns. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_marketing_campaigns. |
| channel_id | varchar(8) | Stable identifier for channel; use it for the joins declared for fr_fragrance_marketing_campaigns. |
| campaign_code | varchar(32) | Controlled or synthetic code for campaign. |
+14 more columns in fr_fragrance_marketing_campaigns. The full schema ships with the download.
fr_fragrance_marketing_spend_monthly· Rows: 120
| Column | Type | Description |
|---|---|---|
| spend_id | varchar(16) | Stable identifier for spend; use it for the joins declared for fr_fragrance_marketing_spend_monthly. |
| campaign_id | varchar(16) | Stable identifier for campaign; use it for the joins declared for fr_fragrance_marketing_spend_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_marketing_spend_monthly. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for fr_fragrance_marketing_spend_monthly. |
| supplier_id | varchar(8) | Stable identifier for supplier; use it for the joins declared for fr_fragrance_marketing_spend_monthly. |
| spend_category | varchar(24) | spend category as the monetary measure defined for the fr_fragrance_marketing_spend_monthly record. |
| planned_spend_usd | numeric(10,2) | planned spend in United States dollars. |
+6 more columns in fr_fragrance_marketing_spend_monthly. The full schema ships with the download.
fr_fragrance_product_cost_standards_monthly· Rows: 3,000
| Column | Type | Description |
|---|---|---|
| cost_id | varchar(24) | Stable identifier for cost; use it for the joins declared for fr_fragrance_product_cost_standards_monthly. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_product_cost_standards_monthly. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_product_cost_standards_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_product_cost_standards_monthly. |
| raw_material_cost_usd | numeric(6,2) | raw material cost in United States dollars. |
| primary_packaging_cost_usd | numeric(6,2) | primary packaging cost in United States dollars. |
| secondary_packaging_cost_usd | numeric(5,2) | secondary packaging cost in United States dollars. |
+10 more columns in fr_fragrance_product_cost_standards_monthly. The full schema ships with the download.
fr_fragrance_production_batches· Rows: 2,948
| Column | Type | Description |
|---|---|---|
| batch_id | varchar(16) | Stable identifier for batch; use it for the joins declared for fr_fragrance_production_batches. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_production_batches. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_production_batches. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_production_batches. |
| cost_id | varchar(24) | Stable identifier for cost; use it for the joins declared for fr_fragrance_production_batches. |
| batch_code | varchar(32) | Controlled or synthetic code for batch. |
| batch_name | varchar(64) | Human-readable batch name. |
+15 more columns in fr_fragrance_production_batches. The full schema ships with the download.
fr_fragrance_quality_tests· Rows: 8,844
| Column | Type | Description |
|---|---|---|
| test_id | varchar(16) | Stable identifier for test; use it for the joins declared for fr_fragrance_quality_tests. |
| batch_id | varchar(16) | Stable identifier for batch; use it for the joins declared for fr_fragrance_quality_tests. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_quality_tests. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_quality_tests. |
| test_code | varchar(16) | Controlled or synthetic code for test. |
| test_name | varchar(32) | Human-readable test name. |
| test_type | varchar(16) | Test type for the fr_fragrance_quality_tests record. |
+10 more columns in fr_fragrance_quality_tests. The full schema ships with the download.
fr_fragrance_inventory_lots· Rows: 2,948
| Column | Type | Description |
|---|---|---|
| lot_id | varchar(16) | Stable identifier for lot; use it for the joins declared for fr_fragrance_inventory_lots. |
| batch_id | varchar(16) | Stable identifier for batch; use it for the joins declared for fr_fragrance_inventory_lots. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_inventory_lots. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_inventory_lots. |
| lot_code | varchar(32) | Controlled or synthetic code for lot. |
| lot_name | varchar(72) | Human-readable lot name. |
| manufacture_date | date | manufacture date as an ISO 8601 calendar date. |
+6 more columns in fr_fragrance_inventory_lots. The full schema ships with the download.
fr_fragrance_sales_orders· Rows: 286,974
| Column | Type | Description |
|---|---|---|
| order_id | varchar(16) | Stable identifier for order; use it for the joins declared for fr_fragrance_sales_orders. |
| customer_id | varchar(16) | Stable identifier for customer; use it for the joins declared for fr_fragrance_sales_orders. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_sales_orders. |
| channel_id | varchar(8) | Stable identifier for channel; use it for the joins declared for fr_fragrance_sales_orders. |
| route_id | varchar(16) | Stable identifier for route; use it for the joins declared for fr_fragrance_sales_orders. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for fr_fragrance_sales_orders. |
| person_id | varchar(16) | Stable identifier for person; use it for the joins declared for fr_fragrance_sales_orders. |
+12 more columns in fr_fragrance_sales_orders. The full schema ships with the download.
fr_fragrance_sales_order_lines· Rows: 742,092
| Column | Type | Description |
|---|---|---|
| line_id | varchar(16) | Stable identifier for line; use it for the joins declared for fr_fragrance_sales_order_lines. |
| order_id | varchar(16) | Stable identifier for order; use it for the joins declared for fr_fragrance_sales_order_lines. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_sales_order_lines. |
| entry_id | varchar(16) | Stable identifier for entry; use it for the joins declared for fr_fragrance_sales_order_lines. |
| price_id | varchar(24) | Stable identifier for price; use it for the joins declared for fr_fragrance_sales_order_lines. |
| campaign_id | varchar(16) | Stable identifier for campaign; use it for the joins declared for fr_fragrance_sales_order_lines. |
| order_line_number | varchar(8) | Order line number for the fr_fragrance_sales_order_lines record. |
+10 more columns in fr_fragrance_sales_order_lines. The full schema ships with the download.
fr_fragrance_sales_returns· Rows: 94,867
| Column | Type | Description |
|---|---|---|
| return_id | varchar(16) | Stable identifier for return; use it for the joins declared for fr_fragrance_sales_returns. |
| line_id | varchar(16) | Stable identifier for line; use it for the joins declared for fr_fragrance_sales_returns. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_sales_returns. |
| customer_id | varchar(16) | Stable identifier for customer; use it for the joins declared for fr_fragrance_sales_returns. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_sales_returns. |
| return_code | varchar(8) | Controlled or synthetic code for return. |
| return_name | varchar(24) | Human-readable return name. |
+10 more columns in fr_fragrance_sales_returns. The full schema ships with the download.
fr_fragrance_expiry_disposals· Rows: 4
| Column | Type | Description |
|---|---|---|
| disposal_id | varchar(16) | Stable identifier for disposal; use it for the joins declared for fr_fragrance_expiry_disposals. |
| lot_id | varchar(16) | Stable identifier for lot; use it for the joins declared for fr_fragrance_expiry_disposals. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_expiry_disposals. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_expiry_disposals. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_expiry_disposals. |
| disposal_code | varchar(8) | Controlled or synthetic code for disposal. |
| disposal_name | varchar(32) | Human-readable disposal name. |
+8 more columns in fr_fragrance_expiry_disposals. The full schema ships with the download.
fr_fragrance_inventory_movements· Rows: 781,969
| Column | Type | Description |
|---|---|---|
| movement_id | varchar(16) | Stable identifier for movement; use it for the joins declared for fr_fragrance_inventory_movements. |
| lot_id | varchar(16) | Stable identifier for lot; use it for the joins declared for fr_fragrance_inventory_movements. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_inventory_movements. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_inventory_movements. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_inventory_movements. |
| batch_id | varchar(16) | Stable identifier for batch; use it for the joins declared for fr_fragrance_inventory_movements. |
| line_id | varchar(16) | Stable identifier for line; use it for the joins declared for fr_fragrance_inventory_movements. |
+12 more columns in fr_fragrance_inventory_movements. The full schema ships with the download.
fr_fragrance_inventory_monthly· Rows: 3,168
| Column | Type | Description |
|---|---|---|
| inventory_id | varchar(16) | Stable identifier for inventory; use it for the joins declared for fr_fragrance_inventory_monthly. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_inventory_monthly. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for fr_fragrance_inventory_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_inventory_monthly. |
| opening_units | integer | opening measured in finished-product units. |
| production_receipts_units | integer | production receipts measured in finished-product units. |
| transfer_in_units | integer | transfer in measured in finished-product units. |
+12 more columns in fr_fragrance_inventory_monthly. The full schema ships with the download.
fr_fragrance_salesperson_performance_monthly· Rows: 6,422
| Column | Type | Description |
|---|---|---|
| performance_id | varchar(16) | Stable identifier for performance; use it for the joins declared for fr_fragrance_salesperson_performance_monthly. |
| person_id | varchar(16) | Stable identifier for person; use it for the joins declared for fr_fragrance_salesperson_performance_monthly. |
| team_id | varchar(16) | Stable identifier for team; use it for the joins declared for fr_fragrance_salesperson_performance_monthly. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for fr_fragrance_salesperson_performance_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_salesperson_performance_monthly. |
| target_net_sales_usd | numeric(11,2) | target net sales in United States dollars. |
| gross_sales_usd | numeric(12,2) | gross sales in United States dollars. |
+12 more columns in fr_fragrance_salesperson_performance_monthly. The full schema ships with the download.
fr_fragrance_product_market_financials_monthly· Rows: 22,589
| Column | Type | Description |
|---|---|---|
| product_fin_id | varchar(16) | Stable identifier for product fin; use it for the joins declared for fr_fragrance_product_market_financials_monthly. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for fr_fragrance_product_market_financials_monthly. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for fr_fragrance_product_market_financials_monthly. |
| channel_id | varchar(8) | Stable identifier for channel; use it for the joins declared for fr_fragrance_product_market_financials_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_product_market_financials_monthly. |
| gross_sales_usd | numeric(11,2) | gross sales in United States dollars. |
| on_invoice_discount_usd | numeric(10,2) | on invoice discount in United States dollars. |
+13 more columns in fr_fragrance_product_market_financials_monthly. The full schema ships with the download.
fr_fragrance_division_financials_monthly· Rows: 1,152
| Column | Type | Description |
|---|---|---|
| division_fin_id | varchar(16) | Stable identifier for division fin; use it for the joins declared for fr_fragrance_division_financials_monthly. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for fr_fragrance_division_financials_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_division_financials_monthly. |
| net_sales_usd | numeric(12,2) | Gross sales less discounts, rebates and return credits, in United States dollars. |
| cost_of_goods_sold_usd | numeric(12,2) | cost of goods sold in United States dollars. |
| sales_payroll_usd | numeric(10,2) | sales payroll in United States dollars. |
| sales_commission_usd | numeric(10,2) | sales commission in United States dollars. |
+11 more columns in fr_fragrance_division_financials_monthly. The full schema ships with the download.
fr_fragrance_company_financials_monthly· Rows: 144
| Column | Type | Description |
|---|---|---|
| company_fin_id | varchar(16) | Stable identifier for company fin; use it for the joins declared for fr_fragrance_company_financials_monthly. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_company_financials_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for fr_fragrance_company_financials_monthly. |
| gross_sales_usd | numeric(12,2) | gross sales in United States dollars. |
| discounts_usd | numeric(12,2) | discounts in United States dollars. |
| return_credit_usd | numeric(10,2) | return credit in United States dollars. |
| net_sales_usd | numeric(12,2) | Gross sales less discounts, rebates and return credits, in United States dollars. |
+23 more columns in fr_fragrance_company_financials_monthly. The full schema ships with the download.
fr_fragrance_company_financials_annual· Rows: 12
| Column | Type | Description |
|---|---|---|
| annual_id | varchar(16) | Stable identifier for annual; use it for the joins declared for fr_fragrance_company_financials_annual. |
| company_id | varchar(8) | Stable identifier for company; use it for the joins declared for fr_fragrance_company_financials_annual. |
| year_id | varchar(8) | Stable identifier for year; use it for the joins declared for fr_fragrance_company_financials_annual. |
| gross_sales_usd | numeric(13,2) | gross sales in United States dollars. |
| discounts_usd | numeric(13,2) | discounts in United States dollars. |
| return_credit_usd | numeric(11,2) | return credit in United States dollars. |
| net_sales_usd | numeric(13,2) | Gross sales less discounts, rebates and return credits, in United States dollars. |
+18 more columns in fr_fragrance_company_financials_annual. The full schema ships with the download.
fr_fragrance_methodology_sources· Rows: 29
| Column | Type | Description |
|---|---|---|
| source_id | varchar(8) | Stable identifier for source; use it for the joins declared for fr_fragrance_methodology_sources. |
| source_code | varchar(40) | Controlled or synthetic code for source. |
| source_name | varchar(40) | Human-readable source name. |
| source_organization | varchar(64) | Source organization for the fr_fragrance_methodology_sources record. |
| source_title | varchar(112) | Source title for the fr_fragrance_methodology_sources record. |
| source_url | varchar(160) | Source url for the fr_fragrance_methodology_sources record. |
| source_type | varchar(48) | Source type for the fr_fragrance_methodology_sources record. |
+7 more columns in fr_fragrance_methodology_sources. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| product_id | company_id | brand_id | product_code | product_name | product_category | product_form | package_type | pack_size | pack_unit | lifecycle_status | launch_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CPG0043 | GRP002 | BRD005 | VXL-F01 | VAUXELIER ORRIS LEDGER | fine_fragrance | eau_de_parfum | fragrance_bottle | 50 | ml | discontinued | 2015-01-22 |
| CPG0044 | GRP002 | BRD006 | VXL-F02 | ROSEVANTHE CITRUS VEIL | fine_fragrance | eau_de_parfum | fragrance_bottle | 75 | ml | active | 2015-04-22 |
| CPG0045 | GRP002 | BRD007 | VXL-F03 | SILTENOIRE CEDAR AFTER RAIN | fine_fragrance | eau_de_parfum | fragrance_bottle | 50 | ml | active | 2015-08-22 |
Version History
| v1.5.0 | 2026-08-18 | Launch stock corrected. The production plan reads a rate smoothed over a year of demand either side of the month, and that window was skipping months a product had no demand in rather than counting them as zero. Before launch it therefore read back the mature rate from the months after launch, and the line ran flat out for a quarter before the product existed. Each SKU opened with about five months of cover it then spent a year working off, which showed as stock climbing while production fell and nothing had yet been sold. Ahead of its first order a product now only builds the launch pipeline, about six weeks of the first month's demand. Finished goods cover falls again from six weeks to under six, and every other series is unchanged: demand, net sales, order volumes, basket shape, lifespans, seasonality and the exact roll-forward. |
Related Datasets
European Skincare Product Operations and Sales Analytics Set (EU)
RetailCPGSKN934 is a deterministic synthetic skincare operations and sales warehouse for fictional London-based Alderquay, linking brands and products to research, regulation, sourcing, production, inventory, customers, sales teams, returns, disposal and profitability across Europe, North America and selected Asian markets.
$299one time
View details FMCG Manufacturing Product Performance Set (EU)
RetailA complete Europe analytical warehouse covering company, plant, product, material, batch, quality, location, channel, customer, shipment, inventory, promotion, sales, return, trade-spend, finance, rating and forecast data.
$199one time
View details FMCG Manufacturing Product Performance Set (US)
RetailA complete United States analytical warehouse covering company, plant, product, material, batch, quality, location, channel, customer, shipment, inventory, promotion, sales, return, trade-spend, finance, rating and forecast data.
$199one time
View details