Customer

Dynamics 365 BC Table ReferenceTablesCompany TablesCCustomer

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

Table Type: Company

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

Table Number: 18

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Name]
   ,[Search Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Contact]
   ,[Phone No_]
   ,[Telex No_]
   ,[Document Sending Profile]
   ,[Ship-to Code]
   ,[Our Account No_]
   ,[Territory Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Chain Name]
   ,[Budgeted Amount]
   ,[Credit Limit (LCY)]
   ,[Customer Posting Group]
   ,[Currency Code]
   ,[Customer Price Group]
   ,[Language Code]
   ,[Registration Number]
   ,[Statistics Group]
   ,[Payment Terms Code]
   ,[Fin_ Charge Terms Code]
   ,[Salesperson Code]
   ,[Shipment Method Code]
   ,[Shipping Agent Code]
   ,[Place of Export]
   ,[Invoice Disc_ Code]
   ,[Customer Disc_ Group]
   ,[Country_Region Code]
   ,[Collection Method]
   ,[Amount]
   ,[Blocked]
   ,[Invoice Copies]
   ,[Last Statement No_]
   ,[Print Statements]
   ,[Bill-to Customer No_]
   ,[Priority]
   ,[Payment Method Code]
   ,[Format Region]
   ,[Last Modified Date Time]
   ,[Last Date Modified]
   ,[Application Method]
   ,[Prices Including VAT]
   ,[Location Code]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[VAT Registration No_]
   ,[Combine Shipments]
   ,[Gen_ Bus_ Posting Group]
   ,[Picture]
   ,[GLN]
   ,[Post Code]
   ,[County]
   ,[EORI Number]
   ,[Use GLN in Electronic Document]
   ,[E-Mail]
   ,[Home Page]
   ,[Reminder Terms Code]
   ,[No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[Reserve]
   ,[Block Payment Tolerance]
   ,[IC Partner Code]
   ,[Prepayment _]
   ,[Partner Type]
   ,[Intrastat Partner Type]
   ,[Exclude from Pmt_ Practices]
   ,[Image]
   ,[Privacy Blocked]
   ,[Disable Search by Name]
   ,[Allow Multiple Posting Groups]
   ,[Preferred Bank Account Code]
   ,[Coupled to CRM]
   ,[Cash Flow Payment Terms Code]
   ,[Primary Contact No_]
   ,[Contact Type]
   ,[Mobile Phone No_]
   ,[Responsibility Center]
   ,[Shipping Advice]
   ,[Shipping Time]
   ,[Shipping Agent Service Code]
   ,[Service Zone Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Base Calendar Code]
   ,[Copy Sell-to Addr_ to Qte From]
   ,[Validate EU Vat Reg_ No_]
   ,[Id]
   ,[Currency Id]
   ,[Payment Terms Id]
   ,[Shipment Method Id]
   ,[Payment Method Id]
   ,[Tax Area ID]
   ,[Contact ID]
   ,[Contact Graph Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Customer].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
      ON
         [Customer].[Document Sending Profile] = [Document Sending Profile].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Customer].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Customer].[Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Customer].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Customer].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Customer].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Customer].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Customer].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Customer].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Customer].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Customer].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Customer].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Customer].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Customer].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Customer].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Customer].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
      ON
         [Customer].[Reminder Terms Code] = [Reminder Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Customer].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Customer].[Currency Filter] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Customer].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Customer].[Cash Flow Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Customer].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
      ON
         [Customer].[Service Zone Code] = [Service Zone].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
      ON
         [Customer].[Base Calendar Code] = [Base Calendar].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Customer].[Currency Id] = [Currency].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Customer].[Payment Terms Id] = [Payment Terms].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Customer].[Shipment Method Id] = [Shipment Method].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Customer].[Payment Method Id] = [Payment Method].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [Customer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Customer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Customer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Name SearchNameNormalText100Namenvarchar(200)
3Search Name SearchSearch NameNormalCode100Search Namenvarchar(200)
4Name 2 SearchName 2NormalText50Name 2nvarchar(100)
5Address SearchAddressNormalText100Addressnvarchar(200)
6Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
7City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Customer].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Customer].[City] = [Post Code].[City]
8Contact SearchContactNormalText100Contactnvarchar(200)
9Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
10Telex No. SearchTelex No.NormalText20Telex No_nvarchar(40)
11Document Sending Profile SearchDocument Sending ProfileNormalCode20Document Sending Profilenvarchar(40)
Key to join to the Document Sending Profile table.

Show/hide example query

