VehicleMileage
Create, update, delete, and query Reckon Vehicle Mileage entities.
Table Specific Information
Select
By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.
Reckon Accounts Hosted allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or = comparison. The available columns for the VehicleMileage table are Id, Name, and TimeModified. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:
SELECT * FROM VehicleMileage WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND Name LIKE '%12345%'
Insert
To insert a VehicleMileage entry, specify an existing VehicleRef and either TotalMiles or both OdometerStart and OdometerEnd.Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | String | True |
The Id of the vehicle mileage. | |
VehicleRef_FullName | String | False |
The vehicle for use in vehicle mileage transactions. Each vehicle name must be unique. | |
VehicleRef_ListID | String | False |
The reference Id for the vehicle mileage transaction. | |
CustomerRef_FullName | String | False |
Customers.FullName |
The full name of a referenced customer in Reckon. You may specify only CustomerRef_FullName or CustomerRef_ListId on insert/update statements and not both. |
CustomerRef_ListID | String | False |
Customers.ID |
The Id of the referenced customer in Reckon. You may specify only CustomerRef_FullName or CustomerRef_ListId on insert/update statements and not both. |
ItemRef_FullName | String | False |
Items.FullName |
A reference to the full name of an item in Reckon. You may specify only ItemRef_FullName or ItemRef_ListId on insert/update statements and not both. |
ItemRef_ListID | String | False |
Items.ID |
A reference to the Id of an item in Reckon. You may specify only ItemRef_FullName or ItemRef_ListId on insert/update statements and not both. |
ClassRef_FullName | String | False |
Class.FullName |
A reference to the full name of a class in Reckon. You may specify only ClassRef_FullName or ClassRef_ListId on insert/update statements and not both. |
ClassRef_ListID | String | False |
Class.ID |
A reference to the Id of a class in Reckon. You may specify only ClassRef_FullName or ClassRef_ListId on insert/update statements and not both. |
TripStartDate | Datetime | False |
Date the trip began. If left blank on an insert, the current date at the time of the transaction will be used. | |
TripEndDate | Datetime | False |
The date the trip ended. If left blank on an insert, the current date at the time of the transaction will be used. | |
OdometerStart | Integer | False |
Odometer reading at the start of the trip. If TotalMiles is specified, you cannot specify OdometerStart and OdometerEnd. | |
OdometerEnd | Integer | False |
Odometer reading at the end of the trip. If TotalMiles is specified, you cannot specify OdometerStart and OdometerEnd. | |
TotalMiles | Double | False |
Total trip miles. If TotalMiles is specified, you cannot specify OdometerStart and OdometerEnd. | |
Notes | String | False |
Additional information. | |
BillableStatus | String | False |
The billig status of the vehicle mileage. 使用できる値は次のとおりです。Billable, NotBillable, HasBeenBilled | |
StandardMileageRate | Double | False |
The mileage rate currently allowed by the tax authority for vehicle expenses. | |
StandardMileageTotalAmount | Double | False |
Amount calculated by multiplying the total trip miles in the current vehicle mileage transaction by the standard mileage rate currently in use. | |
BillableRate | Double | False |
In a billable vehicle mileage transaction, refers to the rate being used to charge mileage to a customer. The rate is specified in the service item or the other charge item that is referenced in the ItemRef columns. | |
BillableAmount | Double | False |
In a billable vehicle mileage transaction, this refers to the total charge that Reckon calculates by by multiplying the trip total mileage by the rate specified in the item referenced by the ItemRef columns. | |
EditSequence | String | True |
A string indicating the revision of the vehicle mileage transaction. | |
TimeCreated | Datetime | True |
When the vehicle mileage was last modified. | |
TimeModified | Datetime | True |
When the vehicle mileage was created. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
StartModifiedDate | String |
This pseudo column is deprecated and should no longer be used. Earliest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format) |
EndModifiedDate | String |
This pseudo column is deprecated and should no longer be used. Latest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format). |
StartTxnDate | String |
This pseudo column is deprecated and should no longer be used. Earliest transaction date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format) |
EndTxnDate | String |
This pseudo column is deprecated and should no longer be used. Latest transaction date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format). |
MaxResults | String |
Maximum number of results to return. |