| fecha |
date
|
|
|
|
| codejercicio |
varchar(4)
|
latin1_swedish_ci
|
|
|
| totalirpf |
decimal(15,7)
|
|
|
|
| cifnif |
varchar(12)
|
latin1_swedish_ci
|
|
|
| direccion |
varchar(100)
|
latin1_swedish_ci
|
|
|
| observaciones |
mediumtext
|
latin1_swedish_ci
|
|
|
| tpv |
tinyint(1)
|
|
|
|
| coddir |
int
|
|
|
|
| ciudad |
varchar(100)
|
latin1_swedish_ci
|
|
|
| tasaconv |
decimal(14,8)
|
|
|
|
| codpais |
varchar(20)
|
latin1_swedish_ci
|
|
|
| totaliva |
decimal(15,7)
|
|
|
|
| idasiento |
int
|
|
|
|
| total |
decimal(15,7)
|
|
|
|
| idfacturarect |
int
|
|
|
|
| codserie |
char(2)
|
latin1_swedish_ci
|
|
|
| porcomision |
decimal(10,7)
|
|
|
|
| totaleuros |
decimal(15,7)
|
|
|
|
| nombrecliente |
varchar(100)
|
latin1_swedish_ci
|
|
|
| neto |
decimal(15,7)
|
|
|
|
| codagente |
varchar(10)
|
latin1_swedish_ci
|
|
|
| codcliente |
varchar(6)
|
latin1_swedish_ci
|
|
|
| codpago |
varchar(10)
|
latin1_swedish_ci
|
|
|
| codalmacen |
varchar(4)
|
latin1_swedish_ci
|
|
|
| coddivisa |
char(3)
|
latin1_swedish_ci
|
|
|
| totalrecargo |
decimal(17,7)
|
|
|
|
| deabono |
tinyint(1)
|
|
|
|
| nogenerarasiento |
tinyint(1)
|
|
|
|
| codigo |
varchar(12)
|
latin1_swedish_ci
|
|
|
| idprovincia |
int
|
|
|
|
| recfinanciero |
decimal(10,7)
|
|
|
|
| idpagodevol |
int
|
|
|
|
| numero |
varchar(12)
|
latin1_swedish_ci
|
|
|
| editable |
tinyint(1)
|
|
|
|
| codpostal |
varchar(10)
|
latin1_swedish_ci
|
|
|
| automatica |
tinyint(1)
|
|
|
|
| provincia |
varchar(100)
|
latin1_swedish_ci
|
|
|
| codigorect |
varchar(12)
|
latin1_swedish_ci
|
|
|
| apartado |
varchar(10)
|
latin1_swedish_ci
|
|
|
| irpf |
decimal(10,7)
|
|
|
|
| idfactura |
int
|
|
|
|
