aurora_standard.stmaintd
| Field | Type | Null | Default | Key | Extra | Comment |
| maint_property | char(20) | YES | | | | |
| maint_type_code | char(30) | YES | | | | |
| maint_serial_no | char(20) | YES | | | | |
| maint_vendor_code | char(6) | YES | | | | |
| maint_start_date | date | YES | | | | |
| maint_end_date | date | YES | | | | |
| maint_comp_date | date | YES | | | | |
| maint_est_cost | decimal(14,2) | YES | | | | |
| maint_actual_cost | decimal(14,2) | YES | | | | |
| maint_desc | char(67) | YES | | | | |
| maint_update_by | char(10) | YES | | | | |
| maint_update_date | date | YES | | | | |
| maint_actual_vend | char(6) | YES | | | | |
| maint_comp_po | char(10) | YES | | | | |
| maint_desc2 | char(67) | YES | | | | |
| maint_desc3 | char(67) | YES | | | | |
| maint_desc4 | char(67) | YES | | | | |
| maint_po_date | date | YES | | | | |
| maint_po_item_code | char(20) | YES | | | | |
| maint_abused | char(1) | YES | | | | |
| chs_rowID | bigint(20) unsigned | NO | | PRI | auto_increment | |
References