Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/40900
Table Type: Company
Table Name: Hist. G/L Account
Database Table Name:
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 Hist. G/L Account can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[]
Show/hide an example select of all columns by name
SELECT
FROM
[]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[] AS [Hist. G/L Account]
LEFT JOIN
[User] AS [User]
ON
[Hist. G/L Account].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Hist. G/L Account].[SystemModifiedBy] = [User].[User Security ID]