| Number | Name | Type | Size | Offset | Index | Relates to |
|---|---|---|---|---|---|---|
| 0 | RECNUM | Number | 0.0 | 0 | ||
| 1 | ITEM_ID | String | 10.0 | 1 | 1 | |
| 2 | DESCRIPTION | String | 35.0 | 11 | 3 | |
| 3 | VENDOR_ID | Number | 6.0 | 46 | 2 | VENDOR.ID |
| 4 | VENDOR_PART_ID | String | 15.0 | 49 | 2 | |
| 5 | UNIT_PRICE | Number | 6.2 | 64 | ||
| 6 | ON_HAND | Number | 6.0 | 68 |
| Name | Descending | Uppercase | |
|---|---|---|---|
| Index #1 | |||
| Item_ID | false | true | |
| Index #2 | |||
| Vendor_ID | false | false | |
| Vendor_Part_ID | false | true | |
| Item_ID | false | true | |
| Index #3 | |||
| Description | false | true | |
| Item_ID | false | true | |