vrpt_Lease

Updated December 24, 2025 13:11

Field Name	Field Description	Data Type	FK Join
AdjustFrequency	Adjust Frequency	nvarchar
AnnualAmount	Annual Ammount	decimal
BankName	Bank Name	nvarchar
BaseYear	Base Year	int
Class	Class	nvarchar
CloseDate	Closed Date	datetime
Comment	Comments	nvarchar
CommonAreaFactor	Common Area Factor	decimal
CPIIncrease	Comparison Price Index Increase	decimal
CPIIncreaseDate	Comparison Price Index Increase Date	datetime
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
CurrentDue	Current Due	decimal
CurrentMonthRent	Current Month Rent	decimal
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Description	nvarchar
DueDate	Due Date	datetime
EarlyTerminationDate	Early Termination Date	datetime
EffectiveDate	Effective Date	datetime
ExpenseStop	Expense Shop	decimal
ExpirationDate	Expiration Date	datetime
FASBClass	Financial Accounting Standard's Board Lease Class	nvarchar
FMVLand	Fair Market Value Land	decimal
FMVProperty	Fair Market Value Property	decimal
HoldoverPenalty	Holdover Penalty	decimal
Id	Lease Id	int
ImplicitRate	Implicit Rate	decimal
IncreaseCap	Increase Cap	decimal
IncrementalRate	Incremental Rate	decimal
IsAuthorized	Indicates if the record is authorized	bit
IsPayable	Indicates if the record is payable	bit
IsReceivable	Indicates if the record is receivable	int
LastCheckNumber	Last Check Number	nvarchar
LateFeesBudget	Late Fees Budget	decimal
LateFeesReceivable	Late Fees Receivable	decimal
LeaseAmount	Lease Amount	decimal
LeaseDate	Lease Date	datetime
LeasedPercentage	Leased Percentage	decimal
LeaseRentableSF	Lease Rentable Square Footage	int
LeaseSecurityDeposit	Lease Security Deposit	decimal
LeaseSignor1	Lease Signor 1	nvarchar
LeaseSignor2	Lease Signor 2	nvarchar
LeaseSignor3	Lease Signor 3	nvarchar
LeaseSignor4	Lease Signor 4	nvarchar
LeaseSpecialCondition	Lease Special Condition	nvarchar
LeaseText	Lease Text	nvarchar
LeaseType	Lease Type	nvarchar
LeaseTypeCode	Lease Type Code	nvarchar
LeaseTypeDescription	Lease Type Description	nvarchar
LeaseTypeId	Lease Type Id	int
LesseeName	Lessee Name	nvarchar
LessorAddress1	Lessor Address 1	nvarchar
LessorAddress2	Lessor Address 2	nvarchar
LessorCity	Lessor City	nvarchar
LessorFax	Lessor Fax	nvarchar
LessorName	Lessor Name	nvarchar
LessorPhone	Lessor Phone	nvarchar
LessorState	Lessor State	nvarchar
LessorZip	Lessor Zip	nvarchar
MarketValue	Market Value	decimal
MiscCharge	Miscellaneous Charge	decimal
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
MonthlyGrossSale	Monthly Gross Sale	decimal
NSFCharge	Insufficient Funds Charge	decimal
Number	Lease Number	nvarchar
NumberOfNSFChecks	Number of Insufficient Funds Checks	int
OccupancyDate	Occupancy Date	datetime
ParentId	Parent Id	int
ParentNumber	Parent Number	nvarchar
ParkingSpot	Parking Spot	int
PayCode	Pay Code	nvarchar
PaymentFrequency	Payment Frequency	int
PaymentFrequencyValue	Payment Frequency Value	int
PrepaidRent	Prepaid Rent	decimal
PreviousBalance	Previous Balance	decimal
PropertyActualSF	Property Actual Square Footage	int
PropertyRentableSF	Property Rentable Square Footage	int
RemainingDue	Remaining Due	decimal
RenewDate	Renew Date	datetime
RentAbatement	Rent Abatement	decimal
RentBillingPercent	Rent Billing Percent	decimal
RentDueDate	Rent Due Date	datetime
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
ReturnDate	Return Date	datetime
ReviewDate	Review Date	datetime
StartDate	Start Date	datetime
StatusAllowNote	Indicates if this record allows a status note	bit
StatusCode	Status Code	nvarchar
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
TagNumber	Tag Number	nvarchar
TaxBase	Tax Base	decimal
TaxBaseYear	Tax Base Year	int
TaxPaid	Tax Paid	decimal
TenantAddress1	Tenant Address 1	nvarchar
TenantAddress2	Tenant Address 2	nvarchar
TenantCity	Tenant City	nvarchar
TenantCode	Tenant Code	nvarchar
TenantEmail	Tenant Email	nvarchar
TenantId	Tenant Id	int
TenantMemo	Tenant Memo	nvarchar
TenantName	Tenant Name	nvarchar
TenantState	Tenant State	nvarchar
TenantZip	Tenant Zip	nvarchar
VendorAddressAddress1	Vendor Address Line 1	nvarchar
VendorAddressAddress2	Vendor Address Line 2	nvarchar
VendorAddressCategory	Vendor Address Category	nvarchar
VendorAddressCity	Vendor City	nvarchar
VendorAddressContact	Vendor Contact	nvarchar
VendorAddressEmail	Vendor Email	nvarchar
VendorAddressFax	Vendor Fax #	nvarchar
VendorAddressId	Vendor Address Id	int	vr_VendorAddress
VendorAddressPhone	Vendor Phone #	nvarchar
VendorAddressPhoneExtension	Vendor Phone # Extension	nvarchar
VendorAddressState	Vendor State	nvarchar
VendorAddressZipCode	Vendor Zip Code	nvarchar
VendorCode	Vendor Code	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorLabel	Vendor Label	varchar
VendorName	Vendor Name	nvarchar

Articles in this section