PriceLevels
Handles QuickBooks Price Levels, supporting creation, deletion, and queries for fixed-percentage pricing adjustments to a wide range of customers or items. You can add and delete Price Levels from this table, but you can only add fixed-percentage Price Levels. To add more specific per-item price levels, use the PriceLevelPerItem table. This table requires QBXML Version 4.0 or higher.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
A unique identifier that distinguishes this price level from others in the system. | |
| 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. 使用できる値は次のとおりです。FixedPercentage, PerItem | |
| IsActive | Boolean | False |
Indicates whether this price level is active and available for use. Inactive price levels cannot be applied to transactions. | ||
| PriceLevelFixedPercentage | Double | False |
Represents a fixed percentage discount or markup applied to all items associated with this price level. | ||
| PriceLevelPerItemAggregate | String | False | 5000 |
Contains details about per-item price adjustments for this price level, such as custom pricing rules. | |
| PriceLevelPerItemRet_CurrencyRef_ListID | String | False |
Currency.ID | 255 |
A reference to the currency identifier for this price level. Requires QuickBooks XML (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. 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 was created. | ||
| TimeModified | Datetime | True |
The date and time of the most recent modification to this price level. | ||
| EditSequence | String | True | 16 |
A unique identifier used for versioning to track changes made to this price level object. |