Direct Debit Collection Entry

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

Table Type: Company

Table Name: Direct Debit Collection Entry
Database Table Name: CRONUS UK Ltd_$Direct Debit Collection Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1208

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 Direct Debit Collection Entry can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Direct Debit Collection No_]
   ,[Entry No_]
   ,[Customer No_]
   ,[Applies-to Entry No_]
   ,[Transfer Date]
   ,[Currency Code]
   ,[Transfer Amount]
   ,[Transaction ID]
   ,[Sequence Type]
   ,[Status]
   ,[Mandate ID]
   ,[Message to Recipient]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Direct Debit Collection 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_$Direct Debit Collection Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Debit Collection Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Direct Debit Collection Entry].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Direct Debit Collection Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Direct Debit Collection Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Direct Debit Collection No_ Primary Key Searchint
3Entry No_ Primary Key Searchint
4Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Direct Debit Collection Entry].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Direct Debit Collection Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Debit Collection Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Direct Debit Collection Entry].[Customer No_] = [Customer].[No_]
5Applies-to Entry No_ Searchint
6Transfer Date Searchdatetime
7Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Direct Debit Collection Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Direct Debit Collection Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Debit Collection Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Direct Debit Collection Entry].[Currency Code] = [Currency].[Code]
8Transfer Amount Searchdecimal(38,38)
9Transaction ID Searchnvarchar(70)
10Sequence Type Searchint
11Status Searchint
12Mandate ID Searchnvarchar(70)
13Message to Recipient Searchnvarchar(280)
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Direct Debit Collection Entry table

Leave a Reply

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