Production Forecast Name

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

Table Type: Company

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

Table Number: 99000851

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 Production Forecast Name can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Name]
   ,[Description]
   ,[View By]
   ,[Forecast Type]
   ,[Location Filter]
   ,[Variant Filter]
   ,[Item Filter]
   ,[Forecast By Locations]
   ,[Forecast By Variants]
   ,[Quantity Type]
   ,[Date Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Production Forecast Name table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Name Primary Key Searchnvarchar(20)
3Description Searchnvarchar(200)
4View By Searchint
5Forecast Type Searchint
6Location Filter Searchimage
7Variant Filter Searchimage
8Item Filter Searchimage
9Forecast By Locations Searchtinyint
10Forecast By Variants Searchtinyint
11Quantity Type Searchint
12Date Filter Searchnvarchar(2048)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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