Credit Transfer Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCredit Transfer Entry

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

Table Type: Company

Table Name: Credit Transfer Entry
Database Table Name: CRONUS UK Ltd_$Credit Transfer Entry$16319982-4995-4fb1-8fb2-2b1e13773e3b

Table Number: 1206

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 Credit Transfer Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Credit Transfer Entry$16319982-4995-4fb1-8fb2-2b1e13773e3b]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Credit Transfer Register No_]
   ,[Entry No_]
   ,[Account Type]
   ,[Data Exch_ Entry No_]
   ,[Pmt_ Disc_ Possible]
   ,[Account No_]
   ,[Applies-to Entry No_]
   ,[Transfer Date]
   ,[Currency Code]
   ,[Transfer Amount]
   ,[Transaction ID]
   ,[Recipient Bank Acc_ No_]
   ,[Message to Recipient]
   ,[Recipient IBAN]
   ,[Recipient Bank Account No_]
   ,[Recipient Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Credit Transfer Entry$16319982-4995-4fb1-8fb2-2b1e13773e3b]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Credit Transfer Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Credit Transfer Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Credit Transfer Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Credit Transfer Entry table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Credit Transfer Register No_	int
3	Entry No_	int
4	Account Type	int
4	Data Exch_ Entry No_	int
5	Account No_	nvarchar(40)
5	Pmt_ Disc_ Possible	decimal(38,38)
6	Applies-to Entry No_	int
7	Transfer Date	datetime
8	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Credit Transfer Entry].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Credit Transfer Entry$16319982-4995-4fb1-8fb2-2b1e13773e3b] AS [Credit Transfer Entry] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Credit Transfer Entry].[Currency Code] = [Currency].[Code]
9	Transfer Amount	decimal(38,38)
10	Transaction ID	nvarchar(70)
11	Recipient Bank Acc_ No_	nvarchar(100)
12	Message to Recipient	nvarchar(280)
13	Recipient IBAN	nvarchar(100)
14	Recipient Bank Account No_	nvarchar(60)
15	Recipient Name	nvarchar(200)
16	$systemId	uniqueidentifier
17	$systemCreatedAt	datetime
18	$systemCreatedBy	uniqueidentifier
19	$systemModifiedAt	datetime
20	$systemModifiedBy	uniqueidentifier