cof_preferenciaxml

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_preferenciaxml_id numeric 10 null
cof_preferenciaxml_uu varchar 36 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_cofpreferenciaxml N
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_cofpreferenciaxml N
bp_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id bplocation_cofpreferenciaxml N
cof_cnpj varchar 14 √ NULL::character varying
bpname varchar 60 √ NULL::character varying
bpname2 varchar 60 √ NULL::character varying
lbr_ie varchar 30 √ NULL::character varying
cof_taxregimecode bpchar 1 √ NULL::bpchar
lbr_cnae varchar 10 √ NULL::character varying
address1 varchar 60 √ NULL::character varying
address2 varchar 60 √ NULL::character varying
address3 varchar 60 √ NULL::character varying
address4 varchar 60 √ NULL::character varying
c_city_id numeric 10 √ NULL::numeric
c_city.c_city_id ccity_cofpreferenciaxml N
c_region_id numeric 10 √ NULL::numeric
c_region.c_region_id cregion_cofpreferenciaxml N
productname varchar 60 √ NULL::character varying
productvalue varchar 40 √ NULL::character varying
product_bom_value varchar 40 √ NULL::character varying
description varchar 255 √ NULL::character varying
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id cproject_cofpreferenciaxml R
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_cofpreferenciaxml R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_cofpreferenciaxml R
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_cofpreferenciaxml R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_cofpreferenciaxml R
cof_csticms_id numeric 10 √ NULL::numeric
lbr_taxstatus.lbr_taxstatus_id cofcsticms_cofpreferenciaxml R
cof_cstpis_id numeric 10 √ NULL::numeric
lbr_taxstatus.lbr_taxstatus_id cofcstpis_cofpreferenciaxml R
cof_cstcofins_id numeric 10 √ NULL::numeric
lbr_taxstatus.lbr_taxstatus_id cofcstcofins_cofpreferenciaxml R
cof_cstipi_id numeric 10 √ NULL::numeric
lbr_taxstatus.lbr_taxstatus_id cofcstipi_cofpreferenciaxml R
cof_csticmsxml varchar 10 √ NULL::character varying
cof_cstpisxml varchar 10 √ NULL::character varying
cof_cstcofinsxml varchar 10 √ NULL::character varying
cof_cstipixml varchar 10 √ NULL::character varying
cof_cfopxml varchar 10 √ null
lbr_cfop_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id lbrcfop_cofpreferenciaxml R
c_paymentterm_id numeric 10 √ NULL::numeric
c_paymentterm.c_paymentterm_id cpaymentterm_cofpreferenciaxml R
phone varchar 40 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
cof_preferenciaxml_key Primary key Asc cof_preferenciaxml_id
cof_preferenciaxml_uu_idx Must be unique Asc cof_preferenciaxml_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation