cof_rv_tracking_order

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

c_order_id

numeric

√

null

documentno

varchar

√

null

c_doctypetarget_id

numeric

√

null

dateordered

timestamp

29,6

√

null

docstatus

varchar

2147483647

√

null

created

timestamp

29,6

√

null

updated

timestamp

29,6

√

null

createdby

numeric

√

null

updatedby

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT o.ad_client_id,
    o.ad_org_id,
    o.c_order_id,
    o.documentno,
    o.c_doctypetarget_id,
    o.dateordered,
    cof_getreflistvalue('C_Order'::character varying, 'DocStatus'::character varying, (o.docstatus)::character varying) AS docstatus,
    o.created,
    o.updated,
    o.createdby,
    o.updatedby
   FROM c_order o
UNION ALL
 SELECT io.ad_client_id,
    io.ad_org_id,
    io.c_order_id,
    io.documentno,
    io.c_doctype_id AS c_doctypetarget_id,
    io.movementdate AS dateordered,
    cof_getreflistvalue('M_InOut'::character varying, 'DocStatus'::character varying, (io.docstatus)::character varying) AS docstatus,
    io.created,
    io.updated,
    io.createdby,
    io.updatedby
   FROM m_inout io
UNION ALL
 SELECT i.ad_client_id,
    i.ad_org_id,
    i.c_order_id,
    i.documentno,
    i.c_doctypetarget_id,
    i.dateinvoiced AS dateordered,
    cof_getreflistvalue('C_Invoice'::character varying, 'DocStatus'::character varying, (i.docstatus)::character varying) AS docstatus,
    i.created,
    i.updated,
    i.createdby,
    i.updatedby
   FROM c_invoice i
UNION ALL
 SELECT df.ad_client_id,
    df.ad_org_id,
    df.c_order_id,
    df.documentno,
    df.c_doctypetarget_id,
    df.ide_dhemi AS dateordered,
    cof_getreflistvalue('LBR_DocFiscal'::character varying, 'DocStatus'::character varying, df.docstatus) AS docstatus,
    df.created,
    df.updated,
    df.createdby,
    df.updatedby
   FROM lbr_docfiscal df
UNION ALL
 SELECT pl.ad_client_id,
    pl.ad_org_id,
    COALESCE(pll.c_order_id, mi.c_order_id, mi2.c_order_id) AS c_order_id,
    pl.documentno,
    (100)::numeric(10,0) AS c_doctypetarget_id,
    pl.cof_packingdate AS dateordered,
    cof_getreflistvalue('COF_PackingList'::character varying, 'COF_Fase'::character varying, pl.cof_fase) AS docstatus,
    pl.created,
    pl.updated,
    pl.createdby,
    pl.updatedby
   FROM ((((cof_packinglist_line pll
     LEFT JOIN cof_packinglist pl ON ((pl.cof_packinglist_id = pll.cof_packinglist_id)))
     LEFT JOIN m_inout mi ON ((pll.m_inout_id = mi.m_inout_id)))
     LEFT JOIN m_rma mr ON ((mr.m_rma_id = pll.m_rma_id)))
     LEFT JOIN m_inout mi2 ON ((mi2.m_inout_id = mr.inout_id)))
UNION ALL
 SELECT arm.ad_client_id,
    arm.ad_org_id,
    ol.c_order_id,
    arm.documentno,
    arm.c_doctype_id AS c_doctypetarget_id,
    arm.created AS dateordered,
    cof_getreflistvalue('M_RMA'::character varying, 'DocStatus'::character varying, (arm.docstatus)::character varying) AS docstatus,
    arm.created,
    arm.updated,
    arm.createdby,
    arm.updatedby
   FROM (((m_rma arm
     LEFT JOIN m_rmaline arml ON ((arml.m_rma_id = arm.m_rma_id)))
     LEFT JOIN m_inoutline iol ON ((iol.m_inoutline_id = arml.m_inoutline_id)))
     LEFT JOIN c_orderline ol ON ((ol.c_orderline_id = iol.c_orderline_id)))
  GROUP BY arm.ad_client_id, arm.ad_org_id, ol.c_order_id, arm.documentno, arm.c_doctype_id, arm.created, arm.docstatus, arm.updated, arm.createdby, arm.updatedby;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views