No_ Series Line

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

Table Type: Company

Table Name: No_ Series Line
Database Table Name: CRONUS UK Ltd_$No_ Series 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 No_ Series Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$No_ Series Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Series Code]
   ,[Line No_]
   ,[Starting Date]
   ,[Starting No_]
   ,[Ending No_]
   ,[Warning No_]
   ,[Increment-by No_]
   ,[Last No_ Used]
   ,[Open]
   ,[Last Date Used]
   ,[Allow Gaps in Nos_]
   ,[Sequence Name]
   ,[Starting Sequence No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$No_ Series Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in No_ Series Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Series Code Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Starting Date Searchdatetime
5Starting No_ Searchnvarchar(40)
6Ending No_ Searchnvarchar(40)
7Warning No_ Searchnvarchar(40)
8Increment-by No_ Searchint
9Last No_ Used Searchnvarchar(40)
10Open Searchtinyint
11Last Date Used Searchdatetime
12Allow Gaps in Nos_ Searchtinyint
13Sequence Name Searchnvarchar(80)
14Starting Sequence No_ Searchbigint
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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