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_location_id | numeric | 10 | √ | null |
|
|
||
| c_campaign_id | numeric | 10 | √ | null |
|
|
||
| c_city_id | numeric | 10 | √ | null |
|
|
||
| c_country_id | numeric | 10 | √ | null |
|
|
||
| c_greeting_id | numeric | 10 | √ | null |
|
|
||
| city | varchar | 60 | √ | null |
|
|
||
| c_job_id | numeric | 10 | √ | null |
|
|
||
| c_location_id | numeric | 10 | √ | null |
|
|
||
| cof_bptypebr | varchar | 2 | √ | null |
|
|
||
| cof_c_leadexpirationreason_id | numeric | 10 | √ | null |
|
|
||
| cof_c_marketsegment_id | numeric | 10 | √ | null |
|
|
||
| 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 |
|
|
||
| description | text | 2147483647 | √ | null |
|
|
||
| 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 | 32 | √ | null |
|
|
||
| supervisor_id | numeric | 10 | √ | null |
|
|
||
| title | varchar | 40 | √ | null |
|
|
||
| userpin | varchar | 20 | √ | null |
|
|
||
| value | varchar | 40 | √ | null |
|
|
||
| cof_respatribuicao_id | numeric | 10 | √ | null |
|
|
||
| created | timestamp | 29,6 | √ | null |
|
|
||
| updated | timestamp | 29,6 | √ | null |
|
|
||
| cof_dataatribuicao | timestamp | 29,6 | √ | null |
|
|