Approval Entry

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

Table Type: Company

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

Table Number: 454

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Table ID]
   ,[Document Type]
   ,[Document No_]
   ,[Sequence No_]
   ,[Approval Code]
   ,[Sender ID]
   ,[Salespers__Purch_ Code]
   ,[Approver ID]
   ,[Status]
   ,[Date-Time Sent for Approval]
   ,[Last Date-Time Modified]
   ,[Last Modified By User ID]
   ,[Due Date]
   ,[Amount]
   ,[Amount (LCY)]
   ,[Currency Code]
   ,[Approval Type]
   ,[Limit Type]
   ,[Available Credit Limit (LCY)]
   ,[Record ID to Approve]
   ,[Delegation Date Formula]
   ,[Workflow Step Instance ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Approval Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Approval Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Table ID Searchint
4Document Type Searchint
5Document No_ Searchnvarchar(40)
6Sequence No_ Searchint
7Approval Code Searchnvarchar(40)
8Sender ID Searchnvarchar(100)
9Salespers__Purch_ Code Searchnvarchar(40)
10Approver ID Searchnvarchar(100)
11Status Searchint
12Date-Time Sent for Approval Searchdatetime
13Last Date-Time Modified Searchdatetime
14Last Modified By User ID Searchnvarchar(100)
15Due Date Searchdatetime
16Amount Searchdecimal(38,38)
17Amount (LCY) Searchdecimal(38,38)
18Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Approval Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Approval Entry].[Currency Code] = [Currency].[Code]
19Approval Type Searchint
20Limit Type Searchint
21Available Credit Limit (LCY) Searchdecimal(38,38)
22Record ID to Approve Searchvarbinary(448)
23Delegation Date Formula Searchvarchar(32)
24Workflow Step Instance ID Searchuniqueidentifier
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Approval Entry table

Leave a Reply

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