SELECT
       [Customer].[Document Sending Profile]
       ,[Document Sending Profile].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
              ON
                     [Customer].[Document Sending Profile] = [Document Sending Profile].[Code]
12Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Customer].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Customer].[Ship-to Code] = [Ship-to Address].[Code]
14Our Account No. SearchOur Account No.NormalText20Our Account No_nvarchar(40)
15Territory Code SearchTerritory CodeNormalCode10Territory Codenvarchar(20)
Key to join to the Territory table.

Show/hide example query

SELECT
       [Customer].[Territory Code]
       ,[Territory].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
              ON
                     [Customer].[Territory Code] = [Territory].[Code]
16Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Customer].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Customer].[Global Dimension 1 Code] = [Dimension].[Code]
17Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Customer].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Customer].[Global Dimension 2 Code] = [Dimension].[Code]
18Chain Name SearchChain NameNormalCode10Chain Namenvarchar(20)
19Budgeted Amount SearchBudgeted AmountNormalDecimal12Budgeted Amountdecimal(38,38)
20Credit Limit (LCY) SearchCredit Limit ($)NormalDecimal12Credit Limit (LCY)decimal(38,38)
21Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Customer].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Customer].[Customer Posting Group] = [Customer Posting Group].[Code]
22Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Customer].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Customer].[Currency Code] = [Currency].[Code]
23Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Customer].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Customer].[Customer Price Group] = [Customer Price Group].[Code]
24Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Customer].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Customer].[Language Code] = [Language].[Code]
25Registration Number SearchRegistration No.NormalText50Registration Numbernvarchar(100)
26Statistics Group SearchStatistics GroupNormalInteger4Statistics Groupint
27Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Customer].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Customer].[Payment Terms Code] = [Payment Terms].[Code]
28Fin. Charge Terms Code SearchFin. Charge Terms CodeNormalCode10Fin_ Charge Terms Codenvarchar(20)
Key to join to the Finance Charge Terms table.

Show/hide example query

SELECT
       [Customer].[Fin_ Charge Terms Code]
       ,[Finance Charge Terms].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Finance Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Terms]
              ON
                     [Customer].[Fin_ Charge Terms Code] = [Finance Charge Terms].[Code]
29Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Customer].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Customer].[Salesperson Code] = [Salesperson/Purchaser].[Code]
30Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Customer].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Customer].[Shipment Method Code] = [Shipment Method].[Code]
31Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Customer].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
              ON
                     [Customer].[Shipping Agent Code] = [Shipping Agent].[Code]
32Place of Export SearchPlace of ExportNormalCode20Place of Exportnvarchar(40)
33Invoice Disc. Code SearchInvoice Disc. CodeNormalCode20Invoice Disc_ Codenvarchar(40)
34Customer Disc. Group SearchCustomer Disc. GroupNormalCode20Customer Disc_ Groupnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Customer].[Customer Disc_ Group]
       ,[Customer Discount Group].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Customer].[Customer Disc_ Group] = [Customer Discount Group].[Code]
35Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Customer].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Customer].[Country_Region Code] = [Country/Region].[Code]
36Collection Method SearchCollection MethodNormalCode20Collection Methodnvarchar(40)
37Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
38Comment SearchCommentFlowFieldBoolean4
39Blocked SearchBlockedNormalOption4Blockedint
Available options are:
  • ” “
  • “Ship”
  • “Invoice”
  • “All”
40Invoice Copies SearchInvoice CopiesNormalInteger4Invoice Copiesint
41Last Statement No. SearchLast Statement No.NormalInteger4Last Statement No_int
42Print Statements SearchPrint StatementsNormalBoolean4Print Statementstinyint
45Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-to Customer No_nvarchar(40)
46Priority SearchPriorityNormalInteger4Priorityint
47Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Customer].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Customer].[Payment Method Code] = [Payment Method].[Code]
48Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
53Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
54Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
55Date Filter SearchDate FilterFlowFilterDate4
56Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
57Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
58Balance SearchBalanceFlowFieldDecimal12
59Balance (LCY) SearchBalance ($)FlowFieldDecimal12
60Net Change SearchNet ChangeFlowFieldDecimal12
61Net Change (LCY) SearchNet Change ($)FlowFieldDecimal12
62Sales (LCY) SearchSales ($)FlowFieldDecimal12
63Profit (LCY) SearchProfit ($)FlowFieldDecimal12
64Inv. Discounts (LCY) SearchInv. Discounts ($)FlowFieldDecimal12
65Pmt. Discounts (LCY) SearchPmt. Discounts ($)FlowFieldDecimal12
66Balance Due SearchBalance DueFlowFieldDecimal12
67Balance Due (LCY) SearchBalance Due ($)FlowFieldDecimal12
69Payments SearchPaymentsFlowFieldDecimal12
70Invoice Amounts SearchInvoice AmountsFlowFieldDecimal12
71Cr. Memo Amounts SearchCr. Memo AmountsFlowFieldDecimal12
72Finance Charge Memo Amounts SearchFinance Charge Memo AmountsFlowFieldDecimal12
74Payments (LCY) SearchPayments ($)FlowFieldDecimal12
75Inv. Amounts (LCY) SearchInv. Amounts ($)FlowFieldDecimal12
76Cr. Memo Amounts (LCY) SearchCr. Memo Amounts ($)FlowFieldDecimal12
77Fin. Charge Memo Amounts (LCY) SearchFin. Charge Memo Amounts ($)FlowFieldDecimal12
78Outstanding Orders SearchOutstanding OrdersFlowFieldDecimal12
79Shipped Not Invoiced SearchShipped Not InvoicedFlowFieldDecimal12
80Application Method SearchApplication MethodNormalOption4Application Methodint
Available options are:
  • “Manual”
  • “Apply to Oldest”
