Capacity Constrained Resource

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

Table Type: Company

Table Name: Capacity Constrained Resource
Database Table Name: CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 99000866

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 Capacity Constrained Resource can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Capacity Type]
   ,[Capacity No_]
   ,[Name]
   ,[Critical Load _]
   ,[Dampener (_ of Total Capacity)]
   ,[Work Center No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Capacity Constrained Resource$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Capacity Constrained Resource table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Capacity Type Primary Key Searchint
3Capacity No_ Primary Key Searchnvarchar(40)
4Name Searchnvarchar(200)
5Critical Load _ Searchdecimal(38,38)
6Dampener (_ of Total Capacity) Searchdecimal(38,38)
7Work Center No_ Searchnvarchar(40)
8$systemId Searchuniqueidentifier
9$systemCreatedAt Searchdatetime
10$systemCreatedBy Searchuniqueidentifier
11$systemModifiedAt Searchdatetime
12$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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