cof_c_cnabconfig_line

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofccnabconfigline R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofccnabconfigline R
cof_c_cnabconfig_line_id numeric 10 null
cof_cnablinetype varchar 2 √ NULL::character varying
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofccnabconfigline R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofccnabconfigline R
name varchar 60 √ NULL::character varying
seqno numeric 10 √ NULL::numeric
startno numeric 10 √ (100)::numeric
endno numeric 10 √ NULL::numeric
datatype bpchar 1 √ NULL::bpchar
decimalpattern varchar 40 √ NULL::character varying
dateformat varchar 40 √ NULL::character varying
script varchar 2000 √ NULL::character varying
cof_c_cnabconfig_id numeric 10 √ null
cof_c_cnabconfig.cof_c_cnabconfig_id cofccnabconfig_cofccnabconfigl C
cof_leftalign bpchar 1 √ 'N'::bpchar
cof_filler varchar 1 √ NULL::character varying
defaultvalue varchar 100 √ NULL::character varying
cof_isoccurrencecode bpchar 1 √ NULL::bpchar
cof_isidentifier bpchar 1 √ 'N'::bpchar
cof_identifiercolumn varchar 255 √ NULL::character varying
cof_ischarge bpchar 1 √ 'N'::bpchar
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_cofccnabconfigline R
cof_c_cnabconfig_line_uu varchar 36 √ NULL::character varying
cof_isupper bpchar 1 √ 'N'::bpchar
cof_isremovespecial bpchar 1 √ 'N'::bpchar
cof_isonlynumbers bpchar 1 √ 'N'::bpchar
cof_condition varchar 500 √ NULL::character varying
cof_isnegativevalue bpchar 1 √ 'N'::bpchar
iscounted bpchar 1 √ 'N'::bpchar
issummarized bpchar 1 √ 'N'::bpchar
cof_recordidentifier varchar 22 √ null
description varchar 2000 √ null
cof_c_cnabconfigincluso_id numeric 10 √ NULL::numeric
cof_c_cnabconfig.cof_c_cnabconfig_id cofccnabconfigincluso_cofccnab R
cof_expignoreline varchar 50 √ NULL::character varying
cof_posicao bpchar 1 √ NULL::bpchar
isprinted bpchar 1 √ 'Y'::bpchar
cof_iscriarlinhaalocacaodespesa bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_c_cnabconfig_line_key Primary key Asc cof_c_cnabconfig_line_id
cof_c_cnabconfig_line_uu_idx Must be unique Asc cof_c_cnabconfig_line_uu

Check Constraints

Constraint Name Constraint
cof_c_cnabconfig_line_cof_ischarge_check ((cof_ischarge = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_cof_isremovespecial_check ((cof_isremovespecial = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_cof_isidentifier_check ((cof_isidentifier = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_cof_isonlynumbers_check ((cof_isonlynumbers = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_issummarized_check ((issummarized = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_iscounted_check ((iscounted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_cof_isoccurrencecode_check ((cof_isoccurrencecode = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_cof_isnegativevalue_check ((cof_isnegativevalue = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_cof_leftalign_check ((cof_leftalign = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_cof_iscriarlinhaalocacaodespesa_check ((cof_iscriarlinhaalocacaodespesa = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_line_cof_isupper_check ((cof_isupper = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation