PriceLevels
Create, delete, and query Reckon 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.
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | String | True |
The unique identifier. | |
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. | |
PriceLevelFixedPercentage | Double | False |
A fixed discount percentage for the price level. | |
PriceLevelPerItemAggregate | String | False |
An aggregate of the per-item price level data. | |
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. |