qtyallocated

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PARTID

INT

10

0

part.id

Implied Constraint

R

LOCATIONGROUPID

INT

10

√

null

QTY

DOUBLE

22

0

Relationships

Close relationships within degrees of separation

View Definition

select `totalqty`.`PARTID` AS `PARTID`,`totalqty`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,coalesce(sum(`totalqty`.`QTY`),0) AS `QTY` from (select 'SO' AS `t`,`fishbowl`.`qtyallocatedso`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedso`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedso`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedso` union select 'PO' AS `t`,`fishbowl`.`qtyallocatedpo`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedpo`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedpo`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedpo` union select 'TOSend' AS `t`,`fishbowl`.`qtyallocatedtosend`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedtosend`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedtosend`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedtosend` union select 'TOReceive' AS `t`,`fishbowl`.`qtyallocatedtoreceive`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedtoreceive`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedtoreceive`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedtoreceive` union select 'MO' AS `t`,`fishbowl`.`qtyallocatedmo`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedmo`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedmo`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedmo`) `totalqty` group by `totalqty`.`PARTID`,`totalqty`.`LOCATIONGROUPID`

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views