== Descripción ==
== Composición ==
== Estructura ==
<pre>
</pre>
== SQL ==
<small><pre>
CREATE VIEW `visintdetpre` AS
SELECT 
	`vidquoten2`.`VidQuoteID` AS `VidQuoteID`,
	`vidquoten2`.`VidQuoteItem` AS `VidQuoteItem`,
	`vidquoten2`.`VidQuoteProdCantidad` AS `VidQuoteProdCantidad`,
	`vidquoten2`.`VidQuoteProdID` AS `VidQuoteProdID`,
	`vidquoten2`.`VidQuoteAncho` AS `VidQuoteAncho`,
	`vidquoten2`.`VidQuoteAlto` AS `VidQuoteAlto`,
	`visprodadic`.`ElementoID` AS `ElementoID`,
	`visprodadic`.`ValorElemento` AS `ValorElemento`,
	`visprodadic`.`ElementoPM` AS `ElementoPM`,
	`visprodadic`.`Descripcion` AS `Descripcion`,
	`visprodadic`.`Magnitud` AS `Magnitud`,
	(CASE `visprodadic`.`Magnitud`
		WHEN 'M2' THEN 
			((((((`vidquoten2`.`VidQuoteAlto` + `visprodadic`.`OffsetVanoAlto`) * `visprodadic`.`CoefVanoAlto`) * 
			((`vidquoten2`.`VidQuoteAncho` + `visprodadic`.`OffsetVanoAncho`) * `visprodadic`.`CoefVanoAncho`)) / 1000000) * 
			`visprodadic`.`ValorElemento`) * 
			(CASE `vidquoten2`.`VidQuoteLPre` 
				WHEN 1 THEN `visprodadic`.`PrecioProd01` 
				WHEN 2 THEN `visprodadic`.`PrecioProd02` 
				WHEN 3 THEN `visprodadic`.`PrecioProd03` END))
		WHEN 'PR' THEN 
			(((((((`vidquoten2`.`VidQuoteAlto` + `visprodadic`.`OffsetVanoAlto`) * 2) * 
			`visprodadic`.`CoefVanoAlto`) + (((`vidquoten2`.`VidQuoteAncho` + `visprodadic`.`OffsetVanoAncho`) * 2) * 
			`visprodadic`.`CoefVanoAncho`)) / 1000) * `visprodadic`.`ValorElemento`) * 
			(CASE `vidquoten2`.`VidQuoteLPre` 
				WHEN 1 THEN `visprodadic`.`PrecioProd01` 
				WHEN 2 THEN `visprodadic`.`PrecioProd02` 
				WHEN 3 THEN `visprodadic`.`PrecioProd03` END))
		WHEN 'ML' THEN 
			((((((`vidquoten2`.`VidQuoteAncho` + `visprodadic`.`OffsetVanoAncho`) * 2) * 
			`visprodadic`.`CoefVanoAncho`) / 1000) * `visprodadic`.`ValorElemento`) * 
			(CASE `vidquoten2`.`VidQuoteLPre` 
				WHEN 1 THEN `visprodadic`.`PrecioProd01` 
				WHEN 2 THEN `visprodadic`.`PrecioProd02` 
				WHEN 3 THEN `visprodadic`.`PrecioProd03` END))
		WHEN 'MG' THEN 
			((((((`vidquoten2`.`VidQuoteAlto` + `visprodadic`.`OffsetVanoAlto`) * `visprodadic`.`CoefVanoAlto`) + 
			((`vidquoten2`.`VidQuoteAncho` + `visprodadic`.`OffsetVanoAncho`) * `visprodadic`.`CoefVanoAncho`)) / 1000) * 
			`visprodadic`.`ValorElemento`) * 
			(CASE `vidquoten2`.`VidQuoteLPre` 
				WHEN 1 THEN `visprodadic`.`PrecioProd01` 
				WHEN 2 THEN `visprodadic`.`PrecioProd02` 
				WHEN 3 THEN `visprodadic`.`PrecioProd03` END))
		ELSE (`visprodadic`.`ValorElemento` * 
				(CASE `vidquoten2`.`VidQuoteLPre` 
					WHEN 1 THEN `visprodadic`.`PrecioProd01` 
					WHEN 2 THEN `visprodadic`.`PrecioProd02` 
					WHEN 3 THEN `visprodadic`.`PrecioProd03` END))
	END) AS `PrecioBase`
FROM (`visprodadic`
	JOIN `vidquoten2`)
WHERE (`visprodadic`.`ProductoID` = `vidquoten2`.`VidQuoteProdID`)

== Bitácora ==
== Uso ==
*[[MACRO:LookupData]]
*[[MACRO:NewResetListBoxDetalleProducto]]

== URL ==