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 |