Issued Reminder Line

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

Table Type: Company

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

Table Number: 298

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Issued 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]
   ,[Canceled]
   ,[System-Created Entry]
   ,[Multiple Interest Rates Entry]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Issued 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_$Issued Reminder Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Reminder Line]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Issued Reminder Line].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in Issued 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
       [Issued Reminder Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Issued Reminder Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Reminder Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Issued 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
31Canceled Searchtinyint
32System-Created Entry Searchtinyint
33Multiple Interest Rates Entry Searchtinyint
34$systemId Searchuniqueidentifier
35$systemCreatedAt Searchdatetime
36$systemCreatedBy Searchuniqueidentifier
37$systemModifiedAt Searchdatetime
38$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Issued Reminder Line table

Leave a Reply

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