debtorno |
varchar(10) |
latin1_swedish_ci |
|
|
|
name |
varchar(40) |
latin1_swedish_ci |
|
|
|
address1 |
varchar(40) |
latin1_swedish_ci |
|
|
|
address2 |
varchar(40) |
latin1_swedish_ci |
|
|
|
address3 |
varchar(40) |
latin1_swedish_ci |
|
|
|
address4 |
varchar(50) |
latin1_swedish_ci |
|
|
|
address5 |
varchar(20) |
latin1_swedish_ci |
|
|
|
address6 |
varchar(15) |
latin1_swedish_ci |
|
|
|
currcode |
char(3) |
latin1_swedish_ci |
|
|
|
salestype |
char(2) |
latin1_swedish_ci |
|
|
|
clientsince |
datetime |
|
|
|
|
holdreason |
smallint(6) |
|
|
|
|
paymentterms |
char(2) |
latin1_swedish_ci |
|
|
|
discount |
double |
|
|
|
|
pymtdiscount |
double |
|
|
|
|
lastpaid |
double |
|
|
|
|
lastpaiddate |
datetime |
|
|
|
|
creditlimit |
double |
|
|
|
|
invaddrbranch |
tinyint(4) |
|
|
|
|
discountcode |
char(2) |
latin1_swedish_ci |
|
|
|
ediinvoices |
tinyint(4) |
|
|
|
|
ediorders |
tinyint(4) |
|
|
|
|
edireference |
varchar(20) |
latin1_swedish_ci |
|
|
|
editransport |
varchar(5) |
latin1_swedish_ci |
|
|
|
ediaddress |
varchar(50) |
latin1_swedish_ci |
|
|
|
ediserveruser |
varchar(20) |
latin1_swedish_ci |
|
|
|
ediserverpwd |
varchar(20) |
latin1_swedish_ci |
|
|
|
taxref |
varchar(20) |
latin1_swedish_ci |
|
|
|
customerpoline |
tinyint(1) |
|
|
|
|
typeid |
tinyint(4) |
|
|
|
|