m_transaction_v

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

m_transaction_id

numeric

√

null

m_transaction.m_transaction_id

Implied Constraint

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

isactive

bpchar

√

null

created

timestamp

29,6

√

null

createdby

numeric

√

null

updated

timestamp

29,6

√

null

updatedby

numeric

√

null

movementtype

bpchar

√

null

m_locator_id

numeric

√

null

m_locator.m_locator_id

Implied Constraint

m_product_id

numeric

√

null

m_product.m_product_id

Implied Constraint

movementdate

timestamp

29,6

√

null

movementqty

numeric

√

null

m_inventoryline_id

numeric

√

null

m_inventoryline.m_inventoryline_id

Implied Constraint

m_inventory_id

numeric

√

null

m_inventory.m_inventory_id

Implied Constraint

m_movementline_id

numeric

√

null

m_movementline.m_movementline_id

Implied Constraint

m_movement_id

numeric

√

null

m_movement.m_movement_id

Implied Constraint

m_inoutline_id

numeric

√

null

m_inoutline.m_inoutline_id

Implied Constraint

m_inout_id

numeric

√

null

m_inout.m_inout_id

Implied Constraint

m_productionline_id

numeric

√

null

m_productionline.m_productionline_id

Implied Constraint

m_production_id

numeric

√

null

m_production.m_production_id

Implied Constraint

c_projectissue_id

numeric

√

null

c_projectissue.c_projectissue_id

Implied Constraint

c_project_id

numeric

√

null

c_project.c_project_id

Implied Constraint

m_attributesetinstance_id

numeric

√

null

m_attributesetinstance.m_attributesetinstance_id

Implied Constraint

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT t.m_transaction_id,
    t.ad_client_id,
    t.ad_org_id,
    t.isactive,
    t.created,
    t.createdby,
    t.updated,
    t.updatedby,
    t.movementtype,
    t.m_locator_id,
    t.m_product_id,
    t.movementdate,
    t.movementqty,
    t.m_inventoryline_id,
    i.m_inventory_id,
    t.m_movementline_id,
    m.m_movement_id,
    t.m_inoutline_id,
    io.m_inout_id,
    t.m_productionline_id,
    pp.m_production_id,
    t.c_projectissue_id,
    pi.c_project_id,
    t.m_attributesetinstance_id
   FROM ((((((m_transaction t
     LEFT JOIN m_inoutline io ON (((t.m_inoutline_id = io.m_inoutline_id) AND (t.m_attributesetinstance_id = io.m_attributesetinstance_id))))
     LEFT JOIN m_movementline m ON (((t.m_movementline_id = m.m_movementline_id) AND (t.m_attributesetinstance_id = m.m_attributesetinstance_id))))
     LEFT JOIN m_inventoryline i ON (((t.m_inventoryline_id = i.m_inventoryline_id) AND (t.m_attributesetinstance_id = i.m_attributesetinstance_id))))
     LEFT JOIN c_projectissue pi ON (((t.c_projectissue_id = pi.c_projectissue_id) AND (t.m_attributesetinstance_id = pi.m_attributesetinstance_id))))
     LEFT JOIN m_productionline pl ON (((t.m_productionline_id = pl.m_productionline_id) AND (t.m_attributesetinstance_id = pl.m_attributesetinstance_id))))
     LEFT JOIN m_productionplan pp ON ((pl.m_productionplan_id = pp.m_productionplan_id)));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views