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
   [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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Direct Debit Collection Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Direct Debit Collection Entry].[Applies-to Entry Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Direct Debit Collection Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Direct Debit Collection Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Direct Debit Collection Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Direct Debit Collection No. Primary Key SearchDirect Debit Collection No.NormalInteger4Direct Debit Collection No_int
Key to join to the Direct Debit Collection table.

Show/hide example query

SELECT
       [Direct Debit Collection Entry].[Direct Debit Collection No_]
       ,[Direct Debit Collection].[No_]
FROM
       [CRONUS UK Ltd_$Direct Debit Collection Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Debit Collection Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Direct Debit Collection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Debit Collection]
              ON
                     [Direct Debit Collection Entry].[Direct Debit Collection No_] = [Direct Debit Collection].[No_]
2Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
3Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(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_]
4Applies-to Entry No. SearchApplies-to Entry No.NormalInteger4Applies-to Entry No_int
5Transfer Date SearchTransfer DateNormalDate4Transfer Datedatetime
6Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
7Transfer Amount SearchTransfer AmountNormalDecimal12Transfer Amountdecimal(38,38)
8Transaction ID SearchTransaction IDNormalText35Transaction IDnvarchar(70)
9Sequence Type SearchSequence TypeNormalOption4Sequence Typeint
Available options are:
  • “One Off”
  • “First”
  • “Recurring”
  • “Last”
10Status SearchStatusNormalOption4Statusint
Available options are:
  • “New”
  • “File Created”
  • “Rejected”
  • “Posted”
11Mandate ID SearchMandate IDNormalCode35Mandate IDnvarchar(70)
12Mandate Type of Payment SearchMandate Type of PaymentFlowFieldOption4
13Customer Name SearchCustomer NameFlowFieldText100
14Applies-to Entry Document No. SearchApplies-to Entry Document No.FlowFieldCode20
15Applies-to Entry Description SearchApplies-to Entry DescriptionFlowFieldText100
16Applies-to Entry Posting Date SearchApplies-to Entry Posting DateFlowFieldDate4
17Applies-to Entry Currency Code SearchApplies-to Entry Currency CodeFlowFieldCode10
18Applies-to Entry Amount SearchApplies-to Entry AmountFlowFieldDecimal12
19Applies-to Entry Rem. Amount SearchApplies-to Entry Rem. AmountFlowFieldDecimal12
20Applies-to Entry Open SearchApplies-to Entry OpenFlowFieldBoolean4
21Direct Debit Collection Status SearchDirect Debit Collection StatusFlowFieldOption4
22Payment Reference SearchPayment ReferenceFlowFieldCode50
23Message to Recipient SearchMessage to RecipientNormalText140Message to Recipientnvarchar(280)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Direct Debit Collection Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Direct Debit Collection Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Debit Collection Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Direct Debit Collection Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Direct Debit Collection Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Direct Debit Collection Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Debit Collection Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Direct Debit Collection Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Direct Debit Collection Entry table

Leave a Reply

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