Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1200
Table Type: Company
Table Name: Bank Export_Import Setup
Database Table Name: CRONUS UK Ltd_$Bank Export_Import Setup$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 Export_Import Setup can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Code]
,[Name]
,[Direction]
,[Processing Codeunit ID]
,[Processing XMLport ID]
,[Data Exch_ Def_ Code]
,[Preserve Non-Latin Characters]
,[Check Export Codeunit]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Bank Export_Import Setup table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Code  | nvarchar(40) |
| 3 | Name | nvarchar(200) |
| 4 | Direction | int |
| 5 | Processing Codeunit ID | int |
| 6 | Processing XMLport ID | int |
| 7 | Data Exch_ Def_ Code | nvarchar(40) |
| 8 | Preserve Non-Latin Characters | tinyint |
| 9 | Check Export Codeunit | int |
| 10 | $systemId | uniqueidentifier |
| 11 | $systemCreatedAt | datetime |
| 12 | $systemCreatedBy | uniqueidentifier |
| 13 | $systemModifiedAt | datetime |
| 14 | $systemModifiedBy | uniqueidentifier |