Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/302
Table Type: Company
Table Name: Finance Charge Memo Header
Database Table Name: CRONUS UK Ltd_$Finance Charge Memo Header$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 Finance Charge Memo Header can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[No_]
,[Customer No_]
,[Name]
,[Name 2]
,[Address]
,[Address 2]
,[Post Code]
,[City]
,[County]
,[Country_Region Code]
,[Language Code]
,[Currency Code]
,[Contact]
,[Your Reference]
,[Shortcut Dimension 1 Code]
,[Shortcut Dimension 2 Code]
,[Customer Posting Group]
,[Gen_ Bus_ Posting Group]
,[VAT Registration No_]
,[Reason Code]
,[Posting Date]
,[Document Date]
,[Due Date]
,[Fin_ Charge Terms Code]
,[Post Interest]
,[Post Additional Fee]
,[Posting Description]
,[No_ Series]
,[Issuing No_ Series]
,[Issuing No_]
,[Tax Area Code]
,[Tax Liable]
,[VAT Bus_ Posting Group]
,[Company Bank Account Code]
,[Dimension Set ID]
,[Assigned User ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Header]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Finance Charge Memo Header].[Customer No_] = [Customer].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Finance Charge Memo Header].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Finance Charge Memo Header].[Language Code] = [Language].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Finance Charge Memo Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
ON
[Finance Charge Memo Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Finance Charge Memo Header].[Tax Area Code] = [Tax Area].[Code]Show/hide columns in Finance Charge Memo Header table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | No_  | nvarchar(40) | ||||
| 3 | Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[Finance Charge Memo Header].[Customer No_]
,[Customer].[No_]
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Header]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Finance Charge Memo Header].[Customer No_] = [Customer].[No_] | ||||||
| 4 | Name | nvarchar(200) | ||||
| 5 | Name 2 | nvarchar(100) | ||||
| 6 | Address | nvarchar(200) | ||||
| 7 | Address 2 | nvarchar(100) | ||||
| 8 | Post Code | nvarchar(40) | ||||
| 9 | City | nvarchar(60) | ||||
| 10 | County | nvarchar(60) | ||||
| 11 | Country_Region Code | nvarchar(20) | ||||
Key to join to the Country_Region table.Show/hide example querySELECT
[Finance Charge Memo Header].[Country_Region Code]
,[Country_Region].[Code]
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Header]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Finance Charge Memo Header].[Country_Region Code] = [Country_Region].[Code] | ||||||
| 12 | Language Code | nvarchar(20) | ||||
Key to join to the Language table.Show/hide example querySELECT
[Finance Charge Memo Header].[Language Code]
,[Language].[Code]
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Header]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Finance Charge Memo Header].[Language Code] = [Language].[Code] | ||||||
| 13 | Currency Code | nvarchar(20) | ||||
Key to join to the Currency table.Show/hide example querySELECT
[Finance Charge Memo Header].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Header]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Finance Charge Memo Header].[Currency Code] = [Currency].[Code] | ||||||
| 14 | Contact | nvarchar(200) | ||||
| 15 | Your Reference | nvarchar(70) | ||||
| 16 | Shortcut Dimension 1 Code | nvarchar(40) | ||||
| 17 | Shortcut Dimension 2 Code | nvarchar(40) | ||||
| 18 | Customer Posting Group | nvarchar(40) | ||||
Key to join to the Customer Posting Group table.Show/hide example querySELECT
[Finance Charge Memo Header].[Customer Posting Group]
,[Customer Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Header]
LEFT JOIN
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
ON
[Finance Charge Memo Header].[Customer Posting Group] = [Customer Posting Group].[Code] | ||||||
| 19 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 20 | VAT Registration No_ | nvarchar(40) | ||||
| 21 | Reason Code | nvarchar(20) | ||||
| 22 | Posting Date | datetime | ||||
| 23 | Document Date | datetime | ||||
| 24 | Due Date | datetime | ||||
| 25 | Fin_ Charge Terms Code | nvarchar(20) | ||||
| 26 | Post Interest | tinyint | ||||
| 27 | Post Additional Fee | tinyint | ||||
| 28 | Posting Description | nvarchar(200) | ||||
| 29 | No_ Series | nvarchar(40) | ||||
| 30 | Issuing No_ Series | nvarchar(40) | ||||
| 31 | Issuing No_ | nvarchar(40) | ||||
| 32 | Tax Area Code | nvarchar(40) | ||||
Key to join to the Tax Area table.Show/hide example querySELECT
[Finance Charge Memo Header].[Tax Area Code]
,[Tax Area].[Code]
FROM
[CRONUS UK Ltd_$Finance Charge Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Header]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Finance Charge Memo Header].[Tax Area Code] = [Tax Area].[Code] | ||||||
| 33 | Tax Liable | tinyint | ||||
| 34 | VAT Bus_ Posting Group | nvarchar(40) | ||||
| 35 | Company Bank Account Code | nvarchar(40) | ||||
| 36 | Dimension Set ID | int | ||||
| 37 | Assigned User ID | nvarchar(100) | ||||
| 38 | $systemId | uniqueidentifier | ||||
| 39 | $systemCreatedAt | datetime | ||||
| 40 | $systemCreatedBy | uniqueidentifier | ||||
| 41 | $systemModifiedAt | datetime | ||||
| 42 | $systemModifiedBy | uniqueidentifier | ||||