cof_rv_detalhesordemservico

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_org_id

numeric

√

null

ad_client_id

numeric

√

null

cof_ordemservico_id

numeric

√

null

cof_ordemservico.cof_ordemservico_id

Implied Constraint

value

varchar

√

null

startdate

timestamp

29,6

√

null

enddate

timestamp

29,6

√

null

datepromised

timestamp

29,6

√

null

c_doctypetarget_id

numeric

√

null

cof_equipments_id

numeric

√

null

cof_equipments.cof_equipments_id

Implied Constraint

a_asset_id

numeric

√

null

a_asset.a_asset_id

Implied Constraint

m_product_id

numeric

√

null

m_product.m_product_id

Implied Constraint

m_attributesetinstance_id

numeric

√

null

m_attributesetinstance.m_attributesetinstance_id

Implied Constraint

cof_nomeentregador

varchar

√

null

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

cof_bpinternal_id

numeric

√

null

cof_precoservico_id

numeric

√

null

cof_precoproduto_id

numeric

√

null

c_bpartnersr_id

numeric

√

null

c_project_id

numeric

√

null

c_project.c_project_id

Implied Constraint

c_activity_id

numeric

√

null

c_activity.c_activity_id

Implied Constraint

c_campaign_id

numeric

√

null

c_campaign.c_campaign_id

Implied Constraint

user1_id

numeric

√

null

user2_id

numeric

√

null

c_salesregion_id

numeric

√

null

c_salesregion.c_salesregion_id

Implied Constraint

cof_prognostico

varchar

2000

√

null

cof_diagnostico

varchar

2000

√

null

cof_solucoes

varchar

2000

√

null

docstatus

varchar

√

null

cof_motivoparalisacao_id

numeric

√

null

cof_motivoparalisacao.cof_motivoparalisacao_id

Implied Constraint

processed

bpchar

√

null

cof_valortotalservicos

numeric

√

null

cof_valortotalprodutos

numeric

√

null

isactive

bpchar

√

null

cof_orderproduto_id

numeric

√

null

cof_orderservico_id

numeric

√

null

cof_movementos_id

numeric

√

null

isactiveline

bpchar

√

null

description

varchar

2147483647

√

null

cof_servico_id

numeric

√

null

m_productline_id

numeric

√

null

cof_faturado

bpchar

√

null

cof_baixaestoque

bpchar

2147483647

√

null

cof_incorporarservico

bpchar

2147483647

√

null

qty

numeric

√

null

cof_motivo

varchar

√

null

cof_valorunitario

numeric

√

null

grandtotal

numeric

√

null

cof_statusinternoos_id

numeric

√

null

cof_statusinternoos.cof_statusinternoos_id

Implied Constraint

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT os.ad_org_id,
    os.ad_client_id,
    os.cof_ordemservico_id,
    os.value,
    os.startdate,
    os.enddate,
    os.datepromised,
    os.c_doctypetarget_id,
    os.cof_equipments_id,
    os.a_asset_id,
    os.m_product_id,
    os.m_attributesetinstance_id,
    os.cof_nomeentregador,
    os.c_bpartner_id,
    os.cof_bpinternal_id,
    os.cof_precoservico_id,
    os.cof_precoproduto_id,
    os.c_bpartnersr_id,
    os.c_project_id,
    os.c_activity_id,
    os.c_campaign_id,
    os.user1_id,
    os.user2_id,
    os.c_salesregion_id,
    os.cof_prognostico,
    os.cof_diagnostico,
    os.cof_solucoes,
    os.docstatus,
    os.cof_motivoparalisacao_id,
    os.processed,
    os.cof_valortotalservicos,
    os.cof_valortotalprodutos,
    os.isactive,
    os.cof_orderproduto_id,
    os.cof_orderservico_id,
    os.cof_movementos_id,
    oss.isactive AS isactiveline,
    oss.description,
    oss.cof_servico_id,
    0 AS m_productline_id,
    oss.cof_faturado,
    NULL::bpchar AS cof_baixaestoque,
    NULL::bpchar AS cof_incorporarservico,
    oss.qty,
    oss.cof_motivo,
    oss.cof_valorunitario,
    oss.grandtotal,
    os.cof_statusinternoos_id
   FROM ((cof_ordemservico os
     LEFT JOIN cof_osservico oss ON ((os.cof_ordemservico_id = oss.cof_ordemservico_id)))
     LEFT JOIN cof_osapontamentos osa ON ((os.cof_ordemservico_id = osa.cof_ordemservico_id)))
UNION
 SELECT os.ad_org_id,
    os.ad_client_id,
    os.cof_ordemservico_id,
    os.value,
    os.startdate,
    os.enddate,
    os.datepromised,
    os.c_doctypetarget_id,
    os.cof_equipments_id,
    os.a_asset_id,
    os.m_product_id,
    os.m_attributesetinstance_id,
    os.cof_nomeentregador,
    os.c_bpartner_id,
    os.cof_bpinternal_id,
    os.cof_precoservico_id,
    os.cof_precoproduto_id,
    os.c_bpartnersr_id,
    os.c_project_id,
    os.c_activity_id,
    os.c_campaign_id,
    os.user1_id,
    os.user2_id,
    os.c_salesregion_id,
    os.cof_prognostico,
    os.cof_diagnostico,
    os.cof_solucoes,
    os.docstatus,
    os.cof_motivoparalisacao_id,
    os.processed,
    os.cof_valortotalservicos,
    os.cof_valortotalprodutos,
    os.isactive,
    os.cof_orderproduto_id,
    os.cof_orderservico_id,
    os.cof_movementos_id,
    osp.isactive AS isactiveline,
    NULL::character varying AS description,
    osp.cof_servico_id,
    osp.m_product_id AS m_productline_id,
    osp.cof_faturado,
    osp.cof_baixaestoque,
    osp.cof_incorporarservico,
    osp.qty,
    osp.cof_motivo,
    osp.cof_valorunitario,
    osp.grandtotal,
    os.cof_statusinternoos_id
   FROM ((cof_ordemservico os
     LEFT JOIN cof_osproduto osp ON ((os.cof_ordemservico_id = osp.cof_ordemservico_id)))
     LEFT JOIN cof_osapontamentos osa ON ((os.cof_ordemservico_id = osa.cof_ordemservico_id)));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views