BILLING_INFO |
| Column Name |
Data Type |
Nulls |
References
Table |
Foreign Key
Name |
| vendor_key |
decimal (15,0) |
|
VENDOR |
fk_billing_info1 |
| contact_first_name |
varchar (50) |
YES |
|
|
| contact_last_name |
varchar (50) |
YES |
|
|
| street1 |
varchar (100) |
YES |
|
|
| street2 |
varchar (100) |
YES |
|
|
| city |
varchar (50) |
YES |
|
|
| state |
varchar (5) |
YES |
|
|
| zip |
varchar (9) |
YES |
|
|
| account_number |
varchar (255) |
YES |
|
|
| email |
varchar (100) |
YES |
|
|
| phone |
varchar (25) |
YES |
|
|
| fax |
varchar (25) |
YES |
|
|
Indexes on BILLING_INFO |
| Index Name |
Column(s) |
| pk_billing_info |
vendor_key |
No References made to BILLING_INFO
No Check Constraints on BILLING_INFO
Copyright 1998, 1999 Computer Strategies, Inc., All Rights Reserved.
Last revised: May 25, 2000 11:26:54 AM EDT