| Number | Name | Type | Size | Offset | Index | Relates to |
|---|---|---|---|---|---|---|
| 0 | RECNUM | Number | 0.0 | 0 | ||
| 1 | CUSTOMER_NUMBER | Number | 6.0 | 1 | 1 | |
| 2 | NAME | String | 30.0 | 4 | 2 | |
| 3 | ADDRESS | String | 30.0 | 34 | ||
| 4 | CITY | String | 14.0 | 64 | ||
| 5 | STATE | String | 2.0 | 78 | ||
| 6 | ZIP | String | 10.0 | 80 | ||
| 7 | PHONE_NUMBER | String | 20.0 | 90 | ||
| 8 | FAX_NUMBER | String | 20.0 | 110 | ||
| 9 | EMAIL_ADDRESS | String | 30.0 | 130 | ||
| 10 | CREDIT_LIMIT | Number | 6.2 | 160 | ||
| 11 | PURCHASES | Number | 6.2 | 164 | ||
| 12 | BALANCE | Number | 6.2 | 168 | 3 | |
| 13 | COMMENTS | BigInt | 1024.0 | 172 | ||
| 14 | STATUS | String | 1.0 | 1196 |
| Name | Descending | Uppercase | |
|---|---|---|---|
| Index #1 | |||
| Customer_Number | false | false | |
| Index #2 | |||
| Name | false | true | |
| Customer_Number | false | false | |
| Index #3 | |||
| Balance | false | false | |
| Customer_Number | false | false | |