View: V_DocumentReport
This view contains aggregate field values and validity statistics, as
well as several types of Capture data.
|
ID | The ID of the document (ID in W_Document).
|
ParentID | The ID of the root document (only populated
when this document is a sub-document). (ParentID in W_Document).
|
BatchID | The ID of the root document (BatchID in W_Document). |
ProcessID | The ID of the process (ProcessID in W_Document).
|
Name | The name of the document (Name in W_Document). |
TypeID | The ID of the document type (TypeID in W_Document).
|
Deleted | Whether the document is canceled (Deleted in W_Document). |
CreatedAt | When the document was created (CreatedAt
in W_Document). |
Field1 – Field20 | The VarcharValue of the field with the assignment Report field = Field1,
Report field = Field2, etc. in C_FieldDefinition.
|
DocTypeName | The name of the document type (Name in C_DocType). |
CurrentSheetCount | The number of sheets (CurrentSheetCount
in W_DocReport). |
CurrentPageCount | The number of pages (CurrentPageCount
in W_DocReport). |
CurrentImageCount | The number of images (CurrentImageCount
in W_DocReport). |
SQL Script
CREATE VIEW [dbo].[V_DocumentReport]
AS
SELECT dbo.W_Document.ID, dbo.W_Document.ParentID, dbo.W_Document.BatchID, dbo.W_Document.ProcessID, dbo.W_Document.Name,
dbo.W_Document.TypeID, dbo.W_Document.Deleted, dbo.W_Document.CreatedAt, dbo.W_DocReport.Field1, dbo.W_DocReport.Field2,
dbo.W_DocReport.Field3, dbo.W_DocReport.Field4, dbo.W_DocReport.Field5, dbo.W_DocReport.Field6, dbo.W_DocReport.Field7, dbo.W_DocReport.Field8,
dbo.W_DocReport.Field9, dbo.W_DocReport.Field10, dbo.W_DocReport.Field11, dbo.W_DocReport.Field12, dbo.W_DocReport.Field13,
dbo.W_DocReport.Field14, dbo.W_DocReport.Field15, dbo.W_DocReport.Field16, dbo.W_DocReport.Field17, dbo.W_DocReport.Field18,
dbo.W_DocReport.Field19, dbo.W_DocReport.Field20, dbo.C_DocType.Name AS DocTypeName, dbo.W_DocReport.CurrentSheetCount,
dbo.W_DocReport.CurrentPageCount, dbo.W_DocReport.CurrentImageCount
FROM dbo.W_Document INNER JOIN
dbo.W_DocReport ON dbo.W_Document.ID = dbo.W_DocReport.DocumentID AND dbo.W_Document.SiteId = dbo.W_DocReport.DocumentSiteId INNER JOIN
dbo.C_DocType ON dbo.W_Document.TypeID = dbo.C_DocType.ID
Uses
Related topics
The available tables
The available views