DELETE FROM "STDEBTDEC" WHERE (("DEBTDECDOC_NO" = :Original_DEBTDECDOC_NO) AND ("DEBT_NO" = :Original_DEBT_NO) AND ("COMPANY_ID" = :Original_COMPANY_ID) AND ("DEBTDECTYPE_CODE" = :Original_DEBTDECTYPE_CODE)) INSERT INTO "STDEBTDEC" ("DEBTDECDOC_NO", "DEBT_NO", "COMPANY_ID", "DEBTDEC_AMT", "DEBTBALANCE_AMT", "DEBTDEC_STATUS", "ENTRY_ID", "ENTRY_DATE", "REMARK", "DEBTDECTYPE_CODE", "STORE_ID", "DEBTTYPE_CODE", "SLIP_DATE") VALUES (:DEBTDECDOC_NO, :DEBT_NO, :COMPANY_ID, :DEBTDEC_AMT, :DEBTBALANCE_AMT, :DEBTDEC_STATUS, :ENTRY_ID, :ENTRY_DATE, :REMARK, :DEBTDECTYPE_CODE, :STORE_ID, :DEBTTYPE_CODE, :SLIP_DATE) SELECT "STDEBTDEC"."DEBTDECDOC_NO", "STDEBTDEC"."DEBT_NO", "STDEBTDEC"."COMPANY_ID", "STDEBTDEC"."DEBTDEC_AMT", "STDEBTDEC"."DEBTBALANCE_AMT", "STDEBTDEC"."DEBTDEC_STATUS", "STDEBTDEC"."ENTRY_ID", "STDEBTDEC"."ENTRY_DATE", "STDEBTDEC"."REMARK", "STDEBTDEC"."DEBTDECTYPE_CODE", "STDEBTDEC"."STORE_ID", "STDEBTDEC"."DEBTTYPE_CODE", "STDEBTDEC"."SLIP_DATE", ' ' as slip_tdate, ' ' as entry_tdate FROM "STDEBTDEC" UPDATE "STDEBTDEC" SET "DEBTDECDOC_NO" = :DEBTDECDOC_NO, "DEBT_NO" = :DEBT_NO, "COMPANY_ID" = :COMPANY_ID, "DEBTDEC_AMT" = :DEBTDEC_AMT, "DEBTBALANCE_AMT" = :DEBTBALANCE_AMT, "DEBTDEC_STATUS" = :DEBTDEC_STATUS, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "REMARK" = :REMARK, "DEBTDECTYPE_CODE" = :DEBTDECTYPE_CODE, "STORE_ID" = :STORE_ID, "DEBTTYPE_CODE" = :DEBTTYPE_CODE, "SLIP_DATE" = :SLIP_DATE WHERE (("DEBTDECDOC_NO" = :Original_DEBTDECDOC_NO) AND ("DEBT_NO" = :Original_DEBT_NO) AND ("COMPANY_ID" = :Original_COMPANY_ID) AND ("DEBTDECTYPE_CODE" = :Original_DEBTDECTYPE_CODE)) DELETE FROM "STDEBTDET" WHERE (("DEBT_NO" = :Original_DEBT_NO) AND ("COMPANY_ID" = :Original_COMPANY_ID) AND ("SEQ_NO" = :Original_SEQ_NO) AND ("DEBTDETTYPE_CODE" = :Original_DEBTDETTYPE_CODE) AND ("DEBTINCDECTYPE_CODE" = :Original_DEBTINCDECTYPE_CODE) AND ("STORE_ID" = :Original_STORE_ID)) INSERT INTO "STDEBTDET" ("DEBT_NO", "COMPANY_ID", "SEQ_NO", "DEBTDETTYPE_CODE", "DEBTDET_DATE", "REFDOC_NO", "DEBTDET_AMT", "DEBTBALANCE_AMT", "DEBTINCDECTYPE_CODE", "STORE_ID", "DEBTTYPE_CODE", "DEBTDET_STATUS") VALUES (:DEBT_NO, :COMPANY_ID, :SEQ_NO, :DEBTDETTYPE_CODE, :DEBTDET_DATE, :REFDOC_NO, :DEBTDET_AMT, :DEBTBALANCE_AMT, :DEBTINCDECTYPE_CODE, :STORE_ID, :DEBTTYPE_CODE, :DEBTDET_STATUS) SELECT "STDEBTDET"."DEBT_NO", "STDEBTDET"."COMPANY_ID", "STDEBTDET"."SEQ_NO", "STDEBTDET"."DEBTDETTYPE_CODE", "STDEBTDET"."DEBTDET_DATE", "STDEBTDET"."REFDOC_NO", "STDEBTDET"."DEBTDET_AMT", "STDEBTDET"."DEBTBALANCE_AMT", "STDEBTDET"."DEBTINCDECTYPE_CODE", "STDEBTDET"."STORE_ID", "STDEBTDET"."DEBTTYPE_CODE", "STDEBTDET"."DEBTDET_STATUS", ' ' as debtdet_tdate FROM "STDEBTDET" UPDATE "STDEBTDET" SET "DEBT_NO" = :DEBT_NO, "COMPANY_ID" = :COMPANY_ID, "SEQ_NO" = :SEQ_NO, "DEBTDETTYPE_CODE" = :DEBTDETTYPE_CODE, "DEBTDET_DATE" = :DEBTDET_DATE, "REFDOC_NO" = :REFDOC_NO, "DEBTDET_AMT" = :DEBTDET_AMT, "DEBTBALANCE_AMT" = :DEBTBALANCE_AMT, "DEBTINCDECTYPE_CODE" = :DEBTINCDECTYPE_CODE, "STORE_ID" = :STORE_ID, "DEBTTYPE_CODE" = :DEBTTYPE_CODE, "DEBTDET_STATUS" = :DEBTDET_STATUS WHERE (("DEBT_NO" = :Original_DEBT_NO) AND ("COMPANY_ID" = :Original_COMPANY_ID) AND ("SEQ_NO" = :Original_SEQ_NO) AND ("DEBTDETTYPE_CODE" = :Original_DEBTDETTYPE_CODE) AND ("DEBTINCDECTYPE_CODE" = :Original_DEBTINCDECTYPE_CODE) AND ("STORE_ID" = :Original_STORE_ID)) DELETE FROM "STDEBTINC" WHERE (("DEBTINCDOC_NO" = :Original_DEBTINCDOC_NO) AND ("DEBT_NO" = :Original_DEBT_NO) AND ("COMPANY_ID" = :Original_COMPANY_ID) AND ("DEBTINCTYPE_CODE" = :Original_DEBTINCTYPE_CODE)) INSERT INTO "STDEBTINC" ("DEBTINCDOC_NO", "DEBT_NO", "COMPANY_ID", "DEBT_AMT", "DEBTBALANCE_AMT", "DEBTINC_STATUS", "DEBTPAY_AMT", "ENTRY_ID", "ENTRY_DATE", "REMARK", "DEBTINCTYPE_CODE", "STORE_ID", "DEBTTYPE_CODE", "SLIP_DATE") VALUES (:DEBTINCDOC_NO, :DEBT_NO, :COMPANY_ID, :DEBT_AMT, :DEBTBALANCE_AMT, :DEBTINC_STATUS, :DEBTPAY_AMT, :ENTRY_ID, :ENTRY_DATE, :REMARK, :DEBTINCTYPE_CODE, :STORE_ID, :DEBTTYPE_CODE, :SLIP_DATE) SELECT "STDEBTINC"."DEBTINCDOC_NO", "STDEBTINC"."DEBT_NO", "STDEBTINC"."COMPANY_ID", "STDEBTINC"."DEBT_AMT", "STDEBTINC"."DEBTBALANCE_AMT", "STDEBTINC"."DEBTINC_STATUS", "STDEBTINC"."DEBTPAY_AMT", "STDEBTINC"."ENTRY_ID", "STDEBTINC"."ENTRY_DATE", "STDEBTINC"."REMARK", "STDEBTINC"."DEBTINCTYPE_CODE", "STDEBTINC"."STORE_ID", "STDEBTINC"."DEBTTYPE_CODE", "STDEBTINC"."SLIP_DATE", ' ' as entry_tdate, ' ' as slip_tdate FROM "STDEBTINC" UPDATE "STDEBTINC" SET "DEBTINCDOC_NO" = :DEBTINCDOC_NO, "DEBT_NO" = :DEBT_NO, "COMPANY_ID" = :COMPANY_ID, "DEBT_AMT" = :DEBT_AMT, "DEBTBALANCE_AMT" = :DEBTBALANCE_AMT, "DEBTINC_STATUS" = :DEBTINC_STATUS, "DEBTPAY_AMT" = :DEBTPAY_AMT, "ENTRY_ID" = :ENTRY_ID, "ENTRY_DATE" = :ENTRY_DATE, "REMARK" = :REMARK, "DEBTINCTYPE_CODE" = :DEBTINCTYPE_CODE, "STORE_ID" = :STORE_ID, "DEBTTYPE_CODE" = :DEBTTYPE_CODE, "SLIP_DATE" = :SLIP_DATE WHERE (("DEBTINCDOC_NO" = :Original_DEBTINCDOC_NO) AND ("DEBT_NO" = :Original_DEBT_NO) AND ("COMPANY_ID" = :Original_COMPANY_ID) AND ("DEBTINCTYPE_CODE" = :Original_DEBTINCTYPE_CODE))