aurora_standard.chsfacon
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| asst_code | varchar(6) | YES | ||||
| asst_desc | varchar(30) | YES | ||||
| clss_code | varchar(6) | YES | ||||
| in_service | date | YES | ||||
| asset_cost | decimal(12,2) | YES | ||||
| net_value | decimal(12,2) | YES | ||||
| asst_life | decimal(4,1) | YES | ||||
| prior_depr | decimal(12,2) | YES | ||||
| last_post | date | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||
|---|---|---|---|---|---|
| asst_code |
|