Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/374
Table Type: Company
Table Name: G/L Acc. Budget Buffer
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 G/L Acc. Budget Buffer can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[]
Show/hide an example select of all columns by name
SELECT
[Code]
,[Income_Balance]
,[Account Category]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[] AS [G/L Acc. Budget Buffer]
LEFT JOIN
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
ON
[G/L Acc. Budget Buffer].[Budget Filter] = [G/L Budget Name].[Name]
LEFT JOIN
[CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
ON
[G/L Acc. Budget Buffer].[Business Unit Filter] = [Business Unit].[Code]
LEFT JOIN
[User] AS [User]
ON
[G/L Acc. Budget Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[G/L Acc. Budget Buffer].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in G/L Acc. Budget Buffer table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Code | Code | Normal | Code | 20 | Code | nvarchar(40) |
3 | Budget Filter | Budget Filter | FlowFilter | Code | 10 | ||
4 | G/L Account Filter | G/L Account Filter | FlowFilter | Code | 20 | ||
5 | Business Unit Filter | Business Unit Filter | FlowFilter | Code | 20 | ||
6 | Global Dimension 1 Filter | Global Dimension 1 Filter | FlowFilter | Code | 20 | ||
7 | Global Dimension 2 Filter | Global Dimension 2 Filter | FlowFilter | Code | 20 | ||
8 | Budget Dimension 1 Filter | Budget Dimension 1 Filter | FlowFilter | Code | 20 | ||
9 | Budget Dimension 2 Filter | Budget Dimension 2 Filter | FlowFilter | Code | 20 | ||
10 | Budget Dimension 3 Filter | Budget Dimension 3 Filter | FlowFilter | Code | 20 | ||
11 | Budget Dimension 4 Filter | Budget Dimension 4 Filter | FlowFilter | Code | 20 | ||
12 | Date Filter | Date Filter | FlowFilter | Date | 4 | ||
13 | Budgeted Amount | Budgeted Amount | FlowField | Decimal | 12 | ||
14 | Income/Balance | Income/Balance | Normal | Option | 4 | Income_Balance | int |
Available options are:
| |||||||
15 | Account Category | Account Category | Normal | Option | 4 | Account Category | int |
Available options are:
| |||||||
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 Acc. Budget Buffer].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[] AS [G/L Acc. Budget Buffer]
LEFT JOIN
[User] AS [User]
ON
[G/L Acc. Budget Buffer].[$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 Acc. Budget Buffer].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[] AS [G/L Acc. Budget Buffer]
LEFT JOIN
[User] AS [User]
ON
[G/L Acc. Budget Buffer].[$systemModifiedBy] = [User].[User Security ID] |