Data Classification
ISO 27001 / ISO 27701 compliant data classification registry
144
Total Fields
124
Encrypted
87
Audited
113
Financial
31
PII
Showing 144 of 144 fields
| Table | Field | Level | Description | Encrypt | Audit | Compliance |
|---|---|---|---|---|---|---|
cm_project_items | unit_price | P1 | Customer-facing unit price | ISO27001SOC2 | ||
cm_project_items | total_price | P1 | Customer-facing total price | ISO27001SOC2 | ||
cm_project_items | margin_percent | P1 | Overall profit margin percentage | ISO27001SOC2 | ||
cm_project_items | material_margin_percent | P1 | Material profit margin percentage | ISO27001SOC2 | ||
cm_project_items | operation_margin_percent | P1 | Operation profit margin percentage | ISO27001SOC2 | ||
cm_project_items | effective_margin_percent | P1 | Effective (realized) margin percentage | ISO27001SOC2 | ||
cm_project_items | material_price_per_unit | P1 | Material selling price per unit | ISO27001SOC2 | ||
cm_project_items | operation_price_per_unit | P1 | Operation selling price per unit | ISO27001SOC2 | ||
cm_project_quote_items | unit_price | P1 | Quoted unit price | ISO27001SOC2 | ||
cm_project_quote_items | total_price | P1 | Quoted total price | ISO27001SOC2 | ||
cm_project_quote_items | margin_percent | P1 | Quoted margin percentage | ISO27001SOC2 | ||
cm_project_quote_items | material_margin_percent | P1 | Quoted material margin | ISO27001SOC2 | ||
cm_project_quote_items | operation_margin_percent | P1 | Quoted operation margin | ISO27001SOC2 | ||
cm_project_quote_items | effective_margin_percent | P1 | Quoted effective margin | ISO27001SOC2 | ||
cm_project_quote_items | material_price_per_unit | P1 | Quoted material price | ISO27001SOC2 | ||
cm_project_quote_items | operation_price_per_unit | P1 | Quoted operation price | ISO27001SOC2 | ||
cm_project_quotes | discount_percent | P1 | Quote discount percentage | ISO27001SOC2 | ||
cm_project_quotes | discount_amount | P1 | Quote discount amount | ISO27001SOC2 | ||
cm_project_item_price_history | prev_unit_price | P1 | Previous unit price | ISO27001SOC2 | ||
cm_project_item_price_history | new_unit_price | P1 | New unit price | ISO27001SOC2 | ||
cm_project_item_price_history | prev_total_price | P1 | Previous total price | ISO27001SOC2 | ||
cm_project_item_price_history | new_total_price | P1 | New total price | ISO27001SOC2 | ||
cm_project_item_price_history | prev_material_margin_percent | P1 | Previous material margin | ISO27001SOC2 | ||
cm_project_item_price_history | new_material_margin_percent | P1 | New material margin | ISO27001SOC2 | ||
cm_project_item_price_history | prev_operation_margin_percent | P1 | Previous operation margin | ISO27001SOC2 | ||
cm_project_item_price_history | new_operation_margin_percent | P1 | New operation margin | ISO27001SOC2 | ||
cm_project_item_price_history | prev_material_price_per_unit | P1 | Previous material price | ISO27001SOC2 | ||
cm_project_item_price_history | new_material_price_per_unit | P1 | New material price | ISO27001SOC2 | ||
cm_project_item_price_history | prev_operation_price_per_unit | P1 | Previous operation price | ISO27001SOC2 | ||
cm_project_item_price_history | new_operation_price_per_unit | P1 | New operation price | ISO27001SOC2 | ||
quote_items | unit_price | P1 | Customer unit price | ISO27001SOC2 | ||
quote_items | total_price | P1 | Customer total price | ISO27001SOC2 | ||
quote_items | margin_percent | P1 | Profit margin percentage | ISO27001SOC2 | ||
quote_item_materials | material_price | P1 | Material price per kg | ISO27001SOC2 | ||
quote_item_materials | unit_price | P1 | Material unit price per piece | ISO27001SOC2 | ||
quote_item_materials | scrap_price | P1 | Scrap recovery price per kg | ISO27001SOC2 | ||
quote_item_materials | scrap_discount | P1 | Scrap discount amount | ISO27001SOC2 | ||
quote_item_operations | unit_cost | P1 | Operation cost per piece | ISO27001SOC2 | ||
quote_item_operations | profit_margin | P1 | Operation profit margin | ISO27001SOC2 | ||
quote_item_operations | machine_rate | P1 | Machine rate (TL/second) | ISO27001SOC2 | ||
quote_item_external_services | base_price | P1 | Service base price | ISO27001SOC2 | ||
quote_item_external_services | unit_cost | P1 | Service unit cost | ISO27001SOC2 | ||
quote_item_additional_costs | unit_price | P1 | Additional cost unit price | ISO27001SOC2 | ||
quote_item_additional_costs | total_price | P1 | Additional cost total | ISO27001SOC2 | ||
quote_additional_costs | amount | P1 | Quote-level additional cost | ISO27001SOC2 | ||
quotes | discount_percent | P1 | Quote discount percentage | ISO27001SOC2 | ||
quotes | discount_amount | P1 | Quote discount amount | ISO27001SOC2 | ||
sales_order_lines | unit_price | P1 | Sales unit price | ISO27001SOC2 | ||
sales_order_lines | line_amount | P1 | Sales line total | ISO27001SOC2 | ||
sales_order_lines | discount_percent | P1 | Line discount percentage | ISO27001SOC2 | ||
sales_order_lines | discount_amount | P1 | Line discount amount | ISO27001SOC2 | ||
sales_orders | discount_percent | P1 | Order discount percentage | ISO27001SOC2 | ||
sales_orders | discount_amount | P1 | Order discount amount | ISO27001SOC2 | ||
supplier_quotation_line_items | unit_price | P1 | Supplier unit price | ISO27001SOC2 | ||
supplier_quotation_line_items | line_amount | P1 | Supplier line total | ISO27001SOC2 | ||
supplier_quotation_line_items | discount_percent | P1 | Supplier discount | ISO27001SOC2 | ||
supplier_quotation_line_items | discount_amount | P1 | Supplier discount amount | ISO27001SOC2 | ||
purchase_order_line_items | unit_price | P1 | Purchase unit price | ISO27001SOC2 | ||
purchase_order_line_items | line_amount | P1 | Purchase line total | ISO27001SOC2 | ||
purchase_order_line_items | discount_percent | P1 | Purchase discount | ISO27001SOC2 | ||
purchase_order_line_items | discount_amount | P1 | Purchase discount amount | ISO27001SOC2 | ||
supplier_price_list_items | unit_price | P1 | Supplier list price | ISO27001SOC2 | ||
customers | minimum_margin_percent | P1 | Customer minimum acceptable margin | ISO27001SOC2 | ||
party_financial_terms | default_discount_percent | P1 | Default discount for party | ISO27001SOC2 | ||
party_financial_terms | credit_limit | P1 | Credit limit amount | ISO27001SOC2 | ||
item_prices | price | P1 | Item price (buy/sell/list/cost) | ISO27001SOC2 | ||
cm_project_items | material_cost_per_unit | P2 | Internal material cost | - | ISO27001SOC2 | |
cm_project_items | operations_cost_per_unit | P2 | Internal operation cost | - | ISO27001SOC2 | |
cm_project_quote_items | material_cost_per_unit | P2 | Quoted material cost | - | ISO27001SOC2 | |
cm_project_quote_items | operations_cost_per_unit | P2 | Quoted operation cost | - | ISO27001SOC2 | |
quote_items | material_cost_per_unit | P2 | Material cost per unit | - | ISO27001SOC2 | |
quote_items | operations_cost_per_unit | P2 | Operations cost per unit | - | ISO27001SOC2 | |
quote_items | base_cost_per_unit | P2 | Total base cost | - | ISO27001SOC2 | |
quote_item_materials | cost_per_unit | P2 | Material cost per unit | - | ISO27001SOC2 | |
quote_item_materials | total_cost | P2 | Total material cost | - | ISO27001SOC2 | |
quote_item_materials | material_amount | P2 | Material amount before inflation | - | ISO27001SOC2 | |
quote_item_operations | cost_per_unit | P2 | Operation cost per unit | - | ISO27001SOC2 | |
quote_item_operations | total_cost | P2 | Total operation cost | - | ISO27001SOC2 | |
quote_item_operations | base_cost | P2 | Base cost pre-margin | - | ISO27001SOC2 | |
quote_item_operations | labor_cost_per_hour | P2 | Labor cost snapshot | - | ISO27001SOC2 | |
quote_item_operations | overhead_cost_per_hour | P2 | Overhead cost snapshot | - | ISO27001SOC2 | |
quote_bom_components | unit_cost | P2 | BOM component unit cost | - | ISO27001SOC2 | |
quote_bom_components | total_cost | P2 | BOM component total cost | - | ISO27001SOC2 | |
cm_project_item_bom_components | unit_cost | P2 | BOM component unit cost | - | ISO27001SOC2 | |
cm_project_item_bom_components | total_cost | P2 | BOM component total cost | - | ISO27001SOC2 | |
work_centers | labor_cost_per_hour | P2 | Work center labor rate | - | ISO27001SOC2 | |
work_centers | overhead_cost_per_hour | P2 | Work center overhead rate | - | ISO27001SOC2 | |
work_stations | labor_cost_per_hour | P2 | Work station labor rate | - | ISO27001SOC2 | |
work_stations | overhead_cost_per_hour | P2 | Work station overhead rate | - | ISO27001SOC2 | |
work_stations | setup_cost_per_hour | P2 | Work station setup rate | - | ISO27001SOC2 | |
work_station_types | default_cost_per_hour | P2 | Default hourly rate | - | ISO27001SOC2 | |
work_station_machining_configs | labor_cost_per_hour | P2 | Machining labor rate | - | ISO27001SOC2 | |
routing_operations | labor_cost | P2 | Operation labor cost | - | ISO27001SOC2 | |
routing_operations | overhead_cost | P2 | Operation overhead cost | - | ISO27001SOC2 | |
routing_operations | setup_cost | P2 | Operation setup cost | - | ISO27001SOC2 | |
routing_operations | subcontract_cost | P2 | Subcontract total cost | - | ISO27001SOC2 | |
routing_operations | subcontract_unit_price | P2 | Subcontract unit price | - | ISO27001SOC2 | |
routings | labor_cost_per_unit | P2 | Routing labor rate | - | ISO27001SOC2 | |
routings | overhead_cost_per_unit | P2 | Routing overhead rate | - | ISO27001SOC2 | |
routings | setup_cost_per_unit | P2 | Routing setup rate | - | ISO27001SOC2 | |
routing_operation_resources | cost_per_unit | P2 | Resource unit cost | - | ISO27001SOC2 | |
routing_operation_resources | total_cost | P2 | Resource total cost | - | ISO27001SOC2 | |
supplier_service_prices | unit_price | P2 | Supplier service price | - | ISO27001SOC2 | |
lots | unit_cost | P3 | Lot unit cost for valuation | - | ISO27001 | |
stock | unit_cost | P3 | Stock unit cost | - | ISO27001 | |
stock | total_cost | P3 | Stock total value | - | ISO27001 | |
stock_movements | unit_cost | P3 | Movement unit cost | - | ISO27001 | |
stock_movements | total_cost | P3 | Movement total cost | - | ISO27001 | |
exchange_rates | usd_buy | P3 | USD buying rate | - | ISO27001 | |
exchange_rates | usd_sell | P3 | USD selling rate | - | ISO27001 | |
exchange_rates | eur_buy | P3 | EUR buying rate | - | ISO27001 | |
exchange_rates | eur_sell | P3 | EUR selling rate | - | ISO27001 | |
items | tax_rate | P3 | Item default tax rate | - | ISO27001 | |
persons | first_name | PII-D | First name | ISO27701KVKKGDPR | ||
persons | last_name | PII-D | Last name | ISO27701KVKKGDPR | ||
parties | name | PII-D | Company/Person name | ISO27701KVKKGDPR | ||
parties | legal_name | PII-D | Legal name | ISO27701KVKKGDPR | ||
parties | tax_id | PII-D | Tax ID / TC Kimlik | ISO27701KVKKGDPR | ||
users | display_name | PII-D | User display name | ISO27701KVKKGDPR | ||
tenant_users | PII-D | User email address | ISO27701KVKKGDPR | |||
contact_mechanisms | contact_value | PII-D | Contact value (email, phone, fax) | ISO27701KVKKGDPR | ||
email_verification_tokens | PII-D | Email address | ISO27701KVKKGDPR | |||
password_reset_tokens | PII-D | Email address | ISO27701KVKKGDPR | |||
supplier_quotations | contact_name | PII-D | Contact person name | ISO27701KVKKGDPR | ||
supplier_quotations | contact_email | PII-D | Contact email | ISO27701KVKKGDPR | ||
supplier_quotations | contact_phone | PII-D | Contact phone | ISO27701KVKKGDPR | ||
request_for_quotations | contact_email | PII-D | Contact email | ISO27701KVKKGDPR | ||
shipments | driver_name | PII-D | Driver name | ISO27701KVKKGDPR | ||
audit_logs | user_name | PII-D | User name | ISO27701KVKKGDPR | ||
audit_logs | user_email | PII-D | User email | ISO27701KVKKGDPR | ||
quality_inspections | inspector_name | PII-D | Inspector name | ISO27701KVKKGDPR | ||
quality_measurements | measured_by_name | PII-D | Measured by name | ISO27701KVKKGDPR | ||
sessions | ip_address | PII-I | IP address | - | ISO27701KVKKGDPR | |
sessions | device_name | PII-I | Device name | - | ISO27701KVKKGDPR | |
auth_methods | provider_id | PII-I | Provider ID (may be email) | - | ISO27701KVKKGDPR | |
audit_logs | ip_address | PII-I | IP address | - | ISO27701KVKKGDPR | |
addresses | line1 | PII-I | Address line 1 | - | ISO27701KVKKGDPR | |
addresses | line2 | PII-I | Address line 2 | - | ISO27701KVKKGDPR | |
addresses | city | PII-I | City | - | ISO27701KVKKGDPR | |
addresses | state | PII-I | State/Province | - | ISO27701KVKKGDPR | |
addresses | postal_code | PII-I | Postal code | - | ISO27701KVKKGDPR | |
addresses | country_code | PII-I | Country code | - | ISO27701KVKKGDPR | |
users | two_factor_secret | PII-S | 2FA secret (authentication) | ISO27701KVKKGDPRHIPAA | ||
auth_methods | password_hash | PII-S | Password hash | ISO27701KVKKGDPRHIPAA |