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
[timestamp]
,[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 columns in Cash Flow Forecast table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | No_  | nvarchar(40) |
| 3 | Search Name | nvarchar(200) |
| 4 | Description | nvarchar(200) |
| 5 | Description 2 | nvarchar(100) |
| 6 | Consider Discount | tinyint |
| 7 | Creation Date | datetime |
| 8 | Created By | nvarchar(100) |
| 9 | Manual Payments To | datetime |
| 10 | No_ Series | nvarchar(40) |
| 11 | Manual Payments From | datetime |
| 12 | G_L Budget From | datetime |
| 13 | G_L Budget To | datetime |
| 14 | Consider CF Payment Terms | tinyint |
| 15 | Consider Pmt_ Disc_ Tol_ Date | tinyint |
| 16 | Consider Pmt_ Tol_ Amount | tinyint |
| 17 | Overdue CF Dates to Work Date | tinyint |
| 18 | Default G_L Budget Name | nvarchar(20) |
| 19 | $systemId | uniqueidentifier |
| 20 | $systemCreatedAt | datetime |
| 21 | $systemCreatedBy | uniqueidentifier |
| 22 | $systemModifiedAt | datetime |
| 23 | $systemModifiedBy | uniqueidentifier |