Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/847
Table Type: Company
Table Name: Cash Flow Forecast Entry
Database Table Name: CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 847Due 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 Entry can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Entry No_]
,[User ID]
,[Cash Flow Forecast No_]
,[Cash Flow Date]
,[Document No_]
,[Cash Flow Account No_]
,[Source Type]
,[Description]
,[Overdue]
,[Document Date]
,[Payment Discount]
,[Associated Entry No_]
,[Associated Document No_]
,[Global Dimension 2 Code]
,[Global Dimension 1 Code]
,[Recurring Method]
,[Amount (LCY)]
,[Positive]
,[Source No_]
,[G_L Budget Name]
,[Source Line No_]
,[Dimension Set ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Cash Flow Forecast Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast Entry].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Entry No.  | Entry No. | Normal | Integer | 4 | Entry No_ | int |
| 2 | User ID  | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
| 10 | Cash Flow Forecast No. | Cash Flow Forecast No. | Normal | Code | 20 | Cash Flow Forecast No_ | nvarchar(40) |
| Key to join to the Cash Flow Forecast table.SELECT
[Cash Flow Forecast Entry].[Cash Flow Forecast No_]
,[Cash Flow Forecast].[No_]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
ON
[Cash Flow Forecast Entry].[Cash Flow Forecast No_] = [Cash Flow Forecast].[No_] |
| 11 | Cash Flow Date | Cash Flow Date | Normal | Date | 4 | Cash Flow Date | datetime |
| 12 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
| 13 | Cash Flow Account No. | Cash Flow Account No. | Normal | Code | 20 | Cash Flow Account No_ | nvarchar(40) |
| Key to join to the Cash Flow Account table.SELECT
[Cash Flow Forecast Entry].[Cash Flow Account No_]
,[Cash Flow Account].[No_]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
ON
[Cash Flow Forecast Entry].[Cash Flow Account No_] = [Cash Flow Account].[No_] |
| 14 | Source Type | Source Type | Normal | Option | 4 | Source Type | int |
| Available options are:
- ” “
- “Receivables”
- “Payables”
- “Liquid Funds”
- “Cash Flow Manual Expense”
- “Cash Flow Manual Revenue”
- “Sales Orders”
- “Purchase Orders”
- “Fixed Assets Budget”
- “Fixed Assets Disposal”
- “Service Orders”
- “G/L Budget”
- “Job”
- “Tax”
- “Azure AI”
|
| 15 | Description | Description | Normal | Text | 250 | Description | nvarchar(500) |
| 16 | Overdue | Overdue | Normal | Boolean | 4 | Overdue | tinyint |
| 17 | Document Date | Document Date | Normal | Date | 4 | Document Date | datetime |
| 21 | Payment Discount | Payment Discount | Normal | Decimal | 12 | Payment Discount | decimal(38,38) |
| 22 | Associated Entry No. | Associated Entry No. | Normal | Integer | 4 | Associated Entry No_ | int |
| 23 | Associated Document No. | Associated Document No. | Normal | Code | 20 | Associated Document No_ | nvarchar(40) |
| 24 | Global Dimension 2 Code | Global Dimension 2 Code | Normal | Code | 20 | Global Dimension 2 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Cash Flow Forecast Entry].[Global Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Global Dimension 2 Code] = [Dimension].[Code] |
| 25 | Global Dimension 1 Code | Global Dimension 1 Code | Normal | Code | 20 | Global Dimension 1 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Cash Flow Forecast Entry].[Global Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[Global Dimension 1 Code] = [Dimension].[Code] |
| 26 | Recurring Method | Recurring Method | Normal | Option | 4 | Recurring Method | int |
| Available options are:
|
| 29 | Amount (LCY) | Amount ($) | Normal | Decimal | 12 | Amount (LCY) | decimal(38,38) |
| 30 | Positive | Positive | Normal | Boolean | 4 | Positive | tinyint |
| 33 | Source No. | Source No. | Normal | Code | 20 | Source No_ | nvarchar(40) |
| 35 | G/L Budget Name | G/L Budget Name | Normal | Code | 10 | G_L Budget Name | nvarchar(20) |
| 36 | Source Line No. | Source Line No. | Normal | Integer | 4 | Source Line No_ | int |
| 480 | Dimension Set ID | Dimension Set ID | Normal | Integer | 4 | Dimension Set ID | int |
| Key to join to the Dimension Set Entry table.SELECT
[Cash Flow Forecast Entry].[Dimension Set ID]
,[Dimension Set Entry].[Dimension Set ID]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Cash Flow Forecast Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID] |
| 481 | Shortcut Dimension 3 Code | Shortcut Dimension 3 Code | FlowField | Code | 20 | | |
| Key to join to the Dimension table.SELECT
[Cash Flow Forecast Entry].[]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[] = [Dimension].[Code] |
| 482 | Shortcut Dimension 4 Code | Shortcut Dimension 4 Code | FlowField | Code | 20 | | |
| Key to join to the Dimension table.SELECT
[Cash Flow Forecast Entry].[]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[] = [Dimension].[Code] |
| 483 | Shortcut Dimension 5 Code | Shortcut Dimension 5 Code | FlowField | Code | 20 | | |
| Key to join to the Dimension table.SELECT
[Cash Flow Forecast Entry].[]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[] = [Dimension].[Code] |
| 484 | Shortcut Dimension 6 Code | Shortcut Dimension 6 Code | FlowField | Code | 20 | | |
| Key to join to the Dimension table.SELECT
[Cash Flow Forecast Entry].[]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[] = [Dimension].[Code] |
| 485 | Shortcut Dimension 7 Code | Shortcut Dimension 7 Code | FlowField | Code | 20 | | |
| Key to join to the Dimension table.SELECT
[Cash Flow Forecast Entry].[]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[] = [Dimension].[Code] |
| 486 | Shortcut Dimension 8 Code | Shortcut Dimension 8 Code | FlowField | Code | 20 | | |
| Key to join to the Dimension table.SELECT
[Cash Flow Forecast Entry].[]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Forecast Entry].[] = [Dimension].[Code] |
| 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.SELECT
[Cash Flow Forecast Entry].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cash Flow Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast Entry]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Forecast Entry].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
