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]Show/hide columns in Hist. G/L Account table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Primary Key  | Primary Key | Normal | Integer | 4 | ||
| 2 | No.  | No. | Normal | Code | 130 | ||
| 3 | Name | Name | Normal | Text | 100 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | ||
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | ||
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | ||
Key to join to the User table.Show/hide example querySELECT [Hist. G/L Account].[] ,[User].[User Security ID] FROM [] AS [Hist. G/L Account] LEFT JOIN [User] AS [User] ON [Hist. G/L Account].[] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | ||
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | ||