MS-QBO Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables MMS-QBO Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/7824

Table Type: Company

Table Name: MS-QBO Setup
Database Table Name: CRONUS UK Ltd_$MS-QBO Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7824

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 MS-QBO Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$MS-QBO Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Realm Id]
   ,[Token Key]
   ,[Token Secret]
   ,[Enabled]
   ,[Default Tax Code]
   ,[Default Country]
   ,[Default Country As Option]
   ,[Default Tax Rate]
   ,[Default Discount Account Id]
   ,[Default Discount Account Code]
   ,[Target Application]
   ,[Access Tokens Last Fetched On]
   ,[Last Configuration Error]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$MS-QBO Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$MS-QBO Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS-QBO Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [MS-QBO Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [MS-QBO Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in MS-QBO 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)
2	Realm Id	Realm Id	Normal	Text	250	Realm Id	nvarchar(500)
3	Token Key	Token Key	Normal	Text	250	Token Key	nvarchar(500)
4	Token Secret	Token Secret	Normal	Text	250	Token Secret	nvarchar(500)
5	Enabled	Enabled	Normal	Boolean	4	Enabled	tinyint
6	Default Tax Code	Default Tax Code	Normal	Text	250	Default Tax Code	nvarchar(500)
7	Default Country	Default Country	Normal	Code	10	Default Country	nvarchar(20)
8	Default Country As Option	Default Country As Option	Normal	Option	4	Default Country As Option	int
	Available options are: “Unknown” “Canada” “UK” “USA”
9	Default Tax Rate	Default Tax Rate	Normal	Text	250	Default Tax Rate	nvarchar(500)
10	Default Discount Account Id	Default Discount Account Id	Normal	Text	250	Default Discount Account Id	nvarchar(500)
11	Default Discount Account Code	Default Discount Account Code	Normal	Text	250	Default Discount Account Code	nvarchar(500)
12	Target Application	Target Application	Normal	Option	4	Target Application	int
	Available options are: “InvoicingApp” “BusinessCenter” “NativeInvoicingApp”
13	Access Tokens Last Fetched On	Access Tokens Last Fetched On	Normal	DateTime	8	Access Tokens Last Fetched On	datetime
14	Last Configuration Error	Last Configuration Error	Normal	Text	250	Last Configuration Error	nvarchar(500)
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 SELECT [MS-QBO Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$MS-QBO Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS-QBO Setup] LEFT JOIN [User] AS [User] ON [MS-QBO Setup].[$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 query SELECT [MS-QBO Setup].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$MS-QBO Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS-QBO Setup] LEFT JOIN [User] AS [User] ON [MS-QBO Setup].[$systemModifiedBy] = [User].[User Security ID]