Finance Charge Memo Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables FFinance Charge Memo Line

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

Table Type: Company

Table Name: Finance Charge Memo Line
Database Table Name: CRONUS UK Ltd_$Finance Charge Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 303

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Finance Charge Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Finance Charge Memo No_]
   ,[Line No_]
   ,[Attached to Line No_]
   ,[Type]
   ,[Entry No_]
   ,[Posting Date]
   ,[Document Date]
   ,[Due Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Original Amount]
   ,[Remaining Amount]
   ,[No_]
   ,[Amount]
   ,[Interest Rate]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT _]
   ,[VAT Calculation Type]
   ,[VAT Amount]
   ,[Tax Group Code]
   ,[VAT Prod_ Posting Group]
   ,[VAT Identifier]
   ,[Line Type]
   ,[VAT Clause Code]
   ,[Detailed Interest Rates Entry]
   ,[System-Created Entry]
   ,[Multiple Interest Rates Entry]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Finance Charge Memo Line$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 Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Line]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Finance Charge Memo Line].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in Finance Charge Memo Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Finance Charge Memo No_	nvarchar(40)
3	Line No_	int
4	Attached to Line No_	int
5	Type	int
6	Entry No_	int
7	Posting Date	datetime
8	Document Date	datetime
9	Due Date	datetime
10	Document Type	int
11	Document No_	nvarchar(40)
12	Description	nvarchar(200)
13	Original Amount	decimal(38,38)
14	Remaining Amount	decimal(38,38)
15	No_	nvarchar(40)
16	Amount	decimal(38,38)
17	Interest Rate	decimal(38,38)
18	Gen_ Prod_ Posting Group	nvarchar(40)
19	VAT _	decimal(38,38)
20	VAT Calculation Type	int
21	VAT Amount	decimal(38,38)
22	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Finance Charge Memo Line].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Finance Charge Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Line] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Finance Charge Memo Line].[Tax Group Code] = [Tax Group].[Code]
23	VAT Prod_ Posting Group	nvarchar(40)
24	VAT Identifier	nvarchar(40)
25	Line Type	int
26	VAT Clause Code	nvarchar(40)
27	Detailed Interest Rates Entry	tinyint
28	System-Created Entry	tinyint
29	Multiple Interest Rates Entry	tinyint
30	$systemId	uniqueidentifier
31	$systemCreatedAt	datetime
32	$systemCreatedBy	uniqueidentifier
33	$systemModifiedAt	datetime
34	$systemModifiedBy	uniqueidentifier