cof_configuracaofiscal

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

null

ad_client.ad_client_id

adclient_cofconfiguracaofiscal

ad_org_id

numeric

null

ad_org.ad_org_id

adorg_cofconfiguracaofiscal

cof_cstcofins_id

numeric

√

NULL::numeric

lbr_taxstatus.lbr_taxstatus_id

cofcstcofins_cofconfiguracaofiscal

cof_csticms_id

numeric

√

NULL::numeric

lbr_taxstatus.lbr_taxstatus_id

cofcsticms_cofconfiguracaofiscal

cof_cstipi_id

numeric

√

NULL::numeric

lbr_taxstatus.lbr_taxstatus_id

cofcstipi_cofconfiguracaofiscal

cof_cstpis_id

numeric

√

NULL::numeric

lbr_taxstatus.lbr_taxstatus_id

cofcstpis_cofconfiguracaofiscal

cof_configuracaofiscal_id

numeric

null

cof_configuracaofiscal_uu

varchar

√

NULL::character varying

cof_isajustarcofins

bpchar

'N'::bpchar

cof_isajustaricms

bpchar

'N'::bpchar

cof_isajustaripi

bpchar

'N'::bpchar

cof_isajustarpis

bpchar

'N'::bpchar

cof_iscreditarcofinscusto

bpchar

'N'::bpchar

cof_iscreditaricmscusto

bpchar

'N'::bpchar

cof_iscreditaripicusto

bpchar

'N'::bpchar

cof_iscreditarimpostoscusto

bpchar

'N'::bpchar

cof_iscreditarpiscusto

bpchar

'N'::bpchar

cof_isdeduziricmsbccofins

bpchar

'N'::bpchar

cof_isdeduziricmsbcpis

bpchar

'N'::bpchar

cof_isforcarcofins

bpchar

'N'::bpchar

cof_isforcarpis

bpchar

'N'::bpchar

cof_issobrescreveraliquotacofins

bpchar

'N'::bpchar

cof_issobrescreveraliquotapis

bpchar

'N'::bpchar

cof_issobrescreverbccofins

bpchar

'N'::bpchar

cof_issobrescreverbcpis

bpchar

'N'::bpchar

cof_issobrescrevercstcofins

bpchar

'N'::bpchar

cof_issobrescrevercsticms

bpchar

'N'::bpchar

cof_issobrescrevercstipi

bpchar

'N'::bpchar

cof_issobrescrevercstpis

bpchar

'N'::bpchar

cof_iszeraraliquotaicms

bpchar

'N'::bpchar

cof_iszeraraliquotaipi

bpchar

'N'::bpchar

cof_iszerarvalorbaseicms

bpchar

'N'::bpchar

cof_iszerarvalorbaseipi

bpchar

'N'::bpchar

c_bpartner_id

numeric

√

NULL::numeric

c_bpartner.c_bpartner_id

cbpartner_cofconfiguracaofiscal

created

timestamp

29,6

null

createdby

numeric

null

ad_user.ad_user_id

createdby_cofconfiguracaofiscal

isactive

bpchar

'Y'::bpchar

lbr_cfop_id

numeric

null

lbr_cfop.lbr_cfop_id

lbrcfop_cofconfiguracaofiscal

lbr_ncm_id

numeric

√

NULL::numeric

lbr_ncm.lbr_ncm_id

lbrncm_cofconfiguracaofiscal

updated

timestamp

29,6

null

updatedby

numeric

null

ad_user.ad_user_id

updatedby_cofconfiguracaofiscal

cof_aliquotacofins

numeric

√

null

cof_aliquotapis

numeric

√

null

cof_taxregimecode

bpchar

√

NULL::bpchar

cof_issobrescreverbasecalc

bpchar

'N'::bpchar

cof_cstibscbs_id

numeric

√

NULL::numeric

lbr_taxstatus.lbr_taxstatus_id

