ROIREQUESTEXTITEMS - Database Reporting Guide - English - Foundation 22.1 - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The ROIREQUESTEXTITEMS table stores external items added to an ROI request. There is a one-to-many relationship between an ROI request and the external items.

ROIREQUESTEXTITEMS Table Values
Column Name Data Type Data Lenght Description
roirequestnum bigint 8 Foreign key to ROIREQUEST table.
roiextitemnum bigint 8 Foreign key to ROIEXTERNALITEM table.
roiquantity bigint 8 Quantity of an external item in the request.
roicost numeric 9 Cost of an external item on the request.
clerkusernum bigint 8 Foreign key to USERACCOUNT table. User who added/modified the external items on the request.

The indexes for ROIREQUESTEXTITEMS table are located in DBSpace1.

ROIREQUESTEXTITEMS Table Indexes
Index Name Indexed Columns
roirequestextitems1 roirequestnum, roiextitemnum