Reminder Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RReminder Line

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

Table Type: Company

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

Table Number: 296

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Reminder No_]
   ,[Line No_]
   ,[Attached to Line No_]
   ,[Type]
   ,[Entry No_]
   ,[No_ of Reminders]
   ,[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]
   ,[Applies-to Document Type]
   ,[Applies-to Document No_]
   ,[Detailed Interest Rates Entry]
   ,[System-Created Entry]
   ,[Multiple Interest Rates Entry]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Reminder Line table

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