| contacto |
char(100)
|
utf8mb3_bin
|
|
|
| codsubcuenta |
char(15)
|
utf8mb3_bin
|
|
|
| codtiporappel |
char(10)
|
utf8mb3_bin
|
|
|
| ivaincluido |
tinyint(1)
|
|
|
|
| codpago |
char(10)
|
utf8mb3_bin
|
|
|
| codcuentadom |
char(6)
|
utf8mb3_bin
|
|
|
| pordtoesp |
decimal(10,7)
|
|
|
|
| recargo |
tinyint(1)
|
|
|
|
| web |
char(250)
|
utf8mb3_bin
|
|
|
| fax |
char(30)
|
utf8mb3_bin
|
|
|
| observaciones |
mediumtext
|
utf8mb3_bin
|
|
|
| capitalimpagado |
decimal(15,7)
|
|
|
|
| codcliente |
char(6)
|
utf8mb3_bin
|
|
|
| email |
char(50)
|
utf8mb3_bin
|
|
|
| cifnif |
char(20)
|
utf8mb3_bin
|
|
|
| debaja |
tinyint(1)
|
|
|
|
| codcontacto |
char(6)
|
utf8mb3_bin
|
|
|
| fechabaja |
date
|
|
|
|
| nombrepila |
char(100)
|
utf8mb3_bin
|
|
|
| codgrupo |
char(6)
|
utf8mb3_bin
|
|
|
| codagente |
char(10)
|
utf8mb3_bin
|
|
|
| personafisica |
tinyint(1)
|
|
|
|
| regimeniva |
char(20)
|
utf8mb3_bin
|
|
|
| portes |
decimal(15,7)
|
|
|
|
| nombre |
char(100)
|
utf8mb3_bin
|
|
|
| codedi |
char(17)
|
utf8mb3_bin
|
|
|
| idsubcuenta |
int
|
|
|
|
| riesgoalcanzado |
decimal(15,7)
|
|
|
|
| copiasfactura |
int
|
|
|
|
| codserie |
char(2)
|
utf8mb3_bin
|
|
|
| nombrecomercial |
char(100)
|
utf8mb3_bin
|
|
|
| riesgomax |
decimal(15,7)
|
|
|
|
| tipoidfiscal |
char(25)
|
utf8mb3_bin
|
|
|
| telefono1 |
char(30)
|
utf8mb3_bin
|
|
|
| telefono2 |
char(30)
|
utf8mb3_bin
|
|
|
| coddivisa |
char(3)
|
utf8mb3_bin
|
|
|
| codcuentarem |
char(6)
|
utf8mb3_bin
|
|
|
| apellidos |
char(100)
|
utf8mb3_bin
|
|
|