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.
| 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.
| Index Name | Indexed Columns |
|---|---|
| roirequestextitems1 | roirequestnum, roiextitemnum |