TripSheet — data reference
All 30 fields BSuit stores for TripSheet (Transport), with the record types they refer to.
On this page
#About TripSheet
TripSheet is a record type in the Transport area of BSuit. This page lists everything BSuit stores for each tripsheet — 30 fields. It is maintained on the “Trip Sheets” page.
| Screen | Module |
|---|---|
| Trip Sheets | Sales |
#Fields
Every field stored for a tripsheet. “Stored as” is the technical field name, useful when talking to support or building reports. 4 fields are references to other record types.
| Field | Stored as | Type | Required | Max length | Refers to |
|---|---|---|---|---|---|
| Trip Sheet Number | TripSheetNumber | Text | No | — | — |
| Trip Date | TripDate | Date | No | — | — |
| Driver Id | DriverId | Text | No | — | Driver |
| Driver Name | DriverName | Text | No | — | — |
| Driver Ledger Id | DriverLedgerId | Text | No | — | — |
| Vehicle Id | VehicleId | Text | No | — | Vehicle |
| Vehicle Number | VehicleNumber | Text | No | — | — |
| Route Description | RouteDescription | Text | No | — | — |
| Started At | StartedAt | Date and time | No | — | — |
| Ended At | EndedAt | Date and time | No | — | — |
| Start Odometer | StartOdometer | Number (decimal) | No | — | — |
| End Odometer | EndOdometer | Number (decimal) | No | — | — |
| Distance Km | DistanceKm | Number (decimal) | No | — | — |
| Advance Paid | AdvancePaid | Number (decimal) | No | — | — |
| Total Expenses | TotalExpenses | Number (decimal) | No | — | — |
| Balance Recoverable | BalanceRecoverable | Number (decimal) | No | — | — |
| Balance Payable | BalancePayable | Number (decimal) | No | — | — |
| Currency Id | CurrencyId | Text | No | — | Currency |
| Expense Ledger Id | ExpenseLedgerId | Text | No | — | — |
| Advance Ledger Id | AdvanceLedgerId | Text | No | — | — |
| Status | Status | Text | No | — | — |
| Settlement Transaction Id | SettlementTransactionId | Text | No | — | — |
| Settled At | SettledAt | Date and time | No | — | — |
| Notes | Notes | Text | No | — | — |
| Company Id | CompanyId | Text | No | — | Company |
| Expenses | Expenses | Text | No | — | — |
| Id | Id | Text | No | — | — |
| Created At | CreatedAt | Date and time | No | — | — |
| Updated At | UpdatedAt | Date and time | No | — | — |
| Is Deleted | IsDeleted | Yes / No | No | — | — |
#Where TripSheet is referenced
Other record types point to this one, so changing or removing a record here can affect them:
| Record type | Field |
|---|---|
| ConsignmentLeg | Trip Sheet Id |
| TripSheetExpense | Trip Sheet Id |
#About this guide
Generated from BSuit’s data model on the date shown under “Seen on a running system”. Field names, types and lengths come from the model itself. References are inferred from field names (a field called “Ledger Id” is treated as pointing to Ledger); the model does not declare relationships, so an inferred link can occasionally be wrong or missing.
About this guide
- Status
- Partially reviewed
- Application
- BSuit ERP
- Audience
- Administrators, analysts and support staff
- Owner
- BSuit documentation team
- Reviewer
- Not yet reviewed
- Last verified
- Never
- Checked against
- Generated from source revision a36c7a086 on 2026-10-02
- Seen on a running system
- Not yet
- Help version
- 2026.0.0-preview
- Guide ID
erp:data/transport.tripsheet