{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["테이블조회","칼럼결과","쿼리결과"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"테이블조회","index":0,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"테이블명","loan_mgnt_dspt_proc"]

{"sheet":"칼럼결과","index":1,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["칼럼","데이터유형","길이","PK","코멘트","CAMEL 표기","쿼리 INSERT","쿼리 UPDATE","쿼리 SELECT","JAVA 변수","BUILDER"]
["DSPT_MGNT_NO","VARCHAR","40","PK","입금관리번호","dsptMgntNo","#{entity.dsptMgntNo}, ","dspt_mgnt_no = #{entity.dsptMgntNo},","A.dspt_mgnt_no, ","@ApiModelProperty(value = \"입금관리번호\") private String dsptMgntNo;",".dsptMgntNo(entity.getDsptMgntNo())"]
["REQ_DT","VARCHAR","8",null,"요청일자","reqDt","#{entity.reqDt}, ","req_dt = #{entity.reqDt},","A.req_dt, ","@ApiModelProperty(value = \"요청일자\") private String reqDt;",".reqDt(entity.getReqDt())"]
["REQ_TM","VARCHAR","6",null,"요청시각","reqTm","#{entity.reqTm}, ","req_tm = #{entity.reqTm},","A.req_tm, ","@ApiModelProperty(value = \"요청시각\") private String reqTm;",".reqTm(entity.getReqTm())"]
["DPST_AMT","BIGINT","20",null,"입금금액","dpstAmt","#{entity.dpstAmt}, ","dpst_amt = #{entity.dpstAmt},","A.dpst_amt, ","@ApiModelProperty(value = \"입금금액\") private String dpstAmt;",".dpstAmt(entity.getDpstAmt())"]
["DPST_DT","VARCHAR","8",null,"입금일자","dpstDt","#{entity.dpstDt}, ","dpst_dt = #{entity.dpstDt},","A.dpst_dt, ","@ApiModelProperty(value = \"입금일자\") private String dpstDt;",".dpstDt(entity.getDpstDt())"]
["DPST_NM","VARCHAR","50",null,"입금자명","dpstNm","#{entity.dpstNm}, ","dpst_nm = #{entity.dpstNm},","A.dpst_nm, ","@ApiModelProperty(value = \"입금자명\") private String dpstNm;",".dpstNm(entity.getDpstNm())"]
["RCV_ACCT_NO","VARCHAR","20",null,"입금계좌번호","rcvAcctNo","#{entity.rcvAcctNo}, ","rcv_acct_no = #{entity.rcvAcctNo},","A.rcv_acct_no, ","@ApiModelProperty(value = \"입금계좌번호\") private String rcvAcctNo;",".rcvAcctNo(entity.getRcvAcctNo())"]
["DPST_BNK_CD","VARCHAR","4",null,"입금은행코드","dpstBnkCd","#{entity.dpstBnkCd}, ","dpst_bnk_cd = #{entity.dpstBnkCd},","A.dpst_bnk_cd, ","@ApiModelProperty(value = \"입금은행코드\") private String dpstBnkCd;",".dpstBnkCd(entity.getDpstBnkCd())"]
["DPST_ST_CD","VARCHAR","4",null,"입금상태코드","dpstStCd","#{entity.dpstStCd}, ","dpst_st_cd = #{entity.dpstStCd},","A.dpst_st_cd, ","@ApiModelProperty(value = \"입금상태코드\") private String dpstStCd;",".dpstStCd(entity.getDpstStCd())"]
["DPST_REQ_ID","VARCHAR","20",null,"입금요청자아이디","dpstReqId","#{entity.dpstReqId}, ","dpst_req_id = #{entity.dpstReqId},","A.dpst_req_id, ","@ApiModelProperty(value = \"입금요청자아이디\") private String dpstReqId;",".dpstReqId(entity.getDpstReqId())"]
["DPST_REQ_NM","VARCHAR","50",null,"입금요청자명","dpstReqNm","#{entity.dpstReqNm}, ","dpst_req_nm = #{entity.dpstReqNm},","A.dpst_req_nm, ","@ApiModelProperty(value = \"입금요청자명\") private String dpstReqNm;",".dpstReqNm(entity.getDpstReqNm())"]
["DPST_AUTH_ID","VARCHAR","20",null,"입금승인자아이디","dpstAuthId","#{entity.dpstAuthId}, ","dpst_auth_id = #{entity.dpstAuthId},","A.dpst_auth_id, ","@ApiModelProperty(value = \"입금승인자아이디\") private String dpstAuthId;",".dpstAuthId(entity.getDpstAuthId())"]
["DPST_AUTH_NM","VARCHAR","50",null,"입금승인자명","dpstAuthNm","#{entity.dpstAuthNm}, ","dpst_auth_nm = #{entity.dpstAuthNm},","A.dpst_auth_nm, ","@ApiModelProperty(value = \"입금승인자명\") private String dpstAuthNm;",".dpstAuthNm(entity.getDpstAuthNm())"]
["DPST_AUTH_DT","VARCHAR","8",null,"입금승인일자","dpstAuthDt","#{entity.dpstAuthDt}, ","dpst_auth_dt = #{entity.dpstAuthDt},","A.dpst_auth_dt, ","@ApiModelProperty(value = \"입금승인일자\") private String dpstAuthDt;",".dpstAuthDt(entity.getDpstAuthDt())"]
["DPST_AUTH_TM","VARCHAR","6",null,"입금승인시각","dpstAuthTm","#{entity.dpstAuthTm}, ","dpst_auth_tm = #{entity.dpstAuthTm},","A.dpst_auth_tm, ","@ApiModelProperty(value = \"입금승인시각\") private String dpstAuthTm;",".dpstAuthTm(entity.getDpstAuthTm())"]
["DSPT_RJCT_DT","VARCHAR","8",null,"입금반려일자","dsptRjctDt","#{entity.dsptRjctDt}, ","dspt_rjct_dt = #{entity.dsptRjctDt},","A.dspt_rjct_dt, ","@ApiModelProperty(value = \"입금반려일자\") private String dsptRjctDt;",".dsptRjctDt(entity.getDsptRjctDt())"]
["DSPT_RJCT_TM","VARCHAR","6",null,"입금반려시각","dsptRjctTm","#{entity.dsptRjctTm}, ","dspt_rjct_tm = #{entity.dsptRjctTm},","A.dspt_rjct_tm, ","@ApiModelProperty(value = \"입금반려시각\") private String dsptRjctTm;",".dsptRjctTm(entity.getDsptRjctTm())"]
["STORE_ID","VARCHAR","20",null,"매장아이디","storeId","#{entity.storeId}, ","store_id = #{entity.storeId},","A.store_id, ","@ApiModelProperty(value = \"매장아이디\") private String storeId;",".storeId(entity.getStoreId())"]
["BRAND_ID","VARCHAR","20",null,"브랜드아이디","brandId","#{entity.brandId}, ","brand_id = #{entity.brandId},","A.brand_id, ","@ApiModelProperty(value = \"브랜드아이디\") private String brandId;",".brandId(entity.getBrandId())"]
["DPST_AUTH_YN","VARCHAR","1",null,"입금승인여부","dpstAuthYn","#{entity.dpstAuthYn}, ","dpst_auth_yn = #{entity.dpstAuthYn},","A.dpst_auth_yn, ","@ApiModelProperty(value = \"입금승인여부\") private String dpstAuthYn;",".dpstAuthYn(entity.getDpstAuthYn())"]
["DSPT_RJCT_RSN","VARCHAR","1000",null,"입금반려사유","dsptRjctRsn","#{entity.dsptRjctRsn}, ","dspt_rjct_rsn = #{entity.dsptRjctRsn},","A.dspt_rjct_rsn, ","@ApiModelProperty(value = \"입금반려사유\") private String dsptRjctRsn;",".dsptRjctRsn(entity.getDsptRjctRsn())"]
["SYS_REG_DTTM","DATETIME","datetime",null,"시스템등록일시","sysRegDttm","#{entity.sysRegDttm}, ","sys_reg_dttm = #{entity.sysRegDttm},","A.sys_reg_dttm, ","@ApiModelProperty(value = \"시스템등록일시\") private String sysRegDttm;",".sysRegDttm(entity.getSysRegDttm())"]
["SYS_REG_ID","VARCHAR","20",null,"시스템등록아이디","sysRegId","#{entity.sysRegId}, ","sys_reg_id = #{entity.sysRegId},","A.sys_reg_id, ","@ApiModelProperty(value = \"시스템등록아이디\") private String sysRegId;",".sysRegId(entity.getSysRegId())"]
["SYS_CHG_DTTM","DATETIME","datetime",null,"시스템변경일시","sysChgDttm","#{entity.sysChgDttm}, ","sys_chg_dttm = #{entity.sysChgDttm},","A.sys_chg_dttm, ","@ApiModelProperty(value = \"시스템변경일시\") private String sysChgDttm;",".sysChgDttm(entity.getSysChgDttm())"]
["SYS_CHG_ID","VARCHAR","20",null,"시스템변경아이디","sysChgId","#{entity.sysChgId}, ","sys_chg_id = #{entity.sysChgId},","A.sys_chg_id, ","@ApiModelProperty(value = \"시스템변경아이디\") private String sysChgId;",".sysChgId(entity.getSysChgId())"]

{"sheet":"쿼리결과","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["조회","SELECT A.dspt_mgnt_no, A.req_dt, A.req_tm, A.dpst_amt, A.dpst_dt, A.dpst_nm, A.rcv_acct_no, A.dpst_bnk_cd, A.dpst_st_cd, A.dpst_req_id, A.dpst_req_nm, A.dpst_auth_id, A.dpst_auth_nm, A.dpst_auth_dt, A.dpst_auth_tm, A.dspt_rjct_dt, A.dspt_rjct_tm, A.store_id, A.brand_id, A.dpst_auth_yn, A.dspt_rjct_rsn, DATE_FORMAT(A.sys_reg_dttm,'%Y.%m.%d %H:%i:%s') AS sys_reg_dttm, A.sys_reg_id, DATE_FORMAT(A.sys_chg_dttm,'%Y.%m.%d %H:%i:%s') AS sys_chg_dttm, A.sys_chg_id\nFROM loan_mgnt_dspt_proc A\nWHERE A.dspt_mgnt_no = #{entity.dsptMgntNo}"]
["등록","INSERT INTO loan_mgnt_dspt_proc\n(dspt_mgnt_no, req_dt, req_tm, dpst_amt, dpst_dt, dpst_nm, rcv_acct_no, dpst_bnk_cd, dpst_st_cd, dpst_req_id, dpst_req_nm, dpst_auth_id, dpst_auth_nm, dpst_auth_dt, dpst_auth_tm, dspt_rjct_dt, dspt_rjct_tm, store_id, brand_id, dpst_auth_yn, dspt_rjct_rsn, sys_reg_dttm, sys_reg_id, sys_chg_dttm, sys_chg_id)\nVALUES \n(#{entity.dsptMgntNo}, #{entity.reqDt}, #{entity.reqTm}, #{entity.dpstAmt}, #{entity.dpstDt}, #{entity.dpstNm}, #{entity.rcvAcctNo}, #{entity.dpstBnkCd}, #{entity.dpstStCd}, #{entity.dpstReqId}, #{entity.dpstReqNm}, #{entity.dpstAuthId}, #{entity.dpstAuthNm}, #{entity.dpstAuthDt}, #{entity.dpstAuthTm}, #{entity.dsptRjctDt}, #{entity.dsptRjctTm}, #{entity.storeId}, #{entity.brandId}, #{entity.dpstAuthYn}, #{entity.dsptRjctRsn}, NOW(), #{entity.sysRegId}, NOW(), #{entity.sysChgId})"]
["수정","UPDATE loan_mgnt_dspt_proc SET\ndspt_mgnt_no = #{entity.dsptMgntNo},\nreq_dt = #{entity.reqDt},\nreq_tm = #{entity.reqTm},\ndpst_amt = #{entity.dpstAmt},\ndpst_dt = #{entity.dpstDt},\ndpst_nm = #{entity.dpstNm},\nrcv_acct_no = #{entity.rcvAcctNo},\ndpst_bnk_cd = #{entity.dpstBnkCd},\ndpst_st_cd = #{entity.dpstStCd},\ndpst_req_id = #{entity.dpstReqId},\ndpst_req_nm = #{entity.dpstReqNm},\ndpst_auth_id = #{entity.dpstAuthId},\ndpst_auth_nm = #{entity.dpstAuthNm},\ndpst_auth_dt = #{entity.dpstAuthDt},\ndpst_auth_tm = #{entity.dpstAuthTm},\ndspt_rjct_dt = #{entity.dsptRjctDt},\ndspt_rjct_tm = #{entity.dsptRjctTm},\nstore_id = #{entity.storeId},\nbrand_id = #{entity.brandId},\ndpst_auth_yn = #{entity.dpstAuthYn},\ndspt_rjct_rsn = #{entity.dsptRjctRsn},\nsys_reg_dttm = NOW(),\nsys_reg_id = #{entity.sysRegId},\nsys_chg_dttm = NOW(),\nsys_chg_id = #{entity.sysChgId}\nWHERE dspt_mgnt_no = #{entity.dsptMgntNo}"]
["삭제","DELETE FROM loan_mgnt_dspt_proc\nWHERE dspt_mgnt_no = #{entity.dsptMgntNo}"]