| Number | Name | Type | Size | Offset | Index | Relates to |
|---|---|---|---|---|---|---|
| 0 | RECNUM | Number | 0.0 | 0 | ||
| 1 | ORDER_NUMBER | Number | 6.0 | 1 | 1 | |
| 2 | CUSTOMER_NUMBER | Number | 6.0 | 4 | 2 | CUSTOMER.CUSTOMER_NUMBER |
| 3 | ORDER_DATE | Date | 3.0 | 7 | 3 | |
| 4 | TERMS | String | 12.0 | 10 | ||
| 5 | SHIP_VIA | String | 12.0 | 22 | ||
| 6 | ORDERED_BY | String | 12.0 | 34 | ||
| 7 | SALESPERSON_ID | String | 4.0 | 46 | . | |
| 8 | ORDER_TOTAL | Number | 8.2 | 50 | ||
| 9 | LAST_DETAIL_NUM | Number | 4.0 | 55 |
| Name | Descending | Uppercase | |
|---|---|---|---|
| Index #1 | |||
| ORDER_NUMBER | false | false | |
| Index #2 | |||
| CUSTOMER_NUMBER | false | false | |
| ORDER_NUMBER | false | false | |
| Index #3 | |||
| ORDER_DATE | false | false | |
| ORDER_NUMBER | false | false | |