cof_rv_unpostedtrx

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

m_transaction_id

numeric

√

null

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

movementtype

bpchar

√

null

movementdate

timestamp

29,6

√

null

movementqty

numeric

√

null

m_attributesetinstance_id

numeric

√

null

m_product_id

numeric

√

null

record_id

numeric

√

null

posted

bpchar

√

null

dateacct

timestamp

29,6

√

null

tablename

text

2147483647

√

null

cof_datetrx

timestamp

29,6

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT t.m_transaction_id,
    t.ad_client_id,
    t.ad_org_id,
    t.movementtype,
    t.movementdate,
    t.movementqty,
    t.m_attributesetinstance_id,
    t.m_product_id,
    COALESCE(iv.m_inventory_id, mv.m_movement_id, io.m_inout_id, prd.m_production_id, pjl.c_projectissue_id) AS record_id,
    COALESCE(iv.posted, mv.posted, io.posted, prd.posted, pjl.posted) AS posted,
    COALESCE(iv.movementdate, mv.movementdate, io.dateacct, prd.movementdate, pjl.movementdate) AS dateacct,
        CASE
            WHEN (iv.m_inventory_id IS NOT NULL) THEN 'M_Inventory'::text
            WHEN (mv.m_movement_id IS NOT NULL) THEN 'M_Movement'::text
            WHEN (io.m_inout_id IS NOT NULL) THEN 'M_InOut'::text
            WHEN (prd.m_production_id IS NOT NULL) THEN 'M_Production'::text
            WHEN (pjl.c_projectissue_id IS NOT NULL) THEN 'C_ProjectIssue'::text
            ELSE NULL::text
        END AS tablename,
    t.created AS cof_datetrx
   FROM (((((((((((m_transaction t
     JOIN m_locator l ON ((t.m_locator_id = l.m_locator_id)))
     JOIN m_product p ON ((t.m_product_id = p.m_product_id)))
     LEFT JOIN m_inventoryline il ON ((t.m_inventoryline_id = il.m_inventoryline_id)))
     LEFT JOIN m_inventory iv ON ((iv.m_inventory_id = il.m_inventory_id)))
     LEFT JOIN m_movementline ml ON ((t.m_movementline_id = ml.m_movementline_id)))
     LEFT JOIN m_movement mv ON ((mv.m_movement_id = ml.m_movement_id)))
     LEFT JOIN m_inoutline iol ON ((t.m_inoutline_id = iol.m_inoutline_id)))
     LEFT JOIN m_inout io ON ((io.m_inout_id = iol.m_inout_id)))
     LEFT JOIN m_productionline prdl ON ((t.m_productionline_id = prdl.m_productionline_id)))
     LEFT JOIN m_production prd ON ((prd.m_production_id = prdl.m_production_id)))
     LEFT JOIN c_projectissue pjl ON ((t.c_projectissue_id = pjl.c_projectissue_id)))
  WHERE (COALESCE(iv.posted, mv.posted, io.posted, prd.posted, pjl.posted) <> 'Y'::bpchar);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views