qtyinventory

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

PARTID

INT

√

null

part.id

Implied Constraint

LOCATIONGROUPID

INT

√

null

QTYONHAND

DOUBLE

√

null

QTYALLOCATEDPO

DOUBLE

√

null

QTYALLOCATEDSO

DOUBLE

√

null

QTYALLOCATEDMO

DOUBLE

√

null

QTYALLOCATEDTO

DOUBLE

√

null

QTYNOTAVAILABLE

DOUBLE

√

null

QTYNOTAVAILABLETOPICK

DOUBLE

√

null

QTYDROPSHIP

DOUBLE

√

null

QTYONORDERPO

DOUBLE

√

null

QTYONORDERSO

DOUBLE

√

null

QTYONORDERTO

DOUBLE

√

null

QTYONORDERMO

DOUBLE

√

null

Relationships

Close relationships within degrees of separation

View Definition

select `totalqty`.`PARTID` AS `PARTID`,`totalqty`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,sum((case when (`totalqty`.`t` = 'QTYONHAND') then `totalqty`.`QTY` else 0 end)) AS `QTYONHAND`,sum((case when (`totalqty`.`t` = 'QTYALLOCATEDPO') then `totalqty`.`QTY` else 0 end)) AS `QTYALLOCATEDPO`,sum((case when (`totalqty`.`t` = 'QTYALLOCATEDSO') then `totalqty`.`QTY` else 0 end)) AS `QTYALLOCATEDSO`,sum((case when (`totalqty`.`t` = 'QTYALLOCATEDMO') then `totalqty`.`QTY` else 0 end)) AS `QTYALLOCATEDMO`,(sum((case when (`totalqty`.`t` = 'QTYALLOCATEDTORECEIVE') then `totalqty`.`QTY` else 0 end)) + sum((case when (`totalqty`.`t` = 'QTYALLOCATEDTOSEND') then `totalqty`.`QTY` else 0 end))) AS `QTYALLOCATEDTO`,sum((case when (`totalqty`.`t` = 'QTYNOTAVAILABLE') then `totalqty`.`QTY` else 0 end)) AS `QTYNOTAVAILABLE`,sum((case when (`totalqty`.`t` = 'QTYNOTAVAILABLETOPICK') then `totalqty`.`QTY` else 0 end)) AS `QTYNOTAVAILABLETOPICK`,sum((case when (`totalqty`.`t` = 'QTYDROPSHIP') then `totalqty`.`QTY` else 0 end)) AS `QTYDROPSHIP`,sum((case when (`totalqty`.`t` = 'QTYONORDERPO') then `totalqty`.`QTY` else 0 end)) AS `QTYONORDERPO`,sum((case when (`totalqty`.`t` = 'QTYONORDERSO') then `totalqty`.`QTY` else 0 end)) AS `QTYONORDERSO`,(sum((case when (`totalqty`.`t` = 'QTYONORDERTORECEIVE') then `totalqty`.`QTY` else 0 end)) + sum((case when (`totalqty`.`t` = 'QTYONORDERTOSEND') then `totalqty`.`QTY` else 0 end))) AS `QTYONORDERTO`,sum((case when (`totalqty`.`t` = 'QTYONORDERMO') then `totalqty`.`QTY` else 0 end)) AS `QTYONORDERMO` from (select 'QTYONHAND' AS `t`,`fishbowl`.`qtyonhand`.`PARTID` AS `PARTID`,`fishbowl`.`qtyonhand`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyonhand`.`QTY` AS `QTY` from `fishbowl`.`qtyonhand` union select 'QTYALLOCATED' AS `t`,`fishbowl`.`qtyallocated`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocated`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocated`.`QTY` AS `QTY` from `fishbowl`.`qtyallocated` union select 'QTYALLOCATEDPO' AS `t`,`fishbowl`.`qtyallocatedpo`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedpo`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedpo`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedpo` union select 'QTYALLOCATEDSO' AS `t`,`fishbowl`.`qtyallocatedso`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedso`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedso`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedso` union select 'QTYALLOCATEDTORECEIVE' AS `t`,`fishbowl`.`qtyallocatedtoreceive`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedtoreceive`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedtoreceive`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedtoreceive` union select 'QTYALLOCATEDTOSEND' AS `t`,`fishbowl`.`qtyallocatedtosend`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedtosend`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedtosend`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedtosend` union select 'QTYALLOCATEDMO' AS `t`,`fishbowl`.`qtyallocatedmo`.`PARTID` AS `PARTID`,`fishbowl`.`qtyallocatedmo`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyallocatedmo`.`QTY` AS `QTY` from `fishbowl`.`qtyallocatedmo` union select 'QTYNOTAVAILABLE' AS `t`,`fishbowl`.`qtynotavailable`.`PARTID` AS `PARTID`,`fishbowl`.`qtynotavailable`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtynotavailable`.`QTY` AS `QTY` from `fishbowl`.`qtynotavailable` union select 'QTYNOTAVAILABLETOPICK' AS `t`,`fishbowl`.`qtynotavailabletopick`.`PARTID` AS `PARTID`,`fishbowl`.`qtynotavailabletopick`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtynotavailabletopick`.`QTY` AS `QTY` from `fishbowl`.`qtynotavailabletopick` union select 'QTYDROPSHIP' AS `t`,`fishbowl`.`qtydropship`.`PARTID` AS `PARTID`,`fishbowl`.`qtydropship`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtydropship`.`QTY` AS `QTY` from `fishbowl`.`qtydropship` union select 'QTYONORDERPO' AS `t`,`fishbowl`.`qtyonorderpo`.`PARTID` AS `PARTID`,`fishbowl`.`qtyonorderpo`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyonorderpo`.`QTY` AS `QTY` from `fishbowl`.`qtyonorderpo` union select 'QTYONORDERSO' AS `t`,`fishbowl`.`qtyonorderso`.`PARTID` AS `PARTID`,`fishbowl`.`qtyonorderso`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyonorderso`.`QTY` AS `QTY` from `fishbowl`.`qtyonorderso` union select 'QTYONORDERTORECEIVE' AS `t`,`fishbowl`.`qtyonordertoreceive`.`PARTID` AS `PARTID`,`fishbowl`.`qtyonordertoreceive`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyonordertoreceive`.`QTY` AS `QTY` from `fishbowl`.`qtyonordertoreceive` union select 'QTYONORDERTOSEND' AS `t`,`fishbowl`.`qtyonordertosend`.`PARTID` AS `PARTID`,`fishbowl`.`qtyonordertosend`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyonordertosend`.`QTY` AS `QTY` from `fishbowl`.`qtyonordertosend` union select 'QTYONORDERMO' AS `t`,`fishbowl`.`qtyonordermo`.`PARTID` AS `PARTID`,`fishbowl`.`qtyonordermo`.`LOCATIONGROUPID` AS `LOCATIONGROUPID`,`fishbowl`.`qtyonordermo`.`QTY` AS `QTY` from `fishbowl`.`qtyonordermo`) `totalqty` group by `totalqty`.`PARTID`,`totalqty`.`LOCATIONGROUPID`

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views