Skip to content

Instantly share code, notes, and snippets.

@dafma
Created July 6, 2017 19:27
Show Gist options
  • Save dafma/f0e1b193269f267da62729aa45c3b808 to your computer and use it in GitHub Desktop.
Save dafma/f0e1b193269f267da62729aa45c3b808 to your computer and use it in GitHub Desktop.
CREATE TABLE logisticaembarques(
idEmbarque INT IDENTITY PRIMARY KEY,
forwater VARCHAR(100) NOT NULL,
numeroCont INT NOT NULL,
contFecha date not null,
numMercancia int not null,
puertoLLegada int not null,
fechabl date null,
fechaETA date null,
fechaCEDIS date null,
Fechapreventa date null,
puertoOrigen varchar(50) null,
kilogramos decimal(7,2),
cbm SMALLINT null,
TipoContenedor varchar(1) null,
agenteAduanal varchar(20) null,
numeroDeFacturaForwater int null,
programacionPago date null,
fleteMaritimoOriginal decimal(7,2),
fechaPagoPedimenmto date null,
fechaPago date null,
fechaDeArriboAFerrocarril date null,
fechaSolicitudFerrocarril date null,
fechaGondola date null,
fechaPantaco date null,
fechaDeLlEgadaInterauto date null,
fechaDesanuaduanizado date null,
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment