Informacion General

Principales Renglones de la Economía

Con una economía estable y diversificada, Colombia ha disfrutado del más consistente crecimiento de toda la América Latina durante varias décadas. El crecimiento se ha mantenido en años recientes por la expansión del sector de la construcción, de los servicios financieros y la llegada de capital del exterior, estas inversiones, en especial en la industria del petróleo, siguen aumentando a un ritmo elevado. Ahora el petróleo está desbancando los ingresos debidos al café, aunque los ingresos por el tráfico de drogas posiblemente superen a los de ambos. La economía que no depende del petróleo, crece a un ritmo más lento.

Los Principales Recursos Naturales: Petróleo, Gas Natural, Carbón, Mineral de Hierro, Níquel, Oro, Cobre, Esmeraldas.

Los productos Agrícolas Son: Café, Flores, Plátanos, Arroz, Tabaco, Maíz, Caña de Azúcar, Cacao, Judías (Frijol), Aceite de Semillas, Hortalizas,

Productos Forestales: Granjas de gambas.

Las principales industrias del País: Textiles, Agroalimentarias, Petróleo, Vestido y Calzado, Bebidas, Productos Químicos, Cemento, Oro, Carbón, Esmeraldas.

SELECT

T1.SHIPMENTID

,T1.NAME

,1010 AS RECID

,T2.VEHICLEBRANDID

,T2.PLATEID

,T2.YEAR

,T6.FIRSTNAME

,T6.MIDDLENAME

,T6.LASTNAME

,T6.LATCOBASICSECLASTNAME

,T8.INVOICEID

,T8.INVOICEAMOUNT

,T8.WEIGHT

,T9.IDENTIFICATIONNUMBER

,T10.NAME AS NAME1

,T10.NAMEALIAS

,T11.DESCRIPTION AS DESCRIPTION1

,T12.STREET

,T13.DESCRIPTION

,T14.NAME AS NAME2

,T16.STREET AS STREET1

--,T17.DESCRIPTION AS DESCRIPTION2

--,T18.NAME AS NAME3

--,T19.NAME AS NAME4

FROM

dbo.WMSSHIPMENT AS T1

LEFT OUTER JOIN dbo.SRF_VEHICLETABLE AS T2 ON T1.VEHICLEID = T2.VEHICLEID

LEFT OUTER JOIN dbo.SRF_VEHICLEDRIVERRELATION AS T5 ON T2.RECID = T5.VEHICLERECID

LEFT OUTER JOIN dbo.SRF_DRIVERTABLE AS T6 ON T5.DRIVERRECID = T6.RECID

--No Data

INNER JOIN dbo.WMSORDERTRANS AS T3 ON T1.SHIPMENTID = T3.SHIPMENTID

INNER JOIN dbo.SALESLINE AS T7 ON T3.INVENTTRANSID = T7.INVENTTRANSID

LEFT OUTER JOIN dbo.CUSTINVOICEJOUR AS T8 ON T7.SALESID = T8.SALESID --Problema con la facturacion

LEFT OUTER JOIN dbo.CUSTTABLE AS T9 ON T7.CUSTACCOUNT = T9.ACCOUNTNUM

LEFT OUTER JOIN dbo.DIRPARTYTABLE AS T10 ON T9.PARTY = T10.RECID

LEFT OUTER JOIN dbo.LOGISTICSPOSTALADDRESS AS T12 ON T10.PRIMARYADDRESSLOCATION = T12.LOCATION

LEFT OUTER JOIN dbo.LOGISTICSADDRESSDISTRICT AS T13 ON T12.DISTRICT = T13.RECID

LEFT OUTER JOIN dbo.LOGISTICSADDRESSCOUNTY AS T14 ON T12.STATE = T14.STATEID AND T12.COUNTY = T14.COUNTYID AND T12.COUNTRYREGIONID = T14.COUNTRYREGIONID

LEFT OUTER JOIN dbo.PAYMTERM AS T11 ON T9.PAYMTERMID = T11.PAYMTERMID

LEFT OUTER JOIN dbo.INVENTSITE AS T4 ON T1.INVENTSITEID = T4.SITEID

LEFT OUTER JOIN dbo.INVENTSITELOGISTICSLOCATION AS T15 ON T4.RECID = T15.SITE

LEFT OUTER JOIN dbo.LOGISTICSPOSTALADDRESS AS T16 ON T15.LOCATION = T16.LOCATION

--No Data

--

--LEFT OUTER JOIN dbo.LOGISTICSADDRESSDISTRICT AS T17 ON T16.DISTRICT = T17.RECID

--LEFT OUTER JOIN dbo.LOGISTICSADDRESSCOUNTY AS T18 ON T16.COUNTY = T18.COUNTYID AND T16.STATE = T18.STATEID AND T16.COUNTRYREGIONID = T18.COUNTRYREGIONID

--LEFT OUTER JOIN dbo.LOGISTICSADDRESSSTATE AS T19 ON T16.STATE = T19.STATEID AND T16.COUNTRYREGIONID = T19.COUNTRYREGIONID

WHERE

(NOT (T1.STATUS = 15))

AND (NOT (T3.EXPEDITIONSTATUS

...