Power BI Connector for QuickBooks

Build 23.0.8839

PriceLevelPerItem

Create and query QuickBooks Price Levels Per Item. Only QuickBooks Premier and Enterprise support Per-Item Price Levels. Note that while Price Levels can be added from this table, you may only add Per-Item Price Levels from this table. Price Levels may be deleted from the PriceLevels table. This table requires QBXML version 4.0 or later.

Columns

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

The unique identifier.

PriceLevelID String False

PriceLevels.ID

255

The unique identifier of the price level.

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.

PriceLevelPerItemRet_ItemRef_ListID String False

Items.ID

255

A reference to the Id of the item. Either the Id or FullName property of the item is required on insertion.

PriceLevelPerItemRet_ItemRef_FullName String False

A reference to the name of the item. Either the Id or FullName property of the item is required on insertion.

PriceLevelPerItemRet_CustomPrice Decimal False

A fixed amount for the price.

PriceLevelPerItemRet_CustomPricePercent Double False

A fixed discount percentage.

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