cof_rv_contract

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_contract_id numeric 10 √ null
cof_contract.cof_contract_id Implied Constraint R
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ null
created timestamp 29,6 √ null
createdby numeric 10 √ null
updated timestamp 29,6 √ null
updatedby numeric 10 √ null
value varchar 40 √ null
name varchar 60 √ null
description varchar 255 √ null
datefrom timestamp 29,6 √ null
dateto timestamp 29,6 √ null
revision varchar 10 √ null
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id Implied Constraint R
amount numeric 0 √ null
cof_contractstatus varchar 2 √ null
c_location_id numeric 10 √ null
c_location.c_location_id Implied Constraint R
percent numeric 0 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
salesrep_id numeric 10 √ null
cof_contractcategory_id numeric 10 √ null
cof_contractcategory.cof_contractcategory_id Implied Constraint R
cof_contractclassification varchar 2 √ null
cof_contractgroup_id numeric 10 √ null
cof_contractgroup.cof_contractgroup_id Implied Constraint R
ad_user_id numeric 10 √ null
m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id Implied Constraint R
c_recurring_id numeric 10 √ null
c_recurring.c_recurring_id Implied Constraint R
cof_isblocked bpchar 1 √ null
cof_processing bpchar 1 √ null
cof_contractnumber varchar 20 √ null
cof_fatorreajuste numeric 0 √ null
paymentrule bpchar 1 √ null
invoicerule bpchar 1 √ null
deliveryrule bpchar 1 √ null
cof_dataemissao timestamp 29,6 √ null
cof_aditivocontrato bpchar 1 √ null
cof_contractoriginal_id numeric 10 √ null
cof_testemunha1 varchar 255 √ null
cof_testemunha2 varchar 255 √ null
cof_documentotestemunha1 varchar 255 √ null
cof_documentotestemunha2 varchar 255 √ null
cof_documentoresponsavel1 varchar 255 √ null
cof_documentoresponsavel2 varchar 255 √ null
cof_responsavel2 varchar 255 √ null
cof_responsavel1 varchar 255 √ null
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id Implied Constraint R
cof_numerorevisao numeric 10 √ null
cof_products_id numeric 10 √ null
cof_products.cof_products_id Implied Constraint R
isactiveline bpchar 1 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
qty numeric 0 √ null
m_productprice_id numeric 10 √ null
m_productprice.m_productprice_id Implied Constraint R
totalprice numeric 0 √ null
discount numeric 0 √ null
balance numeric 0 √ null
priceactual numeric 0 √ null
m_pricelist_version_id numeric 10 √ null
m_pricelist_version.m_pricelist_version_id Implied Constraint R
cof_guarantee varchar 40 √ null
cof_saldofaturar numeric 0 √ null
a_asset_id numeric 10 √ null
a_asset.a_asset_id Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views