Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/6121
Table Type: Company
Table Name: E-Document
Database Table Name: CRONUS UK Ltd_$E-Document$e1d97edc-c239-46b4-8d84-6368bdf67c8b
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 E-Document can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$E-Document$e1d97edc-c239-46b4-8d84-6368bdf67c8b]Show/hide an example select of all columns by name
SELECT
FROM
[CRONUS UK Ltd_$E-Document$e1d97edc-c239-46b4-8d84-6368bdf67c8b]Show/hide columns in E-Document table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|