Incoming Document

Dynamics 365 BC Table ReferenceTablesCompany TablesIIncoming 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: 130

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

   [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]
   ,[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]
   ,[URL]
   ,[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
   [User] AS [User]
      ON
         [Incoming Document].[Released By User ID] = [User].[User Security ID]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Incoming Document].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Incoming Document].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Incoming Document].[Document Type] = [Sales Header].[Document Type]
      AND
         [Incoming Document].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Data Exchange Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exchange Type]
      ON
         [Incoming Document].[Data Exchange Type] = [Data Exchange Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Incoming Document].[Vendor Id] = [Vendor].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Incoming Document].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Incoming Document].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Incoming Document].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Incoming Document table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Created Date-Time SearchCreated Date-TimeNormalDateTime8Created Date-Timedatetime
4Created By User ID SearchCreated By User IDNormalGUID16Created By User IDuniqueidentifier
5Created By User Name SearchCreated By User NameFlowFieldCode50
6Released SearchReleasedNormalBoolean4Releasedtinyint
7Released Date-Time SearchReleased Date-TimeNormalDateTime8Released Date-Timedatetime
8Released By User ID SearchReleased By User IDNormalGUID16Released By User IDuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Incoming Document].[Released By User ID]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
LEFT JOIN
       [User] AS [User]
              ON
                     [Incoming Document].[Released By User ID] = [User].[User Security ID]
9Released By User Name SearchReleased By User NameFlowFieldCode50
10Last Date-Time Modified SearchLast Date-Time ModifiedNormalDateTime8Last Date-Time Modifieddatetime
11Last Modified By User ID SearchLast Modified By User IDNormalGUID16Last Modified By User IDuniqueidentifier
12Last Modified By User Name SearchLast Modified By User NameFlowFieldCode50
13Posted SearchPostedNormalBoolean4Postedtinyint
14Posted Date-Time SearchPosted Date-TimeNormalDateTime8Posted Date-Timedatetime
15Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Journal”
  • “Sales Invoice”
  • “Sales Credit Memo”
  • “Purchase Invoice”
  • “Purchase Credit Memo”
  • ” “
16Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
17Posting Date SearchPosting DateNormalDate4Posting Datedatetime
18Status SearchStatusNormalOption4Statusint
Available options are:
  • “New”
  • “Released”
  • “Rejected”
  • “Posted”
  • “Created”
  • “Failed”
  • “Pending Approval”
19URL1 SearchURL1NormalText250URL1nvarchar(500)
20URL2 SearchURL2NormalText250URL2nvarchar(500)
21URL3 SearchURL3NormalText250URL3nvarchar(500)
22URL4 SearchURL4NormalText250URL4nvarchar(500)
23Vendor Name SearchVendor NameNormalText100Vendor Namenvarchar(200)
24Vendor VAT Registration No. SearchVendor Tax Registration No.NormalText30Vendor VAT Registration No_nvarchar(60)
25Vendor IBAN SearchVendor IBANNormalCode50Vendor IBANnvarchar(100)
26Document Date SearchDocument DateNormalDate4Document Datedatetime
27Vendor Bank Branch No. SearchVendor Bank Branch No.NormalText20Vendor Bank Branch No_nvarchar(40)
28Vendor Bank Account No. SearchVendor Bank Account No.NormalText30Vendor Bank Account No_nvarchar(60)
29Vendor No. SearchVendor No.NormalCode20Vendor 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_]
30Data Exchange Type SearchData Exchange TypeNormalCode20Data Exchange Typenvarchar(40)
Key to join to the Data Exchange Type table.

Show/hide example query

SELECT
       [Incoming Document].[Data Exchange Type]
       ,[Data Exchange Type].[Code]
FROM
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exchange Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exchange Type]
              ON
                     [Incoming Document].[Data Exchange Type] = [Data Exchange Type].[Code]
31OCR Data Corrected SearchOCR Data CorrectedNormalBoolean4OCR Data Correctedtinyint
32OCR Status SearchOCR StatusNormalOption4OCR Statusint
Available options are:
  • ” “
  • “Ready”
  • “Sent”
  • “Error”
  • “Success”
  • “Awaiting Verification”
33OCR Track ID SearchOCR Track IDNormalText20OCR Track IDnvarchar(40)
38OCR Service Doc. Template Code SearchOCR Service Doc. Template CodeNormalCode20OCR Service Doc_ Template Codenvarchar(40)
Key to join to the OCR Service Document Template table.

Show/hide example query

SELECT
       [Incoming Document].[OCR Service Doc_ Template Code]
       ,[OCR Service Document Template].[Code]
FROM
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
LEFT JOIN
       [CRONUS UK Ltd_$OCR Service Document Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [OCR Service Document Template]
              ON
                     [Incoming Document].[OCR Service Doc_ Template Code] = [OCR Service Document Template].[Code]
39OCR Service Doc. Template Name SearchOCR Service Doc. Template NameFlowFieldText50
40OCR Process Finished SearchOCR Process FinishedNormalBoolean4OCR Process Finishedtinyint
41Created Doc. Error Msg. Type SearchCreated Doc. Error Msg. TypeNormalOption4Created Doc_ Error Msg_ Typeint
Available options are:
  • ” “
  • “Error”
  • “Warning”
42Vendor Id SearchVendor IdNormalGUID16Vendor Iduniqueidentifier
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Incoming Document].[Vendor Id]
       ,[Vendor].[$systemId]
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 Id] = [Vendor].[$systemId]
50Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
51Amount Excl. VAT SearchAmount Excl. TaxNormalDecimal12Amount Excl_ VATdecimal(38,38)
52Amount Incl. VAT SearchAmount Incl. TaxNormalDecimal12Amount Incl_ VATdecimal(38,38)
53VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
54Due Date SearchDue DateNormalDate4Due Datedatetime
55Vendor Invoice No. SearchVendor Invoice No.NormalCode35Vendor Invoice No_nvarchar(70)
56Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
57Vendor Phone No. SearchVendor Phone No.NormalText30Vendor Phone No_nvarchar(60)
58Related Record ID SearchRelated Record IDNormalRecordID448Related Record IDvarbinary(448)
60URL SearchURLNormalText1024URLnvarchar(2048)
160Job Queue Status SearchJob Queue StatusNormalOption4Job Queue Statusint
Available options are:
  • ” “
  • “Scheduled”
  • “Error”
  • “Processing”
161Job Queue Entry ID SearchJob Queue Entry IDNormalGUID16Job Queue Entry IDuniqueidentifier
162Processed SearchProcessedNormalBoolean4Processedtinyint
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
       [Incoming Document].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
LEFT JOIN
       [User] AS [User]
              ON
                     [Incoming Document].[$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
       [Incoming Document].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
LEFT JOIN
       [User] AS [User]
              ON
                     [Incoming Document].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Incoming Document table

CurrencySales HeaderSales Header Archive
Dynamics 365 BC Table ReferenceTablesCompany TablesIIncoming Document

Leave a Reply

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