Notes

INSERT INTO dbo.LeaseAssets(ReferenceNumber, NBV_Amount, NBV_Currency, Markup_Amount, Markup_Currency, SpecificCostAdjustment_Amount, SpecificCostAdjustment_Currency, SpecificCostAdjustmentOnCommencement_Amount, SpecificCostAdjustmentOnCommencement_Currency, InstallationDate, UsePayDate, PaymentDate, InterimInterestProcessedAfterPayment, InterimRentProcessedAfterPayment, InterimInterestStartDate, InterimRentStartDate, BillMaxInterim, MaximumInterimDays, InterimRentFactor, InterimRent_Amount, InterimRent_Currency, RentFactor, Rent_Amount, Rent_Currency, OTPRentFactor, OTPRent_Amount, OTPRent_Currency, RVRecapFactor, RVRecapAmount_Amount, RVRecapAmount_Currency, SupplementalRentFactor, SupplementalRent_Amount, SupplementalRent_Currency, CustomerExpectedResidualFactor, CustomerExpectedResidual_Amount, CustomerExpectedResidual_Currency, BookedResidualFactor, BookedResidual_Amount, BookedResidual_Currency, CustomerGuaranteedResidualFactor, CustomerGuaranteedResidual_Amount, CustomerGuaranteedResidual_Currency, ThirdPartyGuaranteedResidualFactor, ThirdPartyGuaranteedResidual_Amount, ThirdPartyGuaranteedResidual_Currency, ResidualValueInsuranceFactor, ResidualValueInsurance_Amount, ResidualValueInsurance_Currency, CapitalizedInterimInterest_Amount, CapitalizedInterimInterest_Currency, CapitalizedInterimRent_Amount, CapitalizedInterimRent_Currency, CapitalizedSalesTax_Amount, CapitalizedSalesTax_Currency, CapitalizationType, IsEligibleForBilling, TerminationDate, IsActive, IsTransferAsset, InterimInterestGeneratedTillDate, InterimRentGeneratedTillDate, IsTaxDepreciable, IsTaxAccountingActive, TaxBasisAmount_Amount, TaxBasisAmount_Currency, TaxDepStartDate, TaxDepEndDate, AccumulatedDepreciation_Amount, AccumulatedDepreciation_Currency, AssetImpairment_Amount, AssetImpairment_Currency, DeferredRentalIncome_Amount, DeferredRentalIncome_Currency, CapitalizedProgressPayment_Amount, CapitalizedProgressPayment_Currency, IsCollateralOnLoan, IsNewlyAdded, IsPrimary, OriginalCapitalizedAmount_Amount, OriginalCapitalizedAmount_Currency, SalesTaxAmount_Amount, SalesTaxAmount_Currency, IsApproved, TaxPaidtoVendor_Amount, TaxPaidtoVendor_Currency, GSTTaxPaidtoVendor_Amount, GSTTaxPaidtoVendor_Currency, HSTTaxPaidtoVendor_Amount, HSTTaxPaidtoVendor_Currency, QSTorPSTTaxPaidtoVendor_Amount, QSTorPSTTaxPaidtoVendor_Currency, CreatedById, CreatedTime, AssetId, CapitalizedForId, TaxDepTemplateId, BillToId, PayableInvoiceId, LeaseTaxAssessmentDetailId, LeaseRestructureId, LeaseFinanceId, OTPDepreciationTerm, TaxReservePercentage, BookDepreciationTemplateId, AssessedUpfrontTax_Amount, AssessedUpfrontTax_Currency, CustomerCost_Amount, CustomerCost_Currency, ETCAdjustmentAmount_Amount, ETCAdjustmentAmount_Currency, PrepaidUpfrontTax_Amount, PrepaidUpfrontTax_Currency, FXTaxBasisAmount_Amount, FXTaxBasisAmount_Currency, IsPrepaidUpfrontTax, ValueAsOfDate, OnRoadDate, IsLeaseAsset, IsSaleLeaseback, CapitalizedIDC_Amount, CapitalizedIDC_Currency, MaturityPaymentFactor, IsFailedSaleLeaseback, FMV_Amount, FMV_Currency, MaturityPayment_Amount, MaturityPayment_Currency, InterimMarkup_Amount, InterimMarkup_Currency, CapitalizedAdditionalCharge_Amount, CapitalizedAdditionalCharge_Currency, PreviousCapitalizedAdditionalCharge_Amount, PreviousCapitalizedAdditionalCharge_Currency, IsAdditionalChargeSoftAsset,AcquisitionLocationId,SalesTaxRemittanceResponsibility,VendorRemitToId, EligibleForResidualValueInsurance, PaymentPO, CustomerCostCenter, EOLFMVCapPercentage, TotalCOGSSCA_Amount, TotalCOGSSCA_Currency,TRACPercentage, CertificateOfAcceptanceNumber,CertificateOfAcceptanceStatus,TrueDownPayment_Amount,TrueDownPayment_Currency,PreCapitalizationRent_Amount, PreCapitalizationRent_Currency,UpfrontLossOnLease_Amount,UpfrontLossOnLease_Currency,IsFERecord, PIACOGS_Amount, PIACOGS_Currency,UpfrontLossOnLeaseResidual_Amount,UpfrontLossOnLeaseResidual_Currency, MigratedAssetLocation, InitialCustomerCost_Amount, InitialCustomerCost_Currency, InitialNBV_Amount, InitialNBV_Currency, IsUpfrontTaxAssessedInOriginalContract, InceptionRentFactor, InceptionPayment_Amount, InceptionPayment_Currency,ContractCommittedValue_Amount,ContractCommittedValue_Currency,RevenuePercentageSplit,BufferPercentageSplit)
OUTPUT Inserted.Id, Inserted.AssetId into #CreatedLeaseAssetIds
SELECT ROW_NUMBER() OVER (PARTITION BY la.LeaseId ORDER By la.Id) AS ReferenceNumber, NBV_Amount, NBV_Currency, Markup_Amount, Markup_Currency, 0.00, NBV_Currency, 0.00, NBV_Currency, a.InServiceDate, ISNULL(leaseAssetInterim.UsePayDate, 0), PaymentDate, CAST(0 AS BIT), CAST(0 AS BIT), leaseAssetInterim.InterimInterestStartDate ,leaseAssetInterim.InterimRentStartDate, ISNULL(leaseAssetInterim.BillMaxInterimRent, 0), ISNULL(leaseAssetInterim.MaximumInterimRentDays, 0), ISNULL(leaseAssetInterim.InterimRentFactor, 0), ISNULL(leaseAssetInterim.InterimRentalAmount_Amount, 0.00), ISNULL(leaseAssetInterim.InterimRentalAmount_Currency, NBV_Currency), RentFactor, FixedTermRentalAmount_Amount, FixedTermRentalAmount_Currency, OTPRentFactor, OTPRentalAmount_Amount, OTPRentalAmount_Currency, RVRecapFactor, RVRecapAmount_Amount, RVRecapAmount_Currency, SupplementalRentFactor, SupplementalRent_Amount, SupplementalRent_Currency, CustomerExpectedResidualFactor, CustomerExpectedResidualAmount_Amount, CustomerExpectedResidualAmount_Currency, BookedResidualFactor, ResidualBookedAmount_Amount, ResidualBookedAmount_Currency, CustomerGuaranteedResidualFactor, CustomerGuaranteedResidualAmount_Amount, CustomerGuaranteedResidualAmount_Currency, ThirdPartyGuaranteedResidualFactor, ThirdPartyGuaranteedResidualAmount_Amount, ThirdPartyGuaranteedResidualAmount_Currency, 0.00, 0.00, Markup_Currency, 0.0, Markup_Currency, 0.0, Markup_Currency, 0.00, Markup_Currency, '_', ISNULL(leaseAssetInterim.IsEligibleForBilling, 0), NULL, CAST(1 AS BIT), CAST(0 AS BIT), NULL, NULL, 0, CAST(0 AS BIT), 0.00, NBV_Currency, NULL, NULL, 0.00, NBV_Currency, 0.00, NBV_Currency, 0.00, NBV_Currency, 0.00, Markup_Currency, CAST(0 AS BIT), CAST(1 AS BIT), IsPrimary, 0.00, Markup_Currency, 0.00, Markup_Currency, IsApproved, la.TaxPaidtoVendor_Amount, la.TaxPaidtoVendor_Currency, la.GSTTaxPaidtoVendor_Amount, la.GSTTaxPaidtoVendor_Currency, la.HSTTaxPaidtoVendor_Amount, la.HSTTaxPaidtoVendor_Currency, la.QSTorPSTTaxPaidtoVendor_Amount, la.QSTorPSTTaxPaidtoVendor_Currency, @UserId, @CreatedTime, R_AssetId, NULL, la.R_TaxDepTemplateId, CASE WHEN @BillToLevel = 'Deal' THEN lease.R_BillToId WHEN la.R_BillToId IS NULL THEN lease.R_BillToId ELSE la.R_BillToId END, NULL, NULL, NULL, LF.InsertedId, OTPRemainingLifeInMonths, TaxReservePercentage, R_BookDepreciationTemplateId, 0.0, la.QSTorPSTTaxPaidtoVendor_Currency , 0.00, Markup_Currency, 0.00, Markup_Currency, 0.00, Markup_Currency, 0.00, NBV_Currency, CAST(0 AS BIT), a.InServiceDate, OnRoadDate, CASE WHEN (a.IsLeaseComponent=1 And IsFailedSaleLeaseback=0) THEN 1 ELSE 0 END, a.IsSaleLeaseback, 0.0, FMV_Currency, 0.0, IsFailedSaleLeaseback, FMV_Amount, FMV_Currency, AssetMaturityPayment_Amount, AssetMaturityPayment_Currency, 0.00, Markup_Currency, 0.00, Markup_Currency, 0.00, Markup_Currency, 0,la.R_AcquisitionLocationId,la.SalesTaxRemittanceResponsibility,la.R_VendorRemitToId, '_' ,la.PaymentPO, la.CustomerCostCenter, la.EOLFMVCapPercentage, 0.0, NBV_Currency, la.TRACPercentage, la.CertificateOfAcceptanceNumber, la.CertificateOfAcceptanceStatus,0.00, Markup_Currency, 0.00, Markup_currency, 0.00, Markup_Currency, CAST(0 AS BIT), 0.00, NBV_Currency,0.00, Markup_Currency, MigratedAssetLocation, 0.00, Markup_Currency, 0.00, Markup_Currency, CAST(0 AS BIT), InceptionRentFactor, InceptionPayment_Amount, InceptionPayment_Currency,ContractCommittedValue_Amount,ContractCommittedValue_Currency,RevenuePercentageSplit,BufferPercentageSplit
FROM stgLeaseAsset la