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 | 6.0 | 7 | 3 | |
4 | TIME_START | String | 5.0 | 10 | ||
5 | TIME_END | String | 5.0 | 15 | ||
6 | TERMS | String | 12.0 | 20 | ||
7 | SHIP_VIA | String | 12.0 | 32 | ||
8 | ORDERED_BY | String | 12.0 | 44 | ||
9 | SALESPERSON_ID | String | 4.0 | 56 | SALESP.ID | |
10 | ORDER_TOTAL | Number | 8.2 | 60 | ||
11 | LAST_DETAIL_NUM | Number | 4.0 | 65 |
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 |