Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2711
Table Type: Company
Table Name: Bank Acc_ Rec_ Match Buffer
Database Table Name: CRONUS UK Ltd_$Bank Acc_ Rec_ Match Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Bank Acc_ Rec_ Match Buffer can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Bank Acc_ Rec_ Match Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Statement No_]
,[Statement Line No_]
,[Bank Account No_]
,[Match ID]
,[Ledger Entry No_]
,[Is Processed]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Bank Acc_ Rec_ Match Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Bank Acc_ Rec_ Match Buffer table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Statement No_  | nvarchar(40) |
| 3 | Statement Line No_ | int |
| 4 | Bank Account No_ | nvarchar(40) |
| 5 | Match ID | int |
| 6 | Ledger Entry No_ | int |
| 7 | Is Processed | tinyint |
| 8 | $systemId | uniqueidentifier |
| 9 | $systemCreatedAt | datetime |
| 10 | $systemCreatedBy | uniqueidentifier |
| 11 | $systemModifiedAt | datetime |
| 12 | $systemModifiedBy | uniqueidentifier |