82Prices Including VAT SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
83Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Customer].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Customer].[Location Code] = [Location].[Code]
84Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
85Telex Answer Back SearchTelex Answer BackNormalText20Telex Answer Backnvarchar(40)
86VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
87Combine Shipments SearchCombine ShipmentsNormalBoolean4Combine Shipmentstinyint
88Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Customer].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Customer].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
89Picture SearchPictureNormalBLOB8Pictureimage
90GLN SearchGLNNormalCode13GLNnvarchar(26)
91Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Customer].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Customer].[Post Code] = [Post Code].[Code]
92County SearchStateNormalText30Countynvarchar(60)
93EORI Number SearchEORI NumberNormalText40EORI Numbernvarchar(80)
95Use GLN in Electronic Document SearchUse GLN in Electronic DocumentsNormalBoolean4Use GLN in Electronic Documenttinyint
97Debit Amount SearchDebit AmountFlowFieldDecimal12
98Credit Amount SearchCredit AmountFlowFieldDecimal12
99Debit Amount (LCY) SearchDebit Amount ($)FlowFieldDecimal12
100Credit Amount (LCY) SearchCredit Amount ($)FlowFieldDecimal12
102E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
103Home Page SearchHome PageNormalText80Home Pagenvarchar(160)
104Reminder Terms Code SearchReminder Terms CodeNormalCode10Reminder Terms Codenvarchar(20)
Key to join to the Reminder Terms table.

Show/hide example query

SELECT
       [Customer].[Reminder Terms Code]
       ,[Reminder Terms].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
              ON
                     [Customer].[Reminder Terms Code] = [Reminder Terms].[Code]
105Reminder Amounts SearchReminder AmountsFlowFieldDecimal12
106Reminder Amounts (LCY) SearchReminder Amounts ($)FlowFieldDecimal12
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Customer].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Customer].[No_ Series] = [No. Series].[Code]
108Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Customer].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Customer].[Tax Area Code] = [Tax Area].[Code]
109Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
110VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Customer].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Customer].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
111Currency Filter SearchCurrency FilterFlowFilterCode10
113Outstanding Orders (LCY) SearchOutstanding Orders ($)FlowFieldDecimal12
114Shipped Not Invoiced (LCY) SearchShipped Not Invoiced ($)FlowFieldDecimal12
115Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
116Block Payment Tolerance SearchBlock Payment ToleranceNormalBoolean4Block Payment Tolerancetinyint
117Pmt. Disc. Tolerance (LCY) SearchPmt. Disc. Tolerance ($)FlowFieldDecimal12
118Pmt. Tolerance (LCY) SearchPmt. Tolerance ($)FlowFieldDecimal12
119IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Customer].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Customer].[IC Partner Code] = [IC Partner].[Code]
120Refunds SearchRefundsFlowFieldDecimal12
121Refunds (LCY) SearchRefunds ($)FlowFieldDecimal12
122Other Amounts SearchOther AmountsFlowFieldDecimal12
123Other Amounts (LCY) SearchOther Amounts ($)FlowFieldDecimal12
124Prepayment % SearchPrepayment %NormalDecimal12Prepayment _decimal(38,38)
125Outstanding Invoices (LCY) SearchOutstanding Invoices ($)FlowFieldDecimal12
126Outstanding Invoices SearchOutstanding InvoicesFlowFieldDecimal12
130Bill-to No. Of Archived Doc. SearchNo. Of Archived Doc.FlowFieldInteger4
131Sell-to No. Of Archived Doc. SearchSell-to No. Of Archived Doc.FlowFieldInteger4
132Partner Type SearchPartner TypeNormalOption4Partner Typeint
Available options are:
  • ” “
  • “Company”
  • “Person”
