ODBC - Production

Notes_RealmLease_ctiwebp
Production
USLAXDomino01/Westfield_US02
RLease\ctirlssle.nsf
Username:Reporting Server/Westfield_US02

Notes_RealmLease_ctiweb
Development
USLAXDomino02/Westfield_US02
RLease\Development\ctirlssle.nsf
Username:Reporting Server/Westfield_US02

Signed Deals

Signed Date = Date Signed by Land Lord
Comes from
_9_weaLvwLASubWFbyDealId_
Formula is
Date({_9_weaLvwLASubWFbyDealId_._7})

Lease Term

Original:
Lease term = if {_9_lvwLeaseSummarybyDealId_.WeaLseType}="E" then {@Term of Extension}
else {@Term Cal}
Proposed:
if {_9_lvwLeaseSummarybyDealId_.WeaLseType}="E" then
If {@Term of Extension}> 12 Then {@Term of Extension}
else {@Term Cal}
------

local numbervar Yrs := if isnull({_9_lvwLeaseSummarybyDealId_.TermYears}) then 0
else tonumber({_9_lvwLeaseSummarybyDealId_.TermYears});
local numbervar Mos := if isnull({_9_lvwLeaseSummarybyDealId_.TermMonths}) then 0
else tonumber({_9_lvwLeaseSummarybyDealId_.TermMonths});

(Yrs*12)+Mos

----
Numbervar ExtYrs:= If NumericText({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs})Then ToNumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs}) * 12 Else 0;
Numbervar ExtMos := If isnull({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos}) Then 0
Else Tonumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos});

ExtYrs + ExtMos

----
Local Numbervar ExtYrs:= If isnull({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs}) Then 0 else ToNumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs});
Local Numbervar ExtMos:= If isnull({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos}) Then 0 else Tonumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos});

(ExtYrs*12)+ExtMos


---
If ({_9_lvwLeaseSummarybyDealId_.WeaLseType}="E") Then
(If{@Term of Extension> 12}= True Then {@Term of Extension})
Else {@Term Cal};

Notes on Signed Deals Report

Signed Deals = Deals Signed by LL
Lease Term change:
Numbervar ExtYrs:= If NumericText({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs})Then ToNumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtYrs}) * 12 Else 0;
Numbervar ExtMos := If isnull({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos}) Then 0
Else Tonumber({_9_lvwLeaseSummarybyDealId_.WeaTrmExtMos});

ExtYrs + ExtMos