cof_rv_lead

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
address1 varchar 60 √ null
address2 varchar 60 √ null
address3 varchar 60 √ null
address4 varchar 60 √ null
address5 varchar 60 √ null
ad_org_id numeric 10 √ null
ad_orgtrx_id numeric 10 √ null
ad_user_id numeric 10 √ null
birthday timestamp 29,6 √ null
bp_location_id numeric 10 √ null
bpname varchar 60 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id Implied Constraint R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id Implied Constraint R
c_city_id numeric 10 √ null
c_city.c_city_id Implied Constraint R
c_country_id numeric 10 √ null
c_country.c_country_id Implied Constraint R
c_greeting_id numeric 10 √ null
c_greeting.c_greeting_id Implied Constraint R
city varchar 60 √ null
c_job_id numeric 10 √ null
c_job.c_job_id Implied Constraint R
c_location_id numeric 10 √ null
c_location.c_location_id Implied Constraint R
cof_bptypebr varchar 2 √ null
cof_c_leadexpirationreason_id numeric 10 √ null
cof_c_leadexpirationreason.cof_c_leadexpirationreason_id Implied Constraint R
cof_c_marketsegment_id numeric 10 √ null
cof_c_marketsegment.cof_c_marketsegment_id Implied Constraint R
cof_cnpj varchar 14 √ null
lbr_cpf varchar 14 √ null
cof_score numeric 10 √ null
comments varchar 2000 √ null
connectionprofile bpchar 1 √ null
c_region_id numeric 10 √ null
c_region.c_region_id Implied Constraint R
description text 2147483647 √ null
email varchar 60 √ null
emailuser varchar 60 √ null
emailuserpw varchar 255 √ null
emailverify varchar 40 √ null
emailverifydate timestamp 29,6 √ null
fax varchar 40 √ null
isactive bpchar 1 √ null
isfullbpaccess bpchar 1 √ null
isinpayroll bpchar 1 √ null
issaleslead bpchar 1 √ null
lastcontact timestamp 29,6 √ null
lastresult varchar 255 √ null
ldapuser varchar 60 √ null
leadsource varchar 10 √ null
leadsourcedescription varchar 255 √ null
leadstatus varchar 10 √ null
leadstatusdescription varchar 255 √ null
name varchar 60 √ null
notificationtype bpchar 1 √ null
password varchar 1024 √ null
phone varchar 40 √ null
phone2 varchar 40 √ null
postal varchar 10 √ null
processing bpchar 1 √ null
regionname varchar 40 √ null
salesrep_id numeric 10 √ null
salt varchar 16 √ null
supervisor_id numeric 10 √ null
title varchar 40 √ null
userpin varchar 20 √ null
value varchar 40 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views