P_RU_CommissionTradeInvoice14

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity P_RU_CommissionTradeInvoice14
  with parameters
    P_ReportingPeriodStartDate : datum,
    P_ReportingPeriodEndDate   : datum

  as select from           P_RU_CommissionTradeInvoice13                 as VatReporting

    inner join             P_RU_VATReturnVersionOnDate(
                           P_Date: $parameters.P_ReportingPeriodEndDate) as VATVer            on  VATVer.CompanyCode         = VatReporting.CompanyCode
                                                                                              and VATVer.RU_VATReturnVersion = VatReporting.RU_VATReturnVersion

    inner join             I_JournalEntry                                as AccDoc            on  AccDoc.CompanyCode        = VatReporting.CompanyCode
                                                                                              and AccDoc.AccountingDocument = VatReporting.AccountingDocument
                                                                                              and AccDoc.FiscalYear         = VatReporting.FiscalYear


    left outer to one join P_RU_CFinVATRevisionDocument                  as RevDoc            on  RevDoc.CompanyCode         = VatReporting.CompanyCode
                                                                                              and RevDoc.RevisionInvoice     = VatReporting.AccountingDocument
                                                                                              and RevDoc.RevisionInvoiceYear = VatReporting.FiscalYear

    left outer to one join P_RU_SuplrCustAccDocItem                      as PartnerAccDocItem on  PartnerAccDocItem.CompanyCode        = VatReporting.CompanyCode
                                                                                              and PartnerAccDocItem.AccountingDocument = VatReporting.AccountingDocument
                                                                                              and PartnerAccDocItem.FiscalYear         = VatReporting.FiscalYear

    left outer to one join P_RU_CustomerCompanyData                      as CustomerData      on  CustomerData.Customer    = PartnerAccDocItem.Customer
                                                                                              and CustomerData.CompanyCode = VatReporting.CompanyCode

    left outer to one join P_RU_SupplierCompanyData                      as SupplierData      on  SupplierData.Supplier    = PartnerAccDocItem.Supplier
                                                                                              and SupplierData.CompanyCode = VatReporting.CompanyCode
{
  VatReporting.CompanyCode,
  VatReporting.AccountingDocument,
  VatReporting.FiscalYear,

  AccDoc.SenderCompanyCode,
  AccDoc.SenderAccountingDocument,
  AccDoc.SenderFiscalYear,
  AccDoc.SenderLogicalSystem,

  VatReporting.PostingDate,
  VatReporting.TaxReportingDate as RU_RegistrationInvoiceDate,

  VatReporting.IsReversal,
  VatReporting.IsReversed,
  VatReporting.ReverseDocument,
  VatReporting.ReverseDocumentFiscalYear,
  VatReporting.TaxItem,
  VatReporting.TaxItemGroup,
  VatReporting.TaxCode,
//  VatReporting.TaxRate,

  VatReporting.TaxCountry,
  VatReporting.TaxJurisdiction,

  VatReporting.RU_VATReturnVersion,
  VatReporting.RU_VATReturnSectionType,
  VatReporting.IsCorrectionInvoice,
  case when VatReporting.IsCorrectionInvoice is null then 'X'
       else '' end                                                        as IsCorrectionInvoiceNull,
  VatReporting.DebitCreditCode,
  VatReporting.DebitCreditCodeCust,
  VatReporting.IsNegativePosting,

  RevDoc.RevisionNumber,

  PartnerAccDocItem.TransactionCurrency,

  //ZUONR, Supplier, Customer, BP

  PartnerAccDocItem.AssignmentReference                                   as ContractNum,
  PartnerAccDocItem.Customer,
  PartnerAccDocItem.Supplier,

  coalesce(CustomerData.BusinessPartner,    SupplierData.BusinessPartner) as BusinessPartner,
  coalesce(CustomerData.CustomerName,       SupplierData.SupplierName)    as BusinessPartnerName,

  CustomerData.CustomerFinsAuthorizationGrp,
  CustomerData.CustomerAccountGroup,
  CustomerData.CustomerIsBusPrpsCmpltd,
  CustomerData.CustomerCompanyAuthznGroup,
  CustomerData.CustCoIsBusPrpsCmpltd,

  SupplierData.SupplierFinsAuthorizationGrp,
  SupplierData.SupplierAccountGroup,
  SupplierData.SupplierIsBusPrpsCmpltd,
  SupplierData.SupplierCompanyAuthznGroup,
  SupplierData.SuplrCoIsBusPrpsCmpltd
}
where
     VatReporting.TaxReportingDate   between $parameters.P_ReportingPeriodStartDate and $parameters.P_ReportingPeriodEndDate
  or RevDoc.RevisionTaxReportingDate between $parameters.P_ReportingPeriodStartDate and $parameters.P_ReportingPeriodEndDate