DELETE FROM "VCMAPACCID" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SYSTEM_CODE" = :Original_SYSTEM_CODE) AND ("SLIPITEMTYPE_CODE" = :Original_SLIPITEMTYPE_CODE) AND ("SHRLONTYPE_CODE" = :Original_SHRLONTYPE_CODE) AND ("SHRLONTYPE_STATUS" = :Original_SHRLONTYPE_STATUS)) INSERT INTO "VCMAPACCID" ("COOP_ID", "SYSTEM_CODE", "SLIPITEMTYPE_CODE", "SHRLONTYPE_CODE", "SHRLONTYPE_STATUS", "ACCOUNT_ID", "ACCINT_ID", "ACCINTARR_ID", "ACCTAX_ID", "SORTACC_ORDER", "SORTINT_ORDER", "SORTINTARR_ORDER", "SORTTAX_ORDER", "PREFIX_RECV", "PREFIX_PAY", "AREA_CODE") VALUES (:COOP_ID, :SYSTEM_CODE, :SLIPITEMTYPE_CODE, :SHRLONTYPE_CODE, :SHRLONTYPE_STATUS, :ACCOUNT_ID, :ACCINT_ID, :ACCINTARR_ID, :ACCTAX_ID, :SORTACC_ORDER, :SORTINT_ORDER, :SORTINTARR_ORDER, :SORTTAX_ORDER, :PREFIX_RECV, :PREFIX_PAY, :AREA_CODE) select * from vcmapaccid UPDATE "VCMAPACCID" SET "COOP_ID" = :COOP_ID, "SYSTEM_CODE" = :SYSTEM_CODE, "SLIPITEMTYPE_CODE" = :SLIPITEMTYPE_CODE, "SHRLONTYPE_CODE" = :SHRLONTYPE_CODE, "SHRLONTYPE_STATUS" = :SHRLONTYPE_STATUS, "ACCOUNT_ID" = :ACCOUNT_ID, "ACCINT_ID" = :ACCINT_ID, "ACCINTARR_ID" = :ACCINTARR_ID, "ACCTAX_ID" = :ACCTAX_ID, "SORTACC_ORDER" = :SORTACC_ORDER, "SORTINT_ORDER" = :SORTINT_ORDER, "SORTINTARR_ORDER" = :SORTINTARR_ORDER, "SORTTAX_ORDER" = :SORTTAX_ORDER, "PREFIX_RECV" = :PREFIX_RECV, "PREFIX_PAY" = :PREFIX_PAY, "AREA_CODE" = :AREA_CODE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("SYSTEM_CODE" = :Original_SYSTEM_CODE) AND ("SLIPITEMTYPE_CODE" = :Original_SLIPITEMTYPE_CODE) AND ("SHRLONTYPE_CODE" = :Original_SHRLONTYPE_CODE) AND ("SHRLONTYPE_STATUS" = :Original_SHRLONTYPE_STATUS))