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 |