SEPA Direct Debit Mandate – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSEPA Direct Debit Mandate

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

Table Type: Company

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

Table Number: 1230

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 SEPA Direct Debit Mandate can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$SEPA Direct Debit Mandate$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[Customer No_]
   ,[Customer Bank Account Code]
   ,[Valid From]
   ,[Valid To]
   ,[Date of Signature]
   ,[Type of Payment]
   ,[Blocked]
   ,[Expected Number of Debits]
   ,[Debit Counter]
   ,[No_ Series]
   ,[Closed]
   ,[Ignore Exp_ Number of Debits]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$SEPA Direct Debit Mandate$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$SEPA Direct Debit Mandate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SEPA Direct Debit Mandate]
LEFT JOIN
   [User] AS [User]
      ON
         [SEPA Direct Debit Mandate].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [SEPA Direct Debit Mandate].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in SEPA Direct Debit Mandate table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	ID	Normal	Code	35	ID	nvarchar(70)
2	Customer No.	Customer No.	Normal	Code	20	Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [SEPA Direct Debit Mandate].[Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$SEPA Direct Debit Mandate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SEPA Direct Debit Mandate] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [SEPA Direct Debit Mandate].[Customer No_] = [Customer].[No_]
3	Customer Bank Account Code	Customer Bank Account Code	Normal	Code	20	Customer Bank Account Code	nvarchar(40)
4	Valid From	Valid From	Normal	Date	4	Valid From	datetime
5	Valid To	Valid To	Normal	Date	4	Valid To	datetime
6	Date of Signature	Date of Signature	Normal	Date	4	Date of Signature	datetime
7	Type of Payment	Type of Payment	Normal	Option	4	Type of Payment	int
	Available options are: “OneOff” “Recurrent”
8	Blocked	Blocked	Normal	Boolean	4	Blocked	tinyint
9	Expected Number of Debits	Expected Number of Debits	Normal	Integer	4	Expected Number of Debits	int
10	Debit Counter	Debit Counter	Normal	Integer	4	Debit Counter	int
11	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [SEPA Direct Debit Mandate].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$SEPA Direct Debit Mandate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SEPA Direct Debit Mandate] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [SEPA Direct Debit Mandate].[No_ Series] = [No. Series].[Code]
12	Closed	Closed	Normal	Boolean	4	Closed	tinyint
13	Ignore Exp. Number of Debits	Ignore Expected Number of Debits	Normal	Boolean	4	Ignore Exp_ Number of Debits	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [SEPA Direct Debit Mandate].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$SEPA Direct Debit Mandate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SEPA Direct Debit Mandate] LEFT JOIN [User] AS [User] ON [SEPA Direct Debit Mandate].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier