== Composicion ==
*[[TABLA:vidquoten1]]
*[[TABLA:vidquoten2]]
*[[TABLA:productos]]
*[[VISTA:vissubxitem]]
== Estructura ==
<pre>
</pre>
== SQL ==
<pre>
CREATE VIEW `fzggestion`.`vislineabs` AS 
SELECT 
    `fzggestion`.`vidquoten2`.`VidQuoteID` AS `VidQuoteID`,
    `fzggestion`.`vidquoten1`.`VidQuoteObra` AS `VidQuoteObra`,
    `fzggestion`.`vidquoten1`.`VidQuoteCliente` AS `VidQuoteCliente`,
    `fzggestion`.`vidquoten1`.`VidQuoteFecha` AS `VidQuoteFecha`,
    `fzggestion`.`vidquoten1`.`VidQuoteEstado` AS `VidQuoteEstado`,
    `fzggestion`.`vidquoten2`.`VidQuoteItem` AS `VidQuoteItem`,
    `fzggestion`.`vidquoten2`.`VidQuoteProdCantidad` AS `VidQuoteProdCantidad`,
    `fzggestion`.`vidquoten2`.`VidQuoteProdID` AS `VidQuoteProdID`,
    IF((`fzggestion`.`vidquoten2`.`VidQuoteAncho` > 0),
    IF((`fzggestion`.`vidquoten2`.`VidQuoteAlto` > 0),
        CONCAT(CONVERT(`fzggestion`.`productos`.`Descripcion` USING utf8),
            ' -Dimension(mm): ',
            LPAD(CAST(`fzggestion`.`vidquoten2`.`VidQuoteAncho` AS CHAR charset utf8),4,'0000'),
            'x',
            LPAD(CAST(`fzggestion`.`vidquoten2`.`VidQuoteAlto` AS CHAR charset utf8),4,'0000'),
            '-'),
        CONCAT(CONVERT(`fzggestion`.`productos`.`Descripcion` USING utf8),
            ' -Largo(mm): ',
            LPAD(CAST(`fzggestion`.`vidquoten2`.`VidQuoteAncho` AS CHAR charset utf8),4,'0000'),
            'mm-')),
            CONVERT(`fzggestion`.`productos`.`Descripcion` using utf8)) AS `Descripcion`,
    `vissubxitem`.`VidQuotePrecioS` AS `VidQuotePrecioS` 
FROM
    (((`fzggestion`.`vidquoten1` JOIN 
    `fzggestion`.`vidquoten2`) JOIN 
    `fzggestion`.`productos`) JOIN 
    `fzggestion`.`vissubxitem`) 
WHERE
    ((`fzggestion`.`vidquoten1`.`VidQuoteID` = `fzggestion`.`vidquoten2`.`VidQuoteID`) AND 
    (`fzggestion`.`productos`.`ProductoID` = `fzggestion`.`vidquoten2`.`VidQuoteProdID`) AND 
    (`vissubxitem`.`VidQuoteID` = `fzggestion`.`vidquoten2`.`VidQuoteID`) AND 
    (`vissubxitem`.`VidQuoteItem` = `fzggestion`.`vidquoten2`.`VidQuoteItem`))
</pre>
== Bitácora ==
== Uso ==
== URL ==