The DOCTYPE table stores a record for every configured OnBase Document Type. This parent table can be joined with the ITEMDATA table to get the name of the Document Type (itemtypename) for a particular document. The DOCTYPE table is located in DBSpace8.
| Column Name | Data Type | Description |
|---|---|---|
| itemtypenum | bigint | The unique identifier of the Document Type. |
| itemtypename | char(66) | The name of the Document Type. |
| itrevnum | bigint | |
| itemtypegroupnum | bigint | |
| filetypenum | bigint | |
| compressfile | bigint | |
| autonamestring | char(150) | |
| inuse | bigint | |
| diskgroupnum | bigint | |
| displaythumbs | bigint | |
| numrows | bigint | |
| isdocrevisionable | bigint | |
| docsourceflag | bigint | |
| imagewindowflags | bigint | |
| uiflags | bigint | |
| itemtypeflags | bigint | |
| revisablebyinst | bigint |
The indexes for the DOCTYPE table are located in DBSpace8.
| Index Name | Indexed Columns |
|---|---|
| doctype1 | itemtypenum |
| doctype2 | itemtypename |