Payment Method

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

Table Type: Company

Table Name: Payment Method
Database Table Name: CRONUS UK Ltd_$Payment Method$16319982-4995-4fb1-8fb2-2b1e13773e3b

Table Number: 289

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 Payment Method can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Payment Method$16319982-4995-4fb1-8fb2-2b1e13773e3b]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[AMC Bank Pmt_ Type]
   ,[Description]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Direct Debit]
   ,[Direct Debit Pmt_ Terms Code]
   ,[Pmt_ Export Line Definition]
   ,[Bank Data Conversion Pmt_ Type]
   ,[Use for Invoicing]
   ,[Last Modified Date Time]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Payment Method$16319982-4995-4fb1-8fb2-2b1e13773e3b]

Show/hide columns in Payment Method table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3AMC Bank Pmt_ Type Searchnvarchar(100)
3Description Searchnvarchar(200)
4Bal_ Account Type Searchint
5Bal_ Account No_ Searchnvarchar(40)
6Direct Debit Searchtinyint
7Direct Debit Pmt_ Terms Code Searchnvarchar(20)
8Pmt_ Export Line Definition Searchnvarchar(40)
9Bank Data Conversion Pmt_ Type Searchnvarchar(100)
10Use for Invoicing Searchtinyint
11Last Modified Date Time Searchdatetime
12Id Searchuniqueidentifier
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Payment Method table

Leave a Reply

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