Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ad_window_id | numeric | 10 | √ | null |
|
|
||
| ad_tab_id | numeric | 10 | √ | null |
|
|
||
| ad_field_id | numeric | 10 | √ | null |
|
|
||
| ad_table_id | numeric | 10 | √ | null |
|
|
||
| ad_column_id | numeric | 10 | √ | null |
|
|
||
| name | varchar | 60 | √ | null |
|
|
||
| description | varchar | 255 | √ | null |
|
|
||
| help | varchar | 2000 | √ | null |
|
|
||
| isdisplayed | bpchar | 1 | √ | null |
|
|
||
| displaylogic | varchar | 2000 | √ | null |
|
|
||
| displaylength | numeric | 10 | √ | null |
|
|
||
| seqno | numeric | 10 | √ | null |
|
|
||
| sortno | numeric | 10 | √ | null |
|
|
||
| issameline | bpchar | 1 | √ | null |
|
|
||
| isheading | bpchar | 1 | √ | null |
|
|
||
| isfieldonly | bpchar | 1 | √ | null |
|
|
||
| isreadonly | bpchar | 1 | √ | null |
|
|
||
| isencryptedfield | bpchar | 1 | √ | null |
|
|
||
| obscuretype | bpchar | 3 | √ | null |
|
|
||
| columnname | varchar | 63 | √ | null |
|
|
||
| columnsql | varchar | 4000 | √ | null |
|
|
||
| fieldlength | numeric | 10 | √ | null |
|
|
||
| vformat | varchar | 255 | √ | null |
|
|
||
| defaultvalue | varchar | 2000 | √ | null |
|
|
||
| iskey | bpchar | 1 | √ | null |
|
|
||
| isparent | bpchar | 1 | √ | null |
|
|
||
| ismandatory | bpchar | 1 | √ | null |
|
|
||
| isidentifier | bpchar | 1 | √ | null |
|
|
||
| istranslated | bpchar | 1 | √ | null |
|
|
||
| ad_reference_value_id | numeric | 10 | √ | null |
|
|
||
| callout | varchar | 255 | √ | null |
|
|
||
| ad_reference_id | numeric | 10 | √ | null |
|
|
||
| ad_val_rule_id | numeric | 10 | √ | null |
|
|
||
| ad_process_id | numeric | 10 | √ | null |
|
|
||
| isalwaysupdateable | bpchar | 1 | √ | null |
|
|
||
| readonlylogic | varchar | 2000 | √ | null |
|
|
||
| mandatorylogic | varchar | 2000 | √ | null |
|
|
||
| isupdateable | bpchar | 1 | √ | null |
|
|
||
| isencryptedcolumn | bpchar | 1 | √ | null |
|
|
||
| isselectioncolumn | bpchar | 1 | √ | null |
|
|
||
| tablename | varchar | 60 | √ | null |
|
|
||
| valuemin | varchar | 20 | √ | null |
|
|
||
| valuemax | varchar | 20 | √ | null |
|
|
||
| fieldgroup | varchar | 60 | √ | null |
|
|
||
| validationcode | varchar | 4000 | √ | null |
|
|
||
| included_tab_id | numeric | 10 | √ | null |
|
|
||
| fieldgrouptype | varchar | 10 | √ | null |
|
|
||
| iscollapsedbydefault | bpchar | 1 | √ | null |
|
|
||
| infofactoryclass | varchar | 255 | √ | null |
|
|
||
| isautocomplete | bpchar | 1 | √ | null |
|
|
||
| isallowcopy | bpchar | 1 | √ | null |
|
|
||
| isdisplayedgrid | bpchar | 1 | √ | null |
|
|
||
| seqnogrid | numeric | 10 | √ | null |
|
|
||
| seqnoselection | numeric | 10 | √ | null |
|
|
||
| xposition | numeric | 10 | √ | null |
|
|
||
| columnspan | numeric | 10 | √ | null |
|
|
||
| numlines | numeric | 10 | √ | null |
|
|
||
| bpchar | 1 | √ | null |
|
|
|||
| formatpattern | varchar | 22 | √ | null |
|
|
||
| isadvancedfield | bpchar | 1 | √ | null |
|
|
||
| isdefaultfocus | bpchar | 1 | √ | null |
|
|
||
| ad_chart_id | numeric | 10 | √ | null |
|
|
||
| ad_labelstyle_id | numeric | 10 | √ | null |
|
|
||
| ad_fieldstyle_id | numeric | 10 | √ | null |
|
|
||
| pa_dashboardcontent_id | numeric | 10 | √ | null |
|
|
||
| placeholder | varchar | 255 | √ | null |
|
|
||
| ishtml | bpchar | 1 | √ | null |
|
|
||
| isquickform | bpchar | 1 | √ | null |
|
|
||
| ad_val_rule_lookup_id | numeric | 10 | √ | null |
|
|
||
| validationcodelookup | varchar | 4000 | √ | null |
|
|
||
| alwaysupdatablelogic | varchar | 2000 | √ | null |
|
|
||
| ad_infowindow_id | numeric | 10 | √ | null |
|
|
||
| entitytype | varchar | 40 | √ | null |
|
|