t_itensnaovendidosaclientes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_org_id numeric 10 √ NULL::numeric
ad_client_id numeric 10 √ NULL::numeric
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_titensnaovendidosacli R
m_product_category_id numeric 10 √ NULL::numeric
m_product_category.m_product_category_id mproductcategory_titensnaovend R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_titensnaovendidosacl R
salesrep_id numeric 10 √ NULL::numeric
ad_user.ad_user_id salesrep_titensnaovendidosacli R
c_bp_group_id numeric 10 √ null
c_bp_group.c_bp_group_id cbpgroup_titensnaovendidosacli R
cof_producttype_id numeric 10 √ NULL::numeric
cof_producttype.cof_producttype_id cofproducttype_titensnaovendid R
cof_productclass_id numeric 10 √ NULL::numeric
cof_productclass.cof_productclass_id cofproductclass_titensnaovendi R
cof_productgroup_id numeric 10 √ NULL::numeric
cof_productgroup.cof_productgroup_id cofproductgroup_titensnaovendi R
ad_pinstance_id numeric 10 √ NULL::numeric
ad_pinstance.ad_pinstance_id adpinstance_titensnaovendidosa C
cof_abc varchar 2 √ null
c_uom_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuom_titensnaovendidosacliente R
t_itensnaovendidosaclientes_uu varchar 36 √ NULL::character varying
cof_grupofornecedor_id numeric 10 √ NULL::numeric
cof_grupofornecedor.cof_grupofornecedor_id cofgrupofornecedor_titensnaove R
cof_exibiremrelatorios bpchar 1 √ 'Y'::bpchar
cof_tipoparceiro_id numeric 10 √ NULL::numeric
cof_tipoparceiro.cof_tipoparceiro_id coftipoparceiro_titensnaovendi R
cof_classeparceiro_id numeric 10 √ NULL::numeric
cof_classeparceiro.cof_classeparceiro_id cofclasseparceiro_titensnaoven R

Indexes

Constraint Name Type Sort Column(s)
t_itensnaovendidosaclientuuidx Must be unique Asc t_itensnaovendidosaclientes_uu

Check Constraints

Constraint Name Constraint
t_itensnaovendidosaclientes_cof_exibiremrelatorios_check ((cof_exibiremrelatorios = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation