aurora_standard.stfdeprd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| asst_code | varchar(6) | YES | MUL | |||
| book_code | varchar(6) | YES | ||||
| last_depr | date | YES | ||||
| last_post | date | YES | ||||
| asst_basis | decimal(12,2) | YES | ||||
| salvage_val | decimal(12,2) | YES | ||||
| bonus_amt | decimal(12,2) | YES | ||||
| prior_depr | decimal(12,2) | YES | ||||
| curr_depr | decimal(12,2) | YES | ||||
| net_value | decimal(12,2) | YES | ||||
| depr_code | varchar(6) | YES | ||||
| limit_code | varchar(6) | YES | ||||
| avg_conv | varchar(1) | YES | ||||
| sl_conversion | varchar(1) | YES | ||||
| manual_val | varchar(1) | YES | ||||
| ok_to_post | varchar(1) | YES | ||||
| asst_life | decimal(4,1) | YES | ||||
| ok_to_adjust | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||
|---|---|---|---|---|---|
| book_code |
| ||||
| asst_code |
|