{
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 Direct Debit"))
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
{
$_x0034_2_Contract_Data/PartyType/text()
}
{
$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
{
$All_HL_Businessv2_Data/BranchName/text()
}
{
$All_HL_Businessv2_Data/Code_Settlements/text()
}
{
$All_HL_Businessv2_Data/Name_Settlements/text()
}
True
{
$All_HL_Businessv2_Data/BankId/text()
}
AUD
{
$All_HL_Businessv2_Data/BranchCode/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.
:)