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
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 Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Primary Key | Primary Key | Normal | Code | 10 | Primary Key | nvarchar(20) |
5 | Stockout Warning | Stockout Warning | Normal | Boolean | 4 | Stockout Warning | tinyint |
10 | Assembly Order Nos. | Assembly Order Nos. | Normal | Code | 20 | Assembly Order Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example query | |||||||
20 | Assembly Quote Nos. | Assembly Quote Nos. | Normal | Code | 20 | Assembly Quote Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example query | |||||||
30 | Blanket Assembly Order Nos. | Blanket Assembly Order Nos. | Normal | Code | 20 | Blanket Assembly Order Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example query | |||||||
50 | Posted Assembly Order Nos. | Posted Assembly Order Nos. | Normal | Code | 20 | Posted Assembly Order Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example query | |||||||
100 | Copy Component Dimensions from | Copy Component Dimensions from | Normal | Option | 4 | Copy Component Dimensions from | int |
Available options are:
| |||||||
110 | Default Location for Orders | Default Location for Orders | Normal | Code | 10 | Default Location for Orders | nvarchar(20) |
Key to join to the Location table.Show/hide example query | |||||||
120 | Copy Comments when Posting | Copy Comments when Posting | Normal | Boolean | 4 | Copy Comments when Posting | tinyint |
130 | Create Movements Automatically | Create Movements Automatically | Normal | Boolean | 4 | Create Movements Automatically | tinyint |
2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example query | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |