MS-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
   [timestamp]
   ,[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 columns in MS-QBO Customer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Id Primary Key Searchnvarchar(500)
3SyncToken Searchnvarchar(500)
4MetaData Searchimage
5MetaData CreateTime Searchdatetime
6MetaData LastUpdatedTime Searchdatetime
7Title Searchnvarchar(30)
8GivenName Searchnvarchar(50)
9MiddleName Searchnvarchar(50)
10FamilyName Searchnvarchar(50)
11Suffix Searchnvarchar(20)
12DisplayName Searchnvarchar(200)
13FullyQualifiedName Searchnvarchar(500)
14CompanyName Searchnvarchar(100)
15PrintOnCheckName Searchnvarchar(220)
16Active Searchtinyint
17PrimaryPhone Searchimage
18AlternatePhone Searchimage
19Mobile Searchimage
20Fax Searchimage
21PrimaryEmailAddr Searchimage
22WebAddr Searchimage
23DefaultTaxCodeRef Searchimage
24Taxable Searchtinyint
25BillAddr Searchimage
26ShipAddr Searchimage
27Notes Searchimage
28Job Searchtinyint
29BillWithParent Searchtinyint
30ParentRef Searchimage
31Level Searchint
32SalesTermRef Searchimage
33PaymentMethodRef Searchimage
34Balance Searchdecimal(38,38)
35OpenBalanceDate Searchdatetime
36BalanceWithJobs Searchdecimal(38,38)
37CurrencyRef Searchimage
38PreferredDeliveryMethod Searchnvarchar(500)
39ResaleNum Searchnvarchar(32)
40All Searchimage
41$systemId Searchuniqueidentifier
42$systemCreatedAt Searchdatetime
43$systemCreatedBy Searchuniqueidentifier
44$systemModifiedAt Searchdatetime
45$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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