Reminder 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Reminder No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Attached to Line No_ Searchint
5Type Searchint
6Entry No_ Searchint
7No_ of Reminders Searchint
8Posting Date Searchdatetime
9Document Date Searchdatetime
10Due Date Searchdatetime
11Document Type Searchint
12Document No_ Searchnvarchar(40)
13Description Searchnvarchar(200)
14Original Amount Searchdecimal(38,38)
15Remaining Amount Searchdecimal(38,38)
16No_ Searchnvarchar(40)
17Amount Searchdecimal(38,38)
18Interest Rate Searchdecimal(38,38)
19Gen_ Prod_ Posting Group Searchnvarchar(40)
20VAT _ Searchdecimal(38,38)
21VAT Calculation Type Searchint
22VAT Amount Searchdecimal(38,38)
23Tax Group Code Searchnvarchar(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]
24VAT Prod_ Posting Group Searchnvarchar(40)
25VAT Identifier Searchnvarchar(40)
26Line Type Searchint
27VAT Clause Code Searchnvarchar(40)
28Applies-to Document Type Searchint
29Applies-to Document No_ Searchnvarchar(40)
30Detailed Interest Rates Entry Searchtinyint
31System-Created Entry Searchtinyint
32Multiple Interest Rates Entry Searchtinyint
33$systemId Searchuniqueidentifier
34$systemCreatedAt Searchdatetime
35$systemCreatedBy Searchuniqueidentifier
36$systemModifiedAt Searchdatetime
37$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Reminder Line table

Leave a Reply

Your email address will not be published. Required fields are marked *