MS-QBO Customer – Dynamics 365 BC Table Reference

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

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

Table Type: Company

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

Table Number: 7820

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 Customer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Id]
   ,[SyncToken]
   ,[MetaData]
   ,[MetaData CreateTime]
   ,[MetaData LastUpdatedTime]
   ,[Title]
   ,[GivenName]
   ,[MiddleName]
   ,[FamilyName]
   ,[Suffix]
   ,[DisplayName]
   ,[FullyQualifiedName]
   ,[CompanyName]
   ,[PrintOnCheckName]
   ,[Active]
   ,[PrimaryPhone]
   ,[AlternatePhone]
   ,[Mobile]
   ,[Fax]
   ,[PrimaryEmailAddr]
   ,[WebAddr]
   ,[DefaultTaxCodeRef]
   ,[Taxable]
   ,[BillAddr]
   ,[ShipAddr]
   ,[Notes]
   ,[Job]
   ,[BillWithParent]
   ,[ParentRef]
   ,[Level]
   ,[SalesTermRef]
   ,[PaymentMethodRef]
   ,[Balance]
   ,[OpenBalanceDate]
   ,[BalanceWithJobs]
   ,[CurrencyRef]
   ,[PreferredDeliveryMethod]
   ,[ResaleNum]
   ,[All]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$MS-QBO Customer$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 Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS-QBO Customer]
LEFT JOIN
   [User] AS [User]
      ON
         [MS-QBO Customer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [MS-QBO Customer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in MS-QBO Customer table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Id	Id	Normal	Text	250	Id	nvarchar(500)
2	SyncToken	SyncToken	Normal	Text	250	SyncToken	nvarchar(500)
3	MetaData	MetaData	Normal	BLOB	8	MetaData	image
4	MetaData CreateTime	MetaData CreateTime	Normal	DateTime	8	MetaData CreateTime	datetime
5	MetaData LastUpdatedTime	MetaData LastUpdatedTime	Normal	DateTime	8	MetaData LastUpdatedTime	datetime
6	Title	Title	Normal	Text	15	Title	nvarchar(30)
7	GivenName	GivenName	Normal	Text	25	GivenName	nvarchar(50)
8	MiddleName	MiddleName	Normal	Text	25	MiddleName	nvarchar(50)
9	FamilyName	FamilyName	Normal	Text	25	FamilyName	nvarchar(50)
10	Suffix	Suffix	Normal	Text	10	Suffix	nvarchar(20)
11	DisplayName	DisplayName	Normal	Text	100	DisplayName	nvarchar(200)
12	FullyQualifiedName	FullyQualifiedName	Normal	Text	250	FullyQualifiedName	nvarchar(500)
13	CompanyName	CompanyName	Normal	Text	50	CompanyName	nvarchar(100)
14	PrintOnCheckName	PrintOnCheckName	Normal	Text	110	PrintOnCheckName	nvarchar(220)
15	Active	Active	Normal	Boolean	4	Active	tinyint
16	PrimaryPhone	PrimaryPhone	Normal	BLOB	8	PrimaryPhone	image
17	AlternatePhone	AlternatePhone	Normal	BLOB	8	AlternatePhone	image
18	Mobile	Mobile	Normal	BLOB	8	Mobile	image
19	Fax	Fax	Normal	BLOB	8	Fax	image
20	PrimaryEmailAddr	PrimaryEmailAddr	Normal	BLOB	8	PrimaryEmailAddr	image
21	WebAddr	WebAddr	Normal	BLOB	8	WebAddr	image
22	DefaultTaxCodeRef	DefaultTaxCodeRef	Normal	BLOB	8	DefaultTaxCodeRef	image
23	Taxable	Taxable	Normal	Boolean	4	Taxable	tinyint
24	BillAddr	BillAddr	Normal	BLOB	8	BillAddr	image
25	ShipAddr	ShipAddr	Normal	BLOB	8	ShipAddr	image
26	Notes	Notes	Normal	BLOB	8	Notes	image
27	Job	Job	Normal	Boolean	4	Job	tinyint
28	BillWithParent	BillWithParent	Normal	Boolean	4	BillWithParent	tinyint
29	ParentRef	ParentRef	Normal	BLOB	8	ParentRef	image
30	Level	Level	Normal	Integer	4	Level	int
31	SalesTermRef	SalesTermRef	Normal	BLOB	8	SalesTermRef	image
32	PaymentMethodRef	PaymentMethodRef	Normal	BLOB	8	PaymentMethodRef	image
33	Balance	Balance	Normal	Decimal	12	Balance	decimal(38,38)
34	OpenBalanceDate	OpenBalanceDate	Normal	Date	4	OpenBalanceDate	datetime
35	BalanceWithJobs	BalanceWithJobs	Normal	Decimal	12	BalanceWithJobs	decimal(38,38)
36	CurrencyRef	CurrencyRef	Normal	BLOB	8	CurrencyRef	image
37	PreferredDeliveryMethod	PreferredDeliveryMethod	Normal	Text	250	PreferredDeliveryMethod	nvarchar(500)
38	ResaleNum	ResaleNum	Normal	Text	16	ResaleNum	nvarchar(32)
39	All	All	Normal	BLOB	8	All	image
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 Customer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$MS-QBO Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS-QBO Customer] LEFT JOIN [User] AS [User] ON [MS-QBO Customer].[$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 Customer].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$MS-QBO Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [MS-QBO Customer] LEFT JOIN [User] AS [User] ON [MS-QBO Customer].[$systemModifiedBy] = [User].[User Security ID]