| customer_code | varchar(6) |
|
|
0
|
| customer_type | varchar(2) |
|
|
|
| customer_name | varchar(120) |
|
|
|
| customer_addr1 | varchar(80) |
|
|
|
| customer_addr2 | varchar(80) |
|
|
|
| customer_city | varchar(80) |
|
|
|
| customer_state | varchar(2) |
|
|
|
| customer_zip | varchar(10) |
|
|
|
| customer_country | varchar(30) |
|
|
|
| customer_phone | varchar(30) |
|
|
|
| customer_fax | varchar(30) |
|
|
|
| customer_email | varchar(50) |
|
|
|
| create_user | varchar(30) |
|
|
|
| create_date | timestamp |
|
|
0000-00-00 00:00:00.000000
|
| mod_user | varchar(30) |
|
|
|
| mod_date | timestamp |
|
|
current_timestamp()
|
| load_date | timestamp |
|
|
0000-00-00 00:00:00.000000
|