Power BI Connector for QuickBooks

Build 23.0.8839

PriceLevels

Create, delete, and query QuickBooks Price Levels. Note that while Price Levels can be added and deleted from this table, you may add only fixed-percentage Price Levels from this table. Per-Item Price Levels may be added via the PriceLevelPerItem table. This table requires QBXML version 4.0 or higher.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier.

Name String False 31

The name of the price level.

PriceLevelType String True 15

The type of price level.

The allowed values are FixedPercentage, PerItem.

IsActive Boolean False

A boolean determining if the price level is active.

PriceLevelFixedPercentage Double False

A fixed discount percentage for the price level.

PriceLevelPerItemAggregate String False 5000

An aggregate of the per-item price level data.

PriceLevelPerItemRet_CurrencyRef_ListID String False

Currency.ID

255

A reference to the currency Id. Requires a minimum QBXML version of 8.0 and multiple currencies enabled for the company file.

PriceLevelPerItemRet_CurrencyRef_FullName String False 64

A reference to the currency name. Requires a minimum QBXML version of 8.0 and multiple currencies enabled for the company file.

TimeCreated Datetime True

The datetime the transaction was made.

TimeModified Datetime True

The last datetime the transaction was modified.

EditSequence String True 16

An identifier used for versioning for this copy of the object.

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