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. |