Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| 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 |
|
|
||
| c_bpartner_id | numeric | 10 | √ | null |
|
|
||
| startdate | timestamp | 29,6 | √ | null |
|
|
||
| enddate | timestamp | 29,6 | √ | null |
|
|
||
| cof_diasuteis | numeric | 10 | √ | null |
|
|
||
| cof_carteiraideal | numeric | 10 | √ | null |
|
|
||
| cof_carteira | numeric | 10 | √ | null |
|
|
||
| cof_positividadeideal | numeric | 0 | √ | null |
|
|
||
| cof_positividade | numeric | 0 | √ | null |
|
|
||
| cof_faturamento | numeric | 0 | √ | null |
|
|
||
| cof_faturamentoideal | numeric | 0 | √ | null |
|
|
||
| cof_pedidosideal | numeric | 0 | √ | null |
|
|
||
| cof_pedidos | numeric | 0 | √ | null |
|
|
||
| cof_recalcular | bpchar | 1 | √ | null |
|
|
||
| cof_ticketmedio | numeric | 0 | √ | null |
|
|
||
| cof_ticketmedioideal | numeric | 0 | √ | null |
|
|
||
| cof_processed | bpchar | 1 | √ | null |
|
|
||
| value | varchar | 40 | √ | null |
|
|
||
| regiao_venda | varchar | 60 | √ | null |
|
|
||
| cof_registerrevision | timestamp | 29,6 | √ | null |
|
|
||
| data_inclusao | timestamp | 29,6 | √ | null |
|
|
||
| totalopenbalance | numeric | 0 | √ | null |
|
|
||
| so_creditlimit | numeric | 0 | √ | null |
|
|
||
| lbr_cnpj | varchar | 18 | √ | null |
|
|