cof_c_cnabconfig

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofccnabconfig R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofccnabconfig R
cof_c_cnabconfig_id numeric 10 null
cof_c_bankintegration.cof_c_cnabconfig_id cofccnabconfig_cofcbankintegra R
cof_c_bankintegration.cof_c_cnabconfigret_id cofccnabconfigret_cofcbankinte R
cof_c_cnabconfig_line.cof_c_cnabconfig_id cofccnabconfig_cofccnabconfigl C
cof_c_cnabconfig_line.cof_c_cnabconfigincluso_id cofccnabconfigincluso_cofccnab R
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofccnabconfig R
isactive bpchar 1 'Y'::bpchar
issotrx bpchar 1 √ NULL::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofccnabconfig R
description varchar 255 √ NULL::character varying
cof_operationtype varchar 3 √ null
cof_c_cnabconfig_uu varchar 36 √ NULL::character varying
processing bpchar 1 √ NULL::bpchar
cof_c_fileformat varchar 10 'UTF-8'::character varying
issummary bpchar 1 'Y'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_c_cnabconfig_key Primary key Asc cof_c_cnabconfig_id
cof_c_cnabconfig_uu_idx Must be unique Asc cof_c_cnabconfig_uu

Check Constraints

Constraint Name Constraint
cof_c_cnabconfig_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_cnabconfig_issummary_check ((issummary = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation