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_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Native - Gen. Settings Buffer].[Language Code] = [Language].[Code]
LEFT JOIN
[User] AS [User]
ON
[Native - Gen. Settings Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Native - Gen. Settings Buffer].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Native – Gen. Settings Buffer 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) |
| 2 | Currency Symbol | Currency Symbol | Normal | Text | 10 | Currency Symbol | nvarchar(20) |
| 3 | Paypal Email Address | Paypal Email Address | Normal | Text | 250 | Paypal Email Address | nvarchar(500) |
| 4 | Country/Region Code | Country/Region Code | Normal | Code | 10 | 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] | |||||||
| 5 | Language Locale ID | Language Locale ID | Normal | Integer | 4 | Language Locale ID | int |
| 6 | Language Code | Language Code | Normal | Text | 50 | 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] | |||||||
| 7 | Language Display Name | Language Display Name | Normal | Text | 80 | Language Display Name | nvarchar(160) |
| 50 | Default Tax ID | Default Tax ID | Normal | GUID | 16 | Default Tax ID | uniqueidentifier |
| 51 | Defauilt Tax Description | Defauilt Tax Description | Normal | Text | 100 | Defauilt Tax Description | nvarchar(200) |
| 52 | Default Payment Terms ID | Default Payment Terms ID | Normal | GUID | 16 | Default Payment Terms ID | uniqueidentifier |
| 53 | Def. Pmt. Term Description | Def. Pmt. Term Description | Normal | Text | 50 | Def_ Pmt_ Term Description | nvarchar(100) |
| 54 | Default Payment Method ID | Default Payment Method ID | Normal | GUID | 16 | Default Payment Method ID | uniqueidentifier |
| 55 | Def. Pmt. Method Description | Def. Pmt. Method Description | Normal | Text | 50 | Def_ Pmt_ Method Description | nvarchar(100) |
| 56 | Amount Rounding Precision | Amount Rounding Precision | Normal | Decimal | 12 | Amount Rounding Precision | decimal(38,38) |
| 57 | Unit-Amount Rounding Precision | Unit-Amount Rounding Precision | Normal | Decimal | 12 | Unit-Amount Rounding Precision | decimal(38,38) |
| 58 | VAT/Tax Rounding Precision | VAT/Tax Rounding Precision | Normal | Decimal | 12 | VAT_Tax Rounding Precision | decimal(38,38) |
| 59 | Quantity Rounding Precision | Quantity Rounding Precision | Normal | Decimal | 12 | Quantity Rounding Precision | decimal(38,38) |
| 60 | EnableSync | EnableSync | Normal | Boolean | 4 | EnableSync | tinyint |
| 61 | EnableSyncCoupons | EnableSyncCoupons | Normal | Boolean | 4 | EnableSyncCoupons | 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 querySELECT
[Native - Gen. Settings Buffer].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Native - Gen_ Settings Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Gen. Settings Buffer]
LEFT JOIN
[User] AS [User]
ON
[Native - Gen. Settings Buffer].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Native - Gen. Settings Buffer].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Native - Gen_ Settings Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Native - Gen. Settings Buffer]
LEFT JOIN
[User] AS [User]
ON
[Native - Gen. Settings Buffer].[$systemModifiedBy] = [User].[User Security ID] | |||||||