| Field Name | Datatype | Format | Extent | Default | Description |
| Address | character | x(20) | 1 | � | � |
| Address2 | character | x(20) | 1 | � | � |
| Balance | decimal | ->,>>>,>>9.99 | 1 | 0 | � |
| City | character | x(12) | 1 | � | � |
| Comments | character | x(60) | 1 | � | � |
| Contact | character | x(20) | 1 | � | � |
| Country | character | x(20) | 1 | USA | � |
| Credit-Limit | decimal | ->,>>>,>>9 | 1 | 1500 | Maximum credit |
| Cust-Num | integer | >>>>9 | 1 | 0 | � |
| Discount | integer | >>9% | 1 | 0 | � |
| Name | character | x(20) | 1 | � | � |
| Phone | character | x(20) | 1 | � | Format/Label/Help based on status of NON-US field. |
| Postal-Code | character | x(10) | 1 | � | Format/Label/Help Message based on status of NON-US field. |
| Sales-Rep | character | X(4) | 1 | � | � |
| State | character | x(20) | 1 | � | Label/Valexp/Valmsg/Help are set based on value of NON-US field! |
| Terms | character | x(20) | 1 | Net30 | � |
Country-Post
Country
Postal-Code
Cust-Num
- Primary
- Unique
Cust-Num
Name
Name
Sales-Rep
Sales-Rep
Return to Listing Of Database Tables