c_taxprovider

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
account varchar 60 √ NULL::character varying
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_ctaxprovider R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_ctaxprovider R
c_taxprovider_id numeric 10 null
c_invoicetax.c_taxprovider_id ctaxprovider_cinvoicetax R
c_ordertax.c_taxprovider_id ctaxprovider_cordertax R
c_tax.c_taxprovider_id ctaxprovider_ctax R
m_rmatax.c_taxprovider_id ctaxprovider_mrmatax R
c_taxprovider_uu varchar 36 √ NULL::character varying
c_taxprovidercfg_id numeric 10 null
c_taxprovidercfg.c_taxprovidercfg_id ctaxprovidercfg_ctaxprovider R
companycode varchar 60 √ NULL::character varying
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
ad_user.ad_user_id createdby_ctaxprovider R
isactive bpchar 1 'Y'::bpchar
license varchar 60 √ NULL::character varying
name varchar 120 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
ad_user.ad_user_id updatedby_ctaxprovider R
seqno numeric 10 (0)::numeric
validateconnection bpchar 1 √ NULL::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_taxprovider_key Primary key Asc c_taxprovider_id
c_taxprovider_uu_idx Must be unique Asc c_taxprovider_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation