Overdue 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

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in Overdue 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

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 Primary Key SearchSent to IDNormalCode50Sent to IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

5Sent Time SearchSent TimeNormalTime4Sent Timedatetime
6Sent Date Primary Key SearchSent DateNormalDate4Sent Datedatetime
7E-Mail Primary Key SearchEmailNormalText100E-Mailnvarchar(200)
8Sent to Name SearchSent to NameNormalText30Sent to Namenvarchar(60)
9Sequence No. SearchSequence No.NormalInteger4Sequence No_int
10Due Date Primary Key SearchDue DateNormalDate4Due Datedatetime
11Approver ID SearchApprover IDNormalCode50Approver IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

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 SearchRecord ID to ApproveNormalRecordID448Record ID to Approvevarbinary(448)
2000000000$systemId Primary Key SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Overdue Approval Entry table

Leave a Reply

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