https://docs.plurivaerp.com/index.php?action=history&feed=atom&title=PV_Iesire_-_Pv_iesire_pret_amanunt PV Iesire - Pv iesire pret amanunt - Revision history 2026-04-28T00:14:06Z Revision history for this page on the wiki MediaWiki 1.35.0 https://docs.plurivaerp.com/index.php?title=PV_Iesire_-_Pv_iesire_pret_amanunt&diff=49581&oldid=prev Ana Marinescu at 11:48, 16 February 2026 2026-02-16T11:48:04Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:48, 16 February 2026</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l159" >Line 159:</td> <td colspan="2" class="diff-lineno">Line 159:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>;DenumireTipProdus </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>;DenumireTipProdus </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>;NumarIesCodBare    </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>;NumarIesCodBare    </div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , LA.</del>DenumireLocatieAsset</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DenumireLocatieAsset</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , proipoz.DenumireProiect AS </del>DenumireProiectPoz</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DenumireProiectPoz</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , proipoz.NrProiect AS </del>NrProiectPoz</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>NrProiectPoz</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , isProd.attr1 AS </del>attr1prod</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>attr1prod</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , isProd.attr2 AS </del>attr2prod</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>attr2prod</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , isProd.attr3 AS </del>attr3prod</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>attr3prod</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , isProd.attr4 AS </del>attr4prod</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>attr4prod</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ISNULL(tblPartner_FirmaCap.Attr1, '') AS </del>Attr1n</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>Attr1n</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , CAST('*' +doc.DocCode+ CAST(iscap.IesCapId AS NVARCHAR(MAX)) + '*'AS NVARCHAR(MAX))  AS </del>IesCapIdCB</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>IesCapIdCB</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,isProd.DenumireProdus,ispoz.DenumireProdus,isProd.DenumireProdus) AS </del>DenumireProdusOrdonare</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DenumireProdusOrdonare</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ISNULL(pf.cod, '') AS  </del>CodProdusFinit  </div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>CodProdusFinit  </div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ISNULL(pf.denumireprodus, '') AS </del>DenumireProdusFinit</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DenumireProdusFinit</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ISNULL(scpf.SOrderNumber , '') + ISNULL('-' + CONVERT(VARCHAR(10) , scpf.SOrderDate , 103) , '') AS </del>Comanda</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>Comanda</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ROUND(ispoz.CantIesire * isnull(ispoz.PretCost, 0), @SetareZecimale) AS </del>ValoarePozitiePretCost</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>ValoarePozitiePretCost</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ROUND(ispoz.CantIesire * isnull(ispoz.PretCost, 0) * ISNULL(ispoz.Tva,0) / 100, @SetareZecimale) AS </del>ValoareTvaPozitiePretCost</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>ValoareTvaPozitiePretCost</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , proi.</del>DescriereProiect</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DescriereProiect</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , a.Asset AS </del>AssetFolosit</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>AssetFolosit</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , apoz.Asset AS </del>AssetFolositPoz</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>AssetFolositPoz</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , YEAR(iscap.DataIes) AS </del>An</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>An</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , MONTH(iscap.DataIes) AS </del>Luna</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>Luna</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , DAY(iscap.DataIes) AS </del>Zi</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>Zi</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , apoz.</del>ValoareNeamortizata</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>ValoareNeamortizata</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , dm.</del>Motiv</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>Motiv</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , dmp.Motiv AS </del>MotivPoz</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>MotivPoz</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ass.NrInventar AS </del>NumarInventar</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>NumarInventar</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,isProd.CodBare as </del>Codbareprodus</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>Codbareprodus</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,isProd.attr3 as </del>attr3produs</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>attr3produs</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,isProd.ZileGarantie as </del>ZileGarantieProdus</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>ZileGarantieProdus</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,  CAST(ROW_NUMBER() OVER (  ORDER BY --MAX(iespoz.ordine)</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>NrPozitie</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> CASE WHEN ISNULL(@setare5,1) = 1</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>LotIntrareProdusFinit</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                              THEN CASE WHEN @Setare391 = 0 OR (@setare391 in (1,2) AND @setare422 = 0)</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DataExpirareProdusFinit</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                      THEN COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus)</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>UMAlt</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                      WHEN @Setare391 = 1 AND @Setare422 = 1</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>CodBareAlt</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                      THEN COALESCE(ispoz.CodProdusAfisare + ' ',</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>ObservatiiInternePoz</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                    CPC.CodProdusClient + ' ',isProd.Cod + ' ','')</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DataIntr</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                          + COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus)</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>Furn_Attr1</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                      WHEN @Setare391 = 2 AND @Setare422 = 1</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>FurnizorOriginal</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                      THEN COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus) + COALESCE(' '</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DenumireCategorieProdus</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                                                + ispoz.CodProdusAfisare,</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>NrBonFiscal</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                                                ' '</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>NrFacturaClientAmanunt</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                                                + CPC.CodProdusClient,</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DataFacturaClientAmanunt  </div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                                                ' ' + isProd.Cod,'')</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>TaraOrigine</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                    END</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>BucPeBax</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                          END</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>CodProdusClient</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                        , CASE WHEN @Setare5 = 2</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DataFabricareProdusFinit</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                                THEN ispoz.IesPozId</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>CantitateIntrareIntrare</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                          END  </del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DataExpirareIntrare</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , CASE WHEN @setare5 = 3</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>DataFabricareIntrare</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                                  THEN ispoz.ordine</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>LotIntrareIntrare</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                                                                              END ) AS INT) AS </del>NrPozitie</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">;</ins>PrimaDataBonConsum</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ppff.LotIntrare AS </del>LotIntrareProdusFinit</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , CONVERT(VARCHAR(50),ppff.DataExpirare, 103) AS </del>DataExpirareProdusFinit</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,UMAlt.UM AS </del>UMAlt</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,CodBareAlt.CodBare AS </del>CodBareAlt</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , ispoz.ObservatiiInterne as </del>ObservatiiInternePoz</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                , CONVERT(VARCHAR(50),porig.DataIntr, 103) as </del>DataIntr</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                , furn.</del>Furn_Attr1</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                , forig.DenumireUnitate as </del>FurnizorOriginal</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">                , catprod.DenumireCategorieProdus as </del>DenumireCategorieProdus</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , iscap.NrBonFiscal as </del>NrBonFiscal</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , COALESCE(fact.NumarFactIes, fact.NumarIes, '') AS </del>NrFacturaClientAmanunt</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , CONVERT(VARCHAR(10), ISNULL(fact.DataFactIes, fact.DataIes), 103) AS </del>DataFacturaClientAmanunt  </div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,torig.DenumireTara AS </del>TaraOrigine</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,CASE WHEN ISNULL(isProd.bucatiBAX,0) = 0 THEN NULL ELSE inv.NumarZecimale(2,ispoz.CantIesire / isProd.bucatiBAX) END AS </del>BucPeBax</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> ,ISNULL(CPC.CodProdusClient,isprod.Cod) as </del>CodProdusClient</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , CONVERT(VARCHAR(50),ppff.DataFabricare, 103) as </del>DataFabricareProdusFinit</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , pfi.</del>CantitateIntrareIntrare<del class="diffchange diffchange-inline">,pfi.</del>DataExpirareIntrare<del class="diffchange diffchange-inline">,pfi.</del>DataFabricareIntrare<del class="diffchange diffchange-inline">,pfi.</del>LotIntrareIntrare</div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> , bc.</del>PrimaDataBonConsum</div></td><td colspan="2"> </td></tr> </table> Ana Marinescu https://docs.plurivaerp.com/index.php?title=PV_Iesire_-_Pv_iesire_pret_amanunt&diff=49580&oldid=prev Ana Marinescu: Created page with "*Pv iesire **Pv iesire pret amanunt ===Campuri=== ;IesCapId ;Text_Ro ;Counter ;TipDoc ;DenumireFirma ;DenumireDivizie ;TipLivrare ;Urgenta ;ValoareTotala ;Val..." 2026-02-16T11:44:03Z <p>Created page with &quot;*<a href="/index.php?title=Pv_iesire" title="Pv iesire">Pv iesire</a> **Pv iesire pret amanunt ===Campuri=== ;IesCapId ;Text_Ro ;Counter ;TipDoc ;DenumireFirma ;DenumireDivizie ;TipLivrare ;Urgenta ;ValoareTotala ;Val...&quot;</p> <p><b>New page</b></p><div>*[[Pv_iesire|Pv iesire]]<br /> **Pv iesire pret amanunt<br /> <br /> <br /> ===Campuri===<br /> ;IesCapId<br /> ;Text_Ro<br /> ;Counter<br /> ;TipDoc<br /> ;DenumireFirma<br /> ;DenumireDivizie<br /> ;TipLivrare<br /> ;Urgenta <br /> ;ValoareTotala<br /> ;ValoareTotalaFaraTVA<br /> ;ValoareTva<br /> ;Valoare<br /> ;Furnizor<br /> ;Adresa_furnizor<br /> ;DenumireProdus<br /> ;CodProdus<br /> ;TipItem<br /> ;UM<br /> ;Greutate<br /> ;GreutateBruta<br /> ;GreutateNetaProdus<br /> ;GreutateNeta<br /> ;DenumireGestiune<br /> ;CodGestiune<br /> ;PretCost<br /> ;NumarFactura<br /> ;Numar<br /> ;NumarComanda<br /> ;DataFactura<br /> ;Data<br /> ;DataValidare <br /> ;DataCreare<br /> ;DataAnulare<br /> ;FirmaId<br /> ;Observatii<br /> ;DelegNume <br /> ;DelegAct<br /> ;DelegElibAct <br /> ;DelegAuto <br /> ;ObservatiiInterne<br /> ;Explicatii1<br /> ;Explicatii2<br /> ;Retur <br /> ;TermenGarantie<br /> ;SerialNumber<br /> ;CentruCostPozitie<br /> ;DenCentruCostPozitie<br /> ;CodArticolBuget<br /> ;DenumireArticolBuget<br /> ;DataValidarePlata<br /> ;DataScadenta<br /> ;CapitalSocial<br /> ;iespozid<br /> ;IntrPoziD<br /> ;IesPozRefId<br /> ;CantDocument<br /> ;Cantiesire<br /> ;CodProducator<br /> ;DiscountPozitie<br /> ;TvaDiscountPozitie<br /> ;PretVanzare<br /> ;PretAmanunt<br /> ;ValoarePozitie<br /> ;ValoareTvaPozitie<br /> ;TotalPlataPePozitie<br /> ;PretVanzareRedus <br /> ;Tva <br /> ;PozExplicatii1<br /> ;PozExplicatii2<br /> ;DataExpirareFactura <br /> ;DataFabricare<br /> ;DataExpirare<br /> ;UserValidare <br /> ;BIActRU<br /> ;CNPRU<br /> ;Client<br /> ;Client_Unitate<br /> ;Client_Partener<br /> ;Cont <br /> ;DenumireBanca<br /> ;CodFiscal<br /> ;Adresa <br /> ;DenumireJudet<br /> ;Client_NrRegComertului<br /> ;Agent<br /> ;Traseu<br /> ;ListaTva<br /> ;DataCurenta<br /> ;OraCurenta<br /> ;LotIntrare<br /> ;FlagConta<br /> ;ContCreditor<br /> ;CodProdusDiv<br /> ;NrCmdProd<br /> ;DataCmdProd<br /> ;ClsComandaProductie<br /> ;LotFactura<br /> ;Lot<br /> ;CentruCost<br /> ;DenCentruCost<br /> ;SirNumeGestionari<br /> ;NrCrt<br /> ;AgentFurnizorFunctie<br /> ;AgentFurnizor<br /> ;AgentFurnizorTelefon<br /> ;Bloc_client<br /> ;Scara_client<br /> ;Etaj_client<br /> ;Apartament_client<br /> ;DenumireTara_client<br /> ;DenumireJudet_client<br /> ;DenumireLocalitate_client<br /> ;Bloc_furnizor<br /> ;Scara_furnizor<br /> ;Etaj_furnizor<br /> ;Apartament_furnizor<br /> ;DenumireTara_furnizor<br /> ;DenumireJudet_furnizor<br /> ;DenumireLocalitate_furnizor<br /> ;Furnizor_CodFiscal<br /> ;Furnizor_NrRegComertului<br /> ;Furnizor_Adresa<br /> ;Furnizor_AdresaSediu<br /> ;Furnizor_AdresaPunctL<br /> ;Furnizor_Cont<br /> ;Furnizor_Banca<br /> ;ClientId<br /> ;Client_AtributFiscal<br /> ;Furnizor_AtributFiscal<br /> ;UserCreare<br /> ;CNP_UserCreare<br /> ;SoldClient<br /> ;Insolventa<br /> ;CSSV<br /> ;CodBare<br /> ;SOrderNumber<br /> ;SOrderDate<br /> ;Locatie<br /> ;ClientComanda<br /> ;Produs<br /> ;DenumireFirmaCrt<br /> ;CodFiscalCRT<br /> ;AdresaCRT<br /> ;Comenzi_clienti<br /> ;attr1<br /> ;attr2<br /> ;Antet<br /> ;Antet1<br /> ;Footer<br /> ;NrProiect<br /> ;DenumireProiect<br /> ;NumarIntern<br /> ;AttrProd2<br /> ;DenumireTipProdus <br /> ;NumarIesCodBare <br /> , LA.DenumireLocatieAsset<br /> , proipoz.DenumireProiect AS DenumireProiectPoz<br /> , proipoz.NrProiect AS NrProiectPoz<br /> , isProd.attr1 AS attr1prod<br /> , isProd.attr2 AS attr2prod<br /> , isProd.attr3 AS attr3prod<br /> , isProd.attr4 AS attr4prod<br /> , ISNULL(tblPartner_FirmaCap.Attr1, '') AS Attr1n<br /> , CAST('*' +doc.DocCode+ CAST(iscap.IesCapId AS NVARCHAR(MAX)) + '*'AS NVARCHAR(MAX)) AS IesCapIdCB<br /> , COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,isProd.DenumireProdus,ispoz.DenumireProdus,isProd.DenumireProdus) AS DenumireProdusOrdonare<br /> , ISNULL(pf.cod, '') AS CodProdusFinit <br /> , ISNULL(pf.denumireprodus, '') AS DenumireProdusFinit<br /> , ISNULL(scpf.SOrderNumber , '') + ISNULL('-' + CONVERT(VARCHAR(10) , scpf.SOrderDate , 103) , '') AS Comanda<br /> , ROUND(ispoz.CantIesire * isnull(ispoz.PretCost, 0), @SetareZecimale) AS ValoarePozitiePretCost<br /> , ROUND(ispoz.CantIesire * isnull(ispoz.PretCost, 0) * ISNULL(ispoz.Tva,0) / 100, @SetareZecimale) AS ValoareTvaPozitiePretCost<br /> , proi.DescriereProiect<br /> , a.Asset AS AssetFolosit<br /> , apoz.Asset AS AssetFolositPoz<br /> , YEAR(iscap.DataIes) AS An<br /> , MONTH(iscap.DataIes) AS Luna<br /> , DAY(iscap.DataIes) AS Zi<br /> , apoz.ValoareNeamortizata<br /> , dm.Motiv<br /> , dmp.Motiv AS MotivPoz<br /> , ass.NrInventar AS NumarInventar<br /> ,isProd.CodBare as Codbareprodus<br /> ,isProd.attr3 as attr3produs<br /> ,isProd.ZileGarantie as ZileGarantieProdus<br /> , CAST(ROW_NUMBER() OVER ( ORDER BY --MAX(iespoz.ordine)<br /> CASE WHEN ISNULL(@setare5,1) = 1<br /> THEN CASE WHEN @Setare391 = 0 OR (@setare391 in (1,2) AND @setare422 = 0)<br /> THEN COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus)<br /> WHEN @Setare391 = 1 AND @Setare422 = 1<br /> THEN COALESCE(ispoz.CodProdusAfisare + ' ',<br /> CPC.CodProdusClient + ' ',isProd.Cod + ' ','')<br /> + COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus)<br /> WHEN @Setare391 = 2 AND @Setare422 = 1<br /> THEN COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus) + COALESCE(' '<br /> + ispoz.CodProdusAfisare,<br /> ' '<br /> + CPC.CodProdusClient,<br /> ' ' + isProd.Cod,'')<br /> END<br /> END<br /> , CASE WHEN @Setare5 = 2<br /> THEN ispoz.IesPozId<br /> END <br /> , CASE WHEN @setare5 = 3<br /> THEN ispoz.ordine<br /> END ) AS INT) AS NrPozitie<br /> , ppff.LotIntrare AS LotIntrareProdusFinit<br /> , CONVERT(VARCHAR(50),ppff.DataExpirare, 103) AS DataExpirareProdusFinit<br /> ,UMAlt.UM AS UMAlt<br /> ,CodBareAlt.CodBare AS CodBareAlt<br /> , ispoz.ObservatiiInterne as ObservatiiInternePoz<br /> , CONVERT(VARCHAR(50),porig.DataIntr, 103) as DataIntr<br /> , furn.Furn_Attr1<br /> , forig.DenumireUnitate as FurnizorOriginal<br /> , catprod.DenumireCategorieProdus as DenumireCategorieProdus<br /> , iscap.NrBonFiscal as NrBonFiscal<br /> , COALESCE(fact.NumarFactIes, fact.NumarIes, '') AS NrFacturaClientAmanunt<br /> , CONVERT(VARCHAR(10), ISNULL(fact.DataFactIes, fact.DataIes), 103) AS DataFacturaClientAmanunt <br /> ,torig.DenumireTara AS TaraOrigine<br /> ,CASE WHEN ISNULL(isProd.bucatiBAX,0) = 0 THEN NULL ELSE inv.NumarZecimale(2,ispoz.CantIesire / isProd.bucatiBAX) END AS BucPeBax<br /> ,ISNULL(CPC.CodProdusClient,isprod.Cod) as CodProdusClient<br /> , CONVERT(VARCHAR(50),ppff.DataFabricare, 103) as DataFabricareProdusFinit<br /> , pfi.CantitateIntrareIntrare,pfi.DataExpirareIntrare,pfi.DataFabricareIntrare,pfi.LotIntrareIntrare<br /> , bc.PrimaDataBonConsum</div> Ana Marinescu