cof_products

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_products_id numeric 10 null
c_invoiceline.cof_products_id cofproducts_cinvoiceline R
c_orderline.cof_products_id cofproducts_corderline R
cof_rv_contract.cof_products_id Implied Constraint R
cof_products_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::numeric
m_product.m_product_id mproduct_cofproducts R
qty numeric 0 null
m_productprice_id numeric 10 √ NULL::numeric
m_productprice.m_productprice_id mproductprice_cofproducts R
totalprice numeric 0 √ null
discount numeric 0 √ null
balance numeric 0 √ null
cof_contract_id numeric 10 √ null
cof_contract.cof_contract_id cofcontract_cofproducts R
priceactual numeric 0 √ null
m_pricelist_version_id numeric 10 null
m_pricelist_version.m_pricelist_version_id mpricelistversion_cofproducts R
cof_guarantee varchar 40 √ NULL::character varying
cof_saldofaturar numeric 0 √ '0'::numeric
a_asset_id numeric 10 √ NULL::numeric
a_asset.a_asset_id aasset_cofproducts R
pricelist numeric 0 √ '0'::numeric

Indexes

Constraint Name Type Sort Column(s)
cof_products_key Primary key Asc cof_products_id
cof_products_uu_idx Must be unique Asc cof_products_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation