Payment Method – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPayment 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	10	Code	nvarchar(20)
2	Description	Description	Normal	Text	100	Description	nvarchar(200)
3	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Bank Account”
4	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
6	Direct Debit	Direct Debit	Normal	Boolean	4	Direct Debit	tinyint
7	Direct Debit Pmt. Terms Code	Direct Debit Pmt. Terms Code	Normal	Code	10	Direct Debit Pmt_ Terms Code	nvarchar(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]
8	Pmt. Export Line Definition	Pmt. Export Line Definition	Normal	Code	20	Pmt_ Export Line Definition	nvarchar(40)
9	Bank Data Conversion Pmt. Type	Bank Data Conversion Pmt. Type	Normal	Text	50	Bank Data Conversion Pmt_ Type	nvarchar(100)
10	Use for Invoicing	Use for Invoicing	Normal	Boolean	4	Use for Invoicing	tinyint
11	Last Modified Date Time	Last Modified Date Time	Normal	DateTime	8	Last Modified Date Time	datetime
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
20100	AMC Bank Pmt. Type	Bank Pmt. Type	Normal	Text	50
27000	SAT Payment Method Code	SAT Payment Method Code	Normal	Code	20
27001	SAT Method of Payment	SAT Method of Payment	Normal	Code	10
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 [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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier