Food Traceability, Recall, HACCP and Cold-Chain Analytics Set (US)
FNBTRC999· 1.6M records · 52 tables · v1.0.0 · Updated 2026-09-01
Retail Food & Beverage Dataset API
Overview
FNBTRC999 follows a modelled food supply network from growing areas and procurement through transformation, regulatory lot genealogy, food-safety monitoring, quality release, refrigerated transport, inventory, customer fulfilment, returns, recall execution, waste and accounting. Public regulatory, economic, weather, energy, freight and calendar sources calibrate deterministic synthetic drivers only. Historical operations are synthetic calibrations, the current period contains synthetic estimates and later periods are synthetic projections. Every generated entity, person, product, identifier, transaction and result is synthetic by construction.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
One lot, both directionsTRACEthe FSMA 204 chain a recall actually walks
63,104Lots traced
120Recalls
Cold chain excursions, percentCold chain excursions, percent
1 / 2
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| ftr_calendar_days | 4,383 |
| ftr_methodology_sources | 36 |
| ftr_ftl_categories | 23 |
| ftr_economic_drivers_monthly | 1,728 |
| ftr_weather_zones | 12 |
| ftr_weather_daily | 52,596 |
| ftr_disruption_events | 84 |
| ftr_organizations | 720 |
| ftr_organization_roles | 1,260 |
| ftr_facilities | 1,080 |
| ftr_growing_areas | 1,800 |
| ftr_people | 2,400 |
| ftr_facility_certifications | 2,600 |
| ftr_traceability_plans | 1,300 |
| ftr_items | 960 |
| ftr_item_components | 3,100 |
| ftr_item_media | 48 |
| ftr_iot_devices | 1,650 |
| ftr_gl_accounts | 96 |
| ftr_purchase_orders | 15,000 |
| ftr_purchase_order_lines | 42,000 |
| ftr_sales_orders | 20,000 |
| ftr_sales_order_lines | 58,000 |
| ftr_invoices | 18,500 |
| ftr_invoice_lines | 54,000 |
| ftr_customer_returns | 4,000 |
| ftr_cash_receipts | 17,000 |
| ftr_production_batches | 22,000 |
| ftr_traceability_lots | 63,104 |
| ftr_lot_lineage | 68,000 |
| ftr_trace_events | 94,000 |
| ftr_trace_event_lots | 182,420 |
| ftr_shipments | 18,000 |
| ftr_shipment_stops | 39,000 |
| ftr_cold_chain_readings | 220,000 |
| ftr_inventory_movements | 216,768 |
| ftr_inventory_monthly | 163,508 |
| ftr_haccp_plans | 120 |
| ftr_haccp_control_points | 580 |
| ftr_haccp_monitoring | 60,000 |
| ftr_quality_samples | 11,000 |
| ftr_quality_results | 44,000 |
| ftr_food_safety_deviations | 2,200 |
| ftr_corrective_actions | 3,200 |
| ftr_audits | 1,200 |
| ftr_recalls | 120 |
| ftr_recall_lots | 1,300 |
| ftr_recall_actions | 6,500 |
| ftr_waste_disposals | 4,800 |
| ftr_journal_entries | 28,300 |
| ftr_journal_lines | 76,600 |
| ftr_business_unit_financials_monthly | 3,456 |
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.
ftr_calendar_days· Rows: 4,383
| Column | Type | Description |
|---|---|---|
| date_id | varchar(24) | Calendar-day key joined to ftr_calendar_days. |
| calendar_date | date | ISO 8601 calendar date for calendar. |
| calendar_year | integer | The modeled calendar year value recorded for this calendar days row. |
| month_number | varchar(8) | Operational month number within its parent document or process. |
| month_name | varchar(16) | Readable month name corresponding to the related code or identifier. |
| quarter_number | varchar(8) | Operational quarter number within its parent document or process. |
| iso_week_number | varchar(8) | Operational iso week number within its parent document or process. |
+9 more columns in ftr_calendar_days. The full schema ships with the download.
ftr_methodology_sources· Rows: 36
| Column | Type | Description |
|---|---|---|
| source_id | varchar(48) | Stable identifier for the pinned methodology source that supports the rule, calibration or external driver. |
| source_code | varchar(40) | Machine-readable source code used for deterministic filtering and grouping. |
| publisher_name | varchar(80) | Readable publisher name corresponding to the related code or identifier. |
| source_title | varchar(120) | The modeled source title value recorded for this methodology sources row. |
| source_url | varchar(200) | The modeled source url value recorded for this methodology sources row. |
| jurisdiction_name | varchar(40) | Readable jurisdiction name corresponding to the related code or identifier. |
| source_frequency | varchar(32) | The modeled source frequency value recorded for this methodology sources row. |
+9 more columns in ftr_methodology_sources. The full schema ships with the download.
ftr_ftl_categories· Rows: 23
| Column | Type | Description |
|---|---|---|
| ftl_category_code | varchar(24) | Machine-readable ftl category code used for deterministic filtering and grouping. |
| ftl_category_name | varchar(80) | Readable ftl category name corresponding to the related code or identifier. |
| ftl_description | varchar(144) | Readable explanation of the ftl carried by this row. |
| applicable_forms | varchar(64) | The modeled applicable forms value recorded for this ftl categories row. |
| excluded_forms | varchar(160) | The modeled excluded forms value recorded for this ftl categories row. |
| source_id | varchar(32) | Stable identifier for the pinned methodology source that supports the rule, calibration or external driver. |
| effective_from | date | The modeled effective from value recorded for this ftl categories row. |
+2 more columns in ftr_ftl_categories. The full schema ships with the download.
ftr_economic_drivers_monthly· Rows: 1,728
| Column | Type | Description |
|---|---|---|
| driver_observation_id | varchar(40) | Stable identifier for the driver observation, used by the declared relationships for this dataset. |
| date_id | varchar(24) | Calendar-day key joined to ftr_calendar_days. |
| driver_code | varchar(24) | Machine-readable driver code used for deterministic filtering and grouping. |
| driver_name | varchar(80) | Readable driver name corresponding to the related code or identifier. |
| geography_code | varchar(8) | Machine-readable geography code used for deterministic filtering and grouping. |
| geography_name | varchar(24) | Readable geography name corresponding to the related code or identifier. |
| unit_name | varchar(24) | Readable unit name corresponding to the related code or identifier. |
+8 more columns in ftr_economic_drivers_monthly. The full schema ships with the download.
ftr_weather_zones· Rows: 12
| Column | Type | Description |
|---|---|---|
| weather_zone_id | varchar(24) | Stable identifier for the weather zone, used by the declared relationships for this dataset. |
| zone_code | varchar(16) | Machine-readable zone code used for deterministic filtering and grouping. |
| zone_name | varchar(56) | Readable zone name corresponding to the related code or identifier. |
| country_code | varchar(8) | Machine-readable country code used for deterministic filtering and grouping. |
| state_or_region_codes | varchar(16) | The modeled state or region codes value recorded for this weather zones row. |
| climate_classification | varchar(32) | The modeled climate classification value recorded for this weather zones row. |
| primary_supply_chain_role | varchar(56) | The modeled primary supply chain role value recorded for this weather zones row. |
+1 more columns in ftr_weather_zones. The full schema ships with the download.
ftr_weather_daily· Rows: 52,596
| Column | Type | Description |
|---|---|---|
| weather_observation_id | varchar(40) | Stable identifier for the weather observation, used by the declared relationships for this dataset. |
| weather_zone_id | varchar(24) | Stable identifier for the weather zone, used by the declared relationships for this dataset. |
| date_id | varchar(24) | Calendar-day key joined to ftr_calendar_days. |
| mean_temperature_c | numeric(6,2) | Mean temperature c in degrees Celsius. |
| min_temperature_c | numeric(6,2) | Min temperature c in degrees Celsius. |
| max_temperature_c | numeric(6,2) | Max temperature c in degrees Celsius. |
| precipitation_mm | numeric(6,2) | The modeled precipitation mm value recorded for this weather daily row. |
+12 more columns in ftr_weather_daily. The full schema ships with the download.
ftr_disruption_events· Rows: 84
| Column | Type | Description |
|---|---|---|
| disruption_id | varchar(40) | Stable identifier for the disruption, used by the declared relationships for this dataset. |
| disruption_code | varchar(24) | Machine-readable disruption code used for deterministic filtering and grouping. |
| disruption_name | varchar(112) | Readable disruption name corresponding to the related code or identifier. |
| disruption_type | varchar(24) | The modeled disruption type value recorded for this disruption events row. |
| start_date_id | varchar(24) | Calendar-day key for start, joined to ftr_calendar_days. |
| end_date_id | varchar(24) | Calendar-day key for end, joined to ftr_calendar_days. |
| weather_zone_id | varchar(24) | Stable identifier for the weather zone, used by the declared relationships for this dataset. |
+11 more columns in ftr_disruption_events. The full schema ships with the download.
ftr_organizations· Rows: 720
| Column | Type | Description |
|---|---|---|
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| organization_code | varchar(32) | Machine-readable organization code used for deterministic filtering and grouping. |
| organization_name | varchar(80) | Readable organization name corresponding to the related code or identifier. |
| legal_form | varchar(48) | The modeled legal form value recorded for this organizations row. |
| primary_role_code | varchar(32) | Machine-readable primary role code used for deterministic filtering and grouping. |
| primary_role_name | varchar(64) | Readable primary role name corresponding to the related code or identifier. |
| country_code | varchar(8) | Machine-readable country code used for deterministic filtering and grouping. |
+13 more columns in ftr_organizations. The full schema ships with the download.
ftr_organization_roles· Rows: 1,260
| Column | Type | Description |
|---|---|---|
| role_assignment_id | varchar(32) | Stable identifier for the role assignment, used by the declared relationships for this dataset. |
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| role_code | varchar(32) | Machine-readable role code used for deterministic filtering and grouping. |
| role_name | varchar(64) | Readable role name corresponding to the related code or identifier. |
| valid_from_date_id | varchar(24) | Calendar-day key for valid from, joined to ftr_calendar_days. |
| valid_to_date_id | varchar(24) | Calendar-day key for valid to, joined to ftr_calendar_days. |
| certification_required_flag | boolean | True when the modeled certification required condition applies to this row. |
+2 more columns in ftr_organization_roles. The full schema ships with the download.
ftr_facilities· Rows: 1,080
| Column | Type | Description |
|---|---|---|
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| weather_zone_id | varchar(24) | Stable identifier for the weather zone, used by the declared relationships for this dataset. |
| facility_code | varchar(32) | Machine-readable facility code used for deterministic filtering and grouping. |
| facility_name | varchar(112) | Readable facility name corresponding to the related code or identifier. |
| facility_type | varchar(32) | The modeled facility type value recorded for this facilities row. |
| facility_type_name | varchar(56) | Readable facility type name corresponding to the related code or identifier. |
+15 more columns in ftr_facilities. The full schema ships with the download.
ftr_growing_areas· Rows: 1,800
| Column | Type | Description |
|---|---|---|
| growing_area_id | varchar(32) | Stable identifier for the growing area, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| area_code | varchar(32) | Machine-readable area code used for deterministic filtering and grouping. |
| area_name | varchar(64) | Readable area name corresponding to the related code or identifier. |
| area_type | varchar(24) | The modeled area type value recorded for this growing areas row. |
| area_type_name | varchar(32) | Readable area type name corresponding to the related code or identifier. |
| latitude | numeric(10,6) | The modeled latitude value recorded for this growing areas row. |
+8 more columns in ftr_growing_areas. The full schema ships with the download.
ftr_people· Rows: 2,400
| Column | Type | Description |
|---|---|---|
| person_id | varchar(32) | Stable identifier for the person, used by the declared relationships for this dataset. |
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| employee_or_contact_code | varchar(24) | Machine-readable employee or contact code used for deterministic filtering and grouping. |
| full_name | varchar(24) | Readable full name corresponding to the related code or identifier. |
| job_title | varchar(40) | The modeled job title value recorded for this people row. |
| contact_function_code | varchar(16) | Machine-readable contact function code used for deterministic filtering and grouping. |
+10 more columns in ftr_people. The full schema ships with the download.
ftr_facility_certifications· Rows: 2,600
| Column | Type | Description |
|---|---|---|
| certification_id | varchar(32) | Stable identifier for the certification, used by the declared relationships for this dataset. |
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| certification_code | varchar(24) | Machine-readable certification code used for deterministic filtering and grouping. |
| certification_name | varchar(80) | Readable certification name corresponding to the related code or identifier. |
| certification_scope | varchar(32) | The modeled certification scope value recorded for this facility certifications row. |
| issuing_body | varchar(56) | The modeled issuing body value recorded for this facility certifications row. |
+5 more columns in ftr_facility_certifications. The full schema ships with the download.
ftr_traceability_plans· Rows: 1,300
| Column | Type | Description |
|---|---|---|
| traceability_plan_id | varchar(40) | Stable identifier for the traceability plan, used by the declared relationships for this dataset. |
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| primary_facility_id | varchar(32) | Stable identifier for the primary facility, used by the declared relationships for this dataset. |
| contact_person_id | varchar(32) | Stable identifier for the contact person, used by the declared relationships for this dataset. |
| plan_code | varchar(32) | Machine-readable plan code used for deterministic filtering and grouping. |
| plan_version | varchar(24) | The modeled plan version value recorded for this traceability plans row. |
| effective_from_date_id | varchar(24) | Calendar-day key for effective from, joined to ftr_calendar_days. |
+9 more columns in ftr_traceability_plans. The full schema ships with the download.
ftr_items· Rows: 960
| Column | Type | Description |
|---|---|---|
| item_id | varchar(40) | Stable identifier for the item, used by the declared relationships for this dataset. |
| item_code | varchar(32) | Machine-readable item code used for deterministic filtering and grouping. |
| item_name | varchar(104) | Readable item name corresponding to the related code or identifier. |
| item_type | varchar(32) | The modeled item type value recorded for this items row. |
| item_type_name | varchar(56) | Readable item type name corresponding to the related code or identifier. |
| ftl_category_code | varchar(24) | Machine-readable ftl category code used for deterministic filtering and grouping. |
| food_category | varchar(16) | The modeled food category value recorded for this items row. |
+19 more columns in ftr_items. The full schema ships with the download.
ftr_item_components· Rows: 3,100
| Column | Type | Description |
|---|---|---|
| component_relationship_id | varchar(40) | Stable identifier for the component relationship, used by the declared relationships for this dataset. |
| parent_item_id | varchar(32) | Stable identifier for the parent item, used by the declared relationships for this dataset. |
| component_item_id | varchar(40) | Stable identifier for the component item, used by the declared relationships for this dataset. |
| component_role_code | varchar(24) | Machine-readable component role code used for deterministic filtering and grouping. |
| component_role_name | varchar(48) | Readable component role name corresponding to the related code or identifier. |
| quantity_per_output_unit | numeric(8,5) | The modeled quantity per output unit value recorded for this item components row. |
| component_uom | varchar(16) | Unit used to interpret the related quantity or measurement. |
+4 more columns in ftr_item_components. The full schema ships with the download.
ftr_item_media· Rows: 48
| Column | Type | Description |
|---|---|---|
| media_asset_id | varchar(32) | Stable identifier for the media asset, used by the declared relationships for this dataset. |
| item_id | varchar(32) | Stable identifier for the item, used by the declared relationships for this dataset. |
| image_file | varchar(56) | The modeled image file value recorded for this item media row. |
| image_format | varchar(16) | The modeled image format value recorded for this item media row. |
| image_width_px | integer | The modeled image width px value recorded for this item media row. |
| image_height_px | integer | The modeled image height px value recorded for this item media row. |
| background_mode | varchar(24) | The modeled background mode value recorded for this item media row. |
+9 more columns in ftr_item_media. The full schema ships with the download.
ftr_iot_devices· Rows: 1,650
| Column | Type | Description |
|---|---|---|
| device_id | varchar(32) | Stable identifier for the device, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| owning_organization_id | varchar(32) | Stable identifier for the owning organization, used by the declared relationships for this dataset. |
| device_code | varchar(32) | Machine-readable device code used for deterministic filtering and grouping. |
| device_type | varchar(16) | The modeled device type value recorded for this iot devices row. |
| device_type_name | varchar(48) | Readable device type name corresponding to the related code or identifier. |
| manufacturer_model | varchar(32) | The modeled manufacturer model value recorded for this iot devices row. |
+8 more columns in ftr_iot_devices. The full schema ships with the download.
ftr_gl_accounts· Rows: 96
| Column | Type | Description |
|---|---|---|
| gl_account_code | varchar(32) | Machine-readable gl account code used for deterministic filtering and grouping. |
| gl_account_name | varchar(40) | Readable gl account name corresponding to the related code or identifier. |
| account_type | varchar(16) | The modeled account type value recorded for this gl accounts row. |
| account_type_name | varchar(40) | Readable account type name corresponding to the related code or identifier. |
| financial_statement_section | varchar(24) | The modeled financial statement section value recorded for this gl accounts row. |
| normal_balance | varchar(16) | The modeled normal balance value recorded for this gl accounts row. |
| active_from_date_id | varchar(24) | Calendar-day key for active from, joined to ftr_calendar_days. |
+2 more columns in ftr_gl_accounts. The full schema ships with the download.
ftr_purchase_orders· Rows: 15,000
| Column | Type | Description |
|---|---|---|
| purchase_order_id | varchar(32) | Stable identifier for the purchase order, used by the declared relationships for this dataset. |
| buyer_organization_id | varchar(32) | Stable identifier for the buyer organization, used by the declared relationships for this dataset. |
| supplier_organization_id | varchar(32) | Stable identifier for the supplier organization, used by the declared relationships for this dataset. |
| receiving_facility_id | varchar(32) | Stable identifier for the receiving facility, used by the declared relationships for this dataset. |
| order_code | varchar(32) | Machine-readable order code used for deterministic filtering and grouping. |
| order_date_id | varchar(24) | Calendar-day key for order, joined to ftr_calendar_days. |
| currency_code | varchar(8) | Machine-readable currency code used for deterministic filtering and grouping. |
+9 more columns in ftr_purchase_orders. The full schema ships with the download.
ftr_purchase_order_lines· Rows: 42,000
| Column | Type | Description |
|---|---|---|
| purchase_order_line_id | varchar(32) | Stable identifier for the purchase order line, used by the declared relationships for this dataset. |
| purchase_order_id | varchar(32) | Stable identifier for the purchase order, used by the declared relationships for this dataset. |
| line_number | varchar(8) | Operational line number within its parent document or process. |
| item_id | varchar(40) | Stable identifier for the item, used by the declared relationships for this dataset. |
| ordered_quantity | integer | Quantity for ordered, expressed in the accompanying unit. |
| order_uom | varchar(16) | Unit used to interpret the related quantity or measurement. |
| unit_price_usd | numeric(8,4) | Modeled unit price amount in United States dollars. |
+7 more columns in ftr_purchase_order_lines. The full schema ships with the download.
ftr_sales_orders· Rows: 20,000
| Column | Type | Description |
|---|---|---|
| sales_order_id | varchar(32) | Stable identifier for the sales order, used by the declared relationships for this dataset. |
| seller_organization_id | varchar(32) | Stable identifier for the seller organization, used by the declared relationships for this dataset. |
| customer_organization_id | varchar(32) | Stable identifier for the customer organization, used by the declared relationships for this dataset. |
| ship_from_facility_id | varchar(32) | Stable identifier for the ship from facility, used by the declared relationships for this dataset. |
| ship_to_facility_id | varchar(32) | Stable identifier for the ship to facility, used by the declared relationships for this dataset. |
| order_code | varchar(40) | Machine-readable order code used for deterministic filtering and grouping. |
| order_date_id | varchar(24) | Calendar-day key for order, joined to ftr_calendar_days. |
+9 more columns in ftr_sales_orders. The full schema ships with the download.
ftr_sales_order_lines· Rows: 58,000
| Column | Type | Description |
|---|---|---|
| sales_order_line_id | varchar(40) | Stable identifier for the sales order line, used by the declared relationships for this dataset. |
| sales_order_id | varchar(32) | Stable identifier for the sales order, used by the declared relationships for this dataset. |
| line_number | varchar(8) | Operational line number within its parent document or process. |
| item_id | varchar(32) | Stable identifier for the item, used by the declared relationships for this dataset. |
| ordered_quantity | integer | Quantity for ordered, expressed in the accompanying unit. |
| fulfilled_quantity | integer | Quantity for fulfilled, expressed in the accompanying unit. |
| backordered_quantity | integer | Quantity for backordered, expressed in the accompanying unit. |
+8 more columns in ftr_sales_order_lines. The full schema ships with the download.
ftr_invoices· Rows: 18,500
| Column | Type | Description |
|---|---|---|
| invoice_id | varchar(40) | Stable identifier for the invoice, used by the declared relationships for this dataset. |
| sales_order_id | varchar(32) | Stable identifier for the sales order, used by the declared relationships for this dataset. |
| seller_organization_id | varchar(32) | Stable identifier for the seller organization, used by the declared relationships for this dataset. |
| customer_organization_id | varchar(32) | Stable identifier for the customer organization, used by the declared relationships for this dataset. |
| invoice_code | varchar(40) | Machine-readable invoice code used for deterministic filtering and grouping. |
| invoice_date_id | varchar(24) | Calendar-day key for invoice, joined to ftr_calendar_days. |
| due_date_id | varchar(24) | Calendar-day key for due, joined to ftr_calendar_days. |
+8 more columns in ftr_invoices. The full schema ships with the download.
ftr_invoice_lines· Rows: 54,000
| Column | Type | Description |
|---|---|---|
| invoice_line_id | varchar(40) | Stable identifier for the invoice line, used by the declared relationships for this dataset. |
| invoice_id | varchar(40) | Stable identifier for the invoice, used by the declared relationships for this dataset. |
| sales_order_line_id | varchar(40) | Stable identifier for the sales order line, used by the declared relationships for this dataset. |
| line_number | varchar(8) | Operational line number within its parent document or process. |
| item_id | varchar(32) | Stable identifier for the item, used by the declared relationships for this dataset. |
| invoiced_quantity | integer | Quantity for invoiced, expressed in the accompanying unit. |
| unit_price_usd | numeric(6,2) | Modeled unit price amount in United States dollars. |
+4 more columns in ftr_invoice_lines. The full schema ships with the download.
ftr_customer_returns· Rows: 4,000
| Column | Type | Description |
|---|---|---|
| return_line_id | varchar(48) | Stable identifier for the return line, used by the declared relationships for this dataset. |
| invoice_line_id | varchar(40) | Stable identifier for the invoice line, used by the declared relationships for this dataset. |
| sales_order_line_id | varchar(40) | Stable identifier for the sales order line, used by the declared relationships for this dataset. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| customer_organization_id | varchar(32) | Stable identifier for the customer organization, used by the declared relationships for this dataset. |
| receiving_facility_id | varchar(32) | Stable identifier for the receiving facility, used by the declared relationships for this dataset. |
| return_code | varchar(32) | Machine-readable return code used for deterministic filtering and grouping. |
+9 more columns in ftr_customer_returns. The full schema ships with the download.
ftr_cash_receipts· Rows: 17,000
| Column | Type | Description |
|---|---|---|
| cash_receipt_id | varchar(40) | Stable identifier for the cash receipt, used by the declared relationships for this dataset. |
| invoice_id | varchar(40) | Stable identifier for the invoice, used by the declared relationships for this dataset. |
| customer_organization_id | varchar(32) | Stable identifier for the customer organization, used by the declared relationships for this dataset. |
| receipt_code | varchar(32) | Machine-readable receipt code used for deterministic filtering and grouping. |
| receipt_date_id | varchar(24) | Calendar-day key for receipt, joined to ftr_calendar_days. |
| currency_code | varchar(8) | Machine-readable currency code used for deterministic filtering and grouping. |
| receipt_amount_usd | numeric(9,2) | Modeled receipt amount amount in United States dollars. |
+5 more columns in ftr_cash_receipts. The full schema ships with the download.
ftr_production_batches· Rows: 22,000
| Column | Type | Description |
|---|---|---|
| production_batch_id | varchar(32) | Stable identifier for the production batch, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| output_item_id | varchar(32) | Stable identifier for the output item, used by the declared relationships for this dataset. |
| haccp_plan_id | varchar(40) | Stable identifier for the haccp plan, used by the declared relationships for this dataset. |
| batch_code | varchar(32) | Machine-readable batch code used for deterministic filtering and grouping. |
| planned_start_date_id | varchar(24) | Calendar-day key for planned start, joined to ftr_calendar_days. |
| actual_start_timestamp | varchar(32) | ISO 8601 timestamp for the actual start event in this row. |
+13 more columns in ftr_production_batches. The full schema ships with the download.
ftr_traceability_lots· Rows: 63,104
| Column | Type | Description |
|---|---|---|
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| traceability_lot_code | varchar(40) | Regulatory traceability lot code carried across covered critical tracking events. |
| item_id | varchar(40) | Stable identifier for the item, used by the declared relationships for this dataset. |
| origin_batch_id | varchar(32) | Stable identifier for the origin batch, used by the declared relationships for this dataset. |
| source_organization_id | varchar(32) | Stable identifier for the source organization, used by the declared relationships for this dataset. |
| tlc_source_facility_id | varchar(32) | Facility where the traceability lot code was assigned under the modeled traceability rule. |
| parent_purchase_order_line_id | varchar(32) | Stable identifier for the parent purchase order line, used by the declared relationships for this dataset. |
+11 more columns in ftr_traceability_lots. The full schema ships with the download.
ftr_lot_lineage· Rows: 68,000
| Column | Type | Description |
|---|---|---|
| lineage_id | varchar(32) | Stable identifier for the lineage, used by the declared relationships for this dataset. |
| production_batch_id | varchar(32) | Stable identifier for the production batch, used by the declared relationships for this dataset. |
| input_lot_id | varchar(40) | Stable identifier for the input lot, used by the declared relationships for this dataset. |
| output_lot_id | varchar(40) | Stable identifier for the output lot, used by the declared relationships for this dataset. |
| relationship_code | varchar(40) | Machine-readable relationship code used for deterministic filtering and grouping. |
| relationship_name | varchar(56) | Readable relationship name corresponding to the related code or identifier. |
| input_quantity | integer | Quantity for input, expressed in the accompanying unit. |
+4 more columns in ftr_lot_lineage. The full schema ships with the download.
ftr_trace_events· Rows: 94,000
| Column | Type | Description |
|---|---|---|
| trace_event_id | varchar(40) | Stable identifier for the trace event, used by the declared relationships for this dataset. |
| event_type_code | varchar(40) | Machine-readable event type code used for deterministic filtering and grouping. |
| event_type_name | varchar(40) | Readable event type name corresponding to the related code or identifier. |
| event_timestamp | varchar(32) | ISO 8601 timestamp for the event event in this row. |
| acting_organization_id | varchar(32) | Stable identifier for the acting organization, used by the declared relationships for this dataset. |
| event_facility_id | varchar(32) | Stable identifier for the event facility, used by the declared relationships for this dataset. |
| source_facility_id | varchar(32) | Stable identifier for the source facility, used by the declared relationships for this dataset. |
+16 more columns in ftr_trace_events. The full schema ships with the download.
ftr_trace_event_lots· Rows: 182,420
| Column | Type | Description |
|---|---|---|
| trace_event_lot_id | varchar(40) | Stable identifier for the trace event lot, used by the declared relationships for this dataset. |
| trace_event_id | varchar(40) | Stable identifier for the trace event, used by the declared relationships for this dataset. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| lot_role_code | varchar(16) | Machine-readable lot role code used for deterministic filtering and grouping. |
| lot_role_name | varchar(40) | Readable lot role name corresponding to the related code or identifier. |
| item_id | varchar(40) | Stable identifier for the item, used by the declared relationships for this dataset. |
| purchase_order_line_id | varchar(32) | Stable identifier for the purchase order line, used by the declared relationships for this dataset. |
+11 more columns in ftr_trace_event_lots. The full schema ships with the download.
ftr_shipments· Rows: 18,000
| Column | Type | Description |
|---|---|---|
| shipment_id | varchar(32) | Stable identifier for the shipment, used by the declared relationships for this dataset. |
| carrier_organization_id | varchar(32) | Stable identifier for the carrier organization, used by the declared relationships for this dataset. |
| origin_facility_id | varchar(32) | Stable identifier for the origin facility, used by the declared relationships for this dataset. |
| destination_facility_id | varchar(32) | Stable identifier for the destination facility, used by the declared relationships for this dataset. |
| sales_order_id | varchar(32) | Stable identifier for the sales order, used by the declared relationships for this dataset. |
| disruption_event_id | varchar(40) | Optional dated disruption-event key whose route zone and active window overlap this shipment. |
| shipment_code | varchar(40) | Machine-readable shipment code used for deterministic filtering and grouping. |
+13 more columns in ftr_shipments. The full schema ships with the download.
ftr_shipment_stops· Rows: 39,000
| Column | Type | Description |
|---|---|---|
| shipment_stop_id | varchar(32) | Stable identifier for the shipment stop, used by the declared relationships for this dataset. |
| shipment_id | varchar(32) | Stable identifier for the shipment, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| stop_sequence | integer | Operational stop sequence within its parent document or process. |
| stop_type_code | varchar(16) | Machine-readable stop type code used for deterministic filtering and grouping. |
| stop_type_name | varchar(40) | Readable stop type name corresponding to the related code or identifier. |
| planned_arrival_timestamp | varchar(32) | ISO 8601 timestamp for the planned arrival event in this row. |
+7 more columns in ftr_shipment_stops. The full schema ships with the download.
ftr_cold_chain_readings· Rows: 220,000
| Column | Type | Description |
|---|---|---|
| cold_chain_reading_id | varchar(32) | Stable identifier for the cold chain reading, used by the declared relationships for this dataset. |
| device_id | varchar(32) | Stable identifier for the device, used by the declared relationships for this dataset. |
| shipment_id | varchar(32) | Stable identifier for the shipment, used by the declared relationships for this dataset. |
| shipment_stop_id | varchar(32) | Stable identifier for the shipment stop, used by the declared relationships for this dataset. |
| reading_timestamp | varchar(32) | ISO 8601 timestamp for the reading event in this row. |
| temperature_c | numeric(7,3) | Temperature c in degrees Celsius. |
| relative_humidity_pct | numeric(6,2) | Modeled relative humidity expressed as a percentage. |
+9 more columns in ftr_cold_chain_readings. The full schema ships with the download.
ftr_inventory_movements· Rows: 216,768
| Column | Type | Description |
|---|---|---|
| inventory_movement_id | varchar(40) | Stable identifier for the inventory movement, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| item_id | varchar(40) | Stable identifier for the item, used by the declared relationships for this dataset. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| movement_timestamp | varchar(32) | ISO 8601 timestamp for the movement event in this row. |
| movement_type_code | varchar(24) | Machine-readable movement type code used for deterministic filtering and grouping. |
| movement_type_name | varchar(48) | Readable movement type name corresponding to the related code or identifier. |
+13 more columns in ftr_inventory_movements. The full schema ships with the download.
ftr_inventory_monthly· Rows: 163,508
| Column | Type | Description |
|---|---|---|
| inventory_balance_id | varchar(40) | Stable identifier for the inventory balance, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| item_id | varchar(40) | Stable identifier for the item, used by the declared relationships for this dataset. |
| month_start_date_id | varchar(24) | First calendar day of the reporting month, joined to ftr_calendar_days. |
| opening_quantity | numeric(12,3) | Quantity for opening, expressed in the accompanying unit. |
| receipt_quantity | numeric(10,3) | Quantity for receipt, expressed in the accompanying unit. |
| production_quantity | numeric(10,3) | Quantity for production, expressed in the accompanying unit. |
+14 more columns in ftr_inventory_monthly. The full schema ships with the download.
ftr_haccp_plans· Rows: 120
| Column | Type | Description |
|---|---|---|
| haccp_plan_id | varchar(40) | Stable identifier for the haccp plan, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| item_id | varchar(32) | Stable identifier for the item, used by the declared relationships for this dataset. |
| plan_code | varchar(24) | Machine-readable plan code used for deterministic filtering and grouping. |
| plan_name | varchar(144) | Readable plan name corresponding to the related code or identifier. |
| plan_version | numeric(4,1) | The modeled plan version value recorded for this haccp plans row. |
| process_name | varchar(48) | Readable process name corresponding to the related code or identifier. |
+7 more columns in ftr_haccp_plans. The full schema ships with the download.
ftr_haccp_control_points· Rows: 580
| Column | Type | Description |
|---|---|---|
| control_point_id | varchar(48) | Stable identifier for the control point, used by the declared relationships for this dataset. |
| haccp_plan_id | varchar(40) | Stable identifier for the haccp plan, used by the declared relationships for this dataset. |
| control_point_code | varchar(40) | Machine-readable control point code used for deterministic filtering and grouping. |
| control_point_name | varchar(40) | Readable control point name corresponding to the related code or identifier. |
| process_step_sequence | integer | The modeled process step sequence value recorded for this haccp control points row. |
| process_step_name | varchar(40) | Readable process step name corresponding to the related code or identifier. |
| hazard_type_code | varchar(16) | Machine-readable hazard type code used for deterministic filtering and grouping. |
+11 more columns in ftr_haccp_control_points. The full schema ships with the download.
ftr_haccp_monitoring· Rows: 60,000
| Column | Type | Description |
|---|---|---|
| monitoring_record_id | varchar(32) | Stable identifier for the monitoring record, used by the declared relationships for this dataset. |
| control_point_id | varchar(48) | Stable identifier for the control point, used by the declared relationships for this dataset. |
| production_batch_id | varchar(32) | Stable identifier for the production batch, used by the declared relationships for this dataset. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| device_id | varchar(32) | Stable identifier for the device, used by the declared relationships for this dataset. |
| observation_method_code | varchar(40) | Machine-readable method distinguishing a calibrated instrument reading from a manual visual pass or fail check. |
| observation_method_name | varchar(40) | Readable HACCP observation method corresponding to observation_method_code. |
+8 more columns in ftr_haccp_monitoring. The full schema ships with the download.
ftr_quality_samples· Rows: 11,000
| Column | Type | Description |
|---|---|---|
| quality_sample_id | varchar(32) | Stable identifier for the quality sample, used by the declared relationships for this dataset. |
| production_batch_id | varchar(32) | Stable identifier for the production batch, used by the declared relationships for this dataset. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| collected_by_person_id | varchar(32) | Stable identifier for the collected by person, used by the declared relationships for this dataset. |
| sample_code | varchar(32) | Machine-readable sample code used for deterministic filtering and grouping. |
| sample_type_code | varchar(32) | Machine-readable sample type code used for deterministic filtering and grouping. |
+10 more columns in ftr_quality_samples. The full schema ships with the download.
ftr_quality_results· Rows: 44,000
| Column | Type | Description |
|---|---|---|
| quality_result_id | varchar(40) | Stable identifier for the quality result, used by the declared relationships for this dataset. |
| quality_sample_id | varchar(32) | Stable identifier for the quality sample, used by the declared relationships for this dataset. |
| test_code | varchar(16) | Machine-readable test code used for deterministic filtering and grouping. |
| test_name | varchar(32) | Readable test name corresponding to the related code or identifier. |
| hazard_type_code | varchar(16) | Machine-readable hazard type code used for deterministic filtering and grouping. |
| hazard_type_name | varchar(32) | Readable hazard type name corresponding to the related code or identifier. |
| test_method | varchar(56) | The modeled test method value recorded for this quality results row. |
+10 more columns in ftr_quality_results. The full schema ships with the download.
ftr_food_safety_deviations· Rows: 2,200
| Column | Type | Description |
|---|---|---|
| deviation_id | varchar(32) | Stable identifier for the deviation, used by the declared relationships for this dataset. |
| monitoring_record_id | varchar(32) | Stable identifier for the monitoring record, used by the declared relationships for this dataset. |
| quality_result_id | varchar(40) | Stable identifier for the quality result, used by the declared relationships for this dataset. |
| cold_chain_reading_id | varchar(32) | Exact excursion reading that caused a telemetry deviation. Blank for HACCP-monitoring and quality-result deviations. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| deviation_code | varchar(32) | Machine-readable deviation code used for deterministic filtering and grouping. |
+10 more columns in ftr_food_safety_deviations. The full schema ships with the download.
ftr_corrective_actions· Rows: 3,200
| Column | Type | Description |
|---|---|---|
| corrective_action_id | varchar(32) | Stable identifier for the corrective action, used by the declared relationships for this dataset. |
| deviation_id | varchar(32) | Stable identifier for the deviation, used by the declared relationships for this dataset. |
| owner_person_id | varchar(32) | Stable identifier for the owner person, used by the declared relationships for this dataset. |
| action_code | varchar(32) | Machine-readable action code used for deterministic filtering and grouping. |
| action_type_code | varchar(32) | Machine-readable action type code used for deterministic filtering and grouping. |
| action_type_name | varchar(48) | Readable action type name corresponding to the related code or identifier. |
| opened_date_id | varchar(24) | Calendar-day key for opened, joined to ftr_calendar_days. |
+10 more columns in ftr_corrective_actions. The full schema ships with the download.
ftr_audits· Rows: 1,200
| Column | Type | Description |
|---|---|---|
| audit_id | varchar(40) | Stable identifier for the audit, used by the declared relationships for this dataset. |
| audited_organization_id | varchar(32) | Stable identifier for the audited organization, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| lead_auditor_person_id | varchar(32) | Stable identifier for the lead auditor person, used by the declared relationships for this dataset. |
| audit_code | varchar(40) | Machine-readable audit code used for deterministic filtering and grouping. |
| audit_type_code | varchar(24) | Machine-readable audit type code used for deterministic filtering and grouping. |
| audit_type_name | varchar(40) | Readable audit type name corresponding to the related code or identifier. |
+10 more columns in ftr_audits. The full schema ships with the download.
ftr_recalls· Rows: 120
| Column | Type | Description |
|---|---|---|
| recall_id | varchar(32) | Stable identifier for the recall, used by the declared relationships for this dataset. |
| initiating_organization_id | varchar(32) | Stable identifier for the initiating organization, used by the declared relationships for this dataset. |
| seed_lot_id | varchar(40) | Stable identifier for the seed lot, used by the declared relationships for this dataset. |
| initiating_deviation_id | varchar(32) | Stable identifier for the initiating deviation, used by the declared relationships for this dataset. |
| initiating_quality_result_id | varchar(40) | Stable identifier for the initiating quality result, used by the declared relationships for this dataset. |
| recall_code | varchar(56) | Machine-readable recall code used for deterministic filtering and grouping. |
| recall_class_code | varchar(8) | Machine-readable recall class code used for deterministic filtering and grouping. |
+12 more columns in ftr_recalls. The full schema ships with the download.
ftr_recall_lots· Rows: 1,300
| Column | Type | Description |
|---|---|---|
| recall_lot_id | varchar(32) | Stable identifier for the recall lot, used by the declared relationships for this dataset. |
| recall_id | varchar(32) | Stable identifier for the recall, used by the declared relationships for this dataset. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| inclusion_reason_code | varchar(32) | Machine-readable inclusion reason code used for deterministic filtering and grouping. |
| inclusion_reason_name | varchar(64) | Readable inclusion reason name corresponding to the related code or identifier. |
| lineage_depth | integer | The modeled lineage depth value recorded for this recall lots row. |
| affected_quantity | integer | Quantity for affected, expressed in the accompanying unit. |
+3 more columns in ftr_recall_lots. The full schema ships with the download.
ftr_recall_actions· Rows: 6,500
| Column | Type | Description |
|---|---|---|
| recall_action_id | varchar(56) | Stable identifier for the recall action, used by the declared relationships for this dataset. |
| recall_id | varchar(32) | Stable identifier for the recall, used by the declared relationships for this dataset. |
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| shipment_id | varchar(32) | Stable identifier for the shipment, used by the declared relationships for this dataset. |
| customer_organization_id | varchar(32) | Stable identifier for the customer organization, used by the declared relationships for this dataset. |
| action_code | varchar(56) | Machine-readable action code used for deterministic filtering and grouping. |
+8 more columns in ftr_recall_actions. The full schema ships with the download.
ftr_waste_disposals· Rows: 4,800
| Column | Type | Description |
|---|---|---|
| waste_disposal_id | varchar(48) | Stable identifier for the waste disposal, used by the declared relationships for this dataset. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| disposal_organization_id | varchar(32) | Stable identifier for the disposal organization, used by the declared relationships for this dataset. |
| recall_id | varchar(32) | Stable identifier for the recall, used by the declared relationships for this dataset. |
| disposal_code | varchar(48) | Machine-readable disposal code used for deterministic filtering and grouping. |
| disposal_date_id | varchar(24) | Calendar-day key for disposal, joined to ftr_calendar_days. |
+11 more columns in ftr_waste_disposals. The full schema ships with the download.
ftr_journal_entries· Rows: 28,300
| Column | Type | Description |
|---|---|---|
| journal_entry_id | varchar(40) | Stable identifier for the journal entry, used by the declared relationships for this dataset. |
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| posting_date_id | varchar(24) | Calendar-day key for posting, joined to ftr_calendar_days. |
| source_document_type_code | varchar(24) | Machine-readable source document type code used for deterministic filtering and grouping. |
| source_document_type_name | varchar(48) | Readable source document type name corresponding to the related code or identifier. |
| invoice_id | varchar(40) | Stable identifier for the invoice, used by the declared relationships for this dataset. |
+10 more columns in ftr_journal_entries. The full schema ships with the download.
ftr_journal_lines· Rows: 76,600
| Column | Type | Description |
|---|---|---|
| journal_line_id | varchar(40) | Stable identifier for the journal line, used by the declared relationships for this dataset. |
| journal_entry_id | varchar(40) | Stable identifier for the journal entry, used by the declared relationships for this dataset. |
| line_number | varchar(8) | Operational line number within its parent document or process. |
| gl_account_code | varchar(32) | Machine-readable gl account code used for deterministic filtering and grouping. |
| facility_id | varchar(32) | Stable identifier for the facility, used by the declared relationships for this dataset. |
| lot_id | varchar(40) | Stable identifier for the lot, used by the declared relationships for this dataset. |
| debit_usd | numeric(9,2) | Modeled debit amount in United States dollars. |
+5 more columns in ftr_journal_lines. The full schema ships with the download.
ftr_business_unit_financials_monthly· Rows: 3,456
| Column | Type | Description |
|---|---|---|
| financial_summary_id | varchar(32) | Stable identifier for the financial summary, used by the declared relationships for this dataset. |
| organization_id | varchar(32) | Stable identifier for the organization, used by the declared relationships for this dataset. |
| month_start_date_id | varchar(24) | First calendar day of the reporting month, joined to ftr_calendar_days. |
| revenue_usd | numeric(11,2) | Modeled revenue amount in United States dollars. |
| discounts_returns_usd | numeric(9,2) | Modeled discounts returns amount in United States dollars. |
| net_revenue_usd | numeric(10,2) | Modeled net revenue amount in United States dollars. |
| raw_material_cost_usd | numeric(10,2) | Modeled raw material cost amount in United States dollars. |
+18 more columns in ftr_business_unit_financials_monthly. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| trace_event_id | event_type_code | event_type_name | event_timestamp | acting_organization_id | event_facility_id | shipment_id | production_batch_id | reference_document_number | event_status | kde_validation_status | source_status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| KDE-HARVEST-20150214-BEZYK | HARVESTING | Harvesting | 2015-02-14T06:00:00Z | ORG-US-GROWER-QB3CJD-V | FAC-US-FARM-HC57XH-T | KDEDOC-HARVEST-15045-EX1R7X-X | COMPLETED | COMPLETE | synthetic_historical | ||
| KDE-HARVEST-20150221-ZNVEA | HARVESTING | Harvesting | 2015-02-21T06:07:00Z | ORG-US-GROWER-QB3CJD-V | FAC-US-FARM-EC0G7B-Z | KDEDOC-HARVEST-15052-KWG7TY-H | COMPLETED | COMPLETE | synthetic_historical | ||
| KDE-HARVEST-20150224-FTFXP | HARVESTING | Harvesting | 2015-02-24T06:14:00Z | ORG-US-GROWER-QB3CJD-V | FAC-US-FARM-HC57XH-T | KDEDOC-HARVEST-15055-YK5BAR-S | COMPLETED | COMPLETE | synthetic_historical |
Version History
| v1.0.0 | 2026-09-01 | Initial enterprise release with end-to-end lot genealogy, food-safety controls, refrigerated transport, recall execution, operational accounting and governed product media. |
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