DELETE FROM "STSTOCKSLIP" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SLIP_NO" = :Original_SLIP_NO) AND ("STORE_ID" = :Original_STORE_ID)) INSERT INTO "STSTOCKSLIP" ("COOP_ID", "SLIP_NO", "STORE_ID", "TERMINAL_NO", "SLIP_DATE", "REFDOC_NO", "DEBT_NO", "SLIPTYPE_CODE", "REMARK", "DEBT_NAME", "DEBTTYPE_CODE", "SLIP_AMT", "DEBTFROMTYPE_CODE", "DISCOUNT_AMT", "SLIPNET_AMT", "VAT_AMT", "RECEIVE_AMT", "CHANGE_AMT", "REMAIN_AMT", "RECEIPTDOC_NO", "TAXDOC_NO", "DELIVERYDOC_NO", "INVOICEDOC_NO", "SLIP_STATUS", "EXPENSE_CODE", "ENTRY_ID", "ENTRY_DATE", "POST_STATUS") VALUES (:COOP_ID, :SLIP_NO, :STORE_ID, :TERMINAL_NO, :SLIP_DATE, :REFDOC_NO, :DEBT_NO, :SLIPTYPE_CODE, :REMARK, :DEBT_NAME, :DEBTTYPE_CODE, :SLIP_AMT, :DEBTFROMTYPE_CODE, :DISCOUNT_AMT, :SLIPNET_AMT, :VAT_AMT, :RECEIVE_AMT, :CHANGE_AMT, :REMAIN_AMT, :RECEIPTDOC_NO, :TAXDOC_NO, :DELIVERYDOC_NO, :INVOICEDOC_NO, :SLIP_STATUS, :EXPENSE_CODE, :ENTRY_ID, :ENTRY_DATE, :POST_STATUS) select * from ststockslip UPDATE "STSTOCKSLIP" SET "COOP_ID" = :COOP_ID, "SLIP_NO" = :SLIP_NO, "STORE_ID" = :STORE_ID, "TERMINAL_NO" = :TERMINAL_NO, "SLIP_DATE" = :SLIP_DATE, "REFDOC_NO" = :REFDOC_NO, "DEBT_NO" = :DEBT_NO, "SLIPTYPE_CODE" = :SLIPTYPE_CODE, "REMARK" = :REMARK, "DEBT_NAME" = :DEBT_NAME, "DEBTTYPE_CODE" = :DEBTTYPE_CODE, "SLIP_AMT" = :SLIP_AMT, "DEBTFROMTYPE_CODE" = :DEBTFROMTYPE_CODE, "DISCOUNT_AMT" = :DISCOUNT_AMT, "SLIPNET_AMT" = :SLIPNET_AMT, "VAT_AMT" = :VAT_AMT, "RECEIVE_AMT" = :RECEIVE_AMT, "CHANGE_AMT" = :CHANGE_AMT, "REMAIN_AMT" = :REMAIN_AMT, "RECEIPTDOC_NO" = :RECEIPTDOC_NO, "TAXDOC_NO" = :TAXDOC_NO, "DELIVERYDOC_NO" = :DELIVERYDOC_NO, "INVOICEDOC_NO" = :INVOICEDOC_NO, "SLIP_STATUS" = :SLIP_STATUS, "EXPENSE_CODE" = :EXPENSE_CODE, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "POST_STATUS" = :POST_STATUS WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SLIP_NO" = :Original_SLIP_NO) AND ("STORE_ID" = :Original_STORE_ID)) DELETE FROM "STSTOCKSLIPDET" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SLIP_NO" = :Original_SLIP_NO) AND ("STORE_ID" = :Original_STORE_ID) AND ("SEQ_NO" = :Original_SEQ_NO)) 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") 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) 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 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 WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SLIP_NO" = :Original_SLIP_NO) AND ("STORE_ID" = :Original_STORE_ID) AND ("SEQ_NO" = :Original_SEQ_NO))