delete0016Dangcagan2

-- -----------------------------------------------------------------------------------------------------------------------------------------
-- AFCTRL352e1284:1667a5cd58c:-4f5c LOLITA L LADINGAN
-- cashreceipt item
DELETE FROM cashreceiptitem WHERE receiptid IN (SELECT objid FROM cashreceipt WHERE  controlid='AFCTRL352e1284:1667a5cd58c:-4f5c');
DELETE FROM cashreceipt_void WHERE receiptid IN (SELECT objid FROM cashreceipt WHERE  controlid='AFCTRL352e1284:1667a5cd58c:-4f5c');
-- cash receipt
DELETE FROM cashreceipt WHERE  controlid='AFCTRL352e1284:1667a5cd58c:-4f5c';
-- af inventory item and detail
DELETE FROM `etracs254_dangcagan`.`af_inventory_detail` WHERE `controlid`='AFCTRL352e1284:1667a5cd58c:-4f5c';
DELETE FROM `etracs254_dangcagan`.`af_inventory` WHERE `objid`='AFCTRL352e1284:1667a5cd58c:-4f5c';
-- af control
DELETE FROM af_control WHERE objid='AFCTRL352e1284:1667a5cd58c:-4f5c';


-- -----------------------------------------------------------------------------------------------------------------------------------------
-- =========================================================================================================================================
-- -----------------------------------------------------------------------------------------------------------------------------------------


-- galvez AFCTRL352e1284:1667a5cd58c:-66e8
-- cancel series
DELETE FROM `etracs254_dangcagan`.`cashreceipt_cancelseries` WHERE `objid`='CRCT352e1284:1667a5cd58c:-4477';
-- cash receipt
DELETE FROM `etracs254_dangcagan`.`cashreceipt` WHERE `objid`='CRCT352e1284:1667a5cd58c:-4479';
-- af inventory item and detail
DELETE FROM `etracs254_dangcagan`.`af_inventory_detail` WHERE `controlid`='AFCTRL352e1284:1667a5cd58c:-66e8';
DELETE FROM `etracs254_dangcagan`.`af_inventory` WHERE `objid`='AFCTRL352e1284:1667a5cd58c:-66e8';
-- af control
DELETE FROM af_control WHERE objid='AFCTRL352e1284:1667a5cd58c:-66e8';
-- -----------------------------------------------------------------------------------------------------------------------------------------
-- RCD
-- AFO detail
DELETE FROM `etracs254_dangcagan`.`af_inventory_detail` WHERE controlid='AFCTRL-91b18d2:161365c7750:-128f';
-- AFO inventory
DELETE FROM `etracs254_dangcagan`.`af_inventory` WHERE `objid`='AFCTRL-91b18d2:161365c7750:-128f';