133Intrastat Partner Type SearchIntrastat Partner TypeNormalOption4Intrastat Partner Typeint
Available options are:
  • ” “
  • “Company”
  • “Person”
134Exclude from Pmt. Practices SearchExclude from Payment PracticesNormalBoolean4Exclude from Pmt_ Practicestinyint
140Image SearchImageNormalMedia16Imageuniqueidentifier
150Privacy Blocked SearchPrivacy BlockedNormalBoolean4Privacy Blockedtinyint
160Disable Search by Name SearchDisable Search by NameNormalBoolean4Disable Search by Nametinyint
175Allow Multiple Posting Groups SearchAllow Multiple Posting GroupsNormalBoolean4Allow Multiple Posting Groupstinyint
288Preferred Bank Account Code SearchPreferred Bank Account CodeNormalCode20Preferred Bank Account Codenvarchar(40)
720Coupled to CRM SearchCoupled to DataverseNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to DataverseFlowFieldBoolean4
840Cash Flow Payment Terms Code SearchCash Flow Payment Terms CodeNormalCode10Cash Flow Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Customer].[Cash Flow Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Customer].[Cash Flow Payment Terms Code] = [Payment Terms].[Code]
5049Primary Contact No. SearchPrimary Contact No.NormalCode20Primary Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Customer].[Primary Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Customer].[Primary Contact No_] = [Contact].[No_]
5050Contact Type SearchContact TypeNormalOption4Contact Typeint
Available options are:
  • “Company”
  • “Person”
5061Mobile Phone No. SearchMobile Phone No.NormalText30Mobile Phone No_nvarchar(60)
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Customer].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Customer].[Responsibility Center] = [Responsibility Center].[Code]
5750Shipping Advice SearchShipping AdviceNormalOption4Shipping Adviceint
Available options are:
  • “Partial”
  • “Complete”
5790Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
5792Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
5900Service Zone Code SearchService Zone CodeNormalCode10Service Zone Codenvarchar(20)
Key to join to the Service Zone table.

Show/hide example query

SELECT
       [Customer].[Service Zone Code]
       ,[Service Zone].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
              ON
                     [Customer].[Service Zone Code] = [Service Zone].[Code]
5902Contract Gain/Loss Amount SearchContract Gain/Loss AmountFlowFieldDecimal12
5903Ship-to Filter SearchShip-to FilterFlowFilterCode10
5910Outstanding Serv. Orders (LCY) SearchOutstanding Serv. Orders ($)FlowFieldDecimal12
5911Serv Shipped Not Invoiced(LCY) SearchServ Shipped Not Invoiced($)FlowFieldDecimal12
5912Outstanding Serv.Invoices(LCY) SearchOutstanding Serv.Invoices($)FlowFieldDecimal12
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
7171No. of Quotes SearchNo. of QuotesFlowFieldInteger4
7172No. of Blanket Orders SearchNo. of Blanket OrdersFlowFieldInteger4
7173No. of Orders SearchNo. of OrdersFlowFieldInteger4
7174No. of Invoices SearchNo. of InvoicesFlowFieldInteger4
7175No. of Return Orders SearchNo. of Return OrdersFlowFieldInteger4
7176No. of Credit Memos SearchNo. of Credit MemosFlowFieldInteger4
7177No. of Pstd. Shipments SearchNo. of Pstd. ShipmentsFlowFieldInteger4
7178No. of Pstd. Invoices SearchNo. of Pstd. InvoicesFlowFieldInteger4
7179No. of Pstd. Return Receipts SearchNo. of Pstd. Return ReceiptsFlowFieldInteger4
7180No. of Pstd. Credit Memos SearchNo. of Pstd. Credit MemosFlowFieldInteger4
7181No. of Ship-to Addresses SearchNo. of Ship-to AddressesFlowFieldInteger4
7182Bill-To No. of Quotes SearchBill-To No. of QuotesFlowFieldInteger4
7183Bill-To No. of Blanket Orders SearchBill-To No. of Blanket OrdersFlowFieldInteger4
7184Bill-To No. of Orders SearchBill-To No. of OrdersFlowFieldInteger4
7185Bill-To No. of Invoices SearchBill-To No. of InvoicesFlowFieldInteger4
7186Bill-To No. of Return Orders SearchBill-To No. of Return OrdersFlowFieldInteger4
7187Bill-To No. of Credit Memos SearchBill-To No. of Credit MemosFlowFieldInteger4
7188Bill-To No. of Pstd. Shipments SearchBill-To No. of Pstd. ShipmentsFlowFieldInteger4
7189Bill-To No. of Pstd. Invoices SearchBill-To No. of Pstd. InvoicesFlowFieldInteger4
7190Bill-To No. of Pstd. Return R. SearchBill-To No. of Pstd. Return R.FlowFieldInteger4
7191Bill-To No. of Pstd. Cr. Memos SearchBill-To No. of Pstd. Cr. MemosFlowFieldInteger4
7600Base Calendar Code SearchBase Calendar CodeNormalCode10Base Calendar Codenvarchar(20)
Key to join to the Base Calendar table.

