Posted Approval Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPosted 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 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 [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]
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 [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]
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 [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]
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 ID	Last Modified By ID	Normal	Code	50	Last Modified By ID	nvarchar(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]
13	Comment	Comment	FlowField	Boolean	4
14	Due Date	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 [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]
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)
22	Posted Record ID	Posted Record ID	Normal	RecordID	448	Posted Record ID	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	Normal	Integer	4	Number of Approved Requests	int
27	Number of Rejected Requests	Number of Rejected Requests	Normal	Integer	4	Number of Rejected Requests	int
28	Iteration No.	Iteration No.	Normal	Integer	4	Iteration No_	int
29	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
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 [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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Posted Approval Entry table

Dynamics 365 BC Table Reference Tables Company Tables PPosted Approval Entry

Leave a Reply Cancel reply