Incoming Document – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IIncoming 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Description	nvarchar(200)
4	Created Date-Time	datetime
5	Created By User ID	uniqueidentifier
6	Released	tinyint
7	Released Date-Time	datetime
8	Released By User ID	uniqueidentifier
9	Last Date-Time Modified	datetime
10	Last Modified By User ID	uniqueidentifier
11	Posted	tinyint
12	Posted Date-Time	datetime
13	Document Type	int
14	Document No_	nvarchar(40)
15	Posting Date	datetime
16	Status	int
17	URL	nvarchar(2048)
18	URL1	nvarchar(500)
19	URL2	nvarchar(500)
20	URL3	nvarchar(500)
21	URL4	nvarchar(500)
22	Vendor Name	nvarchar(200)
23	Vendor VAT Registration No_	nvarchar(60)
24	Vendor IBAN	nvarchar(100)
25	Document Date	datetime
26	Vendor Bank Branch No_	nvarchar(40)
27	Vendor Bank Account No_	nvarchar(60)
28	Vendor No_	nvarchar(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_]
29	Data Exchange Type	nvarchar(40)
30	OCR Data Corrected	tinyint
31	OCR Status	int
32	OCR Track ID	nvarchar(40)
33	OCR Service Doc_ Template Code	nvarchar(40)
34	OCR Process Finished	tinyint
35	Created Doc_ Error Msg_ Type	int
36	Vendor Id	uniqueidentifier
37	Currency Code	nvarchar(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]
38	Amount Excl_ VAT	decimal(38,38)
39	Amount Incl_ VAT	decimal(38,38)
40	VAT Amount	decimal(38,38)
41	Due Date	datetime
42	Vendor Invoice No_	nvarchar(70)
43	Order No_	nvarchar(40)
44	Vendor Phone No_	nvarchar(60)
45	Related Record ID	varbinary(448)
46	Job Queue Status	int
47	Job Queue Entry ID	uniqueidentifier
48	Processed	tinyint
49	$systemId	uniqueidentifier
50	$systemCreatedAt	datetime
51	$systemCreatedBy	uniqueidentifier
52	$systemModifiedAt	datetime
53	$systemModifiedBy	uniqueidentifier