Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ad_client_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| ad_org_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| ad_user_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| c_bpartner_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    |||||
| c_campaign_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    |||||
| c_currency_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    |||||
| closedate | timestamp | 29,6 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| cof_contract_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    |||||
| cof_descricaoencerramento | varchar | 255 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| cof_processing | bpchar | 1 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| comments | text | 2147483647 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| c_opportunity_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    |||||
| c_order_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    |||||
| cost | numeric | 0 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| c_salesstage_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    |||||
| description | varchar | 255 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| documentno | varchar | 60 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| expectedclosedate | timestamp | 29,6 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| isactive | bpchar | 1 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| isclosed | bpchar | 1 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| opportunityamt | numeric | 0 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| probability | numeric | 0 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| processed | bpchar | 1 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| salesrep_id | numeric | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    |||||
| weightedamt | numeric | 0 | √ | null | 
                                         | 
                                    
                                         |