Bank Pmt. Appl. Rule – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables BBank Pmt. Appl. Rule

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

Table Type: Company

Table Name: Bank Pmt. Appl. Rule
Database Table Name: CRONUS UK Ltd_$Bank Pmt_ Appl_ Rule$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1252

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 Bank Pmt. Appl. Rule can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Bank Pmt_ Appl_ Rule$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Match Confidence]
   ,[Priority]
   ,[Related Party Matched]
   ,[Doc_ No__Ext_ Doc_ No_ Matched]
   ,[Amount Incl_ Tolerance Matched]
   ,[Direct Debit Collect_ Matched]
   ,[Score]
   ,[Review Required]
   ,[Apply Immediatelly]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Bank Pmt_ Appl_ Rule$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bank Pmt_ Appl_ Rule$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Pmt. Appl. Rule]
LEFT JOIN
   [User] AS [User]
      ON
         [Bank Pmt. Appl. Rule].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Bank Pmt. Appl. Rule].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Bank Pmt. Appl. Rule table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Match Confidence	Match Confidence	Normal	Option	4	Match Confidence	int
	Available options are: “None” “Low” “Medium” “High”
2	Priority	Priority	Normal	Integer	4	Priority	int
3	Related Party Matched	Related Party Matched	Normal	Option	4	Related Party Matched	int
	Available options are: “Not Considered” “Fully” “Partially” “No”
4	Doc. No./Ext. Doc. No. Matched	Doc. No./Ext. Doc. No. Matched	Normal	Option	4	Doc_ No__Ext_ Doc_ No_ Matched	int
	Available options are: “Not Considered” “Yes” “No” “Yes – Multiple”
5	Amount Incl. Tolerance Matched	Amount Incl. Tolerance Matched	Normal	Option	4	Amount Incl_ Tolerance Matched	int
	Available options are: “Not Considered” “One Match” “Multiple Matches” “No Matches”
6	Direct Debit Collect. Matched	Direct Debit Collect. Matched	Normal	Option	4	Direct Debit Collect_ Matched	int
	Available options are: “Not Considered” “Yes” “No”
30	Score	Score	Normal	Integer	4	Score	int
40	Review Required	Review Required	Normal	Boolean	4	Review Required	tinyint
41	Apply Immediatelly	Apply Immediatelly	Normal	Boolean	4	Apply Immediatelly	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 [Bank Pmt. Appl. Rule].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Bank Pmt_ Appl_ Rule$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Pmt. Appl. Rule] LEFT JOIN [User] AS [User] ON [Bank Pmt. Appl. Rule].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Bank Pmt. Appl. Rule].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Bank Pmt_ Appl_ Rule$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Pmt. Appl. Rule] LEFT JOIN [User] AS [User] ON [Bank Pmt. Appl. Rule].[$systemModifiedBy] = [User].[User Security ID]