Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ad_client_id | numeric | 10 | null |
|
|
||||||
| ad_org_id | numeric | 10 | null |
|
|
||||||
| cof_metadevendas_id | numeric | 10 | null |
|
|
||||||
| cof_metadevendas_uu | varchar | 36 | √ | null |
|
|
|||||
| created | timestamp | 29,6 | null |
|
|
||||||
| createdby | numeric | 10 | null |
|
|
||||||
| description | varchar | 255 | √ | null |
|
|
|||||
| isactive | bpchar | 1 | 'Y'::bpchar |
|
|
||||||
| startdate | timestamp | 29,6 | null |
|
|
||||||
| updated | timestamp | 29,6 | null |
|
|
||||||
| updatedby | numeric | 10 | null |
|
|
||||||
| value | varchar | 40 | √ | null |
|
|
|||||
| enddate | timestamp | 29,6 | null |
|
|
||||||
| cof_meta | numeric | 0 | null |
|
|
||||||
| cof_tipodemeta | bpchar | 1 | null |
|
|
||||||
| ad_user_id | numeric | 10 | √ | null |
|
|
|||||
| cof_isdesconsiderardescontos | bpchar | 1 | 'N'::bpchar |
|
|
||||||
| cof_isdesconsiderarimpostos | bpchar | 1 | 'N'::bpchar |
|
|
||||||
| c_currency_id | numeric | 10 | null |
|
|
||||||
| cof_valoratingido | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_valoremporcentagem | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_valorrestante | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_prazorestante | numeric | 10 | √ | '0'::numeric |
|
|
|||||
| cof_ultimaatualizacao | timestamp | 29,6 | √ | null |
|
|
|||||
| cof_grupofornecedor | varchar | 2000 | √ | NULL::character varying |
|
|
|||||
| cof_org_id_documento | varchar | 2000 | √ | NULL::character varying |
|
|
|||||
| cof_producttype | varchar | 2000 | √ | null |
|
|
|||||
| cof_productclass | varchar | 2000 | √ | NULL::character varying |
|
|
|||||
| cof_productgroup | varchar | 2000 | √ | NULL::character varying |
|
|
|||||
| cof_metodoexecutado | varchar | 2 | 'OV'::character varying |
|
|
||||||
| cof_ritmovendasdiarioparameta | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_diasuteisatedatarecalc | numeric | 10 | √ | '0'::numeric |
|
|
|||||
| cof_projecaometa | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_isconsiderarmemorandocred | bpchar | 1 | 'N'::bpchar |
|
|
||||||
| cof_isincluiservico | bpchar | 1 | 'N'::bpchar |
|
|
||||||
| cof_percmargem | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_custototal | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_qtdvendida | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_qtdvendidakg | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_unifatormultiplicacao | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_unifatordivisao | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_mproduct | varchar | 2000 | √ | NULL::character varying |
|
|
|||||
| cof_vendedorinterno | varchar | 2000 | √ | NULL::character varying |
|
|
|||||
| cof_iscalcrealizado | bpchar | 1 | 'N'::bpchar |
|
|
||||||
| m_costelement_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| m_costtype_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_isdesconsiderarsabados | bpchar | 1 | 'Y'::bpchar |
|
|
||||||
| cof_iscontrolemanualdias | bpchar | 1 | 'N'::bpchar |
|
|
||||||
| cof_markup | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_metamarkup | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_metaquantidade | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_valoratingidoquantidade | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_valorrestantequantidade | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_ritmovendasdiarioparametaqtd | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_projecaometaqtd | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_isdiaatualpassado | bpchar | 1 | 'Y'::bpchar |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cof_metadevendas_key | Primary key | Asc | cof_metadevendas_id |
| cof_metadevendas_uu_idx | Must be unique | Asc | cof_metadevendas_uu |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| cof_metadevendas_cof_isincluiservico_check | ((cof_isincluiservico = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_metadevendas_cof_isdesconsiderarsabados_check | ((cof_isdesconsiderarsabados = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_metadevendas_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_metadevendas_cof_iscalcrealizado_check | ((cof_iscalcrealizado = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_metadevendas_cof_isdiaatualpassado_check | ((cof_isdiaatualpassado = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_metadevendas_cof_iscontrolemanualdias_check | ((cof_iscontrolemanualdias = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_metadevendas_cof_isconsiderarmemorandocred_check | ((cof_isconsiderarmemorandocred = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_metadevendas_cof_isdesconsiderarimpostos_check | ((cof_isdesconsiderarimpostos = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_metadevendas_cof_isdesconsiderardescontos_check | ((cof_isdesconsiderardescontos = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |