ALTER PROCEDURE "Owner"."frx_cl_InfoReport_Tab_PayDoc"
(
    in @AgreementID int             default  1 ,
    in @DateBegin   datetime        default null, --'1950-01-01',
    in @DateEnd     datetime        default null --'2050-01-01'
)
BEGIN
  Set @DateBegin      = Isnull(@DateBegin, convert(datetime, '1960-01-01'));
  Set @DateEnd        = Isnull(@DateEnd, now());
//---------------------------------------------------------------------------------------------------//
Create TABLE #RetTable
(
	TabID 		tinyint,	--1 - запись из PaymentDocuments, 2 - запись из операции по картам
	Summ		decimal( 18 , 2 ),
	NDS			decimal( 18 , 2 ),
	Doc_Date	DateTime,
	MnTarget	tinyint,
	MnType		tinyint,
	Doc_Type	integer,
	Agreement_ref	integer,
	VFOType		integer,
	ContType	integer,
	AgencyTaxRate	integer,
	ServicePercent	integer,
	SummCurCorr	decimal( 18 , 2 )
);
//---------------------------------------------------------------------------------------------------//
insert into #RetTable
(TabID, Summ, NDS, Doc_Date, MnTarget, MnType, Doc_Type,
Agreement_Ref, VFOType, ContType, AgencyTaxRate, ServicePercent)
  Select
     1  as TabID, 
	PD.Summ, PD.NDS, PD.Doc_Date, MnTarget, MnType, 
	Doc_type, PD.Agreement_Ref, VFOType, Isnull(AP.ChangeNPC, 0 ) as ContType, 
	AISC.AgencyTaxRate, AISC.ServicePercent

  from PaymentDocuments PD
    Left join AgreementParameters AP on AP.Agreement_ref = PD.Agreement_Ref
    Left join (Select * from frx__GetAgreements()) AG on AG.ID_Agreement = PD.Agreement_Ref
    Left join AgreementInfoServiceConditions AISC on  AISC.idkey = AG.ID_Condition
  where
      ((PD.Agreement_ref = @AgreementID) or (PD.Agreement_Ref in (Select IDKey from AgreementPackages where TransferTo = @AgreementID)))
      and (Doc_Date <= @DateEnd)
      and (MnTarget in ( 21 , 22 , 23 ));

insert into #RetTable
(TabID, Summ, NDS, Doc_Date, MnTarget, MnType, Doc_Type,
Agreement_Ref, VFOType, ContType, AgencyTaxRate, ServicePercent)  select
     2 , 
	GCO.Summ+ Isnull((Case 
				when ((AO.OperationType =  1 ) AND (AO.AdOperationType =  1 )) OR ((AO.OperationType =  5 ) AND (AO.AdOperationType =  2 )) then  1 
				when ((AO.OperationType =  1 ) AND (AO.AdOperationType =  2 )) OR ((AO.OperationType =  5 ) AND (AO.AdOperationType =  1 )) then - 1 
				else  0 
			   	END * AO.AdOperationSumm), 0 ) as Summ,
	GCO.NDS, GCO.OperationDate as Doc_Date, GCO.MnTarget, GCO.MnType, GCO.ID_CardOperationType as Doc_Type, GCO.ID_Agreement as Agreement_Ref, 
	GCO.PurseNo as VFOType,
    Isnull(AP.ChangeNPC,  0 ) as ContType, AISC.AgencyTaxRate, AISC.ServicePercent
  from Owner.frx__GetCardOperations (@DateBegin = '1950-01-01', @DateEnd = @DateEnd) GCO
	left join AgreementParameters AP on AP.Agreement_ref = GCO.ID_Agreement
	Left join (Select * from frx__GetAgreements()) AG on AG.ID_Agreement = GCO.ID_Agreement
	Left join AgreementInfoServiceConditions AISC on  AISC.idkey = AG.ID_Condition
	Left join mv_AdOperationsJoin AOJ on AOJ.CardOperations_Ref = GCO.ID_CardOperation
	Left join mv_AdOperations AO on AO.IdKey = AOJ.AdOperations_Ref
  where GCO.ID_Agreement in (@AgreementID, (select idkey from AgreementPackages where TransferTo = @AgreementID)) 
	AND GCO.Soft_Ref not in ( 21 , 22 )
  order by mntarget, mntype;

  Select 
    TabID, 
    Summ,
    NDS,
    Doc_Date,
    MnTarget,
    MnType,
    Doc_Type,
    Agreement_ref,
    VFOType,
    ContType,
    AgencyTaxRate,
    ServicePercent,
    SummCurCorr 
  from #RetTable;
END