Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2840
Table Type: Company
Table Name: Native – Gen_ Settings Buffer
Database Table Name: CRONUS UK Ltd_$Native – Gen_ Settings Buffer$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 Native – Gen_ Settings Buffer can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Native - Gen_ Settings Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
FROM
[CRONUS UK Ltd_$Native - Gen_ Settings Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Native - Gen_ Settings Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Gen_ Settings Buffer]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Native - Gen_ Settings Buffer].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Native - Gen_ Settings Buffer].[Language Code] = [Language].[Code]Show/hide columns in Native – Gen_ Settings Buffer table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Primary Key  | nvarchar(20) | ||||
| 3 | Currency Symbol | nvarchar(20) | ||||
| 4 | Paypal Email Address | nvarchar(500) | ||||
| 5 | Country_Region Code | nvarchar(20) | ||||
Key to join to the Country_Region table.Show/hide example querySELECT
[Native - Gen_ Settings Buffer].[Country_Region Code]
,[Country_Region].[Code]
FROM
[CRONUS UK Ltd_$Native - Gen_ Settings Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Gen_ Settings Buffer]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Native - Gen_ Settings Buffer].[Country_Region Code] = [Country_Region].[Code] | ||||||
| 6 | Language Locale ID | int | ||||
| 7 | Language Code | nvarchar(100) | ||||
Key to join to the Language table.Show/hide example querySELECT
[Native - Gen_ Settings Buffer].[Language Code]
,[Language].[Code]
FROM
[CRONUS UK Ltd_$Native - Gen_ Settings Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Gen_ Settings Buffer]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Native - Gen_ Settings Buffer].[Language Code] = [Language].[Code] | ||||||
| 8 | Language Display Name | nvarchar(160) | ||||
| 9 | Default Tax ID | uniqueidentifier | ||||
| 10 | Defauilt Tax Description | nvarchar(200) | ||||
| 11 | Default Payment Terms ID | uniqueidentifier | ||||
| 12 | Def_ Pmt_ Term Description | nvarchar(100) | ||||
| 13 | Default Payment Method ID | uniqueidentifier | ||||
| 14 | Def_ Pmt_ Method Description | nvarchar(100) | ||||
| 15 | Amount Rounding Precision | decimal(38,38) | ||||
| 16 | Unit-Amount Rounding Precision | decimal(38,38) | ||||
| 17 | VAT_Tax Rounding Precision | decimal(38,38) | ||||
| 18 | Quantity Rounding Precision | decimal(38,38) | ||||
| 19 | EnableSync | tinyint | ||||
| 20 | EnableSyncCoupons | tinyint | ||||
| 21 | $systemId | uniqueidentifier | ||||
| 22 | $systemCreatedAt | datetime | ||||
| 23 | $systemCreatedBy | uniqueidentifier | ||||
| 24 | $systemModifiedAt | datetime | ||||
| 25 | $systemModifiedBy | uniqueidentifier | ||||