Posted Approval Entry

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

Table Type: Company

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

Table Number: 456

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Table ID]
   ,[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 ID]
   ,[Due Date]
   ,[Amount]
   ,[Amount (LCY)]
   ,[Currency Code]
   ,[Approval Type]
   ,[Limit Type]
   ,[Available Credit Limit (LCY)]
   ,[Posted Record ID]
   ,[Delegation Date Formula]
   ,[Number of Approved Requests]
   ,[Number of Rejected Requests]
   ,[Iteration No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Posted 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_$Posted Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Approval Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Posted Approval Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Posted Approval Entry table

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

Show/hide example query

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

Show/hide tables related from Posted Approval Entry table

Leave a Reply

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