aurora_standard.stytypdd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| type_code | varchar(6) | YES | MUL | |||
| ded_code | varchar(6) | YES | ||||
| line_no | smallint(6) | YES | ||||
| ded_rate | decimal(18,8) | YES | ||||
| ded_limit | decimal(12,2) | YES | ||||
| ded_apply | varchar(1) | YES | ||||
| acct_no | int(11) | YES | ||||
| department | varchar(3) | YES | ||||
| lo_ded_amt | decimal(12,2) | YES | ||||
| hi_ded_amt | decimal(12,2) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |