DELETE FROM "KPTEMPRECEIVEDET" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("KPSLIP_NO" = :Original_KPSLIP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "KPTEMPRECEIVEDET" ("COOP_ID", "KPSLIP_NO", "SEQ_NO", "MEMCOOP_ID", "MEMBER_NO", "RECV_PERIOD", "REFMEMCOOP_ID", "REF_MEMBNO", "KEEPITEMTYPE_CODE", "SHRLONTYPE_CODE", "BIZZCOOP_ID", "ITEM_SEQNO", "LOANCONTRACT_NO", "DESCRIPTION", "PERIOD", "PRINCIPAL_PAYMENT", "INTEREST_PAYMENT", "INTARREAR_PAYMENT", "ITEM_PAYMENT", "PRINCIPAL_BALANCE", "CALINTFROM_DATE", "CALINTTO_DATE", "PRINCIPAL_PERIOD", "INTEREST_PERIOD", "BFPRINBALANCE_AMT", "BFPERIOD", "BFLASTCALINT_DATE", "BFLASTPAY_DATE", "BFINTEREST_ARREAR", "BFINTMONTH_ARREAR", "BFINTYEAR_ARREAR", "BFPRINCIPAL_ARREAR", "BFCONTRACT_STATUS", "BFCONTLAW_STATUS", "BFCONTRACT_TYPE", "KEEPITEM_STATUS", "POSTING_STATUS", "POSTING_DATE", "CANCEL_ID", "CANCEL_DATE", "CANCEL_ACCID", "ITEM_BALANCE") VALUES (:COOP_ID, :KPSLIP_NO, :SEQ_NO, :MEMCOOP_ID, :MEMBER_NO, :RECV_PERIOD, :REFMEMCOOP_ID, :REF_MEMBNO, :KEEPITEMTYPE_CODE, :SHRLONTYPE_CODE, :BIZZCOOP_ID, :ITEM_SEQNO, :LOANCONTRACT_NO, :DESCRIPTION, :PERIOD, :PRINCIPAL_PAYMENT, :INTEREST_PAYMENT, :INTARREAR_PAYMENT, :ITEM_PAYMENT, :PRINCIPAL_BALANCE, :CALINTFROM_DATE, :CALINTTO_DATE, :PRINCIPAL_PERIOD, :INTEREST_PERIOD, :BFPRINBALANCE_AMT, :BFPERIOD, :BFLASTCALINT_DATE, :BFLASTPAY_DATE, :BFINTEREST_ARREAR, :BFINTMONTH_ARREAR, :BFINTYEAR_ARREAR, :BFPRINCIPAL_ARREAR, :BFCONTRACT_STATUS, :BFCONTLAW_STATUS, :BFCONTRACT_TYPE, :KEEPITEM_STATUS, :POSTING_STATUS, :POSTING_DATE, :CANCEL_ID, :CANCEL_DATE, :CANCEL_ACCID, :ITEM_BALANCE) SELECT COOP_ID, KPSLIP_NO, SEQ_NO, MEMCOOP_ID, MEMBER_NO, RECV_PERIOD, REFMEMCOOP_ID, REF_MEMBNO, KEEPITEMTYPE_CODE, SHRLONTYPE_CODE, BIZZCOOP_ID, ITEM_SEQNO, LOANCONTRACT_NO, DESCRIPTION, PERIOD, PRINCIPAL_PAYMENT, INTEREST_PAYMENT, INTARREAR_PAYMENT, ITEM_PAYMENT, PRINCIPAL_BALANCE, CALINTFROM_DATE, CALINTTO_DATE, PRINCIPAL_PERIOD, INTEREST_PERIOD, BFPRINBALANCE_AMT, BFPERIOD, BFLASTCALINT_DATE, BFLASTPAY_DATE, BFINTEREST_ARREAR, BFINTMONTH_ARREAR, BFINTYEAR_ARREAR, BFPRINCIPAL_ARREAR, BFCONTRACT_STATUS, BFCONTLAW_STATUS, BFCONTRACT_TYPE, KEEPITEM_STATUS, POSTING_STATUS, POSTING_DATE, CANCEL_ID, CANCEL_DATE, CANCEL_ACCID, ITEM_BALANCE FROM KPTEMPRECEIVEDET UPDATE "KPTEMPRECEIVEDET" SET "COOP_ID" = :COOP_ID, "KPSLIP_NO" = :KPSLIP_NO, "SEQ_NO" = :SEQ_NO, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "RECV_PERIOD" = :RECV_PERIOD, "REFMEMCOOP_ID" = :REFMEMCOOP_ID, "REF_MEMBNO" = :REF_MEMBNO, "KEEPITEMTYPE_CODE" = :KEEPITEMTYPE_CODE, "SHRLONTYPE_CODE" = :SHRLONTYPE_CODE, "BIZZCOOP_ID" = :BIZZCOOP_ID, "ITEM_SEQNO" = :ITEM_SEQNO, "LOANCONTRACT_NO" = :LOANCONTRACT_NO, "DESCRIPTION" = :DESCRIPTION, "PERIOD" = :PERIOD, "PRINCIPAL_PAYMENT" = :PRINCIPAL_PAYMENT, "INTEREST_PAYMENT" = :INTEREST_PAYMENT, "INTARREAR_PAYMENT" = :INTARREAR_PAYMENT, "ITEM_PAYMENT" = :ITEM_PAYMENT, "PRINCIPAL_BALANCE" = :PRINCIPAL_BALANCE, "CALINTFROM_DATE" = :CALINTFROM_DATE, "CALINTTO_DATE" = :CALINTTO_DATE, "PRINCIPAL_PERIOD" = :PRINCIPAL_PERIOD, "INTEREST_PERIOD" = :INTEREST_PERIOD, "BFPRINBALANCE_AMT" = :BFPRINBALANCE_AMT, "BFPERIOD" = :BFPERIOD, "BFLASTCALINT_DATE" = :BFLASTCALINT_DATE, "BFLASTPAY_DATE" = :BFLASTPAY_DATE, "BFINTEREST_ARREAR" = :BFINTEREST_ARREAR, "BFINTMONTH_ARREAR" = :BFINTMONTH_ARREAR, "BFINTYEAR_ARREAR" = :BFINTYEAR_ARREAR, "BFPRINCIPAL_ARREAR" = :BFPRINCIPAL_ARREAR, "BFCONTRACT_STATUS" = :BFCONTRACT_STATUS, "BFCONTLAW_STATUS" = :BFCONTLAW_STATUS, "BFCONTRACT_TYPE" = :BFCONTRACT_TYPE, "KEEPITEM_STATUS" = :KEEPITEM_STATUS, "POSTING_STATUS" = :POSTING_STATUS, "POSTING_DATE" = :POSTING_DATE, "CANCEL_ID" = :CANCEL_ID, "CANCEL_DATE" = :CANCEL_DATE, "CANCEL_ACCID" = :CANCEL_ACCID, "ITEM_BALANCE" = :ITEM_BALANCE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("KPSLIP_NO" = :Original_KPSLIP_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "KPTEMPRECEIVE" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("KPSLIP_NO" = :Original_KPSLIP_NO)) INSERT INTO "KPTEMPRECEIVE" ("COOP_ID", "KPSLIP_NO", "MEMCOOP_ID", "MEMBER_NO", "RECV_PERIOD", "REFMEMCOOP_ID", "REF_MEMBNO", "MEMBTYPE_CODE", "DEPARTMENT_CODE", "MEMBSECTION_CODE", "MEMBGROUP_CODE", "PROCESS_DATE", "RECEIPT_NO", "RECEIPT_DATE", "OPERATE_DATE", "SHARESTKBF_VALUE", "SHARESTK_VALUE", "INTEREST_ACCUM", "KEEPING_STATUS", "RECEIVE_AMT", "MONEY_TEXT", "GRT_LIST", "MONEYTYPE_CODE", "TOFROM_ACCID", "MISSPAY_STATUS", "BANK_CODE", "BANK_BRANCH", "BANK_ACCID", "RECEIPT_AMT", "RECEIPT_AMTTEXT", "EXPENSE_CODE", "EXPENSE_BANK", "EXPENSE_BRANCH", "EXPENSE_ACCID", "LAST_SEQ_NO", "SAVEDISK_TYPE", "TRTYPE_CODE", "KEEPSAL_FLAG") VALUES (:COOP_ID, :KPSLIP_NO, :MEMCOOP_ID, :MEMBER_NO, :RECV_PERIOD, :REFMEMCOOP_ID, :REF_MEMBNO, :MEMBTYPE_CODE, :DEPARTMENT_CODE, :MEMBSECTION_CODE, :MEMBGROUP_CODE, :PROCESS_DATE, :RECEIPT_NO, :RECEIPT_DATE, :OPERATE_DATE, :SHARESTKBF_VALUE, :SHARESTK_VALUE, :INTEREST_ACCUM, :KEEPING_STATUS, :RECEIVE_AMT, :MONEY_TEXT, :GRT_LIST, :MONEYTYPE_CODE, :TOFROM_ACCID, :MISSPAY_STATUS, :BANK_CODE, :BANK_BRANCH, :BANK_ACCID, :RECEIPT_AMT, :RECEIPT_AMTTEXT, :EXPENSE_CODE, :EXPENSE_BANK, :EXPENSE_BRANCH, :EXPENSE_ACCID, :LAST_SEQ_NO, :SAVEDISK_TYPE, :TRTYPE_CODE, :KEEPSAL_FLAG) SELECT COOP_ID, KPSLIP_NO, MEMCOOP_ID, MEMBER_NO, RECV_PERIOD, REFMEMCOOP_ID, REF_MEMBNO, MEMBTYPE_CODE, DEPARTMENT_CODE, MEMBSECTION_CODE, MEMBGROUP_CODE, PROCESS_DATE, RECEIPT_NO, RECEIPT_DATE, OPERATE_DATE, SHARESTKBF_VALUE, SHARESTK_VALUE, INTEREST_ACCUM, KEEPING_STATUS, RECEIVE_AMT, MONEY_TEXT, GRT_LIST, MONEYTYPE_CODE, TOFROM_ACCID, MISSPAY_STATUS, BANK_CODE, BANK_BRANCH, BANK_ACCID, RECEIPT_AMT, RECEIPT_AMTTEXT, EXPENSE_CODE, EXPENSE_BANK, EXPENSE_BRANCH, EXPENSE_ACCID, LAST_SEQ_NO, SAVEDISK_TYPE, TRTYPE_CODE, KEEPSAL_FLAG FROM KPTEMPRECEIVE UPDATE "KPTEMPRECEIVE" SET "COOP_ID" = :COOP_ID, "KPSLIP_NO" = :KPSLIP_NO, "MEMCOOP_ID" = :MEMCOOP_ID, "MEMBER_NO" = :MEMBER_NO, "RECV_PERIOD" = :RECV_PERIOD, "REFMEMCOOP_ID" = :REFMEMCOOP_ID, "REF_MEMBNO" = :REF_MEMBNO, "MEMBTYPE_CODE" = :MEMBTYPE_CODE, "DEPARTMENT_CODE" = :DEPARTMENT_CODE, "MEMBSECTION_CODE" = :MEMBSECTION_CODE, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "PROCESS_DATE" = :PROCESS_DATE, "RECEIPT_NO" = :RECEIPT_NO, "RECEIPT_DATE" = :RECEIPT_DATE, "OPERATE_DATE" = :OPERATE_DATE, "SHARESTKBF_VALUE" = :SHARESTKBF_VALUE, "SHARESTK_VALUE" = :SHARESTK_VALUE, "INTEREST_ACCUM" = :INTEREST_ACCUM, "KEEPING_STATUS" = :KEEPING_STATUS, "RECEIVE_AMT" = :RECEIVE_AMT, "MONEY_TEXT" = :MONEY_TEXT, "GRT_LIST" = :GRT_LIST, "MONEYTYPE_CODE" = :MONEYTYPE_CODE, "TOFROM_ACCID" = :TOFROM_ACCID, "MISSPAY_STATUS" = :MISSPAY_STATUS, "BANK_CODE" = :BANK_CODE, "BANK_BRANCH" = :BANK_BRANCH, "BANK_ACCID" = :BANK_ACCID, "RECEIPT_AMT" = :RECEIPT_AMT, "RECEIPT_AMTTEXT" = :RECEIPT_AMTTEXT, "EXPENSE_CODE" = :EXPENSE_CODE, "EXPENSE_BANK" = :EXPENSE_BANK, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_ACCID" = :EXPENSE_ACCID, "LAST_SEQ_NO" = :LAST_SEQ_NO, "SAVEDISK_TYPE" = :SAVEDISK_TYPE, "TRTYPE_CODE" = :TRTYPE_CODE, "KEEPSAL_FLAG" = :KEEPSAL_FLAG WHERE (("COOP_ID" = :Original_COOP_ID) AND ("KPSLIP_NO" = :Original_KPSLIP_NO)) DELETE FROM "MBMEMBMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO)) INSERT INTO "MBMEMBMASTER" ("COOP_ID", "MEMBER_NO", "PRENAME_CODE", "MEMB_NAME", "MEMB_SURNAME", "MEMB_ENAME", "MEMB_ESURNAME", "MEMBGROUP_CODE", "MEMBTYPE_CODE", "SIGNATURE_NAME", "BIRTH_DATE", "MEMBER_DATE", "DEAD_STATUS", "DEAD_DATE", "RETRY_STATUS", "RETRY_DATE", "RESIGN_STATUS", "RESIGN_DATE", "RESIGNCAUSE_CODE", "CLOSE_DATE", "SEX", "MARIAGE_STATUS", "ADDR_NO", "ADDR_MOO", "ADDR_SOI", "ADDR_VILLAGE", "ADDR_ROAD", "TAMBOL_CODE", "AMPHUR_CODE", "PROVINCE_CODE", "ADDR_POSTCODE", "ADDR_PHONE", "ADDR_MOBILEPHONE", "CURRADDR_NO", "CURRADDR_MOO", "CURRADDR_SOI", "CURRADDR_VILLAGE", "CURRADDR_ROAD", "CURRTAMBOL_CODE", "CURRAMPHUR_CODE", "CURRPROVINCE_CODE", "CURRADDR_POSTCODE", "CURRADDR_PHONE", "ADDR_EMAIL", "MEM_TELWORK", "MATE_NAME", "CARD_PERSON", "CARD_TAX", "MEMBER_CARD", "WORK_DATE", "POSITION_CODE", "POSITION_DESC", "LEVEL_CODE", "DEPARTMENT_CODE", "SALARY_AMOUNT", "SALARY_ID", "FIRSTFEE_STATUS", "MEMBER_STATUS", "MEMREF_FLAG", "MEMBER_REF", "KLONGTOON_FLAG", "HAVE_GAIN", "PAUSEKEEP_FLAG", "PAUSEKEEP_DATE", "FIRST_KEEPDATE", "LNPROVIDENTFUND_FLAG", "ALLOWLOAN_FLAG", "DROPGURANTEE_FLAG", "TRANSRIGHT_FLAG", "DROPLOANALL_FLAG", "DIVIDEND_FLAG", "AVERAGE_FLAG", "SEQUEST_DIVAVG", "REMARK", "MEMBER_TYPE", "DIVAVGSHOW_FLAG", "PRINTRECEIPTADDR_TYPE", "WEB_CODE", "IVR_CODE", "MEMBTRANS_DATE", "ACCUM_INTEREST", "SUMINT_LASTYEAR", "MISSPAYLON_AMT", "MISSPAYSHR_AMT", "MATE_MBFLAG", "MATE_MBNO", "EXPENSE_CODE", "EXPENSE_BANK", "EXPENSE_BRANCH", "EXPENSE_ACCID", "APPL_DOCNO", "APPLTYPE_CODE", "COMPOUNDKEEP_GROUP", "COMPOUNDKEEP_DATE", "COMPOUNDKEEP_STATUS", "COMPOUNDKEEP_PERIOD", "COMPOUNDKEEP_DUEDATE", "COMPOUNDKEEP_NMLDATE", "INSURANCE_FLAG", "CREMATION_STATUS", "NATIONALITY", "INCOMEETC_AMT", "FATHER_NAME", "MATHER_NAME", "SUBGROUP_CODE", "EMP_TYPE", "MATEADDR_NO", "MATEADDR_MOO", "MATEADDR_VILLAGE", "MATEADDR_SOI", "MATEADDR_ROAD", "MATETAMBOL_CODE", "MATEAMPHUR_CODE", "MATEPROVINCE_CODE", "MATEADDR_POSTCODE", "MATEADDR_PHONE", "LASTKEEP_DATE", "MATE_CARDPERSON", "MATE_SALARYID", "UPDATE_BYENTRYID", "UPDATE_BYENTRYIP", "KEEPSAL_FLAG", "TAMBOL_DESC") VALUES (:COOP_ID, :MEMBER_NO, :PRENAME_CODE, :MEMB_NAME, :MEMB_SURNAME, :MEMB_ENAME, :MEMB_ESURNAME, :MEMBGROUP_CODE, :MEMBTYPE_CODE, :SIGNATURE_NAME, :BIRTH_DATE, :MEMBER_DATE, :DEAD_STATUS, :DEAD_DATE, :RETRY_STATUS, :RETRY_DATE, :RESIGN_STATUS, :RESIGN_DATE, :RESIGNCAUSE_CODE, :CLOSE_DATE, :SEX, :MARIAGE_STATUS, :ADDR_NO, :ADDR_MOO, :ADDR_SOI, :ADDR_VILLAGE, :ADDR_ROAD, :TAMBOL_CODE, :AMPHUR_CODE, :PROVINCE_CODE, :ADDR_POSTCODE, :ADDR_PHONE, :ADDR_MOBILEPHONE, :CURRADDR_NO, :CURRADDR_MOO, :CURRADDR_SOI, :CURRADDR_VILLAGE, :CURRADDR_ROAD, :CURRTAMBOL_CODE, :CURRAMPHUR_CODE, :CURRPROVINCE_CODE, :CURRADDR_POSTCODE, :CURRADDR_PHONE, :ADDR_EMAIL, :MEM_TELWORK, :MATE_NAME, :CARD_PERSON, :CARD_TAX, :MEMBER_CARD, :WORK_DATE, :POSITION_CODE, :POSITION_DESC, :LEVEL_CODE, :DEPARTMENT_CODE, :SALARY_AMOUNT, :SALARY_ID, :FIRSTFEE_STATUS, :MEMBER_STATUS, :MEMREF_FLAG, :MEMBER_REF, :KLONGTOON_FLAG, :HAVE_GAIN, :PAUSEKEEP_FLAG, :PAUSEKEEP_DATE, :FIRST_KEEPDATE, :LNPROVIDENTFUND_FLAG, :ALLOWLOAN_FLAG, :DROPGURANTEE_FLAG, :TRANSRIGHT_FLAG, :DROPLOANALL_FLAG, :DIVIDEND_FLAG, :AVERAGE_FLAG, :SEQUEST_DIVAVG, :REMARK, :MEMBER_TYPE, :DIVAVGSHOW_FLAG, :PRINTRECEIPTADDR_TYPE, :WEB_CODE, :IVR_CODE, :MEMBTRANS_DATE, :ACCUM_INTEREST, :SUMINT_LASTYEAR, :MISSPAYLON_AMT, :MISSPAYSHR_AMT, :MATE_MBFLAG, :MATE_MBNO, :EXPENSE_CODE, :EXPENSE_BANK, :EXPENSE_BRANCH, :EXPENSE_ACCID, :APPL_DOCNO, :APPLTYPE_CODE, :COMPOUNDKEEP_GROUP, :COMPOUNDKEEP_DATE, :COMPOUNDKEEP_STATUS, :COMPOUNDKEEP_PERIOD, :COMPOUNDKEEP_DUEDATE, :COMPOUNDKEEP_NMLDATE, :INSURANCE_FLAG, :CREMATION_STATUS, :NATIONALITY, :INCOMEETC_AMT, :FATHER_NAME, :MATHER_NAME, :SUBGROUP_CODE, :EMP_TYPE, :MATEADDR_NO, :MATEADDR_MOO, :MATEADDR_VILLAGE, :MATEADDR_SOI, :MATEADDR_ROAD, :MATETAMBOL_CODE, :MATEAMPHUR_CODE, :MATEPROVINCE_CODE, :MATEADDR_POSTCODE, :MATEADDR_PHONE, :LASTKEEP_DATE, :MATE_CARDPERSON, :MATE_SALARYID, :UPDATE_BYENTRYID, :UPDATE_BYENTRYIP, :KEEPSAL_FLAG, :TAMBOL_DESC) select * from mbmembmaster UPDATE "MBMEMBMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "PRENAME_CODE" = :PRENAME_CODE, "MEMB_NAME" = :MEMB_NAME, "MEMB_SURNAME" = :MEMB_SURNAME, "MEMB_ENAME" = :MEMB_ENAME, "MEMB_ESURNAME" = :MEMB_ESURNAME, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "MEMBTYPE_CODE" = :MEMBTYPE_CODE, "SIGNATURE_NAME" = :SIGNATURE_NAME, "BIRTH_DATE" = :BIRTH_DATE, "MEMBER_DATE" = :MEMBER_DATE, "DEAD_STATUS" = :DEAD_STATUS, "DEAD_DATE" = :DEAD_DATE, "RETRY_STATUS" = :RETRY_STATUS, "RETRY_DATE" = :RETRY_DATE, "RESIGN_STATUS" = :RESIGN_STATUS, "RESIGN_DATE" = :RESIGN_DATE, "RESIGNCAUSE_CODE" = :RESIGNCAUSE_CODE, "CLOSE_DATE" = :CLOSE_DATE, "SEX" = :SEX, "MARIAGE_STATUS" = :MARIAGE_STATUS, "ADDR_NO" = :ADDR_NO, "ADDR_MOO" = :ADDR_MOO, "ADDR_SOI" = :ADDR_SOI, "ADDR_VILLAGE" = :ADDR_VILLAGE, "ADDR_ROAD" = :ADDR_ROAD, "TAMBOL_CODE" = :TAMBOL_CODE, "AMPHUR_CODE" = :AMPHUR_CODE, "PROVINCE_CODE" = :PROVINCE_CODE, "ADDR_POSTCODE" = :ADDR_POSTCODE, "ADDR_PHONE" = :ADDR_PHONE, "ADDR_MOBILEPHONE" = :ADDR_MOBILEPHONE, "CURRADDR_NO" = :CURRADDR_NO, "CURRADDR_MOO" = :CURRADDR_MOO, "CURRADDR_SOI" = :CURRADDR_SOI, "CURRADDR_VILLAGE" = :CURRADDR_VILLAGE, "CURRADDR_ROAD" = :CURRADDR_ROAD, "CURRTAMBOL_CODE" = :CURRTAMBOL_CODE, "CURRAMPHUR_CODE" = :CURRAMPHUR_CODE, "CURRPROVINCE_CODE" = :CURRPROVINCE_CODE, "CURRADDR_POSTCODE" = :CURRADDR_POSTCODE, "CURRADDR_PHONE" = :CURRADDR_PHONE, "ADDR_EMAIL" = :ADDR_EMAIL, "MEM_TELWORK" = :MEM_TELWORK, "MATE_NAME" = :MATE_NAME, "CARD_PERSON" = :CARD_PERSON, "CARD_TAX" = :CARD_TAX, "MEMBER_CARD" = :MEMBER_CARD, "WORK_DATE" = :WORK_DATE, "POSITION_CODE" = :POSITION_CODE, "POSITION_DESC" = :POSITION_DESC, "LEVEL_CODE" = :LEVEL_CODE, "DEPARTMENT_CODE" = :DEPARTMENT_CODE, "SALARY_AMOUNT" = :SALARY_AMOUNT, "SALARY_ID" = :SALARY_ID, "FIRSTFEE_STATUS" = :FIRSTFEE_STATUS, "MEMBER_STATUS" = :MEMBER_STATUS, "MEMREF_FLAG" = :MEMREF_FLAG, "MEMBER_REF" = :MEMBER_REF, "KLONGTOON_FLAG" = :KLONGTOON_FLAG, "HAVE_GAIN" = :HAVE_GAIN, "PAUSEKEEP_FLAG" = :PAUSEKEEP_FLAG, "PAUSEKEEP_DATE" = :PAUSEKEEP_DATE, "FIRST_KEEPDATE" = :FIRST_KEEPDATE, "LNPROVIDENTFUND_FLAG" = :LNPROVIDENTFUND_FLAG, "ALLOWLOAN_FLAG" = :ALLOWLOAN_FLAG, "DROPGURANTEE_FLAG" = :DROPGURANTEE_FLAG, "TRANSRIGHT_FLAG" = :TRANSRIGHT_FLAG, "DROPLOANALL_FLAG" = :DROPLOANALL_FLAG, "DIVIDEND_FLAG" = :DIVIDEND_FLAG, "AVERAGE_FLAG" = :AVERAGE_FLAG, "SEQUEST_DIVAVG" = :SEQUEST_DIVAVG, "REMARK" = :REMARK, "MEMBER_TYPE" = :MEMBER_TYPE, "DIVAVGSHOW_FLAG" = :DIVAVGSHOW_FLAG, "PRINTRECEIPTADDR_TYPE" = :PRINTRECEIPTADDR_TYPE, "WEB_CODE" = :WEB_CODE, "IVR_CODE" = :IVR_CODE, "MEMBTRANS_DATE" = :MEMBTRANS_DATE, "ACCUM_INTEREST" = :ACCUM_INTEREST, "SUMINT_LASTYEAR" = :SUMINT_LASTYEAR, "MISSPAYLON_AMT" = :MISSPAYLON_AMT, "MISSPAYSHR_AMT" = :MISSPAYSHR_AMT, "MATE_MBFLAG" = :MATE_MBFLAG, "MATE_MBNO" = :MATE_MBNO, "EXPENSE_CODE" = :EXPENSE_CODE, "EXPENSE_BANK" = :EXPENSE_BANK, "EXPENSE_BRANCH" = :EXPENSE_BRANCH, "EXPENSE_ACCID" = :EXPENSE_ACCID, "APPL_DOCNO" = :APPL_DOCNO, "APPLTYPE_CODE" = :APPLTYPE_CODE, "COMPOUNDKEEP_GROUP" = :COMPOUNDKEEP_GROUP, "COMPOUNDKEEP_DATE" = :COMPOUNDKEEP_DATE, "COMPOUNDKEEP_STATUS" = :COMPOUNDKEEP_STATUS, "COMPOUNDKEEP_PERIOD" = :COMPOUNDKEEP_PERIOD, "COMPOUNDKEEP_DUEDATE" = :COMPOUNDKEEP_DUEDATE, "COMPOUNDKEEP_NMLDATE" = :COMPOUNDKEEP_NMLDATE, "INSURANCE_FLAG" = :INSURANCE_FLAG, "CREMATION_STATUS" = :CREMATION_STATUS, "NATIONALITY" = :NATIONALITY, "INCOMEETC_AMT" = :INCOMEETC_AMT, "FATHER_NAME" = :FATHER_NAME, "MATHER_NAME" = :MATHER_NAME, "SUBGROUP_CODE" = :SUBGROUP_CODE, "EMP_TYPE" = :EMP_TYPE, "MATEADDR_NO" = :MATEADDR_NO, "MATEADDR_MOO" = :MATEADDR_MOO, "MATEADDR_VILLAGE" = :MATEADDR_VILLAGE, "MATEADDR_SOI" = :MATEADDR_SOI, "MATEADDR_ROAD" = :MATEADDR_ROAD, "MATETAMBOL_CODE" = :MATETAMBOL_CODE, "MATEAMPHUR_CODE" = :MATEAMPHUR_CODE, "MATEPROVINCE_CODE" = :MATEPROVINCE_CODE, "MATEADDR_POSTCODE" = :MATEADDR_POSTCODE, "MATEADDR_PHONE" = :MATEADDR_PHONE, "LASTKEEP_DATE" = :LASTKEEP_DATE, "MATE_CARDPERSON" = :MATE_CARDPERSON, "MATE_SALARYID" = :MATE_SALARYID, "UPDATE_BYENTRYID" = :UPDATE_BYENTRYID, "UPDATE_BYENTRYIP" = :UPDATE_BYENTRYIP, "KEEPSAL_FLAG" = :KEEPSAL_FLAG, "TAMBOL_DESC" = :TAMBOL_DESC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO))