aurora_standard.styempod
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| empl_code | varchar(6) | YES | MUL | |||
| obl_code | varchar(6) | YES | ||||
| line_no | bigint(20) unsigned | NO | PRI | auto_increment | ||
| obl_rate | decimal(18,8) | YES | ||||
| obl_limit | decimal(12,2) | YES | ||||
| acct_no | int(11) | YES | ||||
| department | varchar(3) | YES | ||||
| bal_acct_no | int(11) | YES | ||||
| bal_dept | varchar(3) | YES | ||||
| obl_qtd1 | decimal(12,2) | YES | ||||
| obl_qtd2 | decimal(12,2) | YES | ||||
| obl_qtd3 | decimal(12,2) | YES | ||||
| obl_qtd4 | decimal(12,2) | YES | ||||
| obl_ytd | decimal(12,2) | YES | ||||
| obl_apply | varchar(1) | YES | ||||
| obl_date | date | YES |