== Composicion ==
*VISTA:vislineabs
*VISTA:visdetaobs
== Estructura ==
<pre>
</pre>
== SQL ==
<pre>
CREATE VIEW `visreppres` AS 
SELECT
    `vislineabs`.`VidQuoteID` AS `VidQuoteID`,
    `vislineabs`.`VidQuoteObra` AS `VidQuoteObra`,
    `vislineabs`.`VidQuoteCliente` AS `VidQuoteCliente`,
    `vislineabs`.`VidQuoteFecha` AS `VidQuoteFecha`,`vislineabs`.
    `VidQuoteItem` AS `VidQuoteItem`,
    `vislineabs`.`VidQuoteProdCantidad` AS `VidQuoteProdCantidad`,
    `vislineabs`.`VidQuoteProdID` AS `VidQuoteProdID`,
    IF(ISNULL(`visdetaobs`.`Observaciones`),
        `vislineabs`.`Descripcion`,
        CONCAT(
            `vislineabs`.`Descripcion`,
            ' (Incluye ',
            CONVERT(`visdetaobs`.`Observaciones` using utf8),')')) AS `VidQuoteDetalle`,
    `vislineabs`.`VidQuotePrecioS` AS `VidQuotePrecioS` 
FROM
    (`vislineabs` LEFT JOIN `visdetaobs` ON
    (((`visdetaobs`.`VidQuoteID` = `vislineabs`.`VidQuoteID`) AND 
    (`visdetaobs`.`VidQuoteItem` = `vislineabs`.`VidQuoteItem`))))
</pre>
== Bitácora ==
== Uso ==
== URL ==