cof_rv_relcontroleremessaindprestador

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_org_id

numeric

√

null

value

varchar

√

null

c_bpartner_id

numeric

√

null

lbr_docfiscal_id

numeric

√

null

cof_datatransacao

timestamp

29,6

√

null

m_product_id

numeric

√

null

c_uom_id

numeric

√

null

m_attributesetinstance_id

numeric

√

null

cof_quantidademovimentada

numeric

√

null

createdby

numeric

√

null

ad_client_id

numeric

√

null

cof_tipomovimento

text

2147483647

√

null

cof_issaldoaretornar

text

2147483647

√

null

cof_controleremessasind_id

numeric

√

null

cof_saldoretornarnf

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT cc.ad_org_id,
    cc.value,
    cc.c_bpartner_id,
    doc_saida.lbr_docfiscal_id,
    doc_saida.datedoc AS cof_datatransacao,
    docl_saida.m_product_id,
    docl_saida.c_uom_id,
    docl_saida.m_attributesetinstance_id,
    (docl_saida.det_prod_qcom * ('-1'::integer)::numeric) AS cof_quantidademovimentada,
    cc.createdby,
    cc.ad_client_id,
    'Saída'::text AS cof_tipomovimento,
        CASE
            WHEN (mpr.cof_saldoretornarnf > (0)::numeric) THEN 'Y'::text
            ELSE 'N'::text
        END AS cof_issaldoaretornar,
    cc.cof_controleremessasind_id,
    mpr.cof_saldoretornarnf
   FROM ((((cof_controleremessasind cc
     JOIN cof_mprecebida mpr ON ((mpr.cof_controleremessasind_id = cc.cof_controleremessasind_id)))
     JOIN m_productionline prl ON ((mpr.cof_mprecebida_id = prl.cof_mprecebida_id)))
     JOIN lbr_docfiscal_line docl_saida ON ((docl_saida.cof_linhaopindusprestador_id = prl.m_productionline_id)))
     JOIN lbr_docfiscal doc_saida ON ((doc_saida.lbr_docfiscal_id = docl_saida.lbr_docfiscal_id)))
UNION ALL
 SELECT cc.ad_org_id,
    cc.value,
    cc.c_bpartner_id,
    cc.lbr_docfiscal_id,
    cc.cof_datacontafatura AS cof_datatransacao,
    mpr.m_product_id,
    mpr.c_uom_id,
    mpr.m_attributesetinstance_id,
    mpr.cof_quantidaderecebida AS cof_quantidademovimentada,
    mpr.createdby,
    cc.ad_client_id,
    'Entrada'::text AS cof_tipomovimento,
        CASE
            WHEN (mpr.cof_saldoretornarnf > (0)::numeric) THEN 'Y'::text
            ELSE 'N'::text
        END AS cof_issaldoaretornar,
    cc.cof_controleremessasind_id,
    mpr.cof_saldoretornarnf
   FROM (cof_controleremessasind cc
     JOIN cof_mprecebida mpr ON ((mpr.cof_controleremessasind_id = cc.cof_controleremessasind_id)))
UNION ALL
 SELECT cc.ad_org_id,
    cc.value,
    cc.c_bpartner_id,
    doc_dev.lbr_docfiscal_id,
    doc_dev.datedoc AS cof_datatransacao,
    docl_dev.m_product_id,
    docl_dev.c_uom_id,
    docl_dev.m_attributesetinstance_id,
    (docl_dev.det_prod_qcom * ('-1'::integer)::numeric) AS cof_quantidademovimentada,
    cc.createdby,
    cc.ad_client_id,
    'Devolução'::text AS cof_tipomovimento,
        CASE
            WHEN (mpr.cof_saldoretornarnf > (0)::numeric) THEN 'Y'::text
            ELSE 'N'::text
        END AS cof_issaldoaretornar,
    cc.cof_controleremessasind_id,
    mpr.cof_saldoretornarnf
   FROM (((cof_controleremessasind cc
     JOIN cof_mprecebida mpr ON ((mpr.cof_controleremessasind_id = cc.cof_controleremessasind_id)))
     JOIN lbr_docfiscal_line docl_dev ON ((docl_dev.cof_mprecebida_id = mpr.cof_mprecebida_id)))
     JOIN lbr_docfiscal doc_dev ON ((doc_dev.lbr_docfiscal_id = docl_dev.lbr_docfiscal_id)));

cof_rv_relcontroleremessaindprestador

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views