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

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in Assembly Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
5Stockout Warning Primary Key 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

20Assembly Quote Nos. SearchAssembly Quote Nos.NormalCode20Assembly Quote Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

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

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

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

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

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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