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. 使用できる値は次のとおりです。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. |