Approval Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AApproval 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Table ID	Table ID	Normal	Integer	4	Table ID	int
	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]
2	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: “Quote” “Order” “Invoice” “Credit Memo” “Blanket Order” “Return Order” ” “ “Payment”
3	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
4	Sequence No.	Sequence No.	Normal	Integer	4	Sequence No_	int
5	Approval Code	Approval Code	Normal	Code	20	Approval Code	nvarchar(40)
6	Sender ID	Sender ID	Normal	Code	50	Sender ID	nvarchar(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]
7	Salespers./Purch. Code	Salespers./Purch. Code	Normal	Code	20	Salespers__Purch_ Code	nvarchar(40)
8	Approver ID	Approver ID	Normal	Code	50	Approver ID	nvarchar(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]
9	Status	Status	Normal	Option	4	Status	int
	Available options are: “Created” “Open” “Canceled” “Rejected” “Approved” ” “
10	Date-Time Sent for Approval	Date-Time Sent for Approval	Normal	DateTime	8	Date-Time Sent for Approval	datetime
11	Last Date-Time Modified	Last Date-Time Modified	Normal	DateTime	8	Last Date-Time Modified	datetime
12	Last Modified By User ID	Last Modified By User ID	Normal	Code	50	Last Modified By User ID	nvarchar(100)
13	Comment	Comment	FlowField	Boolean	4
14	Due Date	Approval Due Date	Normal	Date	4	Due Date	datetime
15	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
16	Amount (LCY)	Amount ($)	Normal	Decimal	12	Amount (LCY)	decimal(38,38)
17	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
18	Approval Type	Approval Type	Normal	Option	4	Approval Type	int
	Available options are: “Workflow User Group” “Sales Pers./Purchaser” “Approver”
19	Limit Type	Limit Type	Normal	Option	4	Limit Type	int
	Available options are: “Approval Limits” “Credit Limits” “Request Limits” “No Limits”
20	Available Credit Limit (LCY)	Available Credit Limit ($)	Normal	Decimal	12	Available Credit Limit (LCY)	decimal(38,38)
21	Pending Approvals	Pending Approvals	FlowField	Integer	4
22	Record ID to Approve	Record ID to Approve	Normal	RecordID	448	Record ID to Approve	varbinary(448)
23	Delegation Date Formula	Delegation Date Formula	Normal	DateFormula	32	Delegation Date Formula	varchar(32)
26	Number of Approved Requests	Number of Approved Requests	FlowField	Integer	4
27	Number of Rejected Requests	Number of Rejected Requests	FlowField	Integer	4
29	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
30	Workflow Step Instance ID	Workflow Step Instance ID	Normal	GUID	16	Workflow Step Instance ID	uniqueidentifier
31	Related to Change	Related to Change	FlowField	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Approval Entry table

Dynamics 365 BC Table Reference Tables Company Tables AApproval Entry

Leave a Reply Cancel reply