c_region

399 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_region_id numeric 10 null
c_city.c_region_id cregion_ccity R
c_dunning_header_v.c_region_id Implied Constraint R
c_dunning_header_vt.c_region_id Implied Constraint R
c_invoice_header_v.c_region_id Implied Constraint R
c_invoice_header_vt.c_region_id Implied Constraint R
c_location.c_region_id c_region_location R
c_order_header_v.c_region_id Implied Constraint R
c_order_header_vt.c_region_id Implied Constraint R
c_region_trl.c_region_id cregion_cregiontrl C
c_tax.c_region_id c_region_c_tax R
c_tax.to_region_id c_regionto_c_tax R
cof_c_adjustment.c_region_id cregion_cofcadjustment R
cof_c_adjusttable.c_region_id cregion_cofcadjusttable R
cof_c_ibptax.c_region_id Implied Constraint R
cof_c_taxdetermination_fact.c_region_id cregion_cofctaxdeterminationfa R
cof_c_taxdetermination_hdr.cof_estadodestino_id cofestadodestino_cofctaxdeterm R
cof_c_taxdetermination_line.c_region_id cregion_cofctaxdeterminationli R
cof_cbenef_config.c_region_id cregion_cofcbenefconfig R
cof_creditreferences.c_region_id cregion_cofcreditreferences R
cof_equipments.cof_stateplate_id cofstateplate_cofequipments R
cof_orgst.c_region_id Implied Constraint R
cof_packinglist.cof_stateplate_id cofstateplate_cofpackinglist R
cof_participant.cof_regioncrc_id cofregioncrc_cofparticipant R
cof_preferenciaxml.c_region_id cregion_cofpreferenciaxml N
cof_realgoods.c_region_id cregion_cofrealgoods R
cof_rps.dest_region_id destregion_cofrps R
cof_rv_confimpostos.c_region_id Implied Constraint R
cof_rv_detalheslocalizacao.c_region_id Implied Constraint R
cof_rv_lead.c_region_id Implied Constraint R
i_bpartner.c_region_id cregion_ibpartner N
i_invoice.c_region_id cregion_iinvoice N
i_order.c_region_id cregion_iorder N
lbr_di.c_region_id Implied Constraint R
lbr_docfiscal.retira_region_id retiraregion_lbrdocfiscal R
lbr_icmsmatrix.c_region_id Implied Constraint R
lbr_issmatrix.c_region_id Implied Constraint R
lbr_nfewebservice.c_region_id Implied Constraint R
lbr_taxdefinition.c_region_id Implied Constraint R
m_freight.c_region_id cregion_mfreight R
m_freight.to_region_id cregionto_mfreight R
m_inout_header_v.c_region_id Implied Constraint R
m_inout_header_vt.c_region_id Implied Constraint R
rv_bpartner.c_region_id Implied Constraint R
rv_c_invoice.c_region_id Implied Constraint R
rv_c_invoiceline.c_region_id Implied Constraint R
rv_c_invoicetax.c_region_id Implied Constraint R
ad_client_id numeric 10 null
ad_client.ad_client_id c_regionclient R
ad_org_id numeric 10 null
ad_org.ad_org_id c_regionorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
c_country_id numeric 10 null
c_country.c_country_id ccountry_cregion R
isdefault bpchar 1 √ 'N'::bpchar
c_region_uu varchar 36 √ NULL::character varying
lbr_regioncode numeric 10 √ NULL::numeric

Indexes

Constraint Name Type Sort Column(s)
c_region_pkey Primary key Asc c_region_id
c_region_name Must be unique Asc/Asc c_country_id + name
c_region_uu_idx Must be unique Asc c_region_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation