| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| cpset_cps_fk | Capital Planning Setup Id | int | vrpt_cpSetup |
| cpset_createdDate | Record Creation Date | datetime | |
| cpset_creator_fk | User Id (Record Creator) | int | vr_users |
| cpset_et_fk | Utility Service Id | int | vr_UtilityService |
| cpset_modifiedDate | Last Modified Date | datetime | |
| cpset_modifier_fk | User Id (Record Modifier) | int | vr_users |
| cpset_sequence | Sequence | int | |
| cst_code | Account Code | nvarchar | |
| cst_name | Account Name | nvarchar | |
| et_code | Utility Service Code | nvarchar | |
| et_conversion | Utility Service Conversion | decimal | |
| et_cst_fk | Account Id | int | vr_account |
| et_description | Utility Service Description | nvarchar | |
| et_pk | Utility Service Id | int | vr_UtilityService |
| et_serviceTypeText | Service Type Text | nvarchar | |
| et_unit | Utility Service Unit | nvarchar | |
| ett_code | Utility Service Type Code | nvarchar | |
| ett_description | Utility Service Type Description | nvarchar | |
| Id | Utility Service Id | int | vr_UtilityService |