PriceLevelPerItem
Create and query Reckon Price Levels Per Item. Only Reckon 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.
Columns
| Name | Type | ReadOnly | References | Description |
| ID [KEY] | String | True |
The unique identifier. | |
| PriceLevelID | String | False |
PriceLevels.ID |
The unique identifier of the price level. |
| Name | String | False |
The name of the price level. | |
| PriceLevelType | String | True |
The type of price level. 使用できる値は次のとおりです。FixedPercentage, PerItem | |
| IsActive | Boolean | False |
A boolean determining if the price level is active. | |
| PriceLevelPerItemRet_ItemRef_ListID | String | False |
Items.ID |
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 |
Items.FullName |
A reference to the name of the item. Either the Id or FullName property of the item is required on insertion. |
| PriceLevelPerItemRet_CustomPrice | Double | False |
A fixed amount for the price. | |
| PriceLevelPerItemRet_CustomPricePercent | Double | False |
A fixed discount percentage. | |
| TimeCreated | Datetime | True |
The datetime the transaction was made. | |
| TimeModified | Datetime | True |
The last datetime the transaction was modified. | |
| EditSequence | String | True |
An identifier used for versioning for this copy of the object. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| StartTxnDate | String |
This pseudo column is deprecated and should no longer be used. Earliest transaction date to search for. |
| EndTxnDate | String |
This pseudo column is deprecated and should no longer be used. Latest transaction date to search for. |
| StartModifiedDate | String |
This pseudo column is deprecated and should no longer be used. Earliest modified date to search for. |
| EndModifiedDate | String |
This pseudo column is deprecated and should no longer be used. Latest modified date to search for. |
| NameMatchType | String |
This pseudo column is deprecated and should no longer be used. Type of match to perform on name. 使用できる値は次のとおりです。EXACT, STARTSWITH, ENDSWITH, CONTAINS デフォルト値はCONTAINSです。 |