Credit 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Credit Transfer Register No_ Primary Key Searchint
3Entry No_ Primary Key Searchint
4Account Type Searchint
4Data Exch_ Entry No_ Searchint
5Account No_ Searchnvarchar(40)
5Pmt_ Disc_ Possible Searchdecimal(38,38)
6Applies-to Entry No_ Searchint
7Transfer Date Searchdatetime
8Currency Code Searchnvarchar(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]
9Transfer Amount Searchdecimal(38,38)
10Transaction ID Searchnvarchar(70)
11Recipient Bank Acc_ No_ Searchnvarchar(100)
12Message to Recipient Searchnvarchar(280)
13Recipient IBAN Searchnvarchar(100)
14Recipient Bank Account No_ Searchnvarchar(60)
15Recipient Name Searchnvarchar(200)
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Credit Transfer Entry table

Leave a Reply

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