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 an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation]
LEFT JOIN
[User] AS [User]
ON
[G/L - Item Ledger Relation].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[G/L - Item Ledger Relation].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in G/L – Item Ledger Relation table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | G/L Entry No.   | G/L Entry No. | Normal | Integer | 4 | G_L Entry No_ | int |
Key to join to the G/L Entry table.Show/hide example querySELECT
[G/L - Item Ledger Relation].[G_L Entry No_]
,[G/L Entry].[Entry No_]
FROM
[CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation]
LEFT JOIN
[CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
ON
[G/L - Item Ledger Relation].[G_L Entry No_] = [G/L Entry].[Entry No_] | |||||||
| 2 | Value Entry No. | Value Entry No. | Normal | Integer | 4 | Value Entry No_ | int |
Key to join to the Value Entry table.Show/hide example querySELECT
[G/L - Item Ledger Relation].[Value Entry No_]
,[Value Entry].[Entry No_]
FROM
[CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation]
LEFT JOIN
[CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
ON
[G/L - Item Ledger Relation].[Value Entry No_] = [Value Entry].[Entry No_] | |||||||
| 3 | G/L Register No. | G/L Register No. | Normal | Integer | 4 | G_L Register No_ | int |
Key to join to the G/L Register table.Show/hide example querySELECT
[G/L - Item Ledger Relation].[G_L Register No_]
,[G/L Register].[No_]
FROM
[CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation]
LEFT JOIN
[CRONUS UK Ltd_$G_L Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Register]
ON
[G/L - Item Ledger Relation].[G_L Register No_] = [G/L Register].[No_] | |||||||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[G/L - Item Ledger Relation].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation]
LEFT JOIN
[User] AS [User]
ON
[G/L - Item Ledger Relation].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[G/L - Item Ledger Relation].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$G_L - Item Ledger Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L - Item Ledger Relation]
LEFT JOIN
[User] AS [User]
ON
[G/L - Item Ledger Relation].[$systemModifiedBy] = [User].[User Security ID] | |||||||