DELETE FROM "STSTOCKSLIPDET" WHERE (("SLIP_NO" = :Original_SLIP_NO) AND ("STORE_ID" = :Original_STORE_ID) AND ("SEQ_NO" = :Original_SEQ_NO) AND ("COMPANY_ID" = :Original_COMPANY_ID)) INSERT INTO "STSTOCKSLIPDET" ("COOP_ID", "SLIP_NO", "STORE_ID", "SEQ_NO", "ITEM_QTY", "PRODUCT_NO", "ITEMTYPE_CODE", "PRODUCT_PRICE", "DISCOUNT_PERCENT", "PRODUCT_COST", "DISCOUNT_AMT", "ITEM_AMT", "VAT_AMT", "ITEMNET_AMT", "ITEMNOVAT_AMT", "LOT_NO", "SLIPDET_STATUS", "ITEM_RETURN_QTY", "COST_AMT", "BEFORE_METER", "AFTER_METER", "PUMP_ID", "COMPANY_ID") VALUES (:COOP_ID, :SLIP_NO, :STORE_ID, :SEQ_NO, :ITEM_QTY, :PRODUCT_NO, :ITEMTYPE_CODE, :PRODUCT_PRICE, :DISCOUNT_PERCENT, :PRODUCT_COST, :DISCOUNT_AMT, :ITEM_AMT, :VAT_AMT, :ITEMNET_AMT, :ITEMNOVAT_AMT, :LOT_NO, :SLIPDET_STATUS, :ITEM_RETURN_QTY, :COST_AMT, :BEFORE_METER, :AFTER_METER, :PUMP_ID, :COMPANY_ID) SELECT COOP_ID, SLIP_NO, STORE_ID, SEQ_NO, ITEM_QTY, PRODUCT_NO, ITEMTYPE_CODE, PRODUCT_PRICE, DISCOUNT_PERCENT, PRODUCT_COST, DISCOUNT_AMT, ITEM_AMT, VAT_AMT, ITEMNET_AMT, ITEMNOVAT_AMT, LOT_NO, SLIPDET_STATUS, ITEM_RETURN_QTY, COST_AMT, BEFORE_METER, AFTER_METER, PUMP_ID,'' PRODUCT_DESC,'' START_NO, '' END_NO, COMPANY_ID,'' vat_flag FROM STSTOCKSLIPDET UPDATE "STSTOCKSLIPDET" SET "COOP_ID" = :COOP_ID, "SLIP_NO" = :SLIP_NO, "STORE_ID" = :STORE_ID, "SEQ_NO" = :SEQ_NO, "ITEM_QTY" = :ITEM_QTY, "PRODUCT_NO" = :PRODUCT_NO, "ITEMTYPE_CODE" = :ITEMTYPE_CODE, "PRODUCT_PRICE" = :PRODUCT_PRICE, "DISCOUNT_PERCENT" = :DISCOUNT_PERCENT, "PRODUCT_COST" = :PRODUCT_COST, "DISCOUNT_AMT" = :DISCOUNT_AMT, "ITEM_AMT" = :ITEM_AMT, "VAT_AMT" = :VAT_AMT, "ITEMNET_AMT" = :ITEMNET_AMT, "ITEMNOVAT_AMT" = :ITEMNOVAT_AMT, "LOT_NO" = :LOT_NO, "SLIPDET_STATUS" = :SLIPDET_STATUS, "ITEM_RETURN_QTY" = :ITEM_RETURN_QTY, "COST_AMT" = :COST_AMT, "BEFORE_METER" = :BEFORE_METER, "AFTER_METER" = :AFTER_METER, "PUMP_ID" = :PUMP_ID, "COMPANY_ID" = :COMPANY_ID WHERE (("SLIP_NO" = :Original_SLIP_NO) AND ("STORE_ID" = :Original_STORE_ID) AND ("SEQ_NO" = :Original_SEQ_NO) AND ("COMPANY_ID" = :Original_COMPANY_ID))