Power BI Connector for QuickBooks

Build 23.0.8839

VehicleMileage

Create, update, delete, and query QuickBooks Vehicle Mileage entities. QuickBooks requires QBXML version 6.0 or higher to use this table.

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.

QuickBooks 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 ColumnSize Description
ID [KEY] String True 255

The Id of the vehicle mileage.

VehicleRef_FullName String False 100

The vehicle for use in vehicle mileage transactions. Each vehicle name must be unique.

VehicleRef_ListID String False 255

The reference Id for the vehicle mileage transaction.

CustomerRef_FullName String False 1000

The full name of a referenced customer in QuickBooks. You may specify only CustomerRef_FullName or CustomerRef_ListId on insert/update statements and not both.

CustomerRef_ListID String False

Customers.ID

255

The Id of the referenced customer in QuickBooks. You may specify only CustomerRef_FullName or CustomerRef_ListId on insert/update statements and not both.

ItemRef_FullName String False

A reference to the full name of an item in QuickBooks. You may specify only ItemRef_FullName or ItemRef_ListId on insert/update statements and not both.

ItemRef_ListID String False

Items.ID

255

A reference to the Id of an item in QuickBooks. You may specify only ItemRef_FullName or ItemRef_ListId on insert/update statements and not both.

ClassRef_FullName String False 1000

A reference to the full name of a class in QuickBooks. You may specify only ClassRef_FullName or ClassRef_ListId on insert/update statements and not both.

ClassRef_ListID String False

Class.ID

255

A reference to the Id of a class in QuickBooks. You may specify only ClassRef_FullName or ClassRef_ListId on insert/update statements and not both.

TripStartDate String False

Date the trip began. If left blank on an insert, the current date at the time of the transaction will be used.

TripEndDate String 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 5000

Additional information.

BillableStatus String False 13

The billig status of the vehicle mileage.

The allowed values are 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 Decimal False

In a billable vehicle mileage transaction, this refers to the total charge that QuickBooks calculates by by multiplying the trip total mileage by the rate specified in the item referenced by the ItemRef columns.

EditSequence String True 16

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839