eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PN_VAR_LINES_ALL

Product:	PN - Property Manager
Description:	Stores information related to line items associated within each period for a variable rent.
Implementation/DBA Data:	PN.PN_VAR_LINES_ALL

Primary Key: PN_VAR_LINES_PK

LINE_ITEM_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PN_VAR_LINES_ALL	PN_VAR_PERIODS_ALL	PN_VAR_LINES_ALL.PERIOD_ID
PN_VAR_LINES_ALL	%	PN_VAR_LINES_ALL.LINE_TEMPLATE_ID
PN_VAR_LINES_ALL	%	PN_VAR_LINES_ALL.AGREEMENT_TEMPLATE_ID
PN_VAR_LINES_ALL	PN_VAR_RENTS_ALL	PN_VAR_LINES_ALL.VAR_RENT_ID
PN_VAR_LINES_ALL	%	PN_VAR_LINES_ALL.LINE_TEMPLATE_ID
PN_VAR_LINES_ALL	%	PN_VAR_LINES_ALL.LINE_DEFAULT_ID
PN_VAR_LINES_ALL	PN_VAR_PERIODS_ALL	PN_VAR_LINES_ALL.PERIOD_ID
PN_VAR_BKPTS_HEAD_ALL	PN_VAR_LINES_ALL	PN_VAR_BKPTS_HEAD_ALL.LINE_ITEM_ID
PN_VAR_DEDUCTIONS_ALL	PN_VAR_LINES_ALL	PN_VAR_DEDUCTIONS_ALL.LINE_ITEM_ID
PN_VAR_VOL_HIST_ALL	PN_VAR_LINES_ALL	PN_VAR_VOL_HIST_ALL.LINE_ITEM_ID
PN_VAR_DEDUCTIONS_ALL	PN_VAR_LINES_ALL	PN_VAR_DEDUCTIONS_ALL.LINE_ITEM_ID
PN_VAR_BKPTS_HEAD_ALL	PN_VAR_LINES_ALL	PN_VAR_BKPTS_HEAD_ALL.LINE_ITEM_ID
PN_VAR_RENT_SUMM_ALL	PN_VAR_LINES_ALL	PN_VAR_RENT_SUMM_ALL.LINE_ITEM_ID
PN_VAR_RENT_SUMM_ALL	PN_VAR_LINES_ALL	PN_VAR_RENT_SUMM_ALL.LINE_ITEM_ID
PN_VAR_VOL_HIST_ALL	PN_VAR_LINES_ALL	PN_VAR_VOL_HIST_ALL.LINE_ITEM_ID