Approval Entry

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

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

Show/hide columns in 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
	       [Approval Entry].[Table ID]
	       ,[Data Exch. Mapping].[Table ID]
	FROM
	       [CRONUS UK Ltd_$Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
	              ON
	                     [Approval Entry].[Table ID] = [Data Exch. Mapping].[Table ID]
2Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
  • ” “
  • “Payment”
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
	       [Approval Entry].[Sender ID]
	       ,[User].[User Name]
	FROM
	       [CRONUS UK Ltd_$Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Approval Entry].[Sender ID] = [User].[User Name]
7Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
8Approver ID SearchApprover IDNormalCode50Approver IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
	       [Approval Entry].[Approver ID]
	       ,[User Setup].[User ID]
	FROM
	       [CRONUS UK Ltd_$Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	              ON
	                     [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 User ID SearchLast Modified By User IDNormalCode50Last Modified By User IDnvarchar(100)
13Comment SearchCommentFlowFieldBoolean4
14Due Date SearchApproval Due 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
	       [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]
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)
21Pending Approvals SearchPending ApprovalsFlowFieldInteger4
22Record ID to Approve SearchRecord ID to ApproveNormalRecordID448Record ID to Approvevarbinary(448)
23Delegation Date Formula SearchDelegation Date FormulaNormalDateFormula32Delegation Date Formulavarchar(32)
26Number of Approved Requests SearchNumber of Approved RequestsFlowFieldInteger4
27Number of Rejected Requests SearchNumber of Rejected RequestsFlowFieldInteger4
29Entry No. SearchEntry No.NormalInteger4Entry No_int
30Workflow Step Instance ID Primary Key SearchWorkflow Step Instance IDNormalGUID16Workflow Step Instance IDuniqueidentifier
31Related to Change SearchRelated to ChangeFlowFieldBoolean4
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
	       [Approval Entry].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Approval Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Approval Entry table

CurrencySales HeaderSales Header Archive
Dynamics 365 BC Table ReferenceTablesCompany TablesAApproval Entry

Leave a Reply

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