Acc_ 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: 0

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
   [timestamp]
   ,[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 columns in Acc_ Schedule Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Schedule Name Primary Key Searchnvarchar(20)
3Line No_ Primary Key Searchint
4Row No_ Searchnvarchar(20)
5Description Searchnvarchar(200)
6Totaling Searchnvarchar(500)
7Totaling Type Searchint
8New Page Searchtinyint
9Indentation Searchint
10Show Searchint
11Dimension 1 Totaling Searchnvarchar(500)
12Dimension 2 Totaling Searchnvarchar(500)
13Dimension 3 Totaling Searchnvarchar(500)
14Dimension 4 Totaling Searchnvarchar(500)
15Bold Searchtinyint
16Italic Searchtinyint
17Underline Searchtinyint
18Show Opposite Sign Searchtinyint
19Row Type Searchint
20Amount Type Searchint
21Double Underline Searchtinyint
22Hide Currency Symbol Searchtinyint
23Cost Center Totaling Searchnvarchar(160)
24Cost Object Totaling Searchnvarchar(160)
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *