Reminder_Fin_ Charge Entry

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

Table Type: Company

Table Name: Reminder_Fin_ Charge Entry
Database Table Name: CRONUS UK Ltd_$Reminder_Fin_ Charge Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 300

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_Fin_ Charge Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Reminder_Fin_ Charge Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Type]
   ,[No_]
   ,[Reminder Level]
   ,[Posting Date]
   ,[Document Date]
   ,[Interest Posted]
   ,[Interest Amount]
   ,[Customer Entry No_]
   ,[Document Type]
   ,[Document No_]
   ,[Remaining Amount]
   ,[Customer No_]
   ,[User ID]
   ,[Due Date]
   ,[Canceled]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Reminder_Fin_ Charge Entry$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_Fin_ Charge Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder_Fin_ Charge Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Reminder_Fin_ Charge Entry].[Customer No_] = [Customer].[No_]

Show/hide columns in Reminder_Fin_ Charge Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Type Searchint
4No_ Searchnvarchar(40)
5Reminder Level Searchint
6Posting Date Searchdatetime
7Document Date Searchdatetime
8Interest Posted Searchtinyint
9Interest Amount Searchdecimal(38,38)
10Customer Entry No_ Searchint
11Document Type Searchint
12Document No_ Searchnvarchar(40)
13Remaining Amount Searchdecimal(38,38)
14Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Reminder_Fin_ Charge Entry].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Reminder_Fin_ Charge Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder_Fin_ Charge Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Reminder_Fin_ Charge Entry].[Customer No_] = [Customer].[No_]
15User ID Searchnvarchar(100)
16Due Date Searchdatetime
17Canceled Searchtinyint
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Reminder_Fin_ Charge Entry table

Leave a Reply

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