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 |