{"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,"테이블명","stl_mgnt_dtl_ptcl"]

{"sheet":"칼럼결과","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["칼럼","데이터유형","길이","PK","코멘트","CAMEL 표기","쿼리 INSERT","쿼리 UPDATE","쿼리 SELECT","JAVA 변수","BUILDER"]
["STTL_MGNT_UNQ_NO","VARCHAR","40","PK","정산관리고유번호","sttlMgntUnqNo","#{entity.sttlMgntUnqNo}, ","sttl_mgnt_unq_no = #{entity.sttlMgntUnqNo},","A.sttl_mgnt_unq_no, ","@ApiModelProperty(value = \"정산관리고유번호\") private String sttlMgntUnqNo;",".sttlMgntUnqNo(entity.getSttlMgntUnqNo())"]
["STTL_MGNT_DTL_NO","VARCHAR","10","PK","정산관리상세번호","sttlMgntDtlNo","#{entity.sttlMgntDtlNo}, ","sttl_mgnt_dtl_no = #{entity.sttlMgntDtlNo},","A.sttl_mgnt_dtl_no, ","@ApiModelProperty(value = \"정산관리상세번호\") private String sttlMgntDtlNo;",".sttlMgntDtlNo(entity.getSttlMgntDtlNo())"]
["BRAND_ID","VARCHAR","20",null,"브랜드아이디","brandId","#{entity.brandId}, ","brand_id = #{entity.brandId},","A.brand_id, ","@ApiModelProperty(value = \"브랜드아이디\") private String brandId;",".brandId(entity.getBrandId())"]
["WHS_MGNT_UNQ_NO","VARCHAR","40",null,"입고관리고유번호","whsMgntUnqNo","#{entity.whsMgntUnqNo}, ","whs_mgnt_unq_no = #{entity.whsMgntUnqNo},","A.whs_mgnt_unq_no, ","@ApiModelProperty(value = \"입고관리고유번호\") private String whsMgntUnqNo;",".whsMgntUnqNo(entity.getWhsMgntUnqNo())"]
["RTN_MGNT_UNQ_NO","VARCHAR","40",null,"반품관리고유번호","rtnMgntUnqNo","#{entity.rtnMgntUnqNo}, ","rtn_mgnt_unq_no = #{entity.rtnMgntUnqNo},","A.rtn_mgnt_unq_no, ","@ApiModelProperty(value = \"반품관리고유번호\") private String rtnMgntUnqNo;",".rtnMgntUnqNo(entity.getRtnMgntUnqNo())"]
["STORE_ID","VARCHAR","20",null,"매장아이디","storeId","#{entity.storeId}, ","store_id = #{entity.storeId},","A.store_id, ","@ApiModelProperty(value = \"매장아이디\") private String storeId;",".storeId(entity.getStoreId())"]
["ITEM_ID","VARCHAR","40",null,"품목아이디","itemId","#{entity.itemId}, ","item_id = #{entity.itemId},","A.item_id, ","@ApiModelProperty(value = \"품목아이디\") private String itemId;",".itemId(entity.getItemId())"]
["ITEM_NM","VARCHAR","100",null,"품목명","itemNm","#{entity.itemNm}, ","item_nm = #{entity.itemNm},","A.item_nm, ","@ApiModelProperty(value = \"품목명\") private String itemNm;",".itemNm(entity.getItemNm())"]
["UNIT","VARCHAR","20",null,"단위","unit","#{entity.unit}, ","unit = #{entity.unit},","A.unit, ","@ApiModelProperty(value = \"단위\") private String unit;",".unit(entity.getUnit())"]
["UNIT_AMT","BIGINT","20",null,"단가금액","unitAmt","#{entity.unitAmt}, ","unit_amt = #{entity.unitAmt},","A.unit_amt, ","@ApiModelProperty(value = \"단가금액\") private String unitAmt;",".unitAmt(entity.getUnitAmt())"]
["PODR_QTY","INT","11",null,"발주수량","podrQty","#{entity.podrQty}, ","podr_qty = #{entity.podrQty},","A.podr_qty, ","@ApiModelProperty(value = \"발주수량\") private String podrQty;",".podrQty(entity.getPodrQty())"]
["DLV_QTY","INT","11",null,"납품수량","dlvQty","#{entity.dlvQty}, ","dlv_qty = #{entity.dlvQty},","A.dlv_qty, ","@ApiModelProperty(value = \"납품수량\") private String dlvQty;",".dlvQty(entity.getDlvQty())"]
["WHS_QTY","INT","11",null,"입고수량","whsQty","#{entity.whsQty}, ","whs_qty = #{entity.whsQty},","A.whs_qty, ","@ApiModelProperty(value = \"입고수량\") private String whsQty;",".whsQty(entity.getWhsQty())"]
["COL_QTY","INT","11",null,"수거수량","colQty","#{entity.colQty}, ","col_qty = #{entity.colQty},","A.col_qty, ","@ApiModelProperty(value = \"수거수량\") private String colQty;",".colQty(entity.getColQty())"]
["DLV_CMPLT_DT","VARCHAR","8",null,"납품완료일자","dlvCmpltDt","#{entity.dlvCmpltDt}, ","dlv_cmplt_dt = #{entity.dlvCmpltDt},","A.dlv_cmplt_dt, ","@ApiModelProperty(value = \"납품완료일자\") private String dlvCmpltDt;",".dlvCmpltDt(entity.getDlvCmpltDt())"]
["COL_DT","VARCHAR","8",null,"수거일자","colDt","#{entity.colDt}, ","col_dt = #{entity.colDt},","A.col_dt, ","@ApiModelProperty(value = \"수거일자\") private String colDt;",".colDt(entity.getColDt())"]
["WHS_AMT","BIGINT","20",null,"입고금액","whsAmt","#{entity.whsAmt}, ","whs_amt = #{entity.whsAmt},","A.whs_amt, ","@ApiModelProperty(value = \"입고금액\") private String whsAmt;",".whsAmt(entity.getWhsAmt())"]
["COL_AMT","BIGINT","20",null,"수거금액","colAmt","#{entity.colAmt}, ","col_amt = #{entity.colAmt},","A.col_amt, ","@ApiModelProperty(value = \"수거금액\") private String colAmt;",".colAmt(entity.getColAmt())"]
["STTL_DVSN","VARCHAR","4",null,"정산구분","sttlDvsn","#{entity.sttlDvsn}, ","sttl_dvsn = #{entity.sttlDvsn},","A.sttl_dvsn, ","@ApiModelProperty(value = \"정산구분\") private String sttlDvsn;",".sttlDvsn(entity.getSttlDvsn())"]
["PCH_PODR_UNQ_NO","VARCHAR","40",null,"구매발주고유번호","pchPodrUnqNo","#{entity.pchPodrUnqNo}, ","pch_podr_unq_no = #{entity.pchPodrUnqNo},","A.pch_podr_unq_no, ","@ApiModelProperty(value = \"구매발주고유번호\") private String pchPodrUnqNo;",".pchPodrUnqNo(entity.getPchPodrUnqNo())"]
["PCH_PODR_DTL_NO","VARCHAR","10",null,"구매발주상세번호","pchPodrDtlNo","#{entity.pchPodrDtlNo}, ","pch_podr_dtl_no = #{entity.pchPodrDtlNo},","A.pch_podr_dtl_no, ","@ApiModelProperty(value = \"구매발주상세번호\") private String pchPodrDtlNo;",".pchPodrDtlNo(entity.getPchPodrDtlNo())"]
["PCH_REQ_UNQ_NO","VARCHAR","40",null,"구매요청고유번호","pchReqUnqNo","#{entity.pchReqUnqNo}, ","pch_req_unq_no = #{entity.pchReqUnqNo},","A.pch_req_unq_no, ","@ApiModelProperty(value = \"구매요청고유번호\") private String pchReqUnqNo;",".pchReqUnqNo(entity.getPchReqUnqNo())"]
["PCH_REQ_DTL_NO","VARCHAR","10",null,"구매요청상세번호","pchReqDtlNo","#{entity.pchReqDtlNo}, ","pch_req_dtl_no = #{entity.pchReqDtlNo},","A.pch_req_dtl_no, ","@ApiModelProperty(value = \"구매요청상세번호\") private String pchReqDtlNo;",".pchReqDtlNo(entity.getPchReqDtlNo())"]
["RTN_PODR_UNQ_NO","VARCHAR","40",null,"반품발주고유번호","rtnPodrUnqNo","#{entity.rtnPodrUnqNo}, ","rtn_podr_unq_no = #{entity.rtnPodrUnqNo},","A.rtn_podr_unq_no, ","@ApiModelProperty(value = \"반품발주고유번호\") private String rtnPodrUnqNo;",".rtnPodrUnqNo(entity.getRtnPodrUnqNo())"]
["RTN_PODR_DTL_NO","VARCHAR","10",null,"반품발주상세번호","rtnPodrDtlNo","#{entity.rtnPodrDtlNo}, ","rtn_podr_dtl_no = #{entity.rtnPodrDtlNo},","A.rtn_podr_dtl_no, ","@ApiModelProperty(value = \"반품발주상세번호\") private String rtnPodrDtlNo;",".rtnPodrDtlNo(entity.getRtnPodrDtlNo())"]
["RTN_REQ_UNQ_NO","VARCHAR","40",null,"반품요청고유번호","rtnReqUnqNo","#{entity.rtnReqUnqNo}, ","rtn_req_unq_no = #{entity.rtnReqUnqNo},","A.rtn_req_unq_no, ","@ApiModelProperty(value = \"반품요청고유번호\") private String rtnReqUnqNo;",".rtnReqUnqNo(entity.getRtnReqUnqNo())"]
["RTN_REQ_DTL_NO","VARCHAR","10",null,"반품요청상세번호","rtnReqDtlNo","#{entity.rtnReqDtlNo}, ","rtn_req_dtl_no = #{entity.rtnReqDtlNo},","A.rtn_req_dtl_no, ","@ApiModelProperty(value = \"반품요청상세번호\") private String rtnReqDtlNo;",".rtnReqDtlNo(entity.getRtnReqDtlNo())"]
["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.sttl_mgnt_unq_no, A.sttl_mgnt_dtl_no, A.brand_id, A.whs_mgnt_unq_no, A.rtn_mgnt_unq_no, A.store_id, A.item_id, A.item_nm, A.unit, A.unit_amt, A.podr_qty, A.dlv_qty, A.whs_qty, A.col_qty, A.dlv_cmplt_dt, A.col_dt, A.whs_amt, A.col_amt, A.sttl_dvsn, A.pch_podr_unq_no, A.pch_podr_dtl_no, A.pch_req_unq_no, A.pch_req_dtl_no, A.rtn_podr_unq_no, A.rtn_podr_dtl_no, A.rtn_req_unq_no, A.rtn_req_dtl_no, 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 stl_mgnt_dtl_ptcl A\nWHERE A.sttl_mgnt_unq_no = #{entity.sttlMgntUnqNo}\nAND A.sttl_mgnt_dtl_no = #{entity.sttlMgntDtlNo}"]
["등록","INSERT INTO stl_mgnt_dtl_ptcl\n(sttl_mgnt_unq_no, sttl_mgnt_dtl_no, brand_id, whs_mgnt_unq_no, rtn_mgnt_unq_no, store_id, item_id, item_nm, unit, unit_amt, podr_qty, dlv_qty, whs_qty, col_qty, dlv_cmplt_dt, col_dt, whs_amt, col_amt, sttl_dvsn, pch_podr_unq_no, pch_podr_dtl_no, pch_req_unq_no, pch_req_dtl_no, rtn_podr_unq_no, rtn_podr_dtl_no, rtn_req_unq_no, rtn_req_dtl_no, sys_reg_dttm, sys_reg_id, sys_chg_dttm, sys_chg_id)\nVALUES \n(#{entity.sttlMgntUnqNo}, #{entity.sttlMgntDtlNo}, #{entity.brandId}, #{entity.whsMgntUnqNo}, #{entity.rtnMgntUnqNo}, #{entity.storeId}, #{entity.itemId}, #{entity.itemNm}, #{entity.unit}, #{entity.unitAmt}, #{entity.podrQty}, #{entity.dlvQty}, #{entity.whsQty}, #{entity.colQty}, #{entity.dlvCmpltDt}, #{entity.colDt}, #{entity.whsAmt}, #{entity.colAmt}, #{entity.sttlDvsn}, #{entity.pchPodrUnqNo}, #{entity.pchPodrDtlNo}, #{entity.pchReqUnqNo}, #{entity.pchReqDtlNo}, #{entity.rtnPodrUnqNo}, #{entity.rtnPodrDtlNo}, #{entity.rtnReqUnqNo}, #{entity.rtnReqDtlNo}, NOW(), #{entity.sysRegId}, NOW(), #{entity.sysChgId})"]
["수정","UPDATE stl_mgnt_dtl_ptcl SET\nsttl_mgnt_unq_no = #{entity.sttlMgntUnqNo},\nsttl_mgnt_dtl_no = #{entity.sttlMgntDtlNo},\nbrand_id = #{entity.brandId},\nwhs_mgnt_unq_no = #{entity.whsMgntUnqNo},\nrtn_mgnt_unq_no = #{entity.rtnMgntUnqNo},\nstore_id = #{entity.storeId},\nitem_id = #{entity.itemId},\nitem_nm = #{entity.itemNm},\nunit = #{entity.unit},\nunit_amt = #{entity.unitAmt},\npodr_qty = #{entity.podrQty},\ndlv_qty = #{entity.dlvQty},\nwhs_qty = #{entity.whsQty},\ncol_qty = #{entity.colQty},\ndlv_cmplt_dt = #{entity.dlvCmpltDt},\ncol_dt = #{entity.colDt},\nwhs_amt = #{entity.whsAmt},\ncol_amt = #{entity.colAmt},\nsttl_dvsn = #{entity.sttlDvsn},\npch_podr_unq_no = #{entity.pchPodrUnqNo},\npch_podr_dtl_no = #{entity.pchPodrDtlNo},\npch_req_unq_no = #{entity.pchReqUnqNo},\npch_req_dtl_no = #{entity.pchReqDtlNo},\nrtn_podr_unq_no = #{entity.rtnPodrUnqNo},\nrtn_podr_dtl_no = #{entity.rtnPodrDtlNo},\nrtn_req_unq_no = #{entity.rtnReqUnqNo},\nrtn_req_dtl_no = #{entity.rtnReqDtlNo},\nsys_reg_dttm = NOW(),\nsys_reg_id = #{entity.sysRegId},\nsys_chg_dttm = NOW(),\nsys_chg_id = #{entity.sysChgId}\nWHERE sttl_mgnt_unq_no = #{entity.sttlMgntUnqNo}\nAND sttl_mgnt_dtl_no = #{entity.sttlMgntDtlNo}"]
["삭제","DELETE FROM stl_mgnt_dtl_ptcl\nWHERE sttl_mgnt_unq_no = #{entity.sttlMgntUnqNo}\nAND sttl_mgnt_dtl_no = #{entity.sttlMgntDtlNo}"]