Overdue Approval Entry

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

Table Type: Company

Table Name: Overdue Approval Entry
Database Table Name: CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 458

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 Overdue Approval Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Table ID]
   ,[Document Type]
   ,[Document No_]
   ,[Sequence No_]
   ,[Sent Date]
   ,[Sent Time]
   ,[Record ID to Approve]
   ,[Sent to ID]
   ,[E-Mail]
   ,[Sent to Name]
   ,[Due Date]
   ,[Approver ID]
   ,[Approval Code]
   ,[Approval Type]
   ,[Limit Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Overdue Approval Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Table ID Primary Key Searchint
3Document Type Primary Key Searchint
4Document No_ Primary Key Searchnvarchar(40)
5Sequence No_ Primary Key Searchint
6Sent Date Primary Key Searchdatetime
7Sent Time Primary Key Searchdatetime
8Record ID to Approve Primary Key Searchvarbinary(448)
9Sent to ID Searchnvarchar(100)
10E-Mail Searchnvarchar(200)
11Sent to Name Searchnvarchar(60)
12Due Date Searchdatetime
13Approver ID Searchnvarchar(100)
14Approval Code Searchnvarchar(40)
15Approval Type Searchint
16Limit Type Searchint
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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