SalesProductsSchedules
The price schedule for a sales product.
Table-Specific Information
SELECT
The adapter will use the API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the adapter.
SELECT * FROM SalesProductsSchedules WHERE scheduleId = 12 SELECT * FROM SalesProductsSchedules WHERE scheduleId > 15 SELECT * FROM SalesProductsSchedules WHERE comment LIKE '%test' SELECT * FROM SalesProductsSchedules WHERE scheduleId IN (12, 23, 123) SELECT * FROM SalesProductsSchedules WHERE comment IS NOT NULL
Columns
| Name | Type | Description |
| SalesProductsId | Long | The unique identifier of the sales product. |
| Comment | String | The comments or notes associated with the sales product schedule. |
| ScheduleId | Long | Id of schedule. The ID of the schedule. This is part of the key for the list entry. |
| SchedulelookUpName | String | LookUpName of schedule. The ID of the schedule. This is part of the key for the list entry. |
| ScheduleEndDate | Date | The date when the schedule ends. |
| ScheduleStartDate | Date | The date when the schedule starts. This is part of the key for the list entry. |
| PricecurrencyId | Long | Id of currency. The ID of the currency. |
| PricecurrencylookUpName | String | LookUpName of currency. The ID of the currency. |
| PriceexchangeRateId | Long | Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| PriceexchangeRatelookUpName | String | LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| Pricevalue | String | The value of the currency. |