| FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
| TxnID | true | false | ||||
| TimeCreated | true | false | ||||
| TimeModified | true | false | ||||
| EditSequence | true | false | ||||
| VehicleRef_ListID | true | false | ||||
| VehicleRef_FullName | true | false | ||||
| CustomerRef_ListID | true | false | ||||
| CustomerRef_FullName | true | false | ||||
| ItemRef_ListID | true | false | ||||
| ItemRef_FullName | true | false | ||||
| ClassRef_ListID | true | false | ||||
| ClassRef_FullName | true | false | ||||
| TripStartDate | true | false | ||||
| TripEndDate | true | false | ||||
| OdometerStart | true | false | ||||
| OdometerEnd | true | false | ||||
| TotalMiles | true | false | ||||
| Notes | true | false | ||||
| BillableStatus | true | false | ||||
| StandardMileageRate | true | false | ||||
| StandardMileageTotalAmount | true | false | ||||
| BillableRate | true | false | ||||
| BillableAmount | true | false | ||||
| UserData | user field | |||||
| Operation | add,delete |
