Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ctrid | int8 | 19 | √ | null |
|
|
|||||
| mgid | int8 | 19 | √ | null |
|
|
|||||
| ctreference | varchar | 30 | √ | null |
|
|
|||||
| currcode | varchar | 10 | √ | null |
|
|
|||||
| ctdescription | varchar | 255 | √ | null |
|
|
|||||
| ctedescription | varchar | 250 | √ | null |
|
|
|||||
| cteid | int8 | 19 | √ | null |
|
|
|||||
| ctsterm | varchar | 10 | √ | null |
|
|
|||||
| ctetype | varchar | 10 | √ | null |
|
|
|||||
| ctecategory | varchar | 10 | √ | null |
|
|
|||||
| ctefinancedamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsid | int8 | 19 | √ | null |
|
|
|||||
| ctstype | varchar | 10 | √ | null |
|
|
|||||
| ctscategory | varchar | 10 | √ | null |
|
|
|||||
| ctsamortizedamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsinterestamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsrentalamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsstartamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsoutstandingamount | float8 | 17,17 | √ | null |
|
|
|||||
| ctsstartdate | date | 13 | √ | null |
|
|
|||||
| ctsenddate | date | 13 | √ | null |
|
|
|||||
| ctsduedate | date | 13 | √ | null |
|
|
|||||
| ctsstatus | varchar | 10 | √ | null |
|
|