Finance Charge Memo Line

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

Table Type: Company

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

Table Number: 303

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 Finance Charge Memo Line can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Finance Charge Memo No_]
   ,[Line No_]
   ,[Attached to Line No_]
   ,[Type]
   ,[Entry No_]
   ,[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]
   ,[Detailed Interest Rates Entry]
   ,[System-Created Entry]
   ,[Multiple Interest Rates Entry]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Finance Charge Memo 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_$Finance Charge Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Line]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Finance Charge Memo Line].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in Finance Charge Memo Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Finance Charge Memo No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Attached to Line No_ Searchint
5Type Searchint
6Entry No_ Searchint
7Posting Date Searchdatetime
8Document Date Searchdatetime
9Due Date Searchdatetime
10Document Type Searchint
11Document No_ Searchnvarchar(40)
12Description Searchnvarchar(200)
13Original Amount Searchdecimal(38,38)
14Remaining Amount Searchdecimal(38,38)
15No_ Searchnvarchar(40)
16Amount Searchdecimal(38,38)
17Interest Rate Searchdecimal(38,38)
18Gen_ Prod_ Posting Group Searchnvarchar(40)
19VAT _ Searchdecimal(38,38)
20VAT Calculation Type Searchint
21VAT Amount Searchdecimal(38,38)
22Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Finance Charge Memo Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Finance Charge Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Finance Charge Memo Line].[Tax Group Code] = [Tax Group].[Code]
23VAT Prod_ Posting Group Searchnvarchar(40)
24VAT Identifier Searchnvarchar(40)
25Line Type Searchint
26VAT Clause Code Searchnvarchar(40)
27Detailed Interest Rates Entry Searchtinyint
28System-Created Entry Searchtinyint
29Multiple Interest Rates Entry Searchtinyint
30$systemId Searchuniqueidentifier
31$systemCreatedAt Searchdatetime
32$systemCreatedBy Searchuniqueidentifier
33$systemModifiedAt Searchdatetime
34$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Finance Charge Memo Line table

Leave a Reply

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