aurora_standard.stytaxtd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| tax_year | varchar(4) | YES | MUL | |||
| ded_code | varchar(6) | YES | ||||
| pay_period | varchar(1) | YES | ||||
| marital_stat | varchar(2) | YES | ||||
| over_amt | decimal(12,2) | YES | MUL | |||
| base_amt | decimal(12,2) | YES | ||||
| tax_rate | decimal(18,8) | YES | ||||
| order_no | smallint(6) | YES | ||||
| state_marital | varchar(2) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||
|---|---|---|---|---|---|---|---|
| order_no |
| ||||||
| ded_code |
| ||||||
| tax_year |
| ||||||
| tax_rate |
|