PriceLevelPerItem
Manages Per-Item Price Levels in QuickBooks, allowing creation and queries of individual item pricing for specific customers. Available in QuickBooks Premier and Enterprise with QBXML Version 4.0 or higher. In addition to adding Per-Item Price Levels, you can also add Price Levels from this table. To delete Price Levels, you must use the PriceLevels table.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
A unique identifier that distinguishes this price level item from others in the system. | |
| PriceLevelID | String | False |
PriceLevels.ID | 255 |
The unique identifier of the price level to which this item belongs. |
| Name | String | False | 31 |
The descriptive name assigned to the price level, used to identify it in reports or applications. | |
| PriceLevelType | String | True | 15 |
Specifies the type of price level, such as fixed percentage discounts or per-item pricing. The allowed values are FixedPercentage, PerItem. | |
| IsActive | Boolean | False |
Indicates whether this price level item is active and available for use. Inactive items cannot be applied to transactions. | ||
| PriceLevelPerItemRet_ItemRef_ListID | String | False |
Items.ID | 255 |
A reference to the item's identifier. Either the Id or FullName property of the item must be provided when inserting. |
| PriceLevelPerItemRet_ItemRef_FullName | String | False |
A reference to the item's name. Either the Id or FullName property of the item must be provided when inserting. | ||
| PriceLevelPerItemRet_CustomPrice | Decimal | False |
A fixed custom price specified for this item under the price level. | ||
| PriceLevelPerItemRet_CustomPricePercent | Double | False |
A percentage discount or markup applied to this item under the price level. | ||
| PriceLevelPerItemRet_CurrencyRef_ListID | String | False |
Currency.ID | 255 |
A reference to the currency identifier for this price level item. Requires QBXML version 8.0 or higher with multi-currency enabled in the company file. |
| PriceLevelPerItemRet_CurrencyRef_FullName | String | False | 64 |
A reference to the currency name associated with this price level item. Requires QBXML version 8.0 or higher with multi-currency enabled in the company file. | |
| TimeCreated | Datetime | True |
The date and time when this price level item was created. | ||
| TimeModified | Datetime | True |
The date and time of the most recent modification to this price level item. | ||
| EditSequence | String | True | 16 |
A unique identifier used for versioning to track changes made to this price level item. |