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. 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 |
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
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
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. The allowed values are EXACT, STARTSWITH, ENDSWITH, CONTAINS. The default value is CONTAINS. |