Account Schedules Chart Setup

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

Table Type: Company

Table Name: Account Schedules Chart Setup
Database Table Name: CRONUS UK Ltd_$Account Schedules Chart Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 762

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 Account Schedules Chart Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Account Schedules Chart Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User ID]
   ,[Name]
   ,[Description]
   ,[Account Schedule Name]
   ,[Column Layout Name]
   ,[Base X-Axis on]
   ,[Start Date]
   ,[End Date]
   ,[Period Length]
   ,[No_ of Periods]
   ,[Last Viewed]
   ,[Look Ahead]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Account Schedules Chart Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Account Schedules Chart Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchnvarchar(264)
3Name Primary Key Searchnvarchar(60)
4Description Searchnvarchar(500)
5Account Schedule Name Searchnvarchar(20)
6Column Layout Name Searchnvarchar(20)
7Base X-Axis on Searchint
8Start Date Searchdatetime
9End Date Searchdatetime
10Period Length Searchint
11No_ of Periods Searchint
12Last Viewed Searchtinyint
13Look Ahead Searchtinyint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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