m_pricelist_version

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_pricelist_version_id numeric 10 null
c_project.m_pricelist_version_id mpricelistversion_cproject R
c_project_details_v.m_pricelist_version_id Implied Constraint R
c_project_details_vt.m_pricelist_version_id Implied Constraint R
c_project_header_v.m_pricelist_version_id Implied Constraint R
c_project_header_vt.m_pricelist_version_id Implied Constraint R
cof_c_pricechange.m_pricelist_version_id mpricelistversion_cofcpricecha R
cof_products.m_pricelist_version_id mpricelistversion_cofproducts R
cof_rv_contract.m_pricelist_version_id Implied Constraint R
i_pricelist.m_pricelist_version_id mpricelistversion_ipricelist R
m_pricelist_version.m_pricelist_version_base_id mpricelistversionbase_mpriceli R
m_pricelist_version_trl.m_pricelist_version_id mpricelistversion_mpricelistve C
m_product_substituterelated_v.m_pricelist_version_id Implied Constraint R
m_productprice.m_pricelist_version_id mpricelistver_mproductprice C
m_productpricevendorbreak.m_pricelist_version_id mpricelistversion_mproductpric R
rv_warehouseprice.m_pricelist_version_id Implied Constraint R
t_inventoryvalue.m_pricelist_version_id mplversion_tinventoryvalue C
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
m_pricelist_id numeric 10 null
m_pricelist.m_pricelist_id mpricelist_mpricelistversion C
m_discountschema_id numeric 10 null
m_discountschema.m_discountschema_id mdiscounts_mplversion R
validfrom timestamp 29,6 null
proccreate bpchar 1 √ null
m_pricelist_version_base_id numeric 10 √ null
m_pricelist_version.m_pricelist_version_id mpricelistversionbase_mpriceli R
m_pricelist_version_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_pricelist_version_pkey Primary key Asc m_pricelist_version_id
m_pricelist_version_uu_idx Must be unique Asc m_pricelist_version_uu
m_pricelist_version_validfrom Must be unique Asc/Asc m_pricelist_id + validfrom

Check Constraints

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

Relationships

Close relationships within degrees of separation