Overdue Approval Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesOOverdue Approval Entry

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/458

Table Type: Company

Table Name: Overdue Approval Entry
Database Table Name: CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 458

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 Overdue Approval Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Table ID]
   ,[Document Type]
   ,[Document No_]
   ,[Sent to ID]
   ,[Sent Time]
   ,[Sent Date]
   ,[E-Mail]
   ,[Sent to Name]
   ,[Sequence No_]
   ,[Due Date]
   ,[Approver ID]
   ,[Approval Code]
   ,[Approval Type]
   ,[Limit Type]
   ,[Record ID to Approve]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Overdue Approval Entry table

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

Show/hide example query

SELECT
       [Overdue Approval Entry].[Table ID]
       ,[Data Exch. Mapping].[Table ID]
FROM
       [CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Overdue Approval Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
              ON
                     [Overdue Approval Entry].[Table ID] = [Data Exch. Mapping].[Table ID]
2Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
  • ” “
  • “Payment”
3Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
4Sent to ID SearchSent to IDNormalCode50Sent to IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Overdue Approval Entry].[Sent to ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Overdue Approval Entry]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Overdue Approval Entry].[Sent to ID] = [User Setup].[User ID]
5Sent Time Primary Key SearchSent TimeNormalTime4Sent Timedatetime
6Sent Date Primary Key SearchSent DateNormalDate4Sent Datedatetime
7E-Mail SearchEmailNormalText100E-Mailnvarchar(200)
8Sent to Name SearchSent to NameNormalText30Sent to Namenvarchar(60)
9Sequence No. Primary Key SearchSequence No.NormalInteger4Sequence No_int
10Due Date SearchDue DateNormalDate4Due Datedatetime
11Approver ID SearchApprover IDNormalCode50Approver IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Overdue Approval Entry].[Approver ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Overdue Approval Entry]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Overdue Approval Entry].[Approver ID] = [User Setup].[User ID]
12Approval Code SearchApproval CodeNormalCode20Approval Codenvarchar(40)
13Approval Type SearchApproval TypeNormalOption4Approval Typeint
Available options are:
  • “Workflow User Group”
  • “Sales Pers./Purchaser”
  • “Approver”
14Limit Type SearchLimit TypeNormalOption4Limit Typeint
Available options are:
  • “Approval Limits”
  • “Credit Limits”
  • “Request Limits”
  • “No Limits”
15Record ID to Approve Primary Key SearchRecord ID to ApproveNormalRecordID448Record ID to Approvevarbinary(448)
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
       [Overdue Approval Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Overdue Approval Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Overdue 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
       [Overdue Approval Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Overdue Approval Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Overdue Approval Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Overdue Approval Entry table

Sales HeaderSales Header Archive
Dynamics 365 BC Table ReferenceTablesCompany TablesOOverdue Approval Entry

Leave a Reply

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