TABLE DETAIL REFERENCE: VehicleMileage
(Canada VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
VehicleRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
VehicleRefFullName12 VARCHAR 31TrueFalseTrueFalse%s Yes
CustomerRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseTrueFalse%s Yes
ItemRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ItemRefFullName12 VARCHAR 31TrueFalseTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TripStartDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TripEndDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
OdometerStart3 DECIMAL 15TrueFalseTrueFalse%10.2f
OdometerEnd3 DECIMAL 15TrueFalseTrueFalse%10.2f
TotalMiles3 DECIMAL 15TrueFalseTrueFalse%10.2f
Notes12 VARCHAR 4095TrueFalseTrueFalse%s
BillableStatus12 VARCHAR 13TrueFalseTrueFalse
Billable
NotBillable
HasBeenBilled
StandardMileageRate3 DECIMAL 18TrueFalseFalseFalse%10.5f
StandardMileageTotalAmount3 DECIMAL 17TrueFalseFalseFalse%10.2f
BillableRate3 DECIMAL 18TrueFalseTrueFalse%10.5f
BillableAmount3 DECIMAL 18TrueFalseTrueFalse%10.2f