Bill of Materials (BOM) Version Control
Ensures that all Bill of Materials have a clear version number and effectivity dates (start/end) to manage changes over time.
RFC 5322 Email Format Standard
Ensures that email addresses are syntactically valid according to the format defined by the Internet Engineering Task Force (IETF).
Permit/License Expiry Tracking
Ensures all required business permits and licenses have valid expiry dates tracked and monitored.
Work Order Status Lifecycle Validation
Ensures work orders follow valid status transitions and cannot skip required workflow steps.
Numeric Precision for Measurements
Ensures measurement data is stored with appropriate precision for engineering requirements.
Unit of Measure Standardization
Ensures consistent units of measure across all systems and data fields.
SKU Format Standardization
Ensures all Stock Keeping Unit (SKU) identifiers follow a consistent format and structure.
Weight/Volume Consistency Check
Validates that weight and volume measurements are logically consistent based on known density ranges.
Calibration Due Date Enforcement
Ensures all measurement equipment has valid calibration with future expiry dates.
Mandatory Field Completeness
Ensures all fields marked as required/mandatory contain valid non-null values.
Percentage Field Range Validation
Ensures fields representing percentages contain values between 0 and 100.
ISO 4217 Currency Code Standard
Ensures all financial transactions use the standardized three-letter codes for currencies.
Customer Master Golden Record
Ensures single, authoritative customer record exists per unique business entity.
Future Date Prohibition (Transaction Dates)
Prevents transaction dates from being set in the future unless explicitly allowed for scheduling.
Inventory Count Reconciliation Rule
Ensures physical inventory counts are reconciled with system records and variances investigated.
Incoterms® Validation
Ensures trade terms use official Incoterms® 2020 codes.
Asset Criticality Classification
Ensures all physical assets are classified by business criticality (Critical, High, Medium, Low).
Product Category Classification
Ensures all products are classified using standard industry category taxonomy.
Material Safety Data Sheet (MSDS) Linkage
Ensures all chemical products have valid MSDS documentation linked in master data.
ISO 6346 Shipping Container ID Standard
Ensures all shipping container identifiers conform to the international standard (4-letter owner code, 6-digit serial number, 1-digit check digit).
Timestamp Immutability Rule
Ensures audit timestamps (created_at, updated_at) cannot be modified by users and are system-generated only.
Latitude/Longitude Precision Standard
Ensures geographic coordinates have sufficient precision for business use (typically 6 decimal places).
Wellbore Unique Identifier (WUID/UWI)
Ensures every wellbore has a standardized, unique identifier based on its geographic location and other attributes, following industry standards (e.g., PPDM).
Serial Number Uniqueness Global
Ensures serial numbers for physical assets are globally unique across all sites and systems.
Positive Numeric Values Only
Ensures numeric fields that represent quantities, prices, or measurements contain only positive values.
Vessel IMO Number Validation
Ensures all vessel identifiers use valid International Maritime Organization numbers.
Unique Equipment Identifier (Master Data)
Ensures every significant piece of physical equipment has a single, unique, and non-reusable identifier across all company systems.
Referential Integrity Enforcement
Ensures foreign key relationships are maintained and no orphan records exist.
Temperature Range Validation
Ensures temperature readings fall within physically plausible ranges for the specific context.
Tax ID Format Validation
Ensures tax identification numbers follow country-specific format standards.
HS Code Validation (Harmonized System)
Ensures product classifications use valid HS (Harmonized System) tariff codes.
Shift Code Standardization
Ensures work shifts are coded consistently across all sites and systems.
Date Range Validation
Ensures date fields contain logically valid dates within acceptable business ranges.
Customer Credit Limit Validation
Ensures all orders are validated against customer credit limits before approval.
Chart of Accounts Validation
Ensures all financial transactions post to valid, active general ledger account codes.
Duplicate Record Prevention
Ensures no duplicate records exist based on defined business keys.
Port UNLOCODE Validation
Ensures all port/location codes use the UN/LOCODE standard format.
Standard Carrier Alpha Code (SCAC)
Ensures the use of the 2-to-4 letter codes used to identify transportation companies.
Batch/Lot Number Traceability
Ensures all manufactured products have traceable batch or lot numbers for quality control and recalls.
Price Precision Standard (2 Decimal Places)
Ensures all monetary values are stored with exactly 2 decimal places for currency precision.
Inspection Frequency Compliance
Ensures all assets undergo required inspections at mandated frequencies.
Geofence Boundary Validation
Ensures GPS coordinates fall within defined operational boundaries for facilities or service areas.
Vendor Master Completeness
Ensures all vendor/supplier records have complete required fields before activation.
ISO 8601 Date-Time Format
Ensures all date and time data uses the international standard format.
Hazmat Classification Validation
Ensures all hazardous materials are classified according to UN/DOT standards.
Unique Identifier Non-Reuse Policy
Ensures unique identifiers (customer ID, order number, asset tag) are never reused even after deletion or archival.
Password Strength Requirements
Ensures all user passwords meet minimum complexity and length requirements.
Address Validation Service (e.g., USPS/Loqate)
Ensures all physical addresses are validated, cleansed, and standardized against an official postal service database at the point of entry.
E.164 International Phone Number Format
Ensures phone numbers follow the international standard format including country code.
ISO 3166-1 Country Code Standard
Ensures all country data uses the standardized two-letter (alpha-2) codes as defined by the International Organization for Standardization.