| Field | Fill Rate | Contracts |
|---|---|---|
| rate | 100% | 63/63 |
| rate_type | 100% | 63/63 |
| rate_basis | 100% | 63/63 |
| vehicle_type | 100% | 63/63 |
| plan_type | 100% | 63/63 |
| pricing_template | 100% | 63/63 |
| carrier_name | 100% | 63/63 |
| trip_type | 95.2% | 60/63 |
| lane_code | 84.1% | 53/63 |
| pricing_distance | 81.0% | 51/63 |
| transit_time | 54.0% | 34/63 |
| vehicle_type_code | 34.9% | 22/63 |
| capping_period | 31.7% | 20/63 |
| sub_branch_type | 20.6% | 13/63 |
| capping | 15.9% | 10/63 |
| Field | Fill Rate | Count |
|---|---|---|
| total_contract_value | 10.4% | 7/67 |
| deviation_limit | 19.4% | 13/67 |
| master_agreement_reference | 20.9% | 14/67 |
| notice_period_days | 25.4% | 17/67 |
| payment_terms_days | 28.4% | 19/67 |
| client_signatory_designation | 44.8% | 30/67 |
| auto_renewal | 50.7% | 34/67 |
| vendor_signatory_designation | 52.2% | 35/67 |
| client_signatory_name | 64.2% | 43/67 |
| vendor_signatory_name | 65.7% | 44/67 |
| validity_period | 71.6% | 48/67 |
| term_duration | 73.1% | 49/67 |
| penalty_terms | 79.1% | 53/67 |
| agreement_date | 92.5% | 62/67 |
| vendor_signature_present | 92.5% | 62/67 |
| client_signature_present | 92.5% | 62/67 |
| end_date | 95.5% | 64/67 |
| entity_name | 98.5% | 66/67 |
| execution_date | 98.5% | 66/67 |
| commercial_terms | 98.5% | 66/67 |
| contract_type | 98.5% | 66/67 |
| governing_law | 98.5% | 66/67 |
| vendor_name | 100.0% | 67/67 |
| start_date | 100.0% | 67/67 |
| currency | 100.0% | 67/67 |
| has_addendum | 100.0% | 67/67 |
| lob_codes | 100.0% | 67/67 |
| service_segment | 100.0% | 67/67 |
| geography_coverage | 100.0% | 67/67 |
| lob_classification_reasoning | 100.0% | 67/67 |
| # | Category & Details | Severity | Vendors | % Coverage |
|---|---|---|---|---|
| 1 | Extra Hour Charges extra_hour_charges, extra_hour_rate, extra_hr_rate GHOSH TRANSPORT PRIVATE LIMITED: 12-hour deployments charge extra per hour beyond duration (70-180 Rs/hr by vehicle) - time-based penalty not in schema PREMIER PEOPLE LOGISTIC SOLUTIONS PRIVATE LIMITED: Explicitly listed for all 12hr services (60-180 INR) but marked 'NA' for 24hr services—this variable cost component is contractually defined but schema doesn't ... |
critical | 29 | 43.3% |
| 2 | Vehicle Dimensions & Capacity vehicle_capacity_weight, vehicle_dimension_specifications, vehicle_dimension_specs, vehicle_dimensional_specifications, vehicle_dimensions +5 more HARIOM LOGISTICS: Detailed length/breadth/height specs (e.g., 10ft: 10x6.8x7.2) define actual capacity beyond vehicle type label, critical for load planning but schema only captu... MEDALLION TRANSLINKS LLP: Contract includes detailed vehicle dimension specifications (length/breadth/height for all vehicle types) which could be needed for load planning but schema has... |
critical | 27 | 40.3% |
| 3 | Fuel Escalation Mechanism base_fuel_rate, fuel_escalation_applicability, fuel_escalation_formula, fuel_escalation_mechanism, fuel_price_reference +2 more HARIOM LOGISTICS: Explicit 'Not applicable for local line haul & Grocery movements' clause means fixed rates without inflation adjustment, but schema has no field to indicate if ... New Kiran Cargo Movers: Base fuel rate of 92.06 is fundamental for fuel adjustment calculations and cost reconciliation but completely absent from linehaul schema |
critical | 18 | 26.9% |
| 4 | Extra KM Charges extra_km_and_extra_hour_rates, extra_km_rate, variable_km_rate HARIOM LOGISTICS: Adhoc rates include separate 'extra_km' (e.g., 7.35) and 'extra_hour' (e.g., 63) charges beyond base, creating complex multi-component billing that schema's sin... PREMIER PEOPLE LOGISTIC SOLUTIONS PRIVATE LIMITED: Contract specifies per-km overage rates (7.5-23.75 INR) that differ by vehicle type, region, and usage pattern—critical for actual cost calculation beyond base ... |
critical | 17 | 25.4% |
| 5 | Deployment Duration (12h vs 24h) deployment_duration_pricing, deployment_hours, fixed_hours, fixed_hours_per_day, multi_duration_pricing_matrix +3 more GHOSH TRANSPORT PRIVATE LIMITED: LH Local rates have completely different structure: fixed monthly deployment (12hr/24hr) with base km (1000km) and extra km/hour charges, not captured by simple... HARIOM LOGISTICS: All adhoc and monthly rates differentiate 12-hour vs 24-hour shifts with 15-30% rate differences, but schema has no field to capture this critical operational a... |
critical | 16 | 23.9% |
| 6 | Base / Minimum KM Guarantee base_cost_plus_extra_km_structure, base_distance_included, base_included_kilometers, base_kilometers_requirement, fix_km_threshold +5 more GHOSH TRANSPORT PRIVATE LIMITED: 150km minimum per two-way trip affects actual cost calculation but schema only stores it as 'pricing_distance' without enforcement logic GHOSH TRANSPORT PRIVATE LIMITED: LH Local has 1000 fix_km with base rate, then extra_km_rate applies - two-tier pricing structure flattened to single rate |
critical | 13 | 19.4% |
| 7 | LOB / Vertical Segmentation bu_vertical, bu_vertical_applicability, bu_vertical_segmentation, grocery_lh_separate_rate_structure, lob_specific_rates +4 more GHOSH TRANSPORT PRIVATE LIMITED: Rates applicable for specific FK verticals (Non-Large, Large, IWIT, PL, Myntra) - multi-LOB usage not mapped HARIOM LOGISTICS: Separate annexure for Grocery LH (referencing same rates) indicates vertical-specific contracting even when rates align, but schema has no LOB differentiation w... |
critical | 13 | 19.4% |
| 8 | Regional / State-wise Rate Variations origin_state_filter, region_specific_rate_variations, region_specific_rates_granularity, regional_rate_variation, regional_rate_variations +3 more HARIOM LOGISTICS: Adhoc rates vary by region (Delhi/NCR vs Himachal: 1785 vs 1943 for same vehicle), but schema's 'lane_code' is too broad to capture intra-northern region pricin... PREMIER PEOPLE LOGISTIC SOLUTIONS PRIVATE LIMITED: Rates vary significantly by state (Andhra Pradesh vs Telangana shown with different rates for same vehicles)—geographic pricing variation is contractually defin... |
critical | 13 | 19.4% |
| 9 | Adhoc vs Regular Rate Distinction adhoc_daily_rates, adhoc_rate_per_km, adhoc_rates, adhoc_vs_regular_rate_distinction, rate_per_day_adhoc +1 more GHOSH TRANSPORT PRIVATE LIMITED: Contract contains separate adhoc rates (e.g., Pickup: 18.86 vs regular 14.65) triggered by 12-hour advance notice requirement, but schema only captures single r... HARIOM LOGISTICS: Every vehicle type has two distinct rates (regular: 14.91, adhoc: 16.28 for 10ft) representing different pricing tiers, but schema only captures single 'rate' v... |
critical | 12 | 17.9% |
| 10 | Monthly Fixed + Variable Hybrid Pricing fixed_plus_variable_hybrid_model, kms_slab_progression, monthly_deployment_rates, monthly_fixed_variable_hybrid_pricing, monthly_kilometer_slabs +3 more HARIOM LOGISTICS: Entire annexure_b_delhi_ncr_monthly_rates structure with slab-based pricing (1000km to 7500km) for 12hr/24hr shifts is completely missing - represents alternati... LS TRANSCO PVT LTD: Local regular rates use monthly commitment slabs (1000km, 4000km, 7500km per 30-31 days) with drastically different total costs, but schema only captures single... |
critical | 9 | 13.4% |
| 11 | Vehicle Type Variations multi_vehicle_composite_rows, vehicle_groupings, vehicle_type_variants, vehicle_type_variations HARIOM LOGISTICS: Contract groups vehicles (e.g., '19_20_22_feet' combined, '22_24ft' as single category) showing pricing commonality, but schema forces individual vehicle type r... LS TRANSCO PVT LTD: Local rates presented as single rows with 17 vehicle types (TATA_ACE through 32FT_SXL) across columns, but schema explodes into separate rows losing the fact th... |
critical | 8 | 11.9% |
| 12 | Penalty & SLA Structure minimum_bbd_adherence_requirement, penalty_structure, pod_closure_requirements HARIOM LOGISTICS: 40% minimum BBD adherence at BAU prices is contractual obligation affecting rate validity, but schema lacks any quality/compliance metric fields ALLCARGO LOGISTICS LIMITED: Performance-based penalties (0.5-2% of monthly billing) for TAT/pickup breaches create variable costs tied to service levels |
critical | 6 | 9.0% |
| 13 | Service Type Classification local_vs_zonal_service_type, service_type_classification, usage_pattern, zonal_vs_point_to_point_distinction PREMIER PEOPLE LOGISTIC SOLUTIONS PRIVATE LIMITED: Contract has separate 'regular' (1000km fixed) vs 'adhoc' (100km fixed) structures with vastly different economics—regular is monthly commitment while adhoc is ... LS TRANSCO PVT LTD: Contract defines completely separate rate structures for 'lh_zonal' (inter-city) and 'lh_local_regular' (intra-city) with different pricing models, but schema t... |
critical | 5 | 7.5% |
| 14 | Detention & Demurrage Charges demurrage_charges, detention_charges, driver_cum_loader_charges ALLCARGO LOGISTICS LIMITED: Case-by-case charges after 12 hours affect operational costs, though mutually agreed BLUE DART EXPRESS LIMITED: Rs.1/kg/day after 7 days storage creates time-based cost accumulation that static rate card has no temporal dimension to capture |
important | 5 | 7.5% |
| 15 | Peak Season / Capacity Scaling daily_confirmed_vehicle, peak_season_multiplier, vehicle_availability_count, vehicle_availability_terms, volume_commitment_counts GHOSH TRANSPORT PRIVATE LIMITED: 2x BAU vehicles required during peak/BBD periods at same rates - capacity scaling requirement not captured MEDALLION TRANSLINKS LLP: Route_rates contain 'counts' field (10 trips for Patna and Guwahati routes) indicating minimum volume commitments or trip guarantees, which affect financial obl... |
critical | 4 | 6.0% |
| 16 | Rate Inclusions / Exclusions rate_inclusions, rate_inclusions_and_exclusions, rate_inclusivity_scope GHOSH TRANSPORT PRIVATE LIMITED: Rates are 'All inclusive (Tolls, GPS, Digital Locks, Cargo nets)' vs green tax on actuals - cost component breakdown missing HARIOM LOGISTICS: Rates include GPS/Digilock/Cargo net but exclude tolls/parking (at actuals), critical for total cost calculation but schema has no field for what's bundled vs a... |
important | 4 | 6.0% |
| 17 | Route / Geographic Scope destination_scope, facility_exclusions, one_way_trip_rates, per_trip_flat_rates MEDALLION TRANSLINKS LLP: Contract contains separate route_rates section with One Way trips at fixed per-trip prices (₹36,400 Kolkata-Patna, ₹73,400 Kolkata-Guwahati, ₹30,000 Kolkata-Bhu... MEDALLION TRANSLINKS LLP: Origin specified as 'KOLKATA (All Facilities except Bagnan)' for one-way routes - facility-level exclusions affect operational scope but schema has no way to ca... |
critical | 4 | 6.0% |
| 18 | Minimum Chargeable Weight / Volumetric minimum_chargeable_weight, volumetric_weight_conversion ALLCARGO LOGISTICS LIMITED: 10 Kg minimum per docket directly impacts actual charges - shipments below 10 Kg are still charged for 10 Kg, fundamentally changing cost calculations ALLCARGO LOGISTICS LIMITED: 1 CFT = 6 Kg conversion factor determines chargeable weight for bulky items, essential for accurate rating of low-density shipments |
critical | 3 | 4.5% |
| 19 | Minimum Guarantee % minimum_guarantee_percentage MAA TARINI ENTERPRISE: 80-90% minimum guarantee directly impacts revenue calculations (vendor gets paid for undelivered orders up to this %), but schema has no field to capture this f... OMEGA SEIKI MOBILITY PRIVATE LIMITED: 80-90% minimum guarantees on order volumes are contractually binding financial protections that cap vendor risk and create contingent liabilities for the platfo... |
critical | 2 | 3.0% |
| Vendor | LOBs | Fitness | Missing | Critical |
|---|---|---|---|---|
| MADHU LOGISTICS | Large NonLarge Grocery | 75% | 13 | 9 |
| EZY LOGISTICS.IN | Large NonLarge | 80% | 15 | 8 |
| TRUXCARGO PRIVATE LIMITED | Large NonLarge Grocery | 75% | 13 | 8 |
| IDENTIFYPLUS DELIVERY SERVICES PRIVATE LIMITED | Grocery | 65% | 13 | 8 |
| Rapid Roadways | Large NonLarge Grocery | 63% | 10 | 8 |
| ALLCARGO LOGISTICS LIMITED | NonLarge Large | 50% | 16 | 7 |
| New Kiran Cargo Movers | Large NonLarge Grocery | 70% | 15 | 7 |
| DHRUV SUPER LOGISTICS PRIVATE LIMITED | Large NonLarge Grocery | 69% | 14 | 7 |
| BMR LOGISTICS | Large NonLarge | 75% | 13 | 7 |
| LS TRANSCO PVT LTD | Large NonLarge Grocery | 77% | 12 | 7 |
| JENUSHREE TRANSPORT | Large NonLarge | 67% | 12 | 7 |
| SAILAXMI TRANSPORT SERVICE | NonLarge Large Grocery | 75% | 12 | 7 |
| S.Logistics | Large NonLarge | 66% | 10 | 7 |
| PHOTONTECH LOGISTICS PRIVATE LIMITED | Large NonLarge | 69% | 17 | 6 |
| TRINITY GLOBAL TECHNOLOGIES | Large NonLarge Grocery | 79% | 15 | 6 |
| GDS LOGISTICS | Large NonLarge Grocery | 74% | 12 | 6 |
| Safexpress Private Limited | Large NonLarge | 69% | 12 | 6 |
| TEN LOGISTICS INDIA PRIVATE LIMITED | Large NonLarge | 75% | 12 | 6 |
| FLEETEXPRESS SUPPLY CHAIN SOLUTIONS | Large NonLarge Grocery | 67% | 12 | 6 |
| OMEGA SEIKI MOBILITY PRIVATE LIMITED | Grocery | 45% | 11 | 6 |
| Goline Networks Private Limited | Grocery | 64% | 10 | 6 |
| SANJAY TRANSPORT | Large NonLarge | 62% | 10 | 6 |
| OM LOGISTICS SUPPLY CHAIN PRIVATE LIMITED | Large | 59% | 9 | 6 |
| Shree Hari Logistics | Large NonLarge Grocery | 62% | 9 | 6 |
| Apple Logistics | Large NonLarge | 75% | 9 | 6 |
| DKP ENTREPRISES PRIVATE LIMITED | Large NonLarge | 25% | 7 | 6 |
| HARIOM LOGISTICS | Large NonLarge Grocery | 67% | 15 | 5 |
| BLUE DART EXPRESS LIMITED | Large NonLarge | 62% | 13 | 5 |
| GHOSH TRANSPORT PRIVATE LIMITED | Large NonLarge | 75% | 12 | 5 |
| SHRI BALAJI TRANSPORT | Large NonLarge Grocery | 69% | 12 | 5 |