Show/hide example query

SELECT
       [Customer].[Base Calendar Code]
       ,[Base Calendar].[Code]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
              ON
                     [Customer].[Base Calendar Code] = [Base Calendar].[Code]
7601Copy Sell-to Addr. to Qte From SearchCopy Sell-to Addr. to Qte FromNormalOption4Copy Sell-to Addr_ to Qte Fromint
Available options are:
  • “Company”
  • “Person”
7602Validate EU Vat Reg. No. SearchValidate EU VAT Reg. No.NormalBoolean4Validate EU Vat Reg_ No_tinyint
8000Id SearchIdNormalGUID16Iduniqueidentifier
8001Currency Id SearchCurrency IdNormalGUID16Currency Iduniqueidentifier
Key to join to the Currency table.

Show/hide example query

SELECT
       [Customer].[Currency Id]
       ,[Currency].[$systemId]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Customer].[Currency Id] = [Currency].[$systemId]
8002Payment Terms Id SearchPayment Terms IdNormalGUID16Payment Terms Iduniqueidentifier
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Customer].[Payment Terms Id]
       ,[Payment Terms].[$systemId]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Customer].[Payment Terms Id] = [Payment Terms].[$systemId]
8003Shipment Method Id SearchShipment Method IdNormalGUID16Shipment Method Iduniqueidentifier
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Customer].[Shipment Method Id]
       ,[Shipment Method].[$systemId]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Customer].[Shipment Method Id] = [Shipment Method].[$systemId]
8004Payment Method Id SearchPayment Method IdNormalGUID16Payment Method Iduniqueidentifier
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Customer].[Payment Method Id]
       ,[Payment Method].[$systemId]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Customer].[Payment Method Id] = [Payment Method].[$systemId]
9003Tax Area ID SearchTax Area IDNormalGUID16Tax Area IDuniqueidentifier
9004Tax Area Display Name SearchTax Area Display NameFlowFieldText100
9005Contact ID SearchContact IDNormalGUID16Contact IDuniqueidentifier
9006Contact Graph Id SearchContact Graph IdNormalText250Contact Graph Idnvarchar(500)
10004UPS Zone SearchUPS ZoneNormalCode2
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10017Bank Communication SearchBank CommunicationNormalOption4
10018Check Date Format SearchCheck Date FormatNormalOption4
10019Check Date Separator SearchCheck Date SeparatorNormalOption4
10021Balance on Date SearchBalance on DateFlowFieldDecimal12
10022Balance on Date (LCY) SearchBalance on Date ($)FlowFieldDecimal12
10023RFC No. SearchRFC No.NormalCode13
10024CURP No. SearchCURP No.NormalCode18
10025State Inscription SearchState InscriptionNormalText30
14020Tax Identification Type SearchTax Identification TypeNormalOption4
27000CFDI Purpose SearchCFDI PurposeNormalCode10
27001CFDI Relation SearchCFDI RelationNormalCode10
27002SAT Tax Regime Classification SearchSAT Tax Regime ClassificationNormalCode10
27004CFDI Export Code SearchCFDI Export CodeNormalCode10
27005CFDI General Public SearchCFDI General PublicNormalBoolean4
27006CFDI Period SearchCFDI PeriodNormalOption4
27007CFDI Customer Name SearchCFDI Customer NameNormalText300
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Customer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Customer].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Customer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Customer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Customer table

CurrencyCustomer Posting GroupCustomer Price GroupIC PartnerLanguageLocationPayment MethodPayment TermsPost CodeReminder TermsResponsibility CenterSalesperson/PurchaserSalesperson/PurchaserService ZoneShip-to AddressShipment MethodShipping AgentShipping Agent ServicesTax AreaTerritory
Dynamics 365 BC Table ReferenceTablesCompany TablesCCustomer

Leave a Reply

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