Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReportCode | varchar | 40 | ('') |
|
|
|||
| ReportSource | char | 1 | ('') |
|
|
|||
| ReportSeq | smallint | 2 | ((0)) |
|
|
|||
| ControlType | varchar | 30 | ('') |
|
|
|||
| ControlLevel | tinyint | 1 | ((1)) |
|
|
|||
| PrpTopRel | smallint | 2 | ((0)) |
|
|
|||
| PrpLeftRelRight | smallint | 2 | ((0)) |
|
|
|||
| PrpAdditional | varchar | 2000 | ('') |
|
|
|||
| LabelCaption | varchar | 50 | ('') |
|
|
|||
| FieldName | varchar | 2000 | ('') |
|
|
|||
| FieldType | varchar | 15 | ('') |
|
|
|||
| FieldDefaultValue | varchar | 30 | ('') |
|
|
|||
| FieldSelectJoin | varchar | 15 | √ | ('') |
|
|
||
| FieldSelectOperator | varchar | 10 | ('') |
|
|
|||
| FieldSortOrder | varchar | 4 | ('') |
|
|
|||
| LookupTable | varchar | 50 | ('') |
|
|
|||
| LookupSQL | varchar | 2000 | ('') |
|
|
|||
| ClearAllAbleFlag | bit | 1 | ((1)) |
|
|
|||
| MandatoryFlag | bit | 1 | ((0)) |
|
|
|||
| FieldSelectType | varchar | 5 | ('SQL ') |
|
|
|||
| FieldReference | varchar | 10 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ConfigReportForms_1__12 | Primary key | Asc/Asc/Asc | ReportCode + ReportSource + ReportSeq |