aurora_standard.chmprchd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| service_code | varchar(10) | YES | ||||
| prev_charge | decimal(10,3) | YES | ||||
| change_date | date | YES | ||||
| last_cost | decimal(10,3) | YES | ||||
| input_by | int(11) | YES | ||||
| change_time | time | YES | ||||
| progid | varchar(17) | YES | ||||
| prev_descrip | varchar(30) | YES | ||||
| cur_descrip | varchar(30) | YES | ||||
| prev_loc | varchar(20) | YES | ||||
| cur_loc | varchar(20) | YES | ||||
| cur_charge | decimal(10,3) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||
|---|---|---|---|---|---|---|---|
| change_date |
|