| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| dtrname | string |
None. |
|
| dtrcode | string |
None. |
|
| dtrlat | string |
None. |
|
| dtrlon | string |
None. |
|
| zone | string |
None. |
|
| feedername | string |
None. |
|
| supplytype | string |
None. |
|
| ratedcap | string |
None. |
|
| rfname | string |
None. |
|
| rrlname | string |
None. |
|
| remail | string |
None. |
|
| rphone | string |
None. |
|
| faulttype | string |
None. |
|
| fault | string |
None. |
|
| rlat | string |
None. |
|
| rlon | string |
None. |
|
| lvl | string |
None. |
|
| comment | string |
None. |
|
| requested_date | date |
None. |
|
| rp_status | string |
None. |
|
| pcm_comment | string |
None. |
|
| hq_approved | string |
None. |
|
| hq_email | string |
None. |
|
| keyn | string |
None. |
|
| accept_dtr | string |
None. |
|
| prerepair | string |
None. |
|
| postrepair | string |
None. |
|
| procument | string |
None. |
|
| tid | string |
None. |
|
| msg | string |
None. |
|
| backresponse | string |
None. |
|
| ptrfm | string |
None. |
|
| feedback | string |
None. |
|
| agm_feedback | string |
None. |
|
| confirmok | string |
None. |
|
| wrkready | string |
None. |
|
| dtrtype | string |
None. |
|
| siterepaired | string |
None. |
|
| close_status | string |
None. |
|
| dtr_comment | string |
None. |
|
| ntm_comment | string |
None. |
|
| mte_comment | string |
None. |
|
| pc_comment | string |
None. |
|
| hne_comment | string |
None. |
|
| prc_comment | string |
None. |
|
| wrk_comment | string |
None. |
|
| cto_comment | string |
None. |
|
| ntm_approved_status | string |
None. |
|
| dtr_file | string |
None. |
|
| ntm_file | string |
None. |
|
| mte_file | string |
None. |
|
| pc_file | string |
None. |
|
| hne_file | string |
None. |
|
| prc_file | string |
None. |
|
| wrk_file | string |
None. |
|
| cto_file | string |
None. |
|
| pcm_file | string |
None. |
|
| dtr_comment_date | date |
None. |
|
| ntm_comment_date | date |
None. |
|
| mte_comment_date | date |
None. |
|
| pc_comment_date | date |
None. |
|
| hne_comment_date | date |
None. |
|
| prc_comment_date | date |
None. |
|
| wrk_comment_date | date |
None. |
|
| cto_comment_date | date |
None. |
|
| pcm_comment_date | date |
None. |
|
| rfile | string |
None. |
|
| manufactureyr | string |
None. |
|
| manufacturer | string |
None. |
|
| feeder11code | string |
None. |
|
| feeder11name | string |
None. |
|
| feeder33code | string |
None. |
|
| metered_status | string |
None. |
|
| wrk_complete_status | string |
None. |
|
| pcm_return | string |
None. |
|
| prc_return | string |
None. |
|
| ntm_return | string |
None. |
|
| pcm_confirm_return | string |
None. |
|
| pcm_closed_status | string |
None. |
|
| pcm_reject_return | string |
None. |
|
| oil_date | string |
None. |
|
| hne_comment_approval | string |
None. |
|
| hne_comment_date_approval | date |
None. |
|
| wrk_complete_status_date | date |
None. |
|
| pcm_return_date | date |
None. |
|
| ntm_return_date | date |
None. |
|
| pcm_confirm_return_date | date |
None. |
|
| pcm_closed_status_date | date |
None. |
|
| pcm_reject_return_date | date |
None. |
|
| approvehqreport | string |
None. |
|
| approvehqreportdate | date |
None. |
|
| cso_comment | string |
None. |
|
| cso_comment_date | date |
None. |
|
| is_material_required | decimal number |
None. |
|
| close_out_status | string |
None. |
|
| cso_reject_Reason | string |
None. |
|
| cso_file | string |
None. |
|
| DTRMaterialID | integer |
None. |
|
| pc_and_m_confirm_reason | string |
None. |
|
| ntm_pcm_reject_reason | string |
None. |
|
| hpm_reject_reason | string |
None. |
|
| CTO_MATERIAL_APPROVAL_COMMENT | string |
None. |
|
| CTO_MATERIAL_APPROVAL_COMMENT_DATE | date |
None. |
|
| CTO_MATERIAL_REJECTION_COMMENT | string |
None. |
|
| PRC_REJECT_REASON | string |
None. |
|
| NTM_APPROVED_FEEDBACK | string |
None. |
|
| NTM_MSG_FEEDBACK | string |
None. |
|
| HPM_APPROVED_FEEDBACK | string |
None. |
|
| CTO_APPROVED_FEEDBACK | string |
None. |
|
| CSO_APPROVED_FEEDBACK | string |
None. |
|
| PRC_APPROVED_FEEDBACK | string |
None. |
|
| HPM_APPROVEDHQ_FEEDBACK | string |
None. |
|
| CTO_APPROVED_MATERIAL_FEEDBACK | string |
None. |
|
| WRK_APPROVED_MATERIAL_FEEDBACK | string |
None. |
|
| CONFIRM_OK_DATE | date |
None. |
|
| CLOSE_OUT_OIL_LEVEL | string |
None. |
|
| OIL_TYPE | string |
None. |
|
| OIL_NUMBER_LITERS | string |
None. |
|
| AMOUNT_OIL_RECEIVED | string |
None. |
|
| AMOUNT_OIL_LEAVING_WRK | string |
None. |
|
| OIL_DATE_MODIFIED | date |
None. |
|
| PCM_REPORT_OIL_LEVEL | string |
None. |
|
| HPM_HQ_REJECT_REASON | string |
None. |
|
| HPM_APPROVED_REPORT_FEEDBACK | string |
None. |
|
| HPM_APPROVED_REJECT_REASON | string |
None. |
|
| NTM_REPORT_REJECT_REASON | string |
None. |
|
| MATERIALS_REQUIRED_FRM_WRK | decimal number |
None. |
|
| GIS_VALIDATION_STATUS | decimal number |
None. |
|
| GIS_COMMENT | string |
None. |
|
| GIS_VALIDATION_DATE | date |
None. |