Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/846
Table Type: Company
Table Name: Cash Flow Worksheet Line
Database Table Name: CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 846Due 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 Worksheet Line can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Line No_]
,[Cash Flow Forecast No_]
,[Cash Flow Date]
,[Document No_]
,[Cash Flow Account No_]
,[Source Type]
,[Description]
,[Document Type]
,[Document Date]
,[Pmt_ Discount Date]
,[Pmt_ Disc_ Tolerance Date]
,[Payment Terms Code]
,[Payment Discount]
,[Associated Entry No_]
,[Overdue]
,[Shortcut Dimension 2 Code]
,[Shortcut Dimension 1 Code]
,[Amount (LCY)]
,[Source No_]
,[G_L Budget Name]
,[Source Line No_]
,[Dimension Set ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
ON
[Cash Flow Worksheet Line].[Document Type] = [Sales Header Archive].[Document Type]
AND
[Cash Flow Worksheet Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
ON
[Cash Flow Worksheet Line].[Document Type] = [Sales Header].[Document Type]
AND
[Cash Flow Worksheet Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Cash Flow Worksheet Line].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Worksheet Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Worksheet Line].[Shortcut 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 Worksheet Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Worksheet Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Worksheet Line].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 2 | Line No.  | Line No. | Normal | Integer | 4 | Line No_ | int |
| 3 | 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 Worksheet Line].[Cash Flow Forecast No_]
,[Cash Flow Forecast].[No_]
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
[CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
ON
[Cash Flow Worksheet Line].[Cash Flow Forecast No_] = [Cash Flow Forecast].[No_] |
| 4 | Cash Flow Date | Cash Flow Date | Normal | Date | 4 | Cash Flow Date | datetime |
| 5 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
| 6 | 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 Worksheet Line].[Cash Flow Account No_]
,[Cash Flow Account].[No_]
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
[CRONUS UK Ltd_$Cash Flow Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Account]
ON
[Cash Flow Worksheet Line].[Cash Flow Account No_] = [Cash Flow Account].[No_] |
| 7 | 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”
|
| 8 | Description | Description | Normal | Text | 250 | Description | nvarchar(500) |
| 9 | Document Type | Document Type | Normal | Option | 4 | Document Type | int |
| Available options are:
- ” “
- “Payment”
- “Invoice”
- “Credit Memo”
- “Finance Charge Memo”
- “Reminder”
- “Refund”
|
| 10 | Document Date | Document Date | Normal | Date | 4 | Document Date | datetime |
| 11 | Pmt. Discount Date | Pmt. Discount Date | Normal | Date | 4 | Pmt_ Discount Date | datetime |
| 12 | Pmt. Disc. Tolerance Date | Pmt. Disc. Tolerance Date | Normal | Date | 4 | Pmt_ Disc_ Tolerance Date | datetime |
| 13 | Payment Terms Code | Payment Terms Code | Normal | Code | 10 | Payment Terms Code | nvarchar(20) |
| Key to join to the Payment Terms table.SELECT
[Cash Flow Worksheet Line].[Payment Terms Code]
,[Payment Terms].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Cash Flow Worksheet Line].[Payment Terms Code] = [Payment Terms].[Code] |
| 14 | Payment Discount | Payment Discount | Normal | Decimal | 12 | Payment Discount | decimal(38,38) |
| 15 | Associated Entry No. | Associated Entry No. | Normal | Integer | 4 | Associated Entry No_ | int |
| 16 | Overdue | Overdue | Normal | Boolean | 4 | Overdue | tinyint |
| 17 | Shortcut Dimension 2 Code | Shortcut Dimension 2 Code | Normal | Code | 20 | Shortcut Dimension 2 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Cash Flow Worksheet Line].[Shortcut Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Worksheet Line].[Shortcut Dimension 2 Code] = [Dimension].[Code] |
| 18 | Shortcut Dimension 1 Code | Shortcut Dimension 1 Code | Normal | Code | 20 | Shortcut Dimension 1 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[Cash Flow Worksheet Line].[Shortcut Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Cash Flow Worksheet Line].[Shortcut Dimension 1 Code] = [Dimension].[Code] |
| 30 | Amount (LCY) | Amount ($) | Normal | Decimal | 12 | Amount (LCY) | decimal(38,38) |
| 34 | 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 Worksheet Line].[Dimension Set ID]
,[Dimension Set Entry].[Dimension Set ID]
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
[CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
ON
[Cash Flow Worksheet Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID] |
| 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 Worksheet Line].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cash Flow Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Worksheet Line]
LEFT JOIN
[User] AS [User]
ON
[Cash Flow Worksheet Line].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
