|
|
| (One intermediate revision by the same user not shown) |
| Line 12: |
Line 12: |
| | ;Numar comanda client | | ;Numar comanda client |
| | ;Data comanda client | | ;Data comanda client |
| − | ;Luna comanda furnizor | + | ;Data comenzii client |
| − | ;An comanda furnizor | + | ;Luna comanda client |
| | + | ;An comanda client |
| | ;Client | | ;Client |
| | ;Furnizor | | ;Furnizor |
| Line 22: |
Line 23: |
| | ;Data comanda de la furnizor | | ;Data comanda de la furnizor |
| | ;Data comanda furnizor | | ;Data comanda furnizor |
| − | ;Data incarcare
| |
| | ;Agent | | ;Agent |
| | ;Cantitate comanda client | | ;Cantitate comanda client |
| − | ;Valoare comanda client
| + | ;Cantitate comanda furnizor] |
| − | ;Valoare vanzare - Valuta
| + | ;Produs |
| − | ;Cantitate comanda furnizor | + | ;Cod produs |
| − | ;Cantitate receptionata furnizor
| |
| − | ;Diferente cantitate flag
| |
| − | ;Cantitate nereceptionata
| |
| − | ;Valoare nereceptionata
| |
| − | ;Valoarea achizitie nereceptionata - Valuta curs
| |
| − | ;Produs | |
| − | ;UM | |
| | ;Cod produs furnizor | | ;Cod produs furnizor |
| − | , COALESCE(ocp.DenProdusFurnizor,fp.DenumireProdusFurnizor,p.DenProdusFabricant) AS [Denumire produs furnizor]
| + | ;Denumire produs furnizor |
| − | , sp.PretValuta AS [Pret vanzare]
| + | ;Pret vanzare |
| − | , sp.PretValutaRedus AS [Pret vanzare redus]
| + | ;Pret vanzare redus |
| − | , sp.ValutaID AS [Valuta vanzare]
| + | ;Valuta vanzare |
| − | , sp.PretLista AS [Pret lista]
| + | ;Pret lista |
| − | , pp.PretValuta AS [Pret comanda furnizor]
| + | ;Pret comanda furnizor |
| − | , case when ip.PretIntrareValuta<>pp.PretValuta then 1 else 0 end as [Diferente pret flag]
| + | ;Valoare comanda furnizor |
| − | , pp.PretValuta * pp.Cant AS [Valoare comanda furnizor]
| + | ;Valuta comanda furnizor |
| − | , pp.PretValuta*pp.Cant --(pp.PretValuta + ISNULL(pp.CostTransport,0)) * pp.Cant
| + | ;Adresa livrare |
| − | * CASE WHEN ISNULL(pc.ValutaId,@valutaDefaultId) <> ISNULL(@ValutaID,@valutaDefaultid)
| + | ;Termen livrare |
| − | THEN ISNULL(dbo.GetCurs(pc.ValutaId,getdate()),1) / ISNULL(NULLIF(dbo.GetCurs(@ValutaId,getdate()),0),1)
| + | ;Observatii comanda client |
| − | ELSE 1
| + | ;Data DVI |
| − | END
| + | ;Numar DVI |
| − | + (ISNULL(pp.CostTransport,0)
| + | ;Numar factura |
| − | * CASE WHEN ISNULL(pp.ValutaTransportId,@valutaDefaultId) <> ISNULL(pp.ValutaTransportId,@valutaDefaultid)
| + | ;Data factura |
| − | THEN ISNULL(dbo.GetCurs(pp.ValutaTransportId,getdate()),1) / ISNULL(NULLIF(dbo.GetCurs(@ValutaId,getdate()),0),1)
| + | ;Data receptie |
| − | ELSE 1
| + | ;Cantitate intrata |
| − | END) AS [Valoare achizitie - Valuta curs]--DA
| + | ;Serie intrare |
| − | , pp.PretValuta * pp.Cant -- (pp.PretValuta + ISNULL(pp.CostTransport,0)) * pp.Cant
| + | ;Data expirare |
| − | * CASE WHEN ISNULL(pc.ValutaId,@valutaDefaultId) <> ISNULL(@ValutaID,@valutaDefaultid)
| + | ;Lot intrare |
| − | THEN ISNULL(dbo.GetCurs(pc.ValutaId,pc.PorderDate),1) / ISNULL(NULLIF(dbo.GetCurs(@ValutaId,pc.PorderDate),0),1)
| + | ;Data fabricare |
| − | ELSE 1
| + | ;Pret intrare valuta |
| − | END
| + | ;Valuta intrare |
| − | + (ISNULL(pp.CostTransport,0)
| + | ;Taxe vamale |
| − | * CASE WHEN ISNULL(pp.ValutaTransportId,@valutaDefaultId) <> ISNULL(@ValutaID,@valutaDefaultid)
| + | ;Comision vamal |
| − | THEN ISNULL(dbo.GetCurs(pp.ValutaTransportId,pc.PorderDate),1) / ISNULL(NULLIF(dbo.GetCurs(@ValutaId,pc.PorderDate),0),1)
| + | ;Stare comanda furnizor |
| − | ELSE 1
| + | ;Stare comanda client |
| − | END) AS [Valoare achizitie - Valuta]
| + | ;De comandat |
| − | , pp.Cant * isnull(sp.Pretvalutaredus,sp.pretvaluta)
| + | ;Furnizor comanda |
| − | * CASE WHEN ISNULL(sp.ValutaId,@ValutaDefaultID) <> ISNULL(@ValutaId,@ValutaDefaultId)
| + | ;Observatii comanda furnizor |
| − | THEN ISNULL(sp.CursValutar,1) / ISNULL(NULLIF(dbo.GetCurs(@ValutaId,pc.PorderDate),0),1)
| + | ;Cost asigurare |
| − | ELSE 1
| + | ;Valuta cost asigurare |
| − | END - (pp.PretValuta + ISNULL(pp.CostTransport,0)) * pp.Cant
| + | ;Cost transport |
| − | * CASE WHEN ISNULL(pc.ValutaId,@valutaDefaultId) <> ISNULL(@ValutaID,@valutaDefaultid)
| + | ;Valuta cost transport |
| − | THEN ISNULL(dbo.GetCurs(pc.ValutaId,pc.PorderDate),1) / ISNULL(NULLIF(dbo.GetCurs(@ValutaId,pc.PorderDate),0),1)
| + | ;Cost impachetare |
| − | ELSE 1
| + | ;Valuta cost impachetare |
| − | END AS [Adaos]
| + | ;Numar tracking |
| − | , pc.ValutaId AS [Valuta comanda furnizor]
| + | ;Transportator |
| − | , ISNULL(cll.Adresa,'') + ISNULL('LC:' + sp.AdresaLivrare,'') + ISNULL('LF:' + pp.AdresaLivrare,'') AS [Adresa livrare]
| + | ;Cantitate livrata |
| − | , isnull(pp.DataLivrare,pc.DataLivrare) AS [Termen livrare]
| + | ;Proiect client |
| − | , ISNULL(sc.Observatii + ' ','') + ISNULL(sp.Observatii,'') AS [Observatii comanda client]
| + | ;Proiect furnizor |
| − | , ic.DataDVI AS [Data DVI]
| + | ;Tip client |
| − | , ic.NumarDVI AS [Numar DVI]
| + | ;Cod Client |
| − | , ic.NumarFactIntr AS [Numar factura]
| + | ;Atribut1 Client |
| − | , ic.DataFactIntr AS [Data factura]
| + | ;Tip livrare |
| − | , ISNULL(ic.[DataReceptie], ic.DataIntr) AS [Data receptie]
| + | ;Termen plata |
| − | , ip.CantIntrare AS [Cantitate intrata]
| + | ;Mod plata |
| − | , ip.SerieIntrare AS [Serie intrare]
| + | ;Data livrare comanda client |
| − | , ip.DataExpirare AS [Data expirare]
| + | ;Numar intern |
| − | , ip.LotIntrare AS [Lot intrare]
| + | ;Data livrare comanda furnizor |
| − | , ip.DataFabricare AS [Data fabricare]
| + | ;Data livrare 2 comanda client |
| − | , ip.PretIntrareValuta AS [Pret intrare valuta]
| + | ;Saptamana |
| − | , ip.ValutaId AS [Valuta intrare]
| + | ;Cod 4 |
| − | , ip.TaxeVamale AS [Taxe vamale]
| + | ;Cod 5 |
| − | , ip.ComisionVamal AS [Comision vamal]
| + | ;Greutate bruta comanda furnizor |
| − | , scf.Stare AS [Stare comanda furnizor]
| + | ;Greutate neta comanda furnizor |
| − | , scc.Stare AS [Stare comanda client]
| + | ;Tara origine comanda furnizor |
| − | , CASE WHEN pp.POrderPozId IS NULL
| + | ;Incadrare vamala comanda furnizor |
| − | THEN 1
| |
| − | ELSE 0
| |
| − | END AS [De comandat]
| |
| − | , fr.DenumireUnitate AS [Furnizor comanda]
| |
| − | , ISNULL(pp.Observatii+' ','') + ISNULL(pc.Observatii , '') AS [Observatii comanda furnizor]
| |
| − | , pp.CostAsigurare AS [Cost asigurare]
| |
| − | , pp.ValutaAsigurareId AS [Valuta cost asigurare]
| |
| − | , pp.CostTransport AS [Cost transport]
| |
| − | , pp.ValutaTransportId AS [Valuta cost transport]
| |
| − | , pp.CostImpachetare AS [Cost impachetare]
| |
| − | , pp.ValutaImpachetareId AS [Valuta cost impachetare]
| |
| − | , pp.NrTracking AS [Numar tracking]
| |
| − | , trsp.DenumireUnitate AS Transportator
| |
| − | , ocp.DiscountOff
| |
| − | , ocp.DiscountOff2
| |
| − | , ocp.PretLista AS PretLista
| |
| − | , sp.CantLivrata AS [Cantitate livrata]
| |
| − | , p.Cod AS [Cod Produs]
| |
| − | , isnull(pp.PretValuta,0)-isnull(ip.PretIntrareValutaRedus,0) as [Diferenta pret comanda factura]
| |
| − | , pro1.DenumireProiect as [Proiect client]
| |
| − | , pro2.DenumireProiect as [Proiect furnizor]
| |
| − | , CLF.DenumireUnitate AS [Client comanda furnizor]
| |
| − | , cpr.DenumireCategorieProdus AS [Categorie Produs]
| |
| − | , spr.DenumireSubcategorieProdus AS [Subcategorie Produs]
| |
| − | , tpr.DenumireTipProdus AS [Tip Produs]
| |
| − | , gpr.DenumireGrupaV AS [Grupa Produs]
| |
| − | , t.DenumireTara AS [Tara de origine]
| |
| − | , pc.ObservatiiInterne AS [Observatii interne]
| |
| − | , us.DenumireUnitate as [Persoana introducere]
| |
| − | , g.DenumireGestiune AS [Gestiune]
| |
| − | , tp.Denumire AS [Termen plata]
| |
| − | , tp.NumarZile AS [Numar zile termen plata]
| |
| − | , DATEADD(dd,tp.NumarZile,isnull(pp.DataLivrare,pc.DataLivrare)) AS [Data Scadenta]
| |
| − | , @ValutaId AS [Valuta filtru]
| |
| − | , ISNULL(cc.CentruCost + ' ','') + ISNULL(cc.DenCentruCost,'') as [Centru cost]
| |
| − | , pp.ObservatiiInterne AS [Observatii interne comanda furnizor]
| |
| − | , pro2.NrProiect AS [Numar proiect furnizor]
| |
| − | , pp.Cant *(cast(isnull(p.bucatium,1) as decimal(22,8))) AS [Cantitate bucati um]
| |
| − | , umb.um as [Um buc]
| |
| − | , p.bucatium as [Bucati um]
| |
| − | , ip.CantIntrare *(cast(isnull(p.bucatium,1) as decimal(22,8))) AS [Cantitate buc UM intrare ]
| |
| − | , (pp.cant-isnull(pp.CantReceptionata,0)) *(cast(isnull(p.bucatium,1) as decimal(22,8))) as [Cantitate buc UM nereceptionata]
| |
| − | , Isnull(pp.DataLivrare,pc.DataLivrare) as [Data Livrare]
| |
| − | , ISNULL(cle.CodConditieLivrareExterna + ' - ', '') + cle.DenumireConditieLivrareExterna as [Conditii livrare externa]
| |
| − | , ISNULL(mt.CodModalitateTransport + ' - ', '') + mt.DenumireModalitateTransport as [Modalitate transport]
| |
| − | , g2.DenumireGestiune AS [Gestiune intrare]
| |
| − | ,p.Cod4
| |
| − | ,p.Cod5
| |
| − | ,sc.Observatii2
| |
| − | ,pp.Attr1
| |
| − | ,pp.GreutateBruta as [Greutate bruta]
| |
| − | ,pp.GreutateNeta as [Greutate neta]
| |
| − | ,taraorig.DenumireTara as [Tara origine comanda]
| |
| − | ;Incadrare vamala | |
