Item Attribute Value Selection

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

Table Type: Company

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

Table Number: 7504

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 Attribute Value Selection can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Attribute Name]
   ,[Value]
   ,[Attribute ID]
   ,[Unit of Measure]
   ,[Blocked]
   ,[Attribute Type]
   ,[Inherited-From Table ID]
   ,[Inherited-From Key Value]
   ,[Inheritance Level]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Attribute Value Selection$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Item Attribute Value Selection table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Attribute Name Primary Key Searchnvarchar(500)
3Value Searchnvarchar(500)
4Attribute ID Searchint
5Unit of Measure Searchnvarchar(60)
6Blocked Searchtinyint
7Attribute Type Searchint
8Inherited-From Table ID Searchint
9Inherited-From Key Value Searchnvarchar(40)
10Inheritance Level Searchint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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