Number | Name | Type | Size | Offset | Index | Relates to |
---|---|---|---|---|---|---|
0 | RECNUM | Number | 0.0 | 0 | ||
1 | ORDER_NUMBER | Number | 6.0 | 1 | 1 | ORDERHEA.ORDER_NUMBER |
2 | DETAIL_NUMBER | Number | 4.0 | 4 | 1 | |
3 | ITEM_ID | String | 10.0 | 6 | INVT.ITEM_ID | |
4 | QTY_ORDERED | Number | 6.0 | 16 | ||
5 | PRICE | Number | 6.2 | 19 | ||
6 | EXTENDED_PRICE | Number | 8.2 | 23 |
Name | Descending | Uppercase | |
---|---|---|---|
Index #1 | |||
Order_Number | false | false | |
Detail_Number | false | false |