Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1205
Table Type: Company
Table Name: Credit Transfer Register
Database Table Name: CRONUS UK Ltd_$Credit Transfer Register$16319982-4995-4fb1-8fb2-2b1e13773e3b
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 Register can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Credit Transfer Register$16319982-4995-4fb1-8fb2-2b1e13773e3b]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[No_]
,[Data Exch_ Entry No_]
,[Identifier]
,[AMC Bank XTL Journal]
,[Created Date-Time]
,[Created by User]
,[Status]
,[From Bank Account No_]
,[Exported File]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Credit Transfer Register$16319982-4995-4fb1-8fb2-2b1e13773e3b]Show/hide columns in Credit Transfer Register table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | No_  | int |
| 3 | Data Exch_ Entry No_ | int |
| 3 | Identifier | nvarchar(40) |
| 4 | AMC Bank XTL Journal | nvarchar(500) |
| 4 | Created Date-Time | datetime |
| 5 | Created by User | nvarchar(100) |
| 6 | Status | int |
| 7 | From Bank Account No_ | nvarchar(40) |
| 8 | Exported File | image |
| 9 | $systemId | uniqueidentifier |
| 10 | $systemCreatedAt | datetime |
| 11 | $systemCreatedBy | uniqueidentifier |
| 12 | $systemModifiedAt | datetime |
| 13 | $systemModifiedBy | uniqueidentifier |