Catalogs
The catalogs belonging to the shop.
Table-Specific Information
Select
The cmdlet processes all filters client-side within the cmdlet. The following query is the only one processed server side:
SELECT * FROM Catalogs
Insert
The following columns can be used to create a new record:
Status, Title, PriceListId, PublicationId
The following pseudo-column can be used to create a new record:
CompanyLocationIds
Update
The following columns can be updated:
Status, Title, PriceListId, PublicationId
The following pseudo-column can be updated:
CompanyLocationIds
Delete
You can delete entries by specifying the following column:
Id
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
A globally-unique ID. | |
Status | String | False |
The status of the catalog. | |
Title | String | False |
The name of the catalog. | |
PriceListId | String | False |
A globally-unique ID. | |
PublicationId | String | False |
A globally-unique ID. | |
OperationId | String | True |
A globally-unique ID. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
Name | Type | Description |
CompanyLocationIds | String |
The IDs of the company locations to associate to the catalog. |