Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5823
Table Type: Company
Table Name: G_L – Item Ledger Relation
Database Table Name: CRONUS UK Ltd_$G_L – Item Ledger Relation$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 G_L – Item Ledger Relation can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
FROM
[CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in G_L – Item Ledger Relation table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | G_L Entry No_  | int |
| 3 | Value Entry No_ | int |
| 4 | G_L Register No_ | int |
| 5 | $systemId | uniqueidentifier |
| 6 | $systemCreatedAt | datetime |
| 7 | $systemCreatedBy | uniqueidentifier |
| 8 | $systemModifiedAt | datetime |
| 9 | $systemModifiedBy | uniqueidentifier |