VehicleMileage Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
TxnID12VARCHAR36TrueFalseFalseFalse%s6.0US, CA, UK
TimeCreated11TIMESTAMP16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ6.0US, CA, UK
TimeModified11TIMESTAMP16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ6.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s6.0US, CA, UK
VehicleRefListID12VARCHAR36TrueFalseTrueFalse%sListID6.0US, CA, UK
VehicleRefFullName12VARCHAR31TrueFalseTrueFalse%sName6.0US, CA, UK
CustomerRefListID12VARCHAR36TrueFalseTrueFalse%sListID6.0US, CA, UK
CustomerRefFullName12VARCHAR209TrueFalseTrueFalse%sFullName6.0US, CA, UK
ItemRefListID12VARCHAR36TrueFalseTrueFalse%sListID6.0US, CA, UK
ItemRefFullName12VARCHAR31TrueFalseTrueFalse%sFullName6.0US, CA, UK
ClassRefListID12VARCHAR36TrueFalseTrueFalse%sListID6.0US, CA, UK
ClassRefFullName12VARCHAR159TrueFalseTrueFalse%sFullName6.0US, CA, UK
TripStartDate9DATE6TrueFalseTrueFalseCCCC-MM-DD6.0US, CA, UK
TripEndDate9DATE6TrueFalseTrueFalseCCCC-MM-DD6.0US, CA, UK
OdometerStart3DECIMAL15TrueFalseTrueFalse%10.2f6.0US, CA, UK
OdometerEnd3DECIMAL15TrueFalseTrueFalse%10.2f6.0US, CA, UK
TotalMiles3DECIMAL15TrueFalseTrueFalse%10.2f6.0US, CA, UK
Notes12VARCHAR4095TrueFalseTrueFalse%s6.0US, CA, UK
BillableStatus12VARCHAR13TrueFalseTrueFalse
Billable
NotBillable
HasBeenBilled
6.0US, CA, UK
StandardMileageRate3DECIMAL18TrueFalseFalseFalse%10.5f6.0US, CA, UK
StandardMileageTotalAmount3DECIMAL15TrueFalseFalseFalse%10.2f6.0US, CA, UK
BillableRate3DECIMAL18TrueFalseTrueFalse%10.5f6.0US, CA, UK
BillableAmount3DECIMAL15TrueFalseTrueFalse%10.2f6.0US, CA, UK