PV Iesire - Pv iesire pret amanunt

From docs
Revision as of 13:44, 16 February 2026 by Ana Marinescu (talk | contribs) (Created page with "*Pv iesire **Pv iesire pret amanunt ===Campuri=== ;IesCapId ;Text_Ro ;Counter ;TipDoc ;DenumireFirma ;DenumireDivizie ;TipLivrare ;Urgenta ;ValoareTotala ;Val...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Campuri

IesCapId
Text_Ro
Counter
TipDoc
DenumireFirma
DenumireDivizie
TipLivrare
Urgenta
ValoareTotala
ValoareTotalaFaraTVA
ValoareTva
Valoare
Furnizor
Adresa_furnizor
DenumireProdus
CodProdus
TipItem
UM
Greutate
GreutateBruta
GreutateNetaProdus
GreutateNeta
DenumireGestiune
CodGestiune
PretCost
NumarFactura
Numar
NumarComanda
DataFactura
Data
DataValidare
DataCreare
DataAnulare
FirmaId
Observatii
DelegNume
DelegAct
DelegElibAct
DelegAuto
ObservatiiInterne
Explicatii1
Explicatii2
Retur
TermenGarantie
SerialNumber
CentruCostPozitie
DenCentruCostPozitie
CodArticolBuget
DenumireArticolBuget
DataValidarePlata
DataScadenta
CapitalSocial
iespozid
IntrPoziD
IesPozRefId
CantDocument
Cantiesire
CodProducator
DiscountPozitie
TvaDiscountPozitie
PretVanzare
PretAmanunt
ValoarePozitie
ValoareTvaPozitie
TotalPlataPePozitie
PretVanzareRedus
Tva
PozExplicatii1
PozExplicatii2
DataExpirareFactura
DataFabricare
DataExpirare
UserValidare
BIActRU
CNPRU
Client
Client_Unitate
Client_Partener
Cont
DenumireBanca
CodFiscal
Adresa
DenumireJudet
Client_NrRegComertului
Agent
Traseu
ListaTva
DataCurenta
OraCurenta
LotIntrare
FlagConta
ContCreditor
CodProdusDiv
NrCmdProd
DataCmdProd
ClsComandaProductie
LotFactura
Lot
CentruCost
DenCentruCost
SirNumeGestionari
NrCrt
AgentFurnizorFunctie
AgentFurnizor
AgentFurnizorTelefon
Bloc_client
Scara_client
Etaj_client
Apartament_client
DenumireTara_client
DenumireJudet_client
DenumireLocalitate_client
Bloc_furnizor
Scara_furnizor
Etaj_furnizor
Apartament_furnizor
DenumireTara_furnizor
DenumireJudet_furnizor
DenumireLocalitate_furnizor
Furnizor_CodFiscal
Furnizor_NrRegComertului
Furnizor_Adresa
Furnizor_AdresaSediu
Furnizor_AdresaPunctL
Furnizor_Cont
Furnizor_Banca
ClientId
Client_AtributFiscal
Furnizor_AtributFiscal
UserCreare
CNP_UserCreare
SoldClient
Insolventa
CSSV
CodBare
SOrderNumber
SOrderDate
Locatie
ClientComanda
Produs
DenumireFirmaCrt
CodFiscalCRT
AdresaCRT
Comenzi_clienti
attr1
attr2
Antet
Antet1
Footer
NrProiect
DenumireProiect
NumarIntern
AttrProd2
DenumireTipProdus
NumarIesCodBare

, LA.DenumireLocatieAsset , proipoz.DenumireProiect AS DenumireProiectPoz , proipoz.NrProiect AS NrProiectPoz , isProd.attr1 AS attr1prod , isProd.attr2 AS attr2prod , isProd.attr3 AS attr3prod , isProd.attr4 AS attr4prod , ISNULL(tblPartner_FirmaCap.Attr1, ) AS Attr1n , CAST('*' +doc.DocCode+ CAST(iscap.IesCapId AS NVARCHAR(MAX)) + '*'AS NVARCHAR(MAX)) AS IesCapIdCB , COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,isProd.DenumireProdus,ispoz.DenumireProdus,isProd.DenumireProdus) AS DenumireProdusOrdonare , ISNULL(pf.cod, ) AS CodProdusFinit , ISNULL(pf.denumireprodus, ) AS DenumireProdusFinit , ISNULL(scpf.SOrderNumber , ) + ISNULL('-' + CONVERT(VARCHAR(10) , scpf.SOrderDate , 103) , ) AS Comanda , ROUND(ispoz.CantIesire * isnull(ispoz.PretCost, 0), @SetareZecimale) AS ValoarePozitiePretCost , ROUND(ispoz.CantIesire * isnull(ispoz.PretCost, 0) * ISNULL(ispoz.Tva,0) / 100, @SetareZecimale) AS ValoareTvaPozitiePretCost , proi.DescriereProiect , a.Asset AS AssetFolosit , apoz.Asset AS AssetFolositPoz , YEAR(iscap.DataIes) AS An , MONTH(iscap.DataIes) AS Luna , DAY(iscap.DataIes) AS Zi , apoz.ValoareNeamortizata , dm.Motiv , dmp.Motiv AS MotivPoz , ass.NrInventar AS NumarInventar ,isProd.CodBare as Codbareprodus ,isProd.attr3 as attr3produs ,isProd.ZileGarantie as ZileGarantieProdus , CAST(ROW_NUMBER() OVER ( ORDER BY --MAX(iespoz.ordine) CASE WHEN ISNULL(@setare5,1) = 1 

                                              THEN CASE WHEN @Setare391 = 0 OR (@setare391 in (1,2) AND @setare422 = 0)
                                                     THEN COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus)
                                                     WHEN @Setare391 = 1 AND @Setare422 = 1
                                                     THEN COALESCE(ispoz.CodProdusAfisare + ' ',
                                                                   CPC.CodProdusClient + ' ',isProd.Cod + ' ',)
                                                          + COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus)
                                                     WHEN @Setare391 = 2 AND @Setare422 = 1
                                                     THEN COALESCE(ispoz.DenumireProdusAfisare,CPC.DenumireProdusClient,ispoz.DenumireProdus,isProd.DenumireProdus) + COALESCE(' '
                                                                                                + ispoz.CodProdusAfisare,
                                                                                                ' '
                                                                                                + CPC.CodProdusClient,
                                                                                                ' ' + isProd.Cod,)
                                                   END
                                         END
                                                                        , CASE WHEN @Setare5 = 2
                                                                               THEN ispoz.IesPozId
                                                                          END

, CASE WHEN @setare5 = 3 

                                                                                  THEN ispoz.ordine
                                                                             END ) AS INT) AS NrPozitie

, ppff.LotIntrare AS LotIntrareProdusFinit , CONVERT(VARCHAR(50),ppff.DataExpirare, 103) AS DataExpirareProdusFinit ,UMAlt.UM AS UMAlt ,CodBareAlt.CodBare AS CodBareAlt , ispoz.ObservatiiInterne as ObservatiiInternePoz 

               , CONVERT(VARCHAR(50),porig.DataIntr, 103) as DataIntr
               , furn.Furn_Attr1
               , forig.DenumireUnitate as FurnizorOriginal
               , catprod.DenumireCategorieProdus as DenumireCategorieProdus

, iscap.NrBonFiscal as NrBonFiscal , COALESCE(fact.NumarFactIes, fact.NumarIes, ) AS NrFacturaClientAmanunt , CONVERT(VARCHAR(10), ISNULL(fact.DataFactIes, fact.DataIes), 103) AS DataFacturaClientAmanunt ,torig.DenumireTara AS TaraOrigine ,CASE WHEN ISNULL(isProd.bucatiBAX,0) = 0 THEN NULL ELSE inv.NumarZecimale(2,ispoz.CantIesire / isProd.bucatiBAX) END AS BucPeBax ,ISNULL(CPC.CodProdusClient,isprod.Cod) as CodProdusClient , CONVERT(VARCHAR(50),ppff.DataFabricare, 103) as DataFabricareProdusFinit , pfi.CantitateIntrareIntrare,pfi.DataExpirareIntrare,pfi.DataFabricareIntrare,pfi.LotIntrareIntrare , bc.PrimaDataBonConsum

Retrieved from "https://docs.plurivaerp.com/index.php?title=PV_Iesire_-_Pv_iesire_pret_amanunt&oldid=49580"