cofcstibscbs_cofconfiguracaofiscal

cof_isajustaribscbs

bpchar

'N'::bpchar

cof_iszeraraliquotaibsmun

bpchar

'N'::bpchar

cof_iszeraraliquotacbs

bpchar

'N'::bpchar

cof_codclasstrib_id

numeric

√

null

cof_codclasstrib.cof_codclasstrib_id

cofcodclasstrib_cofconfiguracaofiscal

cof_issobrescrevercstibscbs

bpchar

'N'::bpchar

cof_iszerarvalorbaseibscbs

bpchar

'N'::bpchar

cof_iszeraraliquotaibsuf

bpchar

'N'::bpchar

cof_issobrescrevercctibscbs

bpchar

'N'::bpchar

cof_isforcaripi

bpchar

'N'::bpchar

cof_aliquotaipi

numeric

√

null

Indexes

Constraint Name	Type	Sort	Column(s)
cof_configuracaofiscal_key	Primary key	Asc	cof_configuracaofiscal_id
cof_configuracaofiscal_registrounico	Must be unique	Asc/Asc/Asc/Asc/Asc	ad_client_id + ad_org_id + lbr_cfop_id + c_bpartner_id + lbr_ncm_id
cof_configuracaofiscal_uu_idx	Must be unique	Asc	cof_configuracaofiscal_uu

Check Constraints

Constraint Name	Constraint
cof_configuracaofiscal_isactive_check	((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iscreditarimpostoscusto_check	((cof_iscreditarimpostoscusto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iszeraraliquotacbs_check	((cof_iszeraraliquotacbs = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isdeduziricmsbccofins_check	((cof_isdeduziricmsbccofins = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isforcaripi_check	((cof_isforcaripi = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescreveraliquotacofins_check	((cof_issobrescreveraliquotacofins = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescrevercstcofins_check	((cof_issobrescrevercstcofins = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescrevercstipi_check	((cof_issobrescrevercstipi = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescreveraliquotapis_check	((cof_issobrescreveraliquotapis = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescrevercctibscbs_check	((cof_issobrescrevercctibscbs = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescrevercsticms_check	((cof_issobrescrevercsticms = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isforcarcofins_check	((cof_isforcarcofins = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iszerarvalorbaseicms_check	((cof_iszerarvalorbaseicms = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescreverbasecalc_check	((cof_issobrescreverbasecalc = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isajustarpis_check	((cof_isajustarpis = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iscreditaricmscusto_check	((cof_iscreditaricmscusto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isajustaripi_check	((cof_isajustaripi = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iscreditaripicusto_check	((cof_iscreditaripicusto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescrevercstpis_check	((cof_issobrescrevercstpis = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iszeraraliquotaicms_check	((cof_iszeraraliquotaicms = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isajustaricms_check	((cof_isajustaricms = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iszerarvalorbaseipi_check	((cof_iszerarvalorbaseipi = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescrevercstibscbs_check	((cof_issobrescrevercstibscbs = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iszerarvalorbaseibscbs_check	((cof_iszerarvalorbaseibscbs = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isajustarcofins_check	((cof_isajustarcofins = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iscreditarcofinscusto_check	((cof_iscreditarcofinscusto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iszeraraliquotaibsuf_check	((cof_iszeraraliquotaibsuf = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iszeraraliquotaibsmun_check	((cof_iszeraraliquotaibsmun = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isajustaribscbs_check	((cof_isajustaribscbs = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isdeduziricmsbcpis_check	((cof_isdeduziricmsbcpis = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iscreditarpiscusto_check	((cof_iscreditarpiscusto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescreverbccofins_check	((cof_issobrescreverbccofins = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_issobrescreverbcpis_check	((cof_issobrescreverbcpis = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_iszeraraliquotaipi_check	((cof_iszeraraliquotaipi = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_configuracaofiscal_cof_isforcarpis_check	((cof_isforcarpis = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation