{ current-date() } HL Technology Leasing Ltd { for $_x0034_2_Contract_Data in collection("IBS_REPORTS.dbo.42_Contract_Data")/_x0034_2_Contract_Data , $All_HL_Businessv2_Data in collection("IBS_REPORTS.dbo.All_HL_Businessv2_Data")/All_HL_Businessv2_Data where ($_x0034_2_Contract_Data/IBS_Contract_Nos = $All_HL_Businessv2_Data/Code_Party) and ($_x0034_2_Contract_Data/FlowMethodId = "NAB Cardfast") return Operating Lease Direct True { $All_HL_Businessv2_Data/Name_Party/text() } { $All_HL_Businessv2_Data/Code_Party/text() } { $All_HL_Businessv2_Data/ExtName/text() } DirectCustomer Business { $All_HL_Businessv2_Data/PhoneBusiness/text() } { $All_HL_Businessv2_Data/FaxBusiness/text() } { $All_HL_Businessv2_Data/IsSelfBilling/text() } { $All_HL_Businessv2_Data/TradingAs/text() } { $All_HL_Businessv2_Data/BusinessrefNo/text() } Contact Other True True { $All_HL_Businessv2_Data/ContactName_1/text() } { $All_HL_Businessv2_Data/Code_Party/text() } Individual { $All_HL_Businessv2_Data/ContactFirstName_1/text() } { $All_HL_Businessv2_Data/ContactMiddleName_1/text() } { $All_HL_Businessv2_Data/PhoneBusiness/text() } Street { $All_HL_Businessv2_Data/Street/text() } { $All_HL_Businessv2_Data/CityId/text() } { $All_HL_Businessv2_Data/StateProvinceId/text() } { $All_HL_Businessv2_Data/ZipCode/text() } Australia { $All_HL_Businessv2_Data/EffectDtFrom/text() } 9998-12-31 True Street { $All_HL_Businessv2_Data/Street/text() } { $All_HL_Businessv2_Data/CityId/text() } { $All_HL_Businessv2_Data/StateProvinceId/text() } { $All_HL_Businessv2_Data/ZipCode/text() } Australia { $All_HL_Businessv2_Data/EffectDtFrom/text() } 9998-12-31 True AUD True Receipt { $All_HL_Businessv2_Data/FlowMethodID/text() } { $All_HL_Businessv2_Data/FlowMethodID/text() } Loaded False False True { $All_HL_Businessv2_Data/BankId/text() } AUD { $All_HL_Businessv2_Data/CreditCardAssociationId/text() } { $All_HL_Businessv2_Data/CreditCardExpiryDt/text() } { $All_HL_Businessv2_Data/CreditCardHolderName/text() } { $All_HL_Businessv2_Data/CreditCardNumber/text() } THIS PARTY HAS BEEN TRANSFERRED FROM IBS None AUD Complete Complete Activated Approved Provider Monthly Monthly 0 0 Outstanding Balance { $_x0034_2_Contract_Data/ApplicationDt/text() } { $_x0034_2_Contract_Data/ApplicationDt/text() } { $_x0034_2_Contract_Data/ApplicationDt/text() } { $_x0034_2_Contract_Data/ApplicationDt/text() } { $_x0034_2_Contract_Data/InstallmentFrequency/text() } { $_x0034_2_Contract_Data/InstallmentTiming/text() } Fixed Fair Market Value True 0 0 0.00 False False False False True IBS Account No { $_x0034_2_Contract_Data/IBS_Contract_Nos/text() } IBS Funder { $_x0034_2_Contract_Data/IBS_FUNDER/text() } { for $Asset_Combined_Data_HL in collection("IBS_REPORTS.dbo.Asset_Combined_Data_HL")/Asset_Combined_Data_HL where $_x0034_2_Contract_Data/IBS_Contract_Nos = $Asset_Combined_Data_HL/IBSContractNos return { $Asset_Combined_Data_HL/OriginalPurchasePrice/text() } { $Asset_Combined_Data_HL/Installments/text() } { $_x0034_2_Contract_Data/ApplicationDt/text() } { $Asset_Combined_Data_HL/PurchaseDt/text() } { $Asset_Combined_Data_HL/PurchaseDt/text() } { $Asset_Combined_Data_HL/AssetTypeId/text() } { $Asset_Combined_Data_HL/Asset_Name/text() } { $Asset_Combined_Data_HL/SerialNo/text() } { $Asset_Combined_Data_HL/AssetDescription/text() } { $Asset_Combined_Data_HL/Model/text() } { $Asset_Combined_Data_HL/PurchaseDt/text() } { $Asset_Combined_Data_HL/OriginalPurchasePrice/text() } Straight Line { $Asset_Combined_Data_HL/DepreciationRate/text() } Diminishing Value { $Asset_Combined_Data_HL/TaxDepreciationRate/text() } { $Asset_Combined_Data_HL/SubLocation/text() } { $Asset_Combined_Data_HL/AssetID/text() } { $Asset_Combined_Data_HL/TaxAmtSalvageValue/text() } True Base 0 { for $Asset_Combined_Schedules_HL_Balanced1 in collection("IBS_REPORTS.dbo.Asset_Combined_Schedules_HL_Balanced")/Asset_Combined_Schedules_HL_Balanced where $Asset_Combined_Data_HL/AssetID = $Asset_Combined_Schedules_HL_Balanced1/AssetID return Payment Total { $Asset_Combined_Schedules_HL_Balanced1/InstallmentFrequency/text() } { $Asset_Combined_Schedules_HL_Balanced1/Installments/text() } { $Asset_Combined_Schedules_HL_Balanced1/AmtSegment/text() } { $Asset_Combined_Schedules_HL_Balanced1/SegmentNo/text() } } } } (: Stylus Studio meta-information - (c) 2004-2009. Progress Software Corporation. All rights reserved. :)