Item Category

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5722

Table Type: Company

Table Name: Item Category
Database Table Name: CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Item Category can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Parent Category]
   ,[Description]
   ,[Indentation]
   ,[Presentation Order]
   ,[Has Children]
   ,[Last Modified Date Time]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Item Category table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Parent Category Searchnvarchar(40)
4Description Searchnvarchar(200)
5Indentation Searchint
6Presentation Order Searchint
7Has Children Searchtinyint
8Last Modified Date Time Searchdatetime
9Id Searchuniqueidentifier
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Item Category table

Leave a Reply

Your email address will not be published. Required fields are marked *