Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5105
Table Type: Company
Table Name: Customer Template
Database Table Name: CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 5105Due 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 Template can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Code]
,[Description]
,[Territory Code]
,[Global Dimension 1 Code]
,[Global Dimension 2 Code]
,[Customer Posting Group]
,[Currency Code]
,[Customer Price Group]
,[Payment Terms Code]
,[Shipment Method Code]
,[Invoice Disc_ Code]
,[Customer Disc_ Group]
,[Country_Region Code]
,[Payment Method Code]
,[Prices Including VAT]
,[Gen_ Bus_ Posting Group]
,[VAT Bus_ Posting Group]
,[Contact Type]
,[Allow Line Disc_]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
ON
[Customer Template].[Territory Code] = [Territory].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Customer Template].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Customer Template].[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 Template].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Customer Template].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
ON
[Customer Template].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Customer Template].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
ON
[Customer Template].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
ON
[Customer Template].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Customer Template].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
[User] AS [User]
ON
[Customer Template].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Customer Template].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Code  | Code | Normal | Code | 10 | Code | nvarchar(20) |
| 2 | Description  | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 15 | Territory Code | Territory Code | Normal | Code | 10 | Territory Code | nvarchar(20) |
| Key to join to the Territory table.SELECT
[Customer Template].[Territory Code]
,[Territory].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
ON
[Customer Template].[Territory Code] = [Territory].[Code] |
| 16 | Global Dimension 1 Code | Global Dimension 1 Code | Normal | Code | 20 | Global Dimension 1 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Customer Template].[Global Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Customer Template].[Global Dimension 1 Code] = [Dimension].[Code] |
| 17 | Global Dimension 2 Code | Global Dimension 2 Code | Normal | Code | 20 | Global Dimension 2 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Customer Template].[Global Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Customer Template].[Global Dimension 2 Code] = [Dimension].[Code] |
| 21 | Customer Posting Group | Customer Posting Group | Normal | Code | 20 | Customer Posting Group | nvarchar(40) |
| Key to join to the Customer Posting Group table.SELECT
[Customer Template].[Customer Posting Group]
,[Customer Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
ON
[Customer Template].[Customer Posting Group] = [Customer Posting Group].[Code] |
| 22 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
| Key to join to the Currency table.SELECT
[Customer Template].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Customer Template].[Currency Code] = [Currency].[Code] |
| 23 | Customer Price Group | Customer Price Group | Normal | Code | 10 | Customer Price Group | nvarchar(20) |
| Key to join to the Customer Price Group table.SELECT
[Customer Template].[Customer Price Group]
,[Customer Price Group].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
ON
[Customer Template].[Customer Price Group] = [Customer Price Group].[Code] |
| 27 | Payment Terms Code | Payment Terms Code | Normal | Code | 10 | Payment Terms Code | nvarchar(20) |
| Key to join to the Payment Terms table.SELECT
[Customer Template].[Payment Terms Code]
,[Payment Terms].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Customer Template].[Payment Terms Code] = [Payment Terms].[Code] |
| 30 | Shipment Method Code | Shipment Method Code | Normal | Code | 10 | Shipment Method Code | nvarchar(20) |
| Key to join to the Shipment Method table.SELECT
[Customer Template].[Shipment Method Code]
,[Shipment Method].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
ON
[Customer Template].[Shipment Method Code] = [Shipment Method].[Code] |
| 33 | Invoice Disc. Code | Invoice Disc. Code | Normal | Code | 20 | Invoice Disc_ Code | nvarchar(40) |
| 34 | Customer Disc. Group | Customer Disc. Group | Normal | Code | 20 | Customer Disc_ Group | nvarchar(40) |
| Key to join to the Customer Discount Group table.SELECT
[Customer Template].[Customer Disc_ Group]
,[Customer Discount Group].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
ON
[Customer Template].[Customer Disc_ Group] = [Customer Discount Group].[Code] |
| 35 | Country/Region Code | Country/Region Code | Normal | Code | 10 | Country_Region Code | nvarchar(20) |
| 47 | Payment Method Code | Payment Method Code | Normal | Code | 10 | Payment Method Code | nvarchar(20) |
| Key to join to the Payment Method table.SELECT
[Customer Template].[Payment Method Code]
,[Payment Method].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
ON
[Customer Template].[Payment Method Code] = [Payment Method].[Code] |
| 82 | Prices Including VAT | Prices Including VAT | Normal | Boolean | 4 | Prices Including VAT | tinyint |
| 88 | Gen. Bus. Posting Group | Gen. Bus. Posting Group | Normal | Code | 20 | Gen_ Bus_ Posting Group | nvarchar(40) |
| Key to join to the Gen. Business Posting Group table.SELECT
[Customer Template].[Gen_ Bus_ Posting Group]
,[Gen. Business Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
ON
[Customer Template].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code] |
| 110 | VAT Bus. Posting Group | VAT Bus. Posting Group | Normal | Code | 20 | VAT Bus_ Posting Group | nvarchar(40) |
| Key to join to the VAT Business Posting Group table.SELECT
[Customer Template].[VAT Bus_ Posting Group]
,[VAT Business Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
ON
[Customer Template].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code] |
| 5050 | Contact Type | Contact Type | Normal | Option | 4 | Contact Type | int |
| Available options are:
|
| 7001 | Allow Line Disc. | Allow Line Disc. | Normal | Boolean | 4 | Allow Line Disc_ | tinyint |
| 10020 | Credit Limit (LCY) | Credit Limit (LCY) | Normal | Decimal | 12 | | |
| 10092 | State | State | Normal | Text | 30 | | |
| 10108 | Tax Area Code | Tax Area Code | Normal | Code | 20 | | |
| Key to join to the Tax Area table.SELECT
[Customer Template].[]
,[Tax Area].[Code]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Customer Template].[] = [Tax Area].[Code] |
| 10109 | Tax Liable | Tax Liable | Normal | Boolean | 4 | | |
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
| Key to join to the User table.SELECT
[Customer Template].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
[User] AS [User]
ON
[Customer Template].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
