Acc. Schedule Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAcc. Schedule Line

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/85

Table Type: Company

Table Name: Acc. Schedule Line
Database Table Name: CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 85

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 Acc. Schedule Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Schedule Name]
   ,[Line No_]
   ,[Row No_]
   ,[Description]
   ,[Totaling]
   ,[Totaling Type]
   ,[New Page]
   ,[Indentation]
   ,[Show]
   ,[Dimension 1 Totaling]
   ,[Dimension 2 Totaling]
   ,[Dimension 3 Totaling]
   ,[Dimension 4 Totaling]
   ,[Bold]
   ,[Italic]
   ,[Underline]
   ,[Show Opposite Sign]
   ,[Row Type]
   ,[Amount Type]
   ,[Double Underline]
   ,[Hide Currency Symbol]
   ,[Cost Center Totaling]
   ,[Cost Object Totaling]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Line]
LEFT JOIN
   [CRONUS UK Ltd_$Acc_ Schedule Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Name]
      ON
         [Acc. Schedule Line].[Schedule Name] = [Acc. Schedule Name].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
      ON
         [Acc. Schedule Line].[Business Unit Filter] = [Business Unit].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
      ON
         [Acc. Schedule Line].[Cash Flow Forecast Filter] = [Cash Flow Forecast].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Acc. Schedule Line].[Cost Center Filter] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Acc. Schedule Line].[Cost Object Filter] = [Cost Object].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Name]
      ON
         [Acc. Schedule Line].[Cost Budget Filter] = [Cost Budget Name].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Acc. Schedule Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Acc. Schedule Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Acc. Schedule Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Schedule Name	Schedule Name	Normal	Code	10	Schedule Name	nvarchar(20)
	Key to join to the Acc. Schedule Name table. Show/hide example query SELECT [Acc. Schedule Line].[Schedule Name] ,[Acc. Schedule Name].[Name] FROM [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Line] LEFT JOIN [CRONUS UK Ltd_$Acc_ Schedule Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Name] ON [Acc. Schedule Line].[Schedule Name] = [Acc. Schedule Name].[Name]
2	Line No.	Line No.	Normal	Integer	4	Line No_	int
3	Row No.	Row No.	Normal	Code	10	Row No_	nvarchar(20)
4	Description	Description	Normal	Text	100	Description	nvarchar(200)
5	Totaling	Totaling	Normal	Text	250	Totaling	nvarchar(500)
6	Totaling Type	Totaling Type	Normal	Option	4	Totaling Type	int
	Available options are: “Posting Accounts” “Total Accounts” “Formula” “Underline” “Double Underline” “Set Base For Percent” “Cost Type” “Cost Type Total” “Cash Flow Entry Accounts” “Cash Flow Total Accounts” “Account Category” “Statistical Account”
7	New Page	New Page	Normal	Boolean	4	New Page	tinyint
8	Indentation	Indentation	Normal	Integer	4	Indentation	int
11	Date Filter	Date Filter	FlowFilter	Date	4
12	Dimension 1 Filter	Dimension 1 Filter	FlowFilter	Code	20
13	Dimension 2 Filter	Dimension 2 Filter	FlowFilter	Code	20
14	G/L Budget Filter	G/L Budget Filter	FlowFilter	Code	10
15	Business Unit Filter	Business Unit Filter	FlowFilter	Code	20
	Key to join to the Business Unit table. Show/hide example query SELECT [Acc. Schedule Line].[] ,[Business Unit].[Code] FROM [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Line] LEFT JOIN [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] ON [Acc. Schedule Line].[] = [Business Unit].[Code]
16	Show	Show	Normal	Option	4	Show	int
	Available options are: “Yes” “No” “If Any Column Not Zero” “When Positive Balance” “When Negative Balance”
17	Dimension 3 Filter	Dimension 3 Filter	FlowFilter	Code	20
18	Dimension 4 Filter	Dimension 4 Filter	FlowFilter	Code	20
19	Dimension 1 Totaling	Dimension 1 Totaling	Normal	Text	250	Dimension 1 Totaling	nvarchar(500)
20	Dimension 2 Totaling	Dimension 2 Totaling	Normal	Text	250	Dimension 2 Totaling	nvarchar(500)
21	Dimension 3 Totaling	Dimension 3 Totaling	Normal	Text	250	Dimension 3 Totaling	nvarchar(500)
22	Dimension 4 Totaling	Dimension 4 Totaling	Normal	Text	250	Dimension 4 Totaling	nvarchar(500)
23	Bold	Bold	Normal	Boolean	4	Bold	tinyint
24	Italic	Italic	Normal	Boolean	4	Italic	tinyint
25	Underline	Underline	Normal	Boolean	4	Underline	tinyint
26	Show Opposite Sign	Show Opposite Sign	Normal	Boolean	4	Show Opposite Sign	tinyint
27	Row Type	Row Type	Normal	Option	4	Row Type	int
	Available options are: “Net Change” “Balance at Date” “Beginning Balance”
28	Amount Type	Amount Type	Normal	Option	4	Amount Type	int
	Available options are: “Net Amount” “Debit Amount” “Credit Amount”
30	Double Underline	Double Underline	Normal	Boolean	4	Double Underline	tinyint
40	Hide Currency Symbol	Hide Currency Symbol	Normal	Boolean	4	Hide Currency Symbol	tinyint
840	Cash Flow Forecast Filter	Cash Flow Forecast Filter	FlowFilter	Code	20
	Key to join to the Cash Flow Forecast table. Show/hide example query SELECT [Acc. Schedule Line].[] ,[Cash Flow Forecast].[No_] FROM [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Line] LEFT JOIN [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast] ON [Acc. Schedule Line].[] = [Cash Flow Forecast].[No_]
1100	Cost Center Filter	Cost Center Filter	FlowFilter	Code	20
	Key to join to the Cost Center table. Show/hide example query SELECT [Acc. Schedule Line].[] ,[Cost Center].[Code] FROM [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Line] LEFT JOIN [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center] ON [Acc. Schedule Line].[] = [Cost Center].[Code]
1101	Cost Object Filter	Cost Object Filter	FlowFilter	Code	20
	Key to join to the Cost Object table. Show/hide example query SELECT [Acc. Schedule Line].[] ,[Cost Object].[Code] FROM [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Line] LEFT JOIN [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object] ON [Acc. Schedule Line].[] = [Cost Object].[Code]
1102	Cost Center Totaling	Cost Center Totaling	Normal	Text	80	Cost Center Totaling	nvarchar(160)
1103	Cost Object Totaling	Cost Object Totaling	Normal	Text	80	Cost Object Totaling	nvarchar(160)
1104	Cost Budget Filter	Cost Budget Filter	FlowFilter	Code	10
	Key to join to the Cost Budget Name table. Show/hide example query SELECT [Acc. Schedule Line].[] ,[Cost Budget Name].[Name] FROM [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Line] LEFT JOIN [CRONUS UK Ltd_$Cost Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Name] ON [Acc. Schedule Line].[] = [Cost 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 query SELECT [Acc. Schedule Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Acc_ Schedule Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Line] LEFT JOIN [User] AS [User] ON [Acc. Schedule Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables AAcc. Schedule Line

Leave a Reply Cancel reply