Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| ctsid | int8 | 19 | √ | null |
|
|
|||||
| ctesid | int8 | 19 | √ | null |
|
|
|||||
| ctrid | int8 | 19 | √ | null |
|
|
|||||
| ctsorder | int4 | 10 | √ | null |
|
|
|||||
| ctstype | varchar | 10 | √ | null |
|
|
|||||
| ctsterm | varchar | 10 | √ | null |
|
|
|||||
| ctsperiodicity | varchar | 10 | √ | null |
|
|
|||||
| ctsduedate | date | 13 | √ | null |
|
|
|||||
| ctsstartdate | date | 13 | √ | null |
|
|
|||||
| ctsenddate | date | 13 | √ | null |
|
|
|||||
| ctsactuarialrate | float8 | 17,17 | √ | null |
|
|
|||||
| ctsstartamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsamortizedamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsinterestamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsrentalamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsoutstandingamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsbasisamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsbasisrate | float8 | 17,17 | √ | null |
|
|
|||||
| ciid | int8 | 19 | √ | null |
|
|
|||||
| ctsstatus | varchar | 10 | √ | null |
|
|
|||||
| ctsdepositbasis | float8 | 17,17 | √ | null |
|
|
|||||
| ctsdepositrate | float8 | 17,17 | √ | null |
|
|
|||||
| ctsdepositinterest | float8 | 17,17 | √ | null |
|
|
|||||
| taxcode | varchar | 10 | √ | null |
|
|
|||||
| ctscategory | varchar | 10 | √ | null |
|
|
|||||
| assetid | int8 | 19 | √ | null |
|
|
|||||
| tpid | int8 | 19 | √ | null |
|
|
|||||
| ctdescription | varchar | 255 | √ | null |
|
|
|||||
| tpreference | varchar | 30 | √ | null |
|
|
|||||
| tpname | varchar | 100 | √ | null |
|
|
|||||
| currcode | varchar | 10 | √ | null |
|
|