ad_field

31652 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_field_id numeric 10 null
ad_field_backup.ad_field_id Implied Constraint R
ad_field_trl.ad_field_id ad_fieldtrl C
ad_field_v.ad_field_id Implied Constraint R
ad_field_vt.ad_field_id Implied Constraint R
ad_fieldsuggestion.ad_field_id adfield_adfieldsuggestion R
ad_userdef_field.ad_field_id adfield_aduserdeffield R
asp_clientexception.ad_field_id adfield_aspclientexception R
asp_field.ad_field_id adfield_aspfield R
cof_configexportcontabformato.ad_field_id adfield_cofconfigexportcontabf R
cof_labelfield.ad_field_id adfield_coflabelfield R
cof_rv_customization.ad_field_id Implied Constraint R
ad_client_id numeric 10 null
ad_client.ad_client_id fieldclient R
ad_org_id numeric 10 null
ad_org.ad_org_id fieldorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
iscentrallymaintained bpchar 1 'Y'::bpchar
ad_tab_id numeric 10 null
ad_tab.ad_tab_id ad_tab_field C
ad_column_id numeric 10 √ null
ad_column.ad_column_id ad_column_field R
ad_fieldgroup_id numeric 10 √ null
ad_fieldgroup.ad_fieldgroup_id adfieldgroup_adfield R
isdisplayed bpchar 1 'Y'::bpchar
displaylogic varchar 2000 √ null
displaylength numeric 10 √ null
isreadonly bpchar 1 'N'::bpchar
seqno numeric 10 √ null
sortno numeric 10 √ null
issameline bpchar 1 'N'::bpchar
isheading bpchar 1 'N'::bpchar
isfieldonly bpchar 1 'N'::bpchar
isencrypted bpchar 1 'N'::bpchar
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adfield R
obscuretype bpchar 3 √ null
ad_reference_id numeric 10 √ null
ad_reference.ad_reference_id adreference_adfield R
ismandatory bpchar 1 √ null
included_tab_id numeric 10 √ null
ad_tab.ad_tab_id includedtab_adfield R
defaultvalue varchar 2000 √ null
ad_reference_value_id numeric 10 √ null
ad_reference.ad_reference_id adreferencevalue_adfield R
ad_val_rule_id numeric 10 √ null
ad_val_rule.ad_val_rule_id advalrule_adfield R
infofactoryclass varchar 255 √ null
ad_field_uu varchar 36 √ NULL::character varying
isallowcopy bpchar 1 √ NULL::bpchar
seqnogrid numeric 10 √ NULL::numeric
isdisplayedgrid bpchar 1 √ 'Y'::bpchar
xposition numeric 10 √ (1)::numeric
numlines numeric 10 √ (1)::numeric
columnspan numeric 10 √ (1)::numeric
isquickentry bpchar 1 'N'::bpchar
isupdateable bpchar 1 √ NULL::bpchar
isalwaysupdateable bpchar 1 √ NULL::bpchar
mandatorylogic varchar 2000 √ NULL::character varying
readonlylogic varchar 2000 √ NULL::character varying
istoolbarbutton bpchar 1 √ null
isadvancedfield bpchar 1 √ 'N'::bpchar
isdefaultfocus bpchar 1 'N'::bpchar
vformat varchar 255 √ NULL::character varying
ad_labelstyle_id numeric 10 √ NULL::numeric
ad_style.ad_style_id adlabelstyle_adfield R
ad_fieldstyle_id numeric 10 √ NULL::numeric
ad_style.ad_style_id adfieldstyle_adfield R
placeholder varchar 255 √ NULL::character varying
isselectioncolumn bpchar 1 √ NULL::bpchar
ad_val_rule_lookup_id numeric 10 √ NULL::numeric
ad_val_rule.ad_val_rule_id advalrulefind_adfield R
isquickform bpchar 1 'N'::bpchar
columnsql varchar 4000 √ null
ad_chart_id numeric 10 √ NULL::numeric
ad_chart.ad_chart_id adchart_adfield R
alwaysupdatablelogic varchar 2000 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_field_pkey Primary key Asc ad_field_id
ad_field_column Must be unique Asc/Asc ad_tab_id + ad_column_id
ad_field_uu_idx Must be unique Asc ad_field_uu

Check Constraints

Constraint Name Constraint
ad_field_isquickentry_check ((isquickentry = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isreadonly_check ((isreadonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isdisplayedgrid_check ((isdisplayedgrid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_iscentrallymaintained_check ((iscentrallymaintained = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isadvancedfield_check ((isadvancedfield = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isheading_check ((isheading = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_issameline_check ((issameline = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isfieldonly_check ((isfieldonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isdefaultfocus_check ((isdefaultfocus = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isencrypted_check ((isencrypted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isquickform_check ((isquickform = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_field_isdisplayed_check ((isdisplayed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation