TripOn

This module is used to create and manage transporter details in the system.

Transporter represents the vehicle provider company or person who provides transport services like bus, cab, coach, etc.

Table

transporter_master

• id INT (PK) Unique transporter ID
• transporter_name VARCHAR(150) Name of transporter
• location_id INT (FK) Reference to khm_loc_mst_geography.geog_id
• mobile VARCHAR(15) Transporter mobile number
• email VARCHAR(150) Transporter email
• address TEXT Transporter address
• gstin VARCHAR(15) GST number
• display_name VARCHAR(150) Display name
• enterprise_id INT (FK) Reference to enterprise_master.id
• is_active BOOLEAN Active / Inactive status
• added_date DATETIME Created date
• updated_date DATETIME Last updated date

Validations

Add

• Transporter Name required
• Location required
• Mobile Number required
• enterprise_id required

Transporter Name

• Cannot be empty
• Minimum 3 characters required
• Maximum 150 characters allowed
• Duplicate transporter name NOT allowed within same enterprise
• Prevent duplicate:
  • Same transporter_name + enterprise_id

Location

• Must be selected from Geography Master
• Must reference:
  • khm_loc_mst_geography.geog_id
• Cannot be free text

Mobile Number

• Cannot be empty
• Must be numeric
• Must be exactly 10 dig

Email

• If entered, must be valid email format

GSTIN

• If entered, must be exactly 15 characters

Address

• Maximum 500 characters allowed

Display Name

• Max 150 characters allowed

Enterprise

• enterprise_id required
• Must match logged-in enterprise
• Cannot create transporter for another enterprise

Edit

Allow editing

• transporter_name
• location_id
• mobile
• email
• address
• gstin
• display_name
• is_active

Active/Inactive

• is_activa =True -> Transporter usable
• is_active = False -> Transporter hidden

Soft delete only. no Hard delete