VehicleMileage Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
TxnID 12 VARCHAR 36 True False False False %s 6.0 US, CA, UK
TimeCreated 11 TIMESTAMP 16 True False False False CCCC-MM-DDThh:mm:ssZ 6.0 US, CA, UK
TimeModified 11 TIMESTAMP 16 True False False False CCCC-MM-DDThh:mm:ssZ 6.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 6.0 US, CA, UK
VehicleRefListID 12 VARCHAR 36 True False True False %s ListID 6.0 US, CA, UK
VehicleRefFullName 12 VARCHAR 31 True False True False %s Name 6.0 US, CA, UK
CustomerRefListID 12 VARCHAR 36 True False True False %s ListID 6.0 US, CA, UK
CustomerRefFullName 12 VARCHAR 209 True False True False %s FullName 6.0 US, CA, UK
ItemRefListID 12 VARCHAR 36 True False True False %s ListID 6.0 US, CA, UK
ItemRefFullName 12 VARCHAR 31 True False True False %s FullName 6.0 US, CA, UK
ClassRefListID 12 VARCHAR 36 True False True False %s ListID 6.0 US, CA, UK
ClassRefFullName 12 VARCHAR 159 True False True False %s FullName 6.0 US, CA, UK
TripStartDate 9 DATE 6 True False True False CCCC-MM-DD 6.0 US, CA, UK
TripEndDate 9 DATE 6 True False True False CCCC-MM-DD 6.0 US, CA, UK
OdometerStart 3 DECIMAL 15 True False True False %10.2f 6.0 US, CA, UK
OdometerEnd 3 DECIMAL 15 True False True False %10.2f 6.0 US, CA, UK
TotalMiles 3 DECIMAL 15 True False True False %10.2f 6.0 US, CA, UK
Notes 12 VARCHAR 4095 True False True False %s 6.0 US, CA, UK
BillableStatus 12 VARCHAR 13 True False True False
Billable
NotBillable
HasBeenBilled
 6.0 US, CA, UK
StandardMileageRate 3 DECIMAL 18 True False False False %10.5f 6.0 US, CA, UK
StandardMileageTotalAmount 3 DECIMAL 15 True False False False %10.2f 6.0 US, CA, UK
BillableRate 3 DECIMAL 18 True False True False %10.5f 6.0 US, CA, UK
BillableAmount 3 DECIMAL 15 True False True False %10.2f 6.0 US, CA, UK