Assembly Setup

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

Table Type: Company

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

Table Number: 905

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 Assembly Setup can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Stockout Warning]
   ,[Assembly Order Nos_]
   ,[Assembly Quote Nos_]
   ,[Blanket Assembly Order Nos_]
   ,[Posted Assembly Order Nos_]
   ,[Copy Component Dimensions from]
   ,[Default Location for Orders]
   ,[Copy Comments when Posting]
   ,[Create Movements Automatically]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Assembly Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Stockout Warning Searchtinyint
4Assembly Order Nos_ Searchnvarchar(40)
5Assembly Quote Nos_ Searchnvarchar(40)
6Blanket Assembly Order Nos_ Searchnvarchar(40)
7Posted Assembly Order Nos_ Searchnvarchar(40)
8Copy Component Dimensions from Searchint
9Default Location for Orders Searchnvarchar(20)
10Copy Comments when Posting Searchtinyint
11Create Movements Automatically Searchtinyint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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