m_pricelist

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_pricelist_id numeric 10 null
b_topictype.m_pricelist_id mpricelist_btopictype R
c_bp_group.m_pricelist_id mpricelist_cbpgroup N
c_bp_group.po_pricelist_id mpricelistpo_cbpgroup N
c_bpartner.m_pricelist_id mpricelist_cbpartner N
c_bpartner.po_pricelist_id mpricelistpo_cbuspartner N
c_invoice.m_pricelist_id mpricelist_cinvoice R
c_order.m_pricelist_id mpricelist_soheader R
c_pos.m_pricelist_id mpricelist_cpos R
cof_configovs.m_pricelist_id mpricelist_cofconfigovs R
cof_contract.m_pricelist_id mpricelist_cofcontract R
cof_controleremessasind.m_pricelist_id mpricelist_cofcontroleremessas R
cof_ordemservico.cof_precoproduto_id cofprecoproduto_cofordemservic R
cof_ordemservico.cof_precoservico_id cofprecoservico_cofordemservic R
cof_osproduto.m_pricelist_id mpricelist_cofosproduto R
cof_osservico.m_pricelist_id mpricelist_cofosservico R
cof_rps.m_pricelist_id mpricelist_cofrps R
cte_cte.m_pricelist_id mpricelist_ctecte R
i_invoice.m_pricelist_id mpricelist_iinvoice N
i_order.m_pricelist_id mpricelist_iorder N
i_pricelist.m_pricelist_id mpricelist_ipricelist R
m_forecast.m_pricelist_id mpricelist_mforecast R
m_pricelist.basepricelist_id basepricelist R
m_pricelist_trl.m_pricelist_id mpricelist_mpricelisttrl C
m_pricelist_version.m_pricelist_id mpricelist_mpricelistversion C
m_promotionprecondition.m_pricelist_id mpricelist_mpromotionprecondit R
m_requisition.m_pricelist_id mprocelist_mrequisition R
s_timeexpense.m_pricelist_id mpricelist_stimeexpense R
u_posterminal.po_pricelist_id popricelist_uposterminal R
u_posterminal.so_pricelist_id sopricelist_uposterminal R
w_basket.m_pricelist_id mpricelist_wbasket R
w_store.m_pricelist_id mpricelist_wstore R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
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
basepricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id basepricelist R
istaxincluded bpchar 1 'Y'::bpchar
issopricelist bpchar 1 'Y'::bpchar
isdefault bpchar 1 'N'::bpchar
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_mpricelist R
enforcepricelimit bpchar 1 'N'::bpchar
priceprecision numeric 10 2
ismandatory bpchar 1 √ 'N'::bpchar
ispresentforproduct bpchar 1 √ 'N'::bpchar
m_pricelist_uu varchar 36 √ NULL::character varying
cof_ismarkup bpchar 1 √ 'N'::bpchar
cof_liberadosweb bpchar 1 √ 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
m_pricelist_pkey Primary key Asc m_pricelist_id
m_pricelist_name Must be unique Asc/Asc ad_client_id + name
m_pricelist_uu_idx Must be unique Asc m_pricelist_uu

Check Constraints

Constraint Name Constraint
m_pricelist_istaxincluded_check ((istaxincluded = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_pricelist_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_pricelist_issopricelist_check ((issopricelist = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_pricelist_cof_ismarkup_check ((cof_ismarkup = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_pricelist_cof_liberadosweb_check ((cof_liberadosweb = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_pricelist_enforcepricelimit_check ((enforcepricelimit = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation