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_dunning_header_v.c_bpartner_m_pricelist_id Implied Constraint R
c_dunning_header_v.salesrep_bp_m_pricelist_id Implied Constraint R
c_dunning_header_vt.c_bpartner_m_pricelist_id Implied Constraint R
c_dunning_header_vt.salesrep_bp_m_pricelist_id Implied Constraint R
c_dunning_line_v.m_pricelist_id Implied Constraint R
c_dunning_line_vt.m_pricelist_id Implied Constraint R
c_invoice.m_pricelist_id mpricelist_cinvoice R
c_invoice_header_v.bp_m_pricelist_id Implied Constraint R
c_invoice_header_v.bpartner_m_pricelist_id Implied Constraint R
c_invoice_header_v.m_pricelist_id Implied Constraint R
c_invoice_header_vt.bp_m_pricelist_id Implied Constraint R
c_invoice_header_vt.bpartner_m_pricelist_id Implied Constraint R
c_invoice_header_vt.m_pricelist_id Implied Constraint R
c_invoice_v.m_pricelist_id Implied Constraint R
c_invoice_v1.m_pricelist_id Implied Constraint R
c_order.m_pricelist_id mpricelist_soheader R
c_order_header_v.bill_bp_m_pricelist_id Implied Constraint R
c_order_header_v.bp_m_pricelist_id Implied Constraint R
c_order_header_v.m_pricelist_id Implied Constraint R
c_order_header_v.salesrep_bp_m_pricelist_id Implied Constraint R
c_order_header_vt.bill_bp_m_pricelist_id Implied Constraint R
c_order_header_vt.bp_m_pricelist_id Implied Constraint R
c_order_header_vt.m_pricelist_id Implied Constraint R
c_order_header_vt.salesrep_bp_m_pricelist_id Implied Constraint R
c_payselection_check_v.c_bp_m_pricelist_id Implied Constraint R
c_payselection_check_vt.c_bp_m_pricelist_id Implied Constraint R
c_payselection_remittance_v.m_pricelist_id Implied Constraint R
c_payselection_remittance_vt.m_pricelist_id Implied Constraint R
c_pos.m_pricelist_id mpricelist_cpos R
c_project_header_v.c_bp_m_pricelist_id Implied Constraint R
c_project_header_v.salesrep_bp_m_pricelist_id Implied Constraint R
c_project_header_vt.c_bp_m_pricelist_id Implied Constraint R
c_project_header_vt.salesrep_bp_m_pricelist_id Implied Constraint 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
cof_rv_contract.m_pricelist_id Implied Constraint R
cof_rv_docfiscal.m_pricelist_id Implied Constraint R
cof_rv_itenspago.m_pricelist_id Implied Constraint R
cof_rv_mapa_pedido.m_pricelist_id Implied Constraint 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
lbr_docfiscal.m_pricelist_id Implied Constraint R
m_forecast.m_pricelist_id mpricelist_mforecast R
m_inout_header_v.c_bp_m_pricelist_id Implied Constraint R
m_inout_header_vt.c_bp_m_pricelist_id Implied Constraint 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
rv_bpartner.m_pricelist_id Implied Constraint R
rv_c_invoice.c_bp_m_pricelist_id Implied Constraint R
rv_c_invoice.m_pricelist_id Implied Constraint R
rv_c_invoiceline.m_pricelist_id Implied Constraint R
rv_c_invoicetax.c_bp_m_pricelist_id Implied Constraint R
rv_c_invoicetax.m_pricelist_id Implied Constraint R
rv_commissionrundetail.c_invoice_m_pricelist_id Implied Constraint R
rv_commissionrundetail.m_pricelist_id Implied Constraint R
rv_fact_acct.c_bp_m_pricelist_id Implied Constraint R
rv_m_requisition.m_pricelist_id Implied Constraint R
rv_openitem.m_pricelist_id Implied Constraint R
rv_orderdetail.m_pricelist_id Implied Constraint R
s_timeexpense.m_pricelist_id mpricelist_stimeexpense R
t_invoicegl_v.m_pricelist_id Implied Constraint R
t_rv_reconciliation.c_bp_m_pricelist_id Implied Constraint 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_enforcepricelimit_check ((enforcepricelimit = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_pricelist_issopricelist_check ((issopricelist = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_pricelist_istaxincluded_check ((istaxincluded = 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_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation