TechFleets

RE:PLAN

Client —> Broker —> Factoring(Fee 1-3%) ←- Carrier —> Delivered

Normal Carrier Operations

License to ship

• Insurance for Truck & Load
• Driver has to be with Professional License
• Truck/Trailer needs License Plate

Load Purchase

• Rate confirmation
  • Where
  • Destination
• BOL(Bill of Lading) Proof of Delivery —> Broker

Truck-Kun

• Organization
  • Company Name
  • Address - 1 to 1 address table
  • Tax ID
    • Validation: nine-digit format (XX-XXXXXXX)
  • MC number
    • Validation: seven-digit format
  • DOT number
    • Validation: ~~eight~~ seven alphanumeric format
  • Company Fee
    • Validation: two digit percentage (%)
  • Setup Packet
    • PDF file uploaded by carrier during onboarding
  • Factoring
    • Optional table with factoring fee & agreement form
• Equipment
  • Equipment ID
  • Unit Number
  • Type
    • Truck
    • Trailer
  • Drivers
    • Multi Select
    • Optional
  • Make
  • Model
  • Year
    • Validation four digit (YYYY)
  • VIN
    • 17 character alphanumeric value
  • Status
    • Active (if attached to driver)
    • Inactive (if not attached to driver)
  • Plate
    • A table to keep track
  • Inspection
    • A table to keep track
  • Insurance
    • A table to keep track
• Driver
  • DriverID
  • Name
  • Email
  • Phone number
    • Standard 10 digit phone (xxx-xxx-xxxx)
  • Address → (Address Table)
  • Date of Birth
    • standard mm/dd/yyyy
  • License → (License Table)
  • Medical Card → (Medical Card Table)
  • Agreement → (Files Table)
  • W9 → (Files Table)
• Trips
  • Trip ID
  • Status → enum[Accepted, Completed, Pending, Rejected, Canceled]
  • Drivers → (Driver Table)
  • Equipment → (Equipment Table)
  • Loads → (Loads Table)
  • Rate
    • Float
  • Booked By → (Organization Member Table)
  • Note
    • String (Optional)
  • Bill of Lading - (Files Table)
    • Optional
• Statement

DB Relations

• Address Table
  • Address line 1
  • Address line 2 (optional)
  • City
  • State
  • Zip
• Files Table
  • URL
  • Name
    • Defaults to file name but user can override
  • Size
  • Uploaded Date
  • Organization ID
• Factoring Table
  • Name
  • Fee
  • Agreement (PDF file)
• Plate Table
  • PlateNumber
  • PlateState
  • IssueDate
  • ExpirationDate
  • Registrant (Optional) [WHAT WAS THE TYPE FOR IT?]
• License Table
  • License Number
  • License State
  • IssueDate
  • ExpirationDate
  • Type
    • Class A
    • Class B
    • Class C
  • image → (Files Table)
    • accepted format(PDF, PNG, HIEC)
• Inspection Table
  • Inspection ID
  • Report
  • Issue Date
  • Expiration Date
• Medical Card Table
  • Medical Card ID
  • Medical Card Certificate → (Files Table)
  • Issue Date
  • Expiration Date
• Insurance Table
  • Type
    • Physical
    • Liability
  • PolicyNumber
  • Issue Date
  • Expiration Date
  • Certificate (FILE)
  • Drivers[Array]
  • Equipment[Array]
• Loads
  • LoadId
  • Miles
  • Pickup Date
  • Delivery Date
  • Origin
  • Destination