Bank Pmt_ Appl_ Settings

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

Table Type: Company

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

Table Number: 1253

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_ Settings can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bank Pmt_ Appl_ Settings$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[PrimaryKey]
   ,[Vendor Ledger Entries Matching]
   ,[Cust_ Ledger Entries Matching]
   ,[Bank Ledger Entries Matching]
   ,[RelatedParty Name Matching]
   ,[Bank Ledg Closing Doc No Match]
   ,[Apply Man_ Disable Suggestions]
   ,[Enable Apply Immediatelly]
   ,[Empl_ Ledger Entries Matching]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Bank Pmt_ Appl_ Settings$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Bank Pmt_ Appl_ Settings table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2PrimaryKey Primary Key Searchnvarchar(40)
3Vendor Ledger Entries Matching Searchtinyint
4Cust_ Ledger Entries Matching Searchtinyint
5Bank Ledger Entries Matching Searchtinyint
6RelatedParty Name Matching Searchint
7Bank Ledg Closing Doc No Match Searchtinyint
8Apply Man_ Disable Suggestions Searchtinyint
9Enable Apply Immediatelly Searchtinyint
10Empl_ Ledger Entries Matching Searchtinyint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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