aurora_standard.styaccrr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| accr_code | varchar(6) | YES | UNI | |||
| accr_desc | varchar(30) | YES | ||||
| accr_method | varchar(1) | YES | ||||
| accr_rate | decimal(18,8) | YES | ||||
| accr_freq | int(11) | YES | ||||
| accr_lapse | int(11) | YES | ||||
| accr_basis | varchar(1) | YES | ||||
| accr_max | decimal(12,4) | YES | ||||
| accr_when | varchar(1) | YES | ||||
| roll_over_date | date | YES | ||||
| accrue_liab | varchar(1) | YES | ||||
| accrue_liab_date | date | YES | ||||
| liab_fac_no | varchar(3) | YES | ||||
| liab_acct | int(11) | YES | ||||
| liab_dept | varchar(3) | YES | ||||
| expense_fac_no | varchar(3) | YES | ||||
| expense_acct | int(11) | YES | ||||
| expense_dept | varchar(3) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| accr_code |
|