| id |
bigint(20)
|
|
|
|
| empresa_id |
bigint(20)
|
|
|
|
| serie |
varchar(10)
|
utf8_general_ci
|
|
|
| correlativo |
int(11)
|
|
|
|
| tipo_documento |
varchar(20)
|
utf8_general_ci
|
|
|
| tipo_doc_identidad |
varchar(10)
|
utf8_general_ci
|
|
|
| ruc_destinatario |
varchar(20)
|
utf8_general_ci
|
|
|
| razon_social_destinatario |
varchar(200)
|
utf8_general_ci
|
|
|
| correo_destinatario |
varchar(100)
|
utf8_general_ci
|
|
|
| fecha_emision |
date
|
|
|
|
| fecha_traslado |
date
|
|
|
|
| fecha_vencimiento |
date
|
|
|
|
| tipo_traslado |
varchar(50)
|
utf8_general_ci
|
|
|
| observaciones |
text
|
utf8_general_ci
|
|
|
| nro_fb |
varchar(50)
|
utf8_general_ci
|
|
|
| medida_peso_bruto |
varchar(20)
|
utf8_general_ci
|
|
|
| total_medida |
decimal(12,3)
|
|
|
|
| tipo_doc |
varchar(30)
|
utf8_general_ci
|
|
|
| moneda |
varchar(20)
|
utf8_general_ci
|
|
|
| establecimiento |
varchar(100)
|
utf8_general_ci
|
|
|
| punto_partida_id |
bigint(20)
|
|
|
|
| punto_llegada_id |
bigint(20)
|
|
|
|
| modalidad |
varchar(50)
|
utf8_general_ci
|
|
|
| transportista_ruc |
varchar(20)
|
utf8_general_ci
|
|
|
| transportista_razon_social |
varchar(200)
|
utf8_general_ci
|
|
|
| mtc_transp |
varchar(20)
|
utf8_general_ci
|
|
|
| tipo_doc_conductor |
varchar(10)
|
utf8_general_ci
|
|
|
| conductor_id |
bigint(20)
|
|
|
|
| dni_conductor |
varchar(20)
|
utf8_general_ci
|
|
|
| nombre_chofer |
varchar(200)
|
utf8_general_ci
|
|
|
| licencia_conducir |
varchar(20)
|
utf8_general_ci
|
|
|
| vehiculo_id |
bigint(20)
|
|
|
|
| tipo_vehiculo |
varchar(50)
|
utf8_general_ci
|
|
|
| placa_principal |
varchar(10)
|
utf8_general_ci
|
|
|
| numero_tuc_principal |
varchar(50)
|
utf8_general_ci
|
|
|
| marca_vehiculo |
varchar(50)
|
utf8_general_ci
|
|
|
| registro_mtc |
varchar(50)
|
utf8_general_ci
|
|
|
| certificado_inscripcion |
varchar(50)
|
utf8_general_ci
|
|
|
| vehiculo_secundario_id |
bigint(20)
|
|
|
|
| placa_secundaria |
varchar(10)
|
utf8_general_ci
|
|
|
| numero_tuc_secundario |
varchar(50)
|
utf8_general_ci
|
|
|
| registro_mtc_secundario |
varchar(50)
|
utf8_general_ci
|
|
|
| certificado_inscripcion_secundario |
varchar(50)
|
utf8_general_ci
|
|
|
| peso_bruto |
decimal(12,3)
|
|
|
|
| peso_neto |
decimal(12,3)
|
|
|
|
| numero_bultos |
int(11)
|
|
|
|
| transbordo_programado |
tinyint(4)
|
|
|
|
| registrar_vehiculos_transportista |
tinyint(4)
|
|
|
|
| traslado_m1_l |
tinyint(4)
|
|
|
|
| subtotal |
decimal(12,2)
|
|
|
|
| igv |
decimal(12,2)
|
|
|
|
| total_venta |
decimal(12,2)
|
|
|
|
| inafecto |
decimal(12,2)
|
|
|
|
| exon |
decimal(12,2)
|
|
|
|
| estado |
tinyint(4)
|
|
|
|
| sunat |
varchar(100)
|
utf8_general_ci
|
|
|
| user_created_id |
bigint(20)
|
|
|
|
| user_updated_id |
bigint(20)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
