ProductSalesPriceTypes
Query ProductSalesPriceTypes in Sage Business Cloud Accounting.
Table Specific Information
Query the available ProductSalesPriceTypes
Select
The driver uses the Sage Accounting API to process search criteria that refer to Active column. The driver processes other filters client-side within the driver.
- Active supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM ProductSalesPriceTypes WHERE Active=false
Update
Updates are performed based on Id.
UPDATE ProductSalesPriceTypes SET Name='Selling Price' WHERE Id='c9ec71a1fe5c4916a72a9efc22324663'
Delete
You must specify the Id of the ProductSalesPriceTypes to delete it.
DELETE FROM ProductSalesPriceTypes WHERE id ='c9ec71a1fe5c4916a72a9efc22324663'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The unique identifier for the item | |
| UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
| Name | String | False |
The name of the product sales price type | |
| DisplayedAs | String | False |
The name of the resource | |
| CreatedAt | Datetime | True |
The datetime when the item was created | |
| Active | Bool | False |
Indicates whether the price type is displayed in the application | |
| LegacyId | Int | False |
The legacy ID for the item |