| fecha |
date
|
|
|
|
| cifnif |
varchar(12)
|
latin1_swedish_ci
|
|
|
| codejercicio |
varchar(4)
|
latin1_swedish_ci
|
|
|
| direccion |
varchar(100)
|
latin1_swedish_ci
|
|
|
| coddir |
varchar(4)
|
latin1_swedish_ci
|
|
|
| ciudad |
varchar(100)
|
latin1_swedish_ci
|
|
|
| codpais |
varchar(20)
|
latin1_swedish_ci
|
|
|
| tasaconv |
decimal(14,8)
|
|
|
|
| id |
int
|
|
|
|
| codserie |
char(2)
|
latin1_swedish_ci
|
|
|
| porcomision |
decimal(10,7)
|
|
|
|
| nombrecliente |
varchar(100)
|
latin1_swedish_ci
|
|
|
| excepciones |
mediumtext
|
latin1_swedish_ci
|
|
|
| codagente |
varchar(10)
|
latin1_swedish_ci
|
|
|
| codcliente |
varchar(6)
|
latin1_swedish_ci
|
|
|
| fechahasta |
date
|
|
|
|
| codpago |
varchar(10)
|
latin1_swedish_ci
|
|
|
| codalmacen |
varchar(4)
|
latin1_swedish_ci
|
|
|
| coddivisa |
char(3)
|
latin1_swedish_ci
|
|
|
| fechadesde |
date
|
|
|
|
| recfinanciero |
decimal(10,7)
|
|
|
|
| codpostal |
varchar(10)
|
latin1_swedish_ci
|
|
|
| provincia |
varchar(100)
|
latin1_swedish_ci
|
|
|
| apartado |
varchar(10)
|
latin1_swedish_ci
|
|
|