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

   [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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Table ID	int
4	Document No_	nvarchar(40)
5	Sequence No_	int
6	Approval Code	nvarchar(40)
7	Sender ID	nvarchar(100)
8	Salespers__Purch_ Code	nvarchar(40)
9	Approver ID	nvarchar(100)
10	Status	int
11	Date-Time Sent for Approval	datetime
12	Last Date-Time Modified	datetime
13	Last Modified By ID	nvarchar(100)
14	Due Date	datetime
15	Amount	decimal(38,38)
16	Amount (LCY)	decimal(38,38)
17	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	int
19	Limit Type	int
20	Available Credit Limit (LCY)	decimal(38,38)
21	Posted Record ID	varbinary(448)
22	Delegation Date Formula	varchar(32)
23	Number of Approved Requests	int
24	Number of Rejected Requests	int
25	Iteration No_	int
26	$systemId	uniqueidentifier
27	$systemCreatedAt	datetime
28	$systemCreatedBy	uniqueidentifier
29	$systemModifiedAt	datetime
30	$systemModifiedBy	uniqueidentifier