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: 458Due 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.
SELECT
*
FROM
[CRONUS UK Ltd_$Overdue Approval Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
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]
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]
| 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.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] |
| 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 | Sent to ID | Sent to ID | Normal | Code | 50 | Sent to ID | nvarchar(100) |
| Key to join to the User Setup table.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] |
| 5 | Sent Time | Sent Time | Normal | Time | 4 | Sent Time | datetime |
| 6 | Sent Date | Sent Date | Normal | Date | 4 | Sent Date | datetime |
| 7 | E-Mail | Email | Normal | Text | 100 | E-Mail | nvarchar(200) |
| 8 | Sent to Name | Sent to Name | Normal | Text | 30 | Sent to Name | nvarchar(60) |
| 9 | Sequence No. | Sequence No. | Normal | Integer | 4 | Sequence No_ | int |
| 10 | Due Date | Due Date | Normal | Date | 4 | Due Date | datetime |
| 11 | Approver ID | Approver ID | Normal | Code | 50 | Approver ID | nvarchar(100) |
| Key to join to the User Setup table.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] |
| 12 | Approval Code | Approval Code | Normal | Code | 20 | Approval Code | nvarchar(40) |
| 13 | Approval Type | Approval Type | Normal | Option | 4 | Approval Type | int |
| Available options are:
- “Workflow User Group”
- “Sales Pers./Purchaser”
- “Approver”
|
| 14 | Limit Type | Limit Type | Normal | Option | 4 | Limit Type | int |
| Available options are:
- “Approval Limits”
- “Credit Limits”
- “Request Limits”
- “No Limits”
|
| 15 | Record ID to Approve | Record ID to Approve | Normal | RecordID | 448 | Record ID to Approve | varbinary(448) |
| 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.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] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
