MigrationQB Customer

Dynamics 365 BC Table ReferenceTablesCompany TablesMMigrationQB Customer

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

Table Type: Company

Table Name: MigrationQB Customer
Database Table Name:

Table Number: 1912

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

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

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

SELECT
   *
FROM
   [] AS [MigrationQB Customer]
LEFT JOIN
   [User] AS [User]
      ON
         [MigrationQB Customer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [MigrationQB Customer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in MigrationQB Customer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Id SearchIdNormalText250
2CompanyName Primary Key SearchCompanyNameNormalText50
3GivenName SearchGivenNameNormalText25
4FamilyName SearchFamilyNameNormalText25
5DisplayName SearchDisplayNameNormalText100
6BillAddrLine1 SearchBillAddrLine1NormalText250
7BillAddrLine2 SearchBillAddrLine2NormalText250
8BillAddrCity SearchBillAddrCityNormalText250
9BillAddrCountry SearchBillAddrCountryNormalText250
10BillAddrState SearchBillAddrStateNormalText30
11BillAddrPostalCode SearchBillAddrPostalCodeNormalText31
12BillAddrCountrySubDivCode SearchBillAddrCountrySubDivCodeNormalText250
13PrimaryPhone SearchPrimaryPhoneNormalText30
14PrimaryEmailAddr SearchPrimaryEmailAddrNormalText100
15WebAddr SearchWebAddrNormalText250
16Fax SearchFaxNormalText30
17Taxable SearchTaxableNormalBoolean4
18DefaultTaxCodeRef SearchDefaultTaxCodeRefNormalText50
20ListId SearchListIdNormalText40
21ParentRef SearchParentRefNormalText40
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

SELECT
	       [MigrationQB Customer].[]
	       ,[User].[User Security ID]
	FROM
	       [] AS [MigrationQB Customer]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [MigrationQB Customer].[] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16
Dynamics 365 BC Table ReferenceTablesCompany TablesMMigrationQB Customer

Leave a Reply

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