Prod_ Order Capacity Need

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

Table Type: Company

Table Name: Prod_ Order Capacity Need
Database Table Name: CRONUS UK Ltd_$Prod_ Order Capacity Need$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5410

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 Prod_ Order Capacity Need can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Status]
   ,[Prod_ Order No_]
   ,[Requested Only]
   ,[Routing No_]
   ,[Routing Reference No_]
   ,[Operation No_]
   ,[Line No_]
   ,[Type]
   ,[No_]
   ,[Work Center No_]
   ,[Work Center Group Code]
   ,[Date]
   ,[Starting Time]
   ,[Ending Time]
   ,[Allocated Time]
   ,[Send-Ahead Type]
   ,[Time Type]
   ,[Needed Time]
   ,[Needed Time (ms)]
   ,[Lot Size]
   ,[Concurrent Capacities]
   ,[Efficiency]
   ,[Starting Date-Time]
   ,[Ending Date-Time]
   ,[Worksheet Template Name]
   ,[Worksheet Batch Name]
   ,[Worksheet Line No_]
   ,[Active]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Prod_ Order Capacity Need$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Prod_ Order Capacity Need table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Status Primary Key Searchint
3Prod_ Order No_ Primary Key Searchnvarchar(40)
4Requested Only Primary Key Searchtinyint
5Routing No_ Primary Key Searchnvarchar(40)
6Routing Reference No_ Primary Key Searchint
7Operation No_ Primary Key Searchnvarchar(20)
8Line No_ Primary Key Searchint
9Type Searchint
10No_ Searchnvarchar(40)
11Work Center No_ Searchnvarchar(40)
12Work Center Group Code Searchnvarchar(20)
13Date Searchdatetime
14Starting Time Searchdatetime
15Ending Time Searchdatetime
16Allocated Time Searchdecimal(38,38)
17Send-Ahead Type Searchint
18Time Type Searchint
19Needed Time Searchdecimal(38,38)
20Needed Time (ms) Searchdecimal(38,38)
21Lot Size Searchdecimal(38,38)
22Concurrent Capacities Searchdecimal(38,38)
23Efficiency Searchdecimal(38,38)
24Starting Date-Time Searchdatetime
25Ending Date-Time Searchdatetime
26Worksheet Template Name Searchnvarchar(20)
27Worksheet Batch Name Searchnvarchar(20)
28Worksheet Line No_ Searchint
29Active Searchtinyint
30$systemId Searchuniqueidentifier
31$systemCreatedAt Searchdatetime
32$systemCreatedBy Searchuniqueidentifier
33$systemModifiedAt Searchdatetime
34$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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