Posted Approval Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesPPosted 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

   [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_]
   ,[Entry 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_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
      ON
         [Posted Approval Entry].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Approval Entry].[Sender ID] = [User].[User Name]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Posted Approval Entry].[Approver ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Approval Entry].[Last Modified By ID] = [User].[User Name]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Posted Approval Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Approval Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Posted Approval Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Posted Approval Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Table ID SearchTable IDNormalInteger4Table IDint
Key to join to the Data Exch. Mapping table.

Show/hide example query

SELECT
       [Posted Approval Entry].[Table ID]
       ,[Data Exch. Mapping].[Table ID]
FROM
       [CRONUS UK Ltd_$Posted Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Approval Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
              ON
                     [Posted Approval Entry].[Table ID] = [Data Exch. Mapping].[Table ID]
3Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
4Sequence No. SearchSequence No.NormalInteger4Sequence No_int
5Approval Code SearchApproval CodeNormalCode20Approval Codenvarchar(40)
6Sender ID SearchSender IDNormalCode50Sender IDnvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
       [Posted Approval Entry].[Sender ID]
       ,[User].[User Name]
FROM
       [CRONUS UK Ltd_$Posted Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Approval Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Approval Entry].[Sender ID] = [User].[User Name]
7Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Posted Approval Entry].[Salespers__Purch_ Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Posted Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Approval Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Posted Approval Entry].[Salespers__Purch_ Code] = [Salesperson/Purchaser].[Code]
8Approver ID SearchApprover IDNormalCode50Approver IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Posted Approval Entry].[Approver ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Posted Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Approval Entry]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Posted Approval Entry].[Approver ID] = [User Setup].[User ID]
9Status SearchStatusNormalOption4Statusint
Available options are:
  • “Created”
  • “Open”
  • “Canceled”
  • “Rejected”
  • “Approved”
  • ” “
10Date-Time Sent for Approval SearchDate-Time Sent for ApprovalNormalDateTime8Date-Time Sent for Approvaldatetime
11Last Date-Time Modified SearchLast Date-Time ModifiedNormalDateTime8Last Date-Time Modifieddatetime
12Last Modified By ID SearchLast Modified By IDNormalCode50Last Modified By IDnvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
       [Posted Approval Entry].[Last Modified By ID]
       ,[User].[User Name]
FROM
       [CRONUS UK Ltd_$Posted Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Approval Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Approval Entry].[Last Modified By ID] = [User].[User Name]
13Comment SearchCommentFlowFieldBoolean4
14Due Date SearchDue DateNormalDate4Due Datedatetime
15Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
16Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
17Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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 SearchApproval TypeNormalOption4Approval Typeint
Available options are:
  • “Workflow User Group”
  • “Sales Pers./Purchaser”
  • “Approver”
19Limit Type SearchLimit TypeNormalOption4Limit Typeint
Available options are:
  • “Approval Limits”
  • “Credit Limits”
  • “Request Limits”
  • “No Limits”
20Available Credit Limit (LCY) SearchAvailable Credit Limit ($)NormalDecimal12Available Credit Limit (LCY)decimal(38,38)
22Posted Record ID SearchPosted Record IDNormalRecordID448Posted Record IDvarbinary(448)
23Delegation Date Formula SearchDelegation Date FormulaNormalDateFormula32Delegation Date Formulavarchar(32)
26Number of Approved Requests SearchNumber of Approved RequestsNormalInteger4Number of Approved Requestsint
27Number of Rejected Requests SearchNumber of Rejected RequestsNormalInteger4Number of Rejected Requestsint
28Iteration No. SearchIteration No.NormalInteger4Iteration No_int
29Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Posted Approval Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Approval Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Approval Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Posted Approval Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Approval Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Approval Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Posted Approval Entry table

Currency
Dynamics 365 BC Table ReferenceTablesCompany TablesPPosted Approval Entry

Leave a Reply

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