MigrationQB Vendor

Dynamics 365 BC Table ReferenceTablesCompany TablesMMigrationQB Vendor

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

Table Type: Company

Table Name: MigrationQB Vendor
Database Table Name:

Table Number: 1914

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 Vendor 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 Vendor]
LEFT JOIN
   [User] AS [User]
      ON
         [MigrationQB Vendor].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [MigrationQB Vendor].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in MigrationQB Vendor table

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

Show/hide example query

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

Leave a Reply

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