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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext

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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

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

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

Show/hide columns in Payment Method table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Bank Account”
4Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
6Direct Debit SearchDirect DebitNormalBoolean4Direct Debittinyint
7Direct Debit Pmt. Terms Code SearchDirect Debit Pmt. Terms CodeNormalCode10Direct Debit Pmt_ Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Payment Method].[Direct Debit Pmt_ Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Payment Method].[Direct Debit Pmt_ Terms Code] = [Payment Terms].[Code]
8Pmt. Export Line Definition SearchPmt. Export Line DefinitionNormalCode20Pmt_ Export Line Definitionnvarchar(40)
9Bank Data Conversion Pmt. Type SearchBank Data Conversion Pmt. TypeNormalText50Bank Data Conversion Pmt_ Typenvarchar(100)
10Use for Invoicing SearchUse for InvoicingNormalBoolean4Use for Invoicingtinyint
11Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
8000Id SearchIdNormalGUID16Iduniqueidentifier
20100AMC Bank Pmt. Type SearchBank Pmt. TypeNormalText50
27000SAT Payment Method Code SearchSAT Payment Method CodeNormalCode20
27001SAT Method of Payment SearchSAT Method of PaymentNormalCode10
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
       [Payment Method].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
LEFT JOIN
       [User] AS [User]
              ON
                     [Payment Method].[$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
       [Payment Method].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
LEFT JOIN
       [User] AS [User]
              ON
                     [Payment Method].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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