Customer Templ_

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

Table Type: Company

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

Table Number: 1381

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Description]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Phone No_]
   ,[Telex No_]
   ,[Document Sending Profile]
   ,[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]
   ,[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]
   ,[Print Statements]
   ,[Bill-to Customer No_]
   ,[Payment Method Code]
   ,[Application Method]
   ,[Prices Including VAT]
   ,[Location Code]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[VAT Registration No_]
   ,[Combine Shipments]
   ,[Gen_ Bus_ Posting Group]
   ,[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]
   ,[Privacy Blocked]
   ,[Disable Search by Name]
   ,[Cash Flow Payment Terms Code]
   ,[Contact Type]
   ,[Mobile Phone No_]
   ,[Responsibility Center]
   ,[Shipping Advice]
   ,[Shipping Time]
   ,[Shipping Agent Service Code]
   ,[Service Zone Code]
   ,[Allow Line Disc_]
   ,[Base Calendar Code]
   ,[Copy Sell-to Addr_ to Qte From]
   ,[Validate EU Vat Reg_ No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Customer Templ_$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 Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Customer Templ_].[Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Customer Templ_].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Customer Templ_].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Customer Templ_].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Customer Templ_].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Customer Templ_].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Customer Templ_].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Customer Templ_].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Customer Templ_].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Customer Templ_].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Customer Templ_].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Customer Templ_].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Customer Templ_].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Customer Templ_].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
      ON
         [Customer Templ_].[Reminder Terms Code] = [Reminder Terms].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Customer Templ_].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Customer Templ_].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Customer Templ_].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]

Show/hide columns in Customer Templ_ table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Address Searchnvarchar(200)
5Address 2 Searchnvarchar(100)
6City Searchnvarchar(60)
7Phone No_ Searchnvarchar(60)
8Telex No_ Searchnvarchar(40)
9Document Sending Profile Searchnvarchar(40)
10Our Account No_ Searchnvarchar(40)
11Territory Code Searchnvarchar(20)
Key to join to the Territory table.

Show/hide example query

SELECT
       [Customer Templ_].[Territory Code]
       ,[Territory].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
              ON
                     [Customer Templ_].[Territory Code] = [Territory].[Code]
12Global Dimension 1 Code Searchnvarchar(40)
13Global Dimension 2 Code Searchnvarchar(40)
14Chain Name Searchnvarchar(20)
15Budgeted Amount Searchdecimal(38,38)
16Credit Limit (LCY) Searchdecimal(38,38)
17Customer Posting Group Searchnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Customer Templ_].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Customer Templ_].[Language Code] = [Language].[Code]
21Statistics Group Searchint
22Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Customer Templ_].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Customer Templ_].[Payment Terms Code] = [Payment Terms].[Code]
23Fin_ Charge Terms Code Searchnvarchar(20)
24Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Customer Templ_].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Customer Templ_].[Salesperson Code] = [Salesperson_Purchaser].[No_]
25Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

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

Show/hide example query

SELECT
       [Customer Templ_].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Customer Templ_].[Shipping Agent Code] = [Shipping Agent].[Code]
27Place of Export Searchnvarchar(40)
28Invoice Disc_ Code Searchnvarchar(40)
29Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Customer Templ_].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Customer Templ_].[Customer Disc_ Group] = [Customer Discount Group].[No_]
30Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Customer Templ_].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Customer Templ_].[Country_Region Code] = [Country_Region].[Code]
31Collection Method Searchnvarchar(40)
32Amount Searchdecimal(38,38)
33Blocked Searchint
34Print Statements Searchtinyint
35Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Customer Templ_].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Customer Templ_].[Bill-to Customer No_] = [Customer].[No_]
36Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Customer Templ_].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Customer Templ_].[Payment Method Code] = [Payment Method].[Code]
37Application Method Searchint
38Prices Including VAT Searchtinyint
39Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Customer Templ_].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Customer Templ_].[Location Code] = [Location].[Code]
40Fax No_ Searchnvarchar(60)
41Telex Answer Back Searchnvarchar(40)
42VAT Registration No_ Searchnvarchar(40)
43Combine Shipments Searchtinyint
44Gen_ Bus_ Posting Group Searchnvarchar(40)
45GLN Searchnvarchar(26)
46Post Code Searchnvarchar(40)
47County Searchnvarchar(60)
48EORI Number Searchnvarchar(80)
49Use GLN in Electronic Document Searchtinyint
50E-Mail Searchnvarchar(160)
51Home Page Searchnvarchar(160)
52Reminder Terms Code Searchnvarchar(20)
Key to join to the Reminder Terms table.

Show/hide example query

SELECT
       [Customer Templ_].[Reminder Terms Code]
       ,[Reminder Terms].[No_]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
              ON
                     [Customer Templ_].[Reminder Terms Code] = [Reminder Terms].[No_]
53No_ Series Searchnvarchar(40)
54Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Customer Templ_].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Customer Templ_].[Tax Area Code] = [Tax Area].[Code]
55Tax Liable Searchtinyint
56VAT Bus_ Posting Group Searchnvarchar(40)
57Reserve Searchint
58Block Payment Tolerance Searchtinyint
59IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Customer Templ_].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Customer Templ_].[IC Partner Code] = [IC Partner].[Code]
60Prepayment _ Searchdecimal(38,38)
61Partner Type Searchint
62Privacy Blocked Searchtinyint
63Disable Search by Name Searchtinyint
64Cash Flow Payment Terms Code Searchnvarchar(20)
65Contact Type Searchint
66Mobile Phone No_ Searchnvarchar(60)
67Responsibility Center Searchnvarchar(20)
68Shipping Advice Searchint
69Shipping Time Searchvarchar(32)
70Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Customer Templ_].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Customer Templ_].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
71Service Zone Code Searchnvarchar(20)
72Allow Line Disc_ Searchtinyint
73Base Calendar Code Searchnvarchar(20)
74Copy Sell-to Addr_ to Qte From Searchint
75Validate EU Vat Reg_ No_ Searchtinyint
76$systemId Searchuniqueidentifier
77$systemCreatedAt Searchdatetime
78$systemCreatedBy Searchuniqueidentifier
79$systemModifiedAt Searchdatetime
80$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Customer Templ_ table

Leave a Reply

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