Incoming Document

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

Table Type: Company

Table Name: Incoming Document
Database Table Name: CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Incoming Document can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Description]
   ,[Created Date-Time]
   ,[Created By User ID]
   ,[Released]
   ,[Released Date-Time]
   ,[Released By User ID]
   ,[Last Date-Time Modified]
   ,[Last Modified By User ID]
   ,[Posted]
   ,[Posted Date-Time]
   ,[Document Type]
   ,[Document No_]
   ,[Posting Date]
   ,[Status]
   ,[URL]
   ,[URL1]
   ,[URL2]
   ,[URL3]
   ,[URL4]
   ,[Vendor Name]
   ,[Vendor VAT Registration No_]
   ,[Vendor IBAN]
   ,[Document Date]
   ,[Vendor Bank Branch No_]
   ,[Vendor Bank Account No_]
   ,[Vendor No_]
   ,[Data Exchange Type]
   ,[OCR Data Corrected]
   ,[OCR Status]
   ,[OCR Track ID]
   ,[OCR Service Doc_ Template Code]
   ,[OCR Process Finished]
   ,[Created Doc_ Error Msg_ Type]
   ,[Vendor Id]
   ,[Currency Code]
   ,[Amount Excl_ VAT]
   ,[Amount Incl_ VAT]
   ,[VAT Amount]
   ,[Due Date]
   ,[Vendor Invoice No_]
   ,[Order No_]
   ,[Vendor Phone No_]
   ,[Related Record ID]
   ,[Job Queue Status]
   ,[Job Queue Entry ID]
   ,[Processed]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Incoming Document].[Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Incoming Document].[Currency Code] = [Currency].[Code]

Show/hide columns in Incoming Document table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Description Searchnvarchar(200)
4Created Date-Time Searchdatetime
5Created By User ID Searchuniqueidentifier
6Released Searchtinyint
7Released Date-Time Searchdatetime
8Released By User ID Searchuniqueidentifier
9Last Date-Time Modified Searchdatetime
10Last Modified By User ID Searchuniqueidentifier
11Posted Searchtinyint
12Posted Date-Time Searchdatetime
13Document Type Searchint
14Document No_ Searchnvarchar(40)
15Posting Date Searchdatetime
16Status Searchint
17URL Searchnvarchar(2048)
18URL1 Searchnvarchar(500)
19URL2 Searchnvarchar(500)
20URL3 Searchnvarchar(500)
21URL4 Searchnvarchar(500)
22Vendor Name Searchnvarchar(200)
23Vendor VAT Registration No_ Searchnvarchar(60)
24Vendor IBAN Searchnvarchar(100)
25Document Date Searchdatetime
26Vendor Bank Branch No_ Searchnvarchar(40)
27Vendor Bank Account No_ Searchnvarchar(60)
28Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Incoming Document].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Incoming Document].[Vendor No_] = [Vendor].[No_]
29Data Exchange Type Searchnvarchar(40)
30OCR Data Corrected Searchtinyint
31OCR Status Searchint
32OCR Track ID Searchnvarchar(40)
33OCR Service Doc_ Template Code Searchnvarchar(40)
34OCR Process Finished Searchtinyint
35Created Doc_ Error Msg_ Type Searchint
36Vendor Id Searchuniqueidentifier
37Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Incoming Document].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Incoming Document].[Currency Code] = [Currency].[Code]
38Amount Excl_ VAT Searchdecimal(38,38)
39Amount Incl_ VAT Searchdecimal(38,38)
40VAT Amount Searchdecimal(38,38)
41Due Date Searchdatetime
42Vendor Invoice No_ Searchnvarchar(70)
43Order No_ Searchnvarchar(40)
44Vendor Phone No_ Searchnvarchar(60)
45Related Record ID Searchvarbinary(448)
46Job Queue Status Searchint
47Job Queue Entry ID Searchuniqueidentifier
48Processed Searchtinyint
49$systemId Searchuniqueidentifier
50$systemCreatedAt Searchdatetime
51$systemCreatedBy Searchuniqueidentifier
52$systemModifiedAt Searchdatetime
53$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Incoming Document table

Leave a Reply

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