| 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 | |