Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5261
Table Type: Company
Table Name: G/L Account Mapping Line
Database Table Name: CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada
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 Account Mapping Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada]
Show/hide an example select of all columns by name
SELECT
[G_L Account Mapping Code]
,[G_L Account No_]
,[Standard Account Type]
,[Standard Account Category No_]
,[Standard Account No_]
,[G_L Entries Exists]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
[User] AS [User]
ON
[G/L Account Mapping Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[G/L Account Mapping Line].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in G/L Account Mapping Line table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | G/L Account Mapping Code | G/L Account Mapping Code | Normal | Code | 20 | G_L Account Mapping Code | nvarchar(40) |
Key to join to the G/L Account Mapping Header table.Show/hide example querySELECT
[G/L Account Mapping Line].[G_L Account Mapping Code]
,[G/L Account Mapping Header].[Code]
FROM
[CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Header]
ON
[G/L Account Mapping Line].[G_L Account Mapping Code] = [G/L Account Mapping Header].[Code] | |||||||
2 | G/L Account No. | G/L Account No. | Normal | Code | 20 | G_L Account No_ | nvarchar(40) |
Key to join to the G/L Account table.Show/hide example querySELECT
[G/L Account Mapping Line].[G_L Account No_]
,[G/L Account].[No_]
FROM
[CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
[CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
ON
[G/L Account Mapping Line].[G_L Account No_] = [G/L Account].[No_] | |||||||
3 | Standard Account Type | Standard Account Type | Normal | Option | 4 | Standard Account Type | int |
Available options are:
| |||||||
4 | Standard Account Category No. | Standard Account Category No. | Normal | Code | 20 | Standard Account Category No_ | nvarchar(40) |
5 | Standard Account No. | Standard Account No. | Normal | Code | 20 | Standard Account No_ | nvarchar(40) |
6 | G/L Entries Exists | G/L Entries Exists | Normal | Boolean | 4 | G_L Entries Exists | tinyint |
50 | G/L Account Name | G/L Account Name | FlowField | Text | 100 | ||
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 Account Mapping Line].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
[User] AS [User]
ON
[G/L Account Mapping Line].[$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 Account Mapping Line].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
[User] AS [User]
ON
[G/L Account Mapping Line].[$systemModifiedBy] = [User].[User Security ID] |