Table: dbo.PPC_Workpaper
This table stores document information of a PPC Checkpoint Tools documents. WorkpaperCS can integration with PPCs Checkpoint Tools by allowing users to add PPC Checkpoint Tools document into WorkpaperCS. Information stored in this table come from Custom Properties of PPC Checkpoint tools Excel or Word documents.
Columns
Name | Type | Constraints | Description
workpaper_KEY | int (4) | NOT NULL | Primary key for this table and a foreign key to the Workpaper table.
template_version | nvarchar (512) | NOT NULL | PPC Checkpoint Tools template version.
product_code | nvarchar (512) | NOT NULL | PPC Checkpoint Tools product code.
template_file_name | nvarchar (512) | NOT NULL | PPC Checkpoint Tools template file name.
template_title | nvarchar (512) | NOT NULL | PPC Checkpoint Tools template title.
template_id_guid | uniqueidentifier (16) | NOT NULL | PPC Checkpoint Tools template id. This is their document id as Guid format.
book_acronym | nvarchar (512) | NOT NULL | PPC CheckpointTools template document book_acronym custom property. Data stored in this column comes from PPC CheckpointTools OBET type template Word or Excel document custom properties. They will be empty for non-OBET type template documents.

Primary key
Name | Columns | Description
PK_PPC_Workpaper$workpaper_KEY | workpaper_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_PPC_Workpaper__Workpaper__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) |