cof_retentionconfig

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofretentionconfig R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofretentionconfig R
c_charge_id numeric 10 √ NULL::numeric
c_charge.c_charge_id ccharge_cofretentionconfig R
cof_retentionconfig_id numeric 10 null
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofretentionconfig R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofretentionconfig R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_cofretentionconfig R
c_doctype_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cdoctype_cofretentionconfig R
lbr_taxname_id numeric 10 √ NULL::numeric
lbr_taxname.lbr_taxname_id lbrtaxname_cofretentionconfig R
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id cpaymentterm_cofretentionconfi R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_cofretention R
cof_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id cofpaymentterm_cofretentioncon R
cof_retentionconfig_uu varchar 36 √ NULL::character varying
cof_configuracaorentencao bpchar 1 'A'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_retentionconfig_key Primary key Asc cof_retentionconfig_id
cof_retentionconfig_uu_idx Must be unique Asc cof_retentionconfig_uu

Check Constraints

Constraint Name Constraint
cof_retentionconfig_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation