Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ad_org_id | numeric | 10 | √ | null |
|
|
||
| ad_client_id | numeric | 10 | √ | null |
|
|
||
| c_bpartner_id | numeric | 10 | √ | null |
|
|
||
| c_bp_group_id | numeric | 10 | √ | null |
|
|
||
| name | varchar | 120 | √ | null |
|
|
||
| cof_situacaocomercial | varchar | 4 | √ | null |
|
|
||
| cof_nameloc | varchar | 60 | √ | null |
|
|
||
| phone | varchar | 40 | √ | null |
|
|
||
| isshipto | bpchar | 1 | √ | null |
|
|
||
| ispayfrom | bpchar | 1 | √ | null |
|
|
||
| isbillto | bpchar | 1 | √ | null |
|
|
||
| isremitto | bpchar | 1 | √ | null |
|
|
||
| cof_m_shipregion_id | numeric | 10 | √ | null |
|
|
||
| cof_modfrete | bpchar | 1 | √ | null |
|
|
||
| cof_sequenciaentrega | numeric | 10 | √ | null |
|
|
||
| cof_sequenciaentregacidade | numeric | 10 | √ | null |
|
|
||
| cof_sequenciaentregaregiao | numeric | 10 | √ | null |
|
|
||
| c_salesregion_id | numeric | 10 | √ | null |
|
|
||
| cof_shipper_id | numeric | 10 | √ | null |
|
|
||
| address1 | varchar | 60 | √ | null |
|
|
||
| address2 | varchar | 60 | √ | null |
|
|
||
| address3 | varchar | 60 | √ | null |
|
|
||
| address4 | varchar | 60 | √ | null |
|
|
||
| address5 | varchar | 60 | √ | null |
|
|
||
| c_city_id | numeric | 10 | √ | null |
|
|
||
| c_country_id | numeric | 10 | √ | null |
|
|
||
| c_region_id | numeric | 10 | √ | null |
|
|
||
| regionname | varchar | 40 | √ | null |
|
|
||
| city | varchar | 60 | √ | null |
|
|
||
| cof_latitude | varchar | 15 | √ | null |
|
|
||
| cof_longitude | varchar | 15 | √ | null |
|
|
||
| postal | varchar | 10 | √ | null |
|
|
||
| cityname | varchar | 60 | √ | null |
|
|
||
| areacode | varchar | 10 | √ | null |
|
|
||
| locode | varchar | 10 | √ | null |
|
|
||
| coordinates | varchar | 15 | √ | null |
|
|
||
| lbr_citycode | varchar | 10 | √ | null |
|
|
||
| lbr_regioncode | numeric | 10 | √ | null |
|
|
||
| cof_regiondescription | varchar | 255 | √ | null |
|
|
||
| ad_language | varchar | 6 | √ | null |
|
|
||
| cof_countryname | varchar | 60 | √ | null |
|
|
||
| cof_countrydescription | varchar | 255 | √ | null |
|
|
||
| c_currency_id | numeric | 10 | √ | null |
|
|
||
| countrycode | bpchar | 2 | √ | null |
|
|
||
| value | varchar | 40 | √ | null |
|
|
||
| cof_nameregiaoentrega | varchar | 60 | √ | null |
|
|
||
| cof_shipregiondescription | varchar | 255 | √ | null |
|
|
||
| isactive | bpchar | 1 | √ | null |
|
|
||
| isdefault | bpchar | 1 | √ | null |
|
|