vrpt_UtilityRateSchedule

Updated February 04, 2026 15:57

Field Name	Field Description	Data Type	FK Join
et_code	Utility Service Code	nvarchar
et_description	Utility Service Description	nvarchar
Id	Utility Rate Schedule Id	int
PK	Utility Rate Schedule Id	int
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
rs_adjLIMIT	Adjustment Limit	decimal
rs_adjPERCBILL	Adjustment Percentage Bill	decimal
rs_adjUNITCOST	Adjustment Unit Cost	decimal
rs_bdFlatRate	Billed Demand Flat Rate	decimal
rs_bdMonths	Billed Demand Months	decimal
rs_bdPcHi	Billed Demand Percent of the Greatest Recorded Demand	decimal
rs_bdPsCont	Billed Demand Percent of Contract Demand Amount	decimal
rs_billedDemand	Billed Demand	smallint
rs_calcBaseCost	Calculated Base Cost	decimal
rs_capImproveCost1	Capital Improvement Cost 1	decimal
rs_capImproveCost2	Capital Improvement Cost 2	decimal
rs_code	Code	nvarchar
rs_createdDate	Record Creation Date	datetime
rs_creator_fk	User Id (Record Creator)	nvarchar	vr_users
rs_curr_fk	Currency Id	int	vrpt_Currency
rs_dcAdjHi	Disconnect Adjustment High	decimal
rs_dcAdjLo	Disconnect Adjustment Low	decimal
rs_demandUnitCost	Demand Unit Cost	decimal
rs_demandUnitMax	Demand Unit Maximum	decimal
rs_demandUnitMin	Demand Unit Minimum	decimal
rs_demChargeTypeS	Demand Summer Charge Type	smallint
rs_demChargeTypeW	Demand Winter Charge Type	smallint
rs_description	Description	nvarchar
rs_et_fk	Utility Service Id	int	vr_UtilityService
rs_exch_date	Currency Exchange Date	datetime
rs_exch_fk	Currency Exchange Id	int
rs_flatCharge	Flat Charge	decimal
rs_generationCost	Generation Cost	decimal
rs_mantenanceCost	Maintenance Cost	decimal
rs_markUp	Mark Up	decimal
rs_maxAVGAmount	Maximum Average Amount	decimal
rs_maxAVGCharge	Maximum Average Charge	smallint
rs_minimumBILLDEMAND	Minimum Bill Demand	decimal
rs_minimumCharge	Minimum Charge	smallint
rs_minimumEQUAL	Minimum Equal	decimal
rs_minimumOFHIGH	Minimum Of High	decimal
rs_minimumPERCURR	Minimum Per Currency	decimal
rs_minimumPLUS	Minimum Plus	decimal
rs_minimumPROCMONTH	Minimum Proc Month	decimal
rs_minimumSet	Minimum Set	decimal
rs_modifiedDate	Last Modified Date	datetime
rs_modifier_fk	User Id (Record Modifier)	int	vr_users
rs_name	Name	nvarchar
rs_pfMinimumUnit	Pay Frequency Minimum Unit	decimal
rs_pfUnitCostH	Pay Frequency Unit Cost High	decimal
rs_pfUnitCostL	Pay Frequency Unit Cost Low	decimal
rs_pfUnitMax	Pay Frequency Unit Maximum	decimal
rs_pk	Utility Rate Schedule Id	int
rs_pmBPAverage	Indicates if the utility rate schedule record is using partial and multiple month billing period averaging method	bit
rs_purchaseCost	Purchase Cost	decimal
rs_pvDiscount	Primary Volt Discount	decimal
rs_pvMeter	Primary Volt Discount Meter	decimal
rs_rc_fk	Repair Center Id	int	vr_RepairCenter
rs_scFlatrate	Service Charge Flat Rate	decimal
rs_serviceCharge	Service Charge	smallint
rs_sFixedCharge	Summer Fixed Charge	decimal
rs_sstCH1	Summer Stepped Demand Charge 1	decimal
rs_sstCH10	Summer Stepped Demand Charge 10	decimal
rs_sstCH2	Summer Stepped Demand Charge 2	decimal
rs_sstCH3	Summer Stepped Demand Charge 3	decimal
rs_sstCH4	Summer Stepped Demand Charge 4	decimal
rs_sstCH5	Summer Stepped Demand Charge 5	decimal
rs_sstCH6	Summer Stepped Demand Charge 6	decimal
rs_sstCH7	Summer Stepped Demand Charge 7	decimal
rs_sstCH8	Summer Stepped Demand Charge 8	decimal
rs_sstCH9	Summer Stepped Demand Charge 9	decimal
rs_sstUNIT1	Summer Stepped Demand Unit 1	decimal
rs_sstUNIT10	Summer Stepped Demand Unit 10	decimal
rs_sstUNIT2	Summer Stepped Demand Unit 2	decimal
rs_sstUNIT3	Summer Stepped Demand Unit 3	decimal
rs_sstUNIT4	Summer Stepped Demand Unit 4	decimal
rs_sstUNIT5	Summer Stepped Demand Unit 5	decimal
rs_sstUNIT6	Summer Stepped Demand Unit 6	decimal
rs_sstUNIT7	Summer Stepped Demand Unit 7	decimal
rs_sstUNIT8	Summer Stepped Demand Unit 8	decimal
rs_sstUNIT9	Summer Stepped Demand Unit 9	decimal
rs_summerBegin	Summer Begin	datetime
rs_summerECharge	Summer Energy Charge	smallint
rs_summerFCUnit	Summer Fixed Charge Unit	decimal
rs_sUnitCost	Summer Unit Cost	decimal
rs_swCharge	Summer Winter Charge	bit
rs_taxADJMETH	Tax Adjustment Method	smallint
rs_ubAdjUnit	Used-Based Adjustment Unit	decimal
rs_ubUnitLimit	Used-Based Adjustment Unit Limit	decimal
rs_ven_fk	Vendor Id	int	vr_Vendor
rs_wFixedCharge	Winter Fixed Charge	decimal
rs_wFlatCharge	Winter Flat Charge	decimal
rs_winterBegin	Winter Begin	datetime
rs_winterECharge	Winter Energy Charge	smallint
rs_winterFCUnit	Winter Fixed Charge Unit	decimal
rs_wstCH1	Winter Stepped Demand Charge 1	decimal
rs_wstCH10	Winter Stepped Demand Charge 10	decimal
rs_wstCH2	Winter Stepped Demand Charge 2	decimal
rs_wstCH3	Winter Stepped Demand Charge 3	decimal
rs_wstCH4	Winter Stepped Demand Charge 4	decimal
rs_wstCH5	Winter Stepped Demand Charge 5	decimal
rs_wstCH6	Winter Stepped Demand Charge 6	decimal
rs_wstCH7	Winter Stepped Demand Charge 7	decimal
rs_wstCH8	Winter Stepped Demand Charge 8	decimal
rs_wstCH9	Winter Stepped Demand Charge 9	decimal
rs_wstUNIT1	Winter Stepped Demand Unit 1	decimal
rs_wstUNIT10	Winter Stepped Demand Unit 10	decimal
rs_wstUNIT2	Winter Stepped Demand Unit 2	decimal
rs_wstUNIT3	Winter Stepped Demand Unit 3	decimal
rs_wstUNIT4	Winter Stepped Demand Unit 4	decimal
rs_wstUNIT5	Winter Stepped Demand Unit 5	decimal
rs_wstUNIT6	Winter Stepped Demand Unit 6	decimal
rs_wstUNIT7	Winter Stepped Demand Unit 7	decimal
rs_wstUNIT8	Winter Stepped Demand Unit 8	decimal
rs_wstUNIT9	Winter Stepped Demand Unit 9	decimal
rs_wUnitCost	Winter Unit Cost	decimal
serviceCharge	Service Charge	nvarchar
ven_code	Vendor Code	nvarchar
ven_Name	Vendor Name	nvarchar

Articles in this section