Reminder Terms

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

Table Type: Company

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

Table Number: 292

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Description]
   ,[Post Interest]
   ,[Post Additional Fee]
   ,[Max_ No_ of Reminders]
   ,[Minimum Amount (LCY)]
   ,[Post Add_ Fee per Line]
   ,[Note About Line Fee on Report]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Reminder Terms table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Description Searchnvarchar(200)
4Post Interest Searchtinyint
5Post Additional Fee Searchtinyint
6Max_ No_ of Reminders Searchint
7Minimum Amount (LCY) Searchdecimal(38,38)
8Post Add_ Fee per Line Searchtinyint
9Note About Line Fee on Report Searchnvarchar(300)
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Reminder Terms table

Leave a Reply

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