Native – Gen_ Settings Buffer

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

Table Number: 2840

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 IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Currency Symbol Searchnvarchar(20)
4Paypal Email Address Searchnvarchar(500)
5Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [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]
6Language Locale ID Searchint
7Language Code Searchnvarchar(100)
Key to join to the Language table.

Show/hide example query

SELECT
       [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]
8Language Display Name Searchnvarchar(160)
9Default Tax ID Searchuniqueidentifier
10Defauilt Tax Description Searchnvarchar(200)
11Default Payment Terms ID Searchuniqueidentifier
12Def_ Pmt_ Term Description Searchnvarchar(100)
13Default Payment Method ID Searchuniqueidentifier
14Def_ Pmt_ Method Description Searchnvarchar(100)
15Amount Rounding Precision Searchdecimal(38,38)
16Unit-Amount Rounding Precision Searchdecimal(38,38)
17VAT_Tax Rounding Precision Searchdecimal(38,38)
18Quantity Rounding Precision Searchdecimal(38,38)
19EnableSync Searchtinyint
20EnableSyncCoupons Searchtinyint
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Native – Gen_ Settings Buffer table

Leave a Reply

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