Issued Fin_ Charge Memo Line

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

Table Type: Company

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

Table Number: 305

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

Show/hide an example select of all columns

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

Show/hide columns in Issued Fin_ 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
       [Issued Fin_ Charge Memo Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Issued Fin_ Charge Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Issued Fin_ Charge Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Issued Fin_ Charge Memo Line].[Tax Group Code] = [Tax Group].[Code]
23VAT Prod_ Posting Group Searchnvarchar(40)
24VAT Identifier Searchnvarchar(40)
25VAT Clause Code Searchnvarchar(40)
26Detailed Interest Rates Entry Searchtinyint
27System-Created Entry Searchtinyint
28Multiple Interest Rates Entry Searchtinyint
29$systemId Searchuniqueidentifier
30$systemCreatedAt Searchdatetime
31$systemCreatedBy Searchuniqueidentifier
32$systemModifiedAt Searchdatetime
33$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Issued Fin_ Charge Memo Line table

Leave a Reply

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