Column reference: Bookings source
You will know which group to open in the Bookings source for each kind of column, and which booking screen each column is filled from.
The Bookings source is the widest in the builder: one row per booking, with columns from the booking form, the Add Amounts panel, the invoice and receipts linked to it, and every tenant custom field. The columns come in the groups below; tick what you need and leave the rest.
Column groups
Group | Columns you will find | Filled from |
|---|---|---|
LR and parties | LR NO., Parent Booking No, Trip No, Paying Customer, Consigner, Consignee, Supplier (market vehicle), Created by, Approved by | Booking form header |
Trip | Vehicle, Ownership Type, Driver, Booking Status, Container Nos, Material, Trailer | Booking form |
Dates and job clock | PickUp Date, Dropoff Date, Started, Delivered, Actual hrs, Billed On, POD Uploaded Date, created and updated dates | Form, Add Amounts job clock, driver app stamps |
Addresses | PickUp Add., DropOff Add., city and state parts, alternate route | Vehicle Info on the form |
Goods | Goods Invoice No, Goods Invoice Date, Goods Invoice Value and its currency | Goods Info on the form |
E-way bill | Eway Bill No, Valid Date | Booking form, where the fields are in use |
Readings | Start Reading, End Reading, Distance (kms) | Vehicle Info on the form |
Customer billing | Billing Type, freight, Adjustment lines, Total Amount excl. tax, tax, invoice totals, Invoice No., Status (Pending Invoice / Invoice Created / Partial Payment / Payment Received) | Add Amounts › Customer Billing, the linked customer invoice |
Costs | Supplier Pay, Expenses Total, Fuel Expenses Total, Driver Payments Total | Add Amounts profit panel; expense vouchers, fuel entries and employee transactions related to the booking |
Profit | Revenue, Profit Loss | Profit panel: Revenue − Supplier Pay − Expenses − Fuel Expenses − Driver Payments |
Payments | Receipt numbers, amounts received, balance | Receipts allocated to the booking’s invoice |
POD and files | POD Challan, POD Uploaded Date, file counts | Pod Info and Booking Files |
Notes | Notes, Amount In Words, description | Form and view page |
Custom fields | Every tenant custom field on the booking form, such as a seal number, a sales person, in and out times, loaded capacity or a customer contact | Custom fields set up for your company |
Choosing columns
- For an unbilled-trips report: LR NO., Paying Customer, Dropoff Date, Billed On, Status, Total Amount excl. tax.
- For a POD-pending report: LR NO., Vehicle, Driver, Delivered, POD Uploaded Date.
- For a trip profit report: LR NO., Vehicle, Revenue, Supplier Pay, Expenses Total, Fuel Expenses Total, Driver Payments Total, Profit Loss.
- For a customer’s own trip list: LR NO., PickUp Date, Dropoff Date, PickUp Add., DropOff Add., Container Nos, plus the custom fields that carry their references.
Notes on the figures
- Cost columns only count entries whose Related To is the booking. An expense without it sits in the books but not on the row.
- Market-vehicle hire is in Supplier Pay, not Driver Payments Total.
- Status is the billing state; Booking Status is the trip state. Keep both if you filter on either.
- Custom field column names are whatever your company called the field, so they vary between tenants.
Need Help?
Chat with the NShine ERP support team on WhatsApp at +91 79950 87755, or ask from inside the app. Last checked 9 November 2026 against app.nshineerp.com.