| codpostal |
char(10)
|
utf8mb3_bin
|
|
|
| fecha |
date
|
|
|
|
| codagente |
char(10)
|
utf8mb3_bin
|
|
|
| totalrecargo |
decimal(17,7)
|
|
|
|
| recfinanciero |
decimal(10,7)
|
|
|
|
| provincia |
char(100)
|
utf8mb3_bin
|
|
|
| tasaconv |
decimal(14,8)
|
|
|
|
| codejercicio |
char(4)
|
utf8mb3_bin
|
|
|
| porcomision |
decimal(10,7)
|
|
|
|
| numero |
char(12)
|
utf8mb3_bin
|
|
|
| coddivisa |
char(3)
|
utf8mb3_bin
|
|
|
| totaliva |
decimal(15,7)
|
|
|
|
| editable |
tinyint(1)
|
|
|
|
| idprovincia |
int
|
|
|
|
| totalirpf |
decimal(15,7)
|
|
|
|
| direccion |
char(100)
|
utf8mb3_bin
|
|
|
| codserie |
char(2)
|
utf8mb3_bin
|
|
|
| idpresupuesto |
int
|
|
|
|
| coddir |
int
|
|
|
|
| codpais |
char(20)
|
utf8mb3_bin
|
|
|
| codpago |
char(10)
|
utf8mb3_bin
|
|
|
| servido |
char(10)
|
utf8mb3_bin
|
|
|
| totaleuros |
decimal(15,7)
|
|
|
|
| irpf |
decimal(10,7)
|
|
|
|
| ciudad |
char(100)
|
utf8mb3_bin
|
|
|
| codalmacen |
char(4)
|
utf8mb3_bin
|
|
|
| nombrecliente |
char(100)
|
utf8mb3_bin
|
|
|
| idpedido |
int
|
|
|
|
| codcliente |
char(6)
|
utf8mb3_bin
|
|
|
| observaciones |
mediumtext
|
utf8mb3_bin
|
|
|
| cifnif |
char(12)
|
utf8mb3_bin
|
|
|
| neto |
decimal(15,7)
|
|
|
|
| total |
decimal(15,7)
|
|
|
|
| apartado |
char(10)
|
utf8mb3_bin
|
|
|
| codigo |
char(12)
|
utf8mb3_bin
|
|
|
| fechasalida |
date
|
|
|
|