vrpt_ARLeaseInvoice

Updated December 19, 2025 15:54

Field Name	Field Description	Data Type	FK Join
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
arli_baserent	Base Rent	decimal
arli_executionCost	Execution Cost	decimal
arli_latePayment	Late Payment	decimal
arli_operatingExpense	Operating Expense	decimal
arli_otherPayment	Other Payment	decimal
arli_otherTax	Other Tax	decimal
arli_realPropertyTax	Real Property Tax	decimal
arli_wocharge	Work Order Charge	decimal
Baserent	Base Rent	decimal
BatchJobId	Batch Job Id	int	vr_BatchJob
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeDateId	Currency Exchange Date Id	int
CurrencyId	Currency Id	int	vrpt_Currency
Date	Date	datetime
DiscountDays	Discount Days	int
DiscountPercent	Discount Percent	decimal
DueDate	Due Date	datetime
ExecutionCost	Execution Cost	decimal
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Accounts Receivable Lease Invoice Id	int
LatePayment	Late Payment	decimal
lease_venaddr_fk	Vendor Address Id	int	vr_VendorAddress
LeaseDescription	Lease Description	nvarchar
LeaseId	Lease Id	int	vrpt_Lease
LeaseNumber	Lease Number	nvarchar
LeasePayable	Lease Payable	bit
LeaseScheduleId	Lease Schedule Id	int
LeaseStatus	Lease Status	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Accounts Receivable Lease Invoice Number	nvarchar
OperatingExpense	Operating Expense	decimal
OtherPayment	Other Payment	decimal
OtherTax	Other Tax	decimal
PaidLateProcessed	Indicates if the record's payment was processed as late	bit
RealPropertyTax	Real Property Tax	decimal
ReferenceNumber	Reference Number	nvarchar
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
SiteCode	Site Code	nvarchar
SiteId	Site Id	int	vr_Site
SiteName	Site Name	nvarchar
st_description	Site Description	nvarchar
StatusCode	Status Code	nvarchar
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
SubTotalAmount	Sub Total Amount	decimal
TaxAmount	Tax Amount	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
TenantName	Tenant Name	nvarchar
TenantState	Tenant State	nvarchar
TenantZip	Tenant Zip	nvarchar
TermDays	Term Days	int
TotalAmount	Total Amount	decimal
venaddr_city	Vendor City	nvarchar
venaddr_state	Vendor State	nvarchar
venaddr_zipcode	Vendor Zip Code	nvarchar
VendorAddressLinkAddress1	Vendor Address Link Address 1	nvarchar
VendorAddressLinkAddress2	Vendor Address Link Address 2	nvarchar
VendorAddressLinkContact	Vendor Address Link Contact	nvarchar
VendorAddressLinkEmail	Vendor Address Link Email	nvarchar
VendorAddressLinkFax	Vendor Address Link Fax	nvarchar
VendorAddressLinkPhone	Vendor Address Link Phone	nvarchar
WoCharge	Work Order Charge	decimal

Articles in this section