Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/840
Table Type: Company
Table Name: Cash Flow Forecast
Database Table Name: CRONUS UK Ltd_$Cash Flow Forecast$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 Cash Flow Forecast can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[No_]
,[Search Name]
,[Description]
,[Description 2]
,[Consider Discount]
,[Creation Date]
,[Created By]
,[Manual Payments To]
,[No_ Series]
,[Manual Payments From]
,[G_L Budget From]
,[G_L Budget To]
,[Consider CF Payment Terms]
,[Consider Pmt_ Disc_ Tol_ Date]
,[Consider Pmt_ Tol_ Amount]
,[Overdue CF Dates to Work Date]
,[Default G_L Budget Name]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast].[Created By] = [User].[User Name]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Cash Flow Forecast table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | No.   | No. | Normal | Code | 20 | No_ | nvarchar(40) |
| 2 | Search Name | Search Name | Normal | Code | 100 | Search Name | nvarchar(200) |
| 3 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 4 | Description 2 | Description 2 | Normal | Text | 50 | Description 2 | nvarchar(100) |
| 5 | Consider Discount | Consider Discount | Normal | Boolean | 4 | Consider Discount | tinyint |
| 6 | Creation Date | Creation Date | Normal | Date | 4 | Creation Date | datetime |
| 7 | Created By | Created By | Normal | Code | 50 | Created By | nvarchar(100) |
Key to join to the User table.Show/hide example querySELECT
[Cash Flow Forecast].[Created By]
,[User].[User Name]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast].[Created By] = [User].[User Name] | |||||||
| 8 | Manual Payments To | Manual Payments To | Normal | Date | 4 | Manual Payments To | datetime |
| 9 | Comment | Comment | FlowField | Boolean | 4 | ||
| 10 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[Cash Flow Forecast].[No_ Series]
,[No. Series].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
LEFT JOIN
[CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
ON
[Cash Flow Forecast].[No_ Series] = [No. Series].[Code] | |||||||
| 11 | Manual Payments From | Manual Payments From | Normal | Date | 4 | Manual Payments From | datetime |
| 12 | G/L Budget From | G/L Budget From | Normal | Date | 4 | G_L Budget From | datetime |
| 13 | G/L Budget To | G/L Budget To | Normal | Date | 4 | G_L Budget To | datetime |
| 14 | Consider CF Payment Terms | Consider CF Payment Terms | Normal | Boolean | 4 | Consider CF Payment Terms | tinyint |
| 15 | Consider Pmt. Disc. Tol. Date | Consider Pmt. Disc. Tol. Date | Normal | Boolean | 4 | Consider Pmt_ Disc_ Tol_ Date | tinyint |
| 16 | Consider Pmt. Tol. Amount | Consider Pmt. Tol. Amount | Normal | Boolean | 4 | Consider Pmt_ Tol_ Amount | tinyint |
| 17 | Account No. Filter | Account No. Filter | FlowFilter | Code | 20 | ||
| 18 | Source Type Filter | Source Type Filter | FlowFilter | Option | 4 | ||
| 19 | Cash Flow Date Filter | Cash Flow Date Filter | FlowFilter | Date | 4 | ||
| 20 | Amount (LCY) | Amount ($) | FlowField | Decimal | 12 | ||
| 21 | Positive Filter | Positive Filter | FlowFilter | Boolean | 4 | ||
| 22 | Overdue CF Dates to Work Date | Overdue CF Dates to Work Date | Normal | Boolean | 4 | Overdue CF Dates to Work Date | tinyint |
| 23 | Default G/L Budget Name | Default G/L Budget Name | Normal | Code | 10 | Default G_L Budget Name | nvarchar(20) |
Key to join to the G/L Budget Name table.Show/hide example querySELECT
[Cash Flow Forecast].[Default G_L Budget Name]
,[G/L Budget Name].[Name]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
LEFT JOIN
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
ON
[Cash Flow Forecast].[Default G_L Budget Name] = [G/L Budget Name].[Name] | |||||||
| 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
[Cash Flow Forecast].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast].[$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
[Cash Flow Forecast].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast].[$systemModifiedBy] = [User].[User Security ID] | |||||||