aurora_standard.c8bals
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fullnm | char(40) | YES | MUL | |||
| vis_no | char(20) | YES | MUL | |||
| ps_cd | char(20) | YES | ||||
| adm_dt | char(10) | YES | ||||
| dis_dt | char(10) | YES | ||||
| lpay_dt | char(10) | YES | ||||
| bill_stat | varchar(2) | YES | ||||
| unb_amt | decimal(10,2) | YES | ||||
| billed_amt | decimal(10,2) | YES | ||||
| late_amt | decimal(10,2) | YES | ||||
| tot_chrgs | decimal(10,2) | YES | ||||
| sp_bal | decimal(10,2) | YES | ||||
| ins_nm | char(20) | YES | ||||
| ins_bal | decimal(10,2) | YES | ||||
| curbal | decimal(10,2) | YES |
References
| Local Column | References | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| adm_dt |
| ||||||||
| ins_nm |
| ||||||||
| fullnm |
| ||||||||
| vis_no |
|