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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Assembly Setup].[Default Location for Orders] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Assembly Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Assembly Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Assembly Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
5Stockout Warning SearchStockout WarningNormalBoolean4Stockout Warningtinyint
10Assembly Order Nos. SearchAssembly Order Nos.NormalCode20Assembly Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Assembly Setup].[Assembly Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Assembly Setup].[Assembly Order Nos_] = [No. Series].[Code]
20Assembly Quote Nos. SearchAssembly Quote Nos.NormalCode20Assembly Quote Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Assembly Setup].[Assembly Quote Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Assembly Setup].[Assembly Quote Nos_] = [No. Series].[Code]
30Blanket Assembly Order Nos. SearchBlanket Assembly Order Nos.NormalCode20Blanket Assembly Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Assembly Setup].[Blanket Assembly Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Assembly Setup].[Blanket Assembly Order Nos_] = [No. Series].[Code]
50Posted Assembly Order Nos. SearchPosted Assembly Order Nos.NormalCode20Posted Assembly Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Assembly Setup].[Posted Assembly Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Assembly Setup].[Posted Assembly Order Nos_] = [No. Series].[Code]
100Copy Component Dimensions from SearchCopy Component Dimensions fromNormalOption4Copy Component Dimensions fromint
Available options are:
  • “Item/Resource Card”
  • “Order Header”
110Default Location for Orders SearchDefault Location for OrdersNormalCode10Default Location for Ordersnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Assembly Setup].[Default Location for Orders]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Assembly Setup].[Default Location for Orders] = [Location].[Code]
120Copy Comments when Posting SearchCopy Comments when PostingNormalBoolean4Copy Comments when Postingtinyint
130Create Movements Automatically SearchCreate Movements AutomaticallyNormalBoolean4Create Movements Automaticallytinyint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Assembly Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Assembly Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Assembly Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Assembly Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Assembly Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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