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
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
[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]
,[Intrastat 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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Customer Templ.].[City] = [Post Code].[City]
LEFT JOIN
[CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
ON
[Customer Templ.].[Document Sending Profile] = [Document Sending Profile].[Code]
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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Customer Templ.].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Customer Templ.].[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 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].[Code]
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$ext] AS [Shipping Agent]
ON
[Customer Templ.].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] 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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
ON
[Customer Templ.].[Post Code] = [Post Code].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
ON
[Customer Templ.].[Reminder Terms Code] = [Reminder Terms].[Code]
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_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Customer Templ.].[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 Templ.].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
ON
[Customer Templ.].[Service Zone Code] = [Service Zone].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
ON
[Customer Templ.].[Base Calendar Code] = [Base Calendar].[Code]
LEFT JOIN
[User] AS [User]
ON
[Customer Templ.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Customer Templ.].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Customer Templ. table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Code | Code | Normal | Code | 20 | Code | nvarchar(40) |
2 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
5 | Address | Address | Normal | Text | 100 | Address | nvarchar(200) |
6 | Address 2 | Address 2 | Normal | Text | 50 | Address 2 | nvarchar(100) |
7 | City | City | Normal | Text | 30 | City | nvarchar(60) |
Key to join to the Post Code table.Show/hide example querySELECT [Customer Templ.].[City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Customer Templ.].[City] = [Post Code].[City] | |||||||
9 | Phone No. | Phone No. | Normal | Text | 30 | Phone No_ | nvarchar(60) |
10 | Telex No. | Telex No. | Normal | Text | 20 | Telex No_ | nvarchar(40) |
11 | Document Sending Profile | Document Sending Profile | Normal | Code | 20 | Document Sending Profile | nvarchar(40) |
Key to join to the Document Sending Profile table.Show/hide example querySELECT [Customer Templ.].[Document Sending Profile] ,[Document Sending Profile].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile] ON [Customer Templ.].[Document Sending Profile] = [Document Sending Profile].[Code] | |||||||
14 | Our Account No. | Our Account No. | Normal | Text | 20 | Our Account No_ | nvarchar(40) |
15 | Territory Code | Territory Code | Normal | Code | 10 | Territory Code | nvarchar(20) |
Key to join to the Territory table.Show/hide example querySELECT [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] | |||||||
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.Show/hide example querySELECT [Customer Templ.].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Customer Templ.].[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.Show/hide example querySELECT [Customer Templ.].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Customer Templ.].[Global Dimension 2 Code] = [Dimension].[Code] | |||||||
18 | Chain Name | Chain Name | Normal | Code | 10 | Chain Name | nvarchar(20) |
19 | Budgeted Amount | Budgeted Amount | Normal | Decimal | 12 | Budgeted Amount | decimal(38,38) |
20 | Credit Limit (LCY) | Credit Limit ($) | Normal | Decimal | 12 | Credit Limit (LCY) | decimal(38,38) |
21 | Customer Posting Group | Customer Posting Group | Normal | Code | 20 | Customer Posting Group | nvarchar(40) |
Key to join to the Customer Posting Group table.Show/hide example querySELECT [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] | |||||||
22 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
Key to join to the Currency table.Show/hide example querySELECT [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] | |||||||
23 | Customer Price Group | Customer Price Group | Normal | Code | 10 | Customer Price Group | nvarchar(20) |
Key to join to the Customer Price Group table.Show/hide example querySELECT [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] | |||||||
24 | Language Code | Language Code | Normal | Code | 10 | Language Code | nvarchar(20) |
Key to join to the Language table.Show/hide example querySELECT [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] | |||||||
26 | Statistics Group | Statistics Group | Normal | Integer | 4 | Statistics Group | int |
27 | Payment Terms Code | Payment Terms Code | Normal | Code | 10 | Payment Terms Code | nvarchar(20) |
Key to join to the Payment Terms table.Show/hide example querySELECT [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] | |||||||
28 | Fin. Charge Terms Code | Fin. Charge Terms Code | Normal | Code | 10 | Fin_ Charge Terms Code | nvarchar(20) |
Key to join to the Finance Charge Terms table.Show/hide example querySELECT [Customer Templ.].[Fin_ Charge Terms Code] ,[Finance Charge Terms].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Finance Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Terms] ON [Customer Templ.].[Fin_ Charge Terms Code] = [Finance Charge Terms].[Code] | |||||||
29 | Salesperson Code | Salesperson Code | Normal | Code | 20 | Salesperson Code | nvarchar(40) |
Key to join to the Salesperson/Purchaser table.Show/hide example querySELECT [Customer Templ.].[Salesperson Code] ,[Salesperson/Purchaser].[Code] 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].[Code] | |||||||
30 | Shipment Method Code | Shipment Method Code | Normal | Code | 10 | Shipment Method Code | nvarchar(20) |
Key to join to the Shipment Method table.Show/hide example querySELECT [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] | |||||||
31 | Shipping Agent Code | Shipping Agent Code | Normal | Code | 10 | Shipping Agent Code | nvarchar(20) |
Key to join to the Shipping Agent table.Show/hide example querySELECT [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$ext] AS [Shipping Agent] ON [Customer Templ.].[Shipping Agent Code] = [Shipping Agent].[Code] | |||||||
32 | Place of Export | Place of Export | Normal | Code | 20 | Place of Export | nvarchar(40) |
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.Show/hide example querySELECT [Customer Templ.].[Customer Disc_ Group] ,[Customer Discount Group].[Code] 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].[Code] | |||||||
35 | Country/Region Code | Country/Region Code | Normal | Code | 10 | Country_Region Code | nvarchar(20) |
36 | Collection Method | Collection Method | Normal | Code | 20 | Collection Method | nvarchar(40) |
37 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
39 | Blocked | Blocked | Normal | Option | 4 | Blocked | int |
Available options are:
| |||||||
42 | Print Statements | Print Statements | Normal | Boolean | 4 | Print Statements | tinyint |
45 | Bill-to Customer No. | Bill-to Customer No. | Normal | Code | 20 | Bill-to Customer No_ | nvarchar(40) |
Key to join to the Customer table.Show/hide example querySELECT [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_] | |||||||
47 | Payment Method Code | Payment Method Code | Normal | Code | 10 | Payment Method Code | nvarchar(20) |
Key to join to the Payment Method table.Show/hide example querySELECT [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$ext] AS [Payment Method] ON [Customer Templ.].[Payment Method Code] = [Payment Method].[Code] | |||||||
80 | Application Method | Application Method | Normal | Option | 4 | Application Method | int |
Available options are:
| |||||||
82 | Prices Including VAT | Prices Including Tax | Normal | Boolean | 4 | Prices Including VAT | tinyint |
83 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
Key to join to the Location table.Show/hide example querySELECT [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] | |||||||
84 | Fax No. | Fax No. | Normal | Text | 30 | Fax No_ | nvarchar(60) |
85 | Telex Answer Back | Telex Answer Back | Normal | Text | 20 | Telex Answer Back | nvarchar(40) |
86 | VAT Registration No. | VAT Registration No. | Normal | Text | 20 | VAT Registration No_ | nvarchar(40) |
87 | Combine Shipments | Combine Shipments | Normal | Boolean | 4 | Combine Shipments | 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.Show/hide example querySELECT [Customer Templ.].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Customer Templ.].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code] | |||||||
90 | GLN | GLN | Normal | Code | 13 | GLN | nvarchar(26) |
91 | Post Code | ZIP Code | Normal | Code | 20 | Post Code | nvarchar(40) |
Key to join to the Post Code table.Show/hide example querySELECT [Customer Templ.].[Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Customer Templ.].[Post Code] = [Post Code].[Code] | |||||||
92 | County | State | Normal | Text | 30 | County | nvarchar(60) |
93 | EORI Number | EORI Number | Normal | Text | 40 | EORI Number | nvarchar(80) |
95 | Use GLN in Electronic Document | Use GLN in Electronic Documents | Normal | Boolean | 4 | Use GLN in Electronic Document | tinyint |
102 | Normal | Text | 80 | nvarchar(160) | |||
103 | Home Page | Home Page | Normal | Text | 80 | Home Page | nvarchar(160) |
104 | Reminder Terms Code | Reminder Terms Code | Normal | Code | 10 | Reminder Terms Code | nvarchar(20) |
Key to join to the Reminder Terms table.Show/hide example querySELECT [Customer Templ.].[Reminder Terms Code] ,[Reminder Terms].[Code] 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].[Code] | |||||||
107 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT [Customer Templ.].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Customer Templ.].[No_ Series] = [No. Series].[Code] | |||||||
108 | Tax Area Code | Tax Area Code | Normal | Code | 20 | Tax Area Code | nvarchar(40) |
Key to join to the Tax Area table.Show/hide example querySELECT [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] | |||||||
109 | Tax Liable | Tax Liable | Normal | Boolean | 4 | Tax Liable | tinyint |
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.Show/hide example querySELECT [Customer Templ.].[VAT Bus_ Posting Group] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Customer Templ.].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code] | |||||||
115 | Reserve | Reserve | Normal | Option | 4 | Reserve | int |
Available options are:
| |||||||
116 | Block Payment Tolerance | Block Payment Tolerance | Normal | Boolean | 4 | Block Payment Tolerance | tinyint |
119 | IC Partner Code | IC Partner Code | Normal | Code | 20 | IC Partner Code | nvarchar(40) |
Key to join to the IC Partner table.Show/hide example querySELECT [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] | |||||||
124 | Prepayment % | Prepayment % | Normal | Decimal | 12 | Prepayment _ | decimal(38,38) |
132 | Partner Type | Partner Type | Normal | Option | 4 | Partner Type | int |
Available options are:
| |||||||
133 | Intrastat Partner Type | Intrastat Partner Type | Normal | Option | 4 | Intrastat Partner Type | int |
Available options are:
| |||||||
150 | Privacy Blocked | Privacy Blocked | Normal | Boolean | 4 | Privacy Blocked | tinyint |
160 | Disable Search by Name | Disable Search by Name | Normal | Boolean | 4 | Disable Search by Name | tinyint |
840 | Cash Flow Payment Terms Code | Cash Flow Payment Terms Code | Normal | Code | 10 | Cash Flow Payment Terms Code | nvarchar(20) |
Key to join to the Payment Terms table.Show/hide example querySELECT [Customer Templ.].[Cash Flow 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.].[Cash Flow Payment Terms Code] = [Payment Terms].[Code] | |||||||
5050 | Contact Type | Contact Type | Normal | Option | 4 | Contact Type | int |
Available options are:
| |||||||
5061 | Mobile Phone No. | Mobile Phone No. | Normal | Text | 30 | Mobile Phone No_ | nvarchar(60) |
5700 | Responsibility Center | Responsibility Center | Normal | Code | 10 | Responsibility Center | nvarchar(20) |
Key to join to the Responsibility Center table.Show/hide example querySELECT [Customer Templ.].[Responsibility Center] ,[Responsibility Center].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center] ON [Customer Templ.].[Responsibility Center] = [Responsibility Center].[Code] | |||||||
5750 | Shipping Advice | Shipping Advice | Normal | Option | 4 | Shipping Advice | int |
Available options are:
| |||||||
5790 | Shipping Time | Shipping Time | Normal | DateFormula | 32 | Shipping Time | varchar(32) |
5792 | Shipping Agent Service Code | Shipping Agent Service Code | Normal | Code | 10 | Shipping Agent Service Code | nvarchar(20) |
5900 | Service Zone Code | Service Zone Code | Normal | Code | 10 | Service Zone Code | nvarchar(20) |
Key to join to the Service Zone table.Show/hide example querySELECT [Customer Templ.].[Service Zone Code] ,[Service Zone].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone] ON [Customer Templ.].[Service Zone Code] = [Service Zone].[Code] | |||||||
7001 | Allow Line Disc. | Allow Line Disc. | Normal | Boolean | 4 | Allow Line Disc_ | tinyint |
7600 | Base Calendar Code | Base Calendar Code | Normal | Code | 10 | Base Calendar Code | nvarchar(20) |
Key to join to the Base Calendar table.Show/hide example querySELECT [Customer Templ.].[Base Calendar Code] ,[Base Calendar].[Code] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar] ON [Customer Templ.].[Base Calendar Code] = [Base Calendar].[Code] | |||||||
7601 | Copy Sell-to Addr. to Qte From | Copy Sell-to Addr. to Qte From | Normal | Option | 4 | Copy Sell-to Addr_ to Qte From | int |
Available options are:
| |||||||
7602 | Validate EU Vat Reg. No. | Validate EU VAT Reg. No. | Normal | Boolean | 4 | Validate EU Vat Reg_ No_ | tinyint |
10004 | UPS Zone | UPS Zone | Normal | Code | 2 | ||
10015 | Tax Exemption No. | Tax Exemption No. | Normal | Text | 30 | ||
10017 | Bank Communication | Bank Communication | Normal | Option | 4 | ||
10018 | Check Date Format | Check Date Format | Normal | Option | 4 | ||
10019 | Check Date Separator | Check Date Separator | Normal | Option | 4 | ||
10023 | RFC No. | RFC No. | Normal | Code | 13 | ||
10024 | CURP No. | CURP No. | Normal | Code | 18 | ||
10025 | State Inscription | State Inscription | Normal | Text | 30 | ||
10092 | State | State | Normal | Text | 30 | ||
14020 | Tax Identification Type | Tax Identification Type | Normal | Option | 4 | ||
27000 | CFDI Purpose | CFDI Purpose | Normal | Code | 10 | ||
27001 | CFDI Relation | CFDI Relation | Normal | Code | 10 | ||
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.Show/hide example querySELECT [Customer Templ.].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] LEFT JOIN [User] AS [User] ON [Customer Templ.].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |