vw_fiOpenPositionInstallmentPlanData erweiterung

Story: 710489
Kunde: Haus Rabenhorst O. Lauffs GmbH & Co. KG
Ersteller:in: Hodac Simon
Zugewiesen: Seebach Oliver
Technische Lösung: if exists (select id from sysobjects where name = 'vw_fiOpenPositionInstallmentPlan')
DROP VIEW [dbo].[vw_fiOpenPositionInstallmentPlan]
GO
--[BEGIN]====================================[ ]===[STORY/TICKET#710489]=========
-- Autor: seebach_o
-- Datum: 2024-12-03
-- Script: 4.0.0.0 (3.0.120.0)
-- Auftraggeber: Rabenhorst (simon_h)
-- Grund: Wenn der Zahllauf durchgeführt wird, sollen die Buchungstexte der Buchungen auf die Offenen Posten mit übernommen werden, welche bezahlt werden dadurch.
CREATE VIEW [dbo].[vw_fiOpenPositionInstallmentPlan]
AS
SELECT
vw.FiOpenPosition_SID
,fip.SID as FiInstallmentPlan_SID
,vw.FiAccount_SID
,vw.FiAccount_accountID
,vw.FiBookingPosGrp_SID
,vw.CRMPartner_SID
,vw.FiAccountType_SID
,vw.FiBooking_bookingdate
,vw.FiBooking_extDocID
,vw.FiBooking_bankCollBlock
,vw.FiBooking_extDocDate
,vw.Currency_SID
,vw.FiOpenPosition_finished
,pt.SID as PaymentType_SID
,pt.aPercent as PaymentType_aPercent
,isnull(fip.LPayDate,dateadd(day,isnull(pt.PaymentTargetNet,0),isnull(vw.FiBooking_extDocDate, vw.FiBooking_bookingdate))) as FiBooking_dueDate
,isnull(fip.discountDate,case when (ISNULL(pt.Days,0)<>0) then DATEADD(DAY,pt.Days, ISNULL(vw.FiBooking_extDocDate, vw.FiBooking_bookingdate)) else null end) as FiBooking_discountDate
,case when fip.SID IS NOT NULL then fip.value when es.setFinished = 1 then 0 else vw.FiOpenPosition_value end as FiOpenPosition_value
,case when fbp.SID IS NOT NULL then 0 else vw.FiOpenPosition_valuePlanned end as FiOpenPosition_valuePlanned
,vw.FiBooking_SID as FiBooking_SID
,vw.FiBooking_aName as FiBooking_name
,vw.FiBooking_dunningBlock as FiBooking_dunningBlock
,vw.FiBooking_remark as FiBooking_remark
,vw.FiBookingPos_SID as FiBookingPos_SID
,vw.FiBookingPos_isCredit as FiBookingPos_isCredit
,vw.FiBookingPos_CRMPartnerBusiness as FiBookingPos_CRMPartnerBusiness
,vw.FiBookingPos_remark as FiBookingPos_remark
,vw.BankCon_SID as BankCon_SID
,vw.BankCon_IBAN as BankCon_IBAN
,vw.FiOpenPosition_forcePaymentRun as FiOpenPosition_forcePaymentRun
,isnull(fip.FK_PaymentSrc_SID, vw.PaymentSrc_SID) as PaymentSrc_SID
from F4MBS.dbo.vw_fiOpenPosition as vw
left outer join F4MBS.dbo.FiInstallmentPlan fip
left outer join F4MBS.dbo.FiBookingPos fbp on fbp.SID = fip.FK_FiBookingPos_SID
left outer join F4MBS.dbo.FiBookingPosGrp fbpg on fbpg.SID = fbp.FK_FiBookingPosGrp_SID
left outer join F4MBS.dbo.FiBooking fb on fb.SID = fbpg.FK_FiBooking_SID
left outer join F4MBS.dbo.FiBookingBatch fbb on fbb.SID = fb.FK_FiBookingBatch_SID
left outer join F4MBS.dbo.EnqState es on es.SID = fbb.FK_EnqState_SID
on fip.FK_FiOpenPosition_SID = vw.FiOpenPosition_SID
left outer join F4MBS.dbo.PaymentType pt on pt.SID = ISNULL(fip.FK_PaymentType_SID, vw.PaymentType_SID)
--[END]======================================[ ]=======================
GO