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

{"sheet":"칼럼결과","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["칼럼","데이터유형","길이","PK","코멘트","CAMEL 표기","쿼리 INSERT","쿼리 UPDATE","쿼리 SELECT","JAVA 변수","BUILDER"]
["STCK_MGNT_DTL_NO","VARCHAR","10","PK","재고관리상세번호","stckMgntDtlNo","#{entity.stckMgntDtlNo}, ","stck_mgnt_dtl_no = #{entity.stckMgntDtlNo},","A.stck_mgnt_dtl_no, ","@ApiModelProperty(value = \"재고관리상세번호\") private String stckMgntDtlNo;",".stckMgntDtlNo(entity.getStckMgntDtlNo())"]
["BRAND_ID","VARCHAR","20","PK","브랜드아이디","brandId","#{entity.brandId}, ","brand_id = #{entity.brandId},","A.brand_id, ","@ApiModelProperty(value = \"브랜드아이디\") private String brandId;",".brandId(entity.getBrandId())"]
["WHS_ID","VARCHAR","20","PK","창고아이디","whsId","#{entity.whsId}, ","whs_id = #{entity.whsId},","A.whs_id, ","@ApiModelProperty(value = \"창고아이디\") private String whsId;",".whsId(entity.getWhsId())"]
["LOCATION","VARCHAR","4","PK","LOCATION","location","#{entity.location}, ","location = #{entity.location},","A.location, ","@ApiModelProperty(value = \"LOCATION\") private String location;",".location(entity.getLocation())"]
["ITEM_ID","VARCHAR","10","PK","품목아이디","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())"]
["INOUT_CD","VARCHAR","10",null,"입출고구분","inoutCd","#{entity.inoutCd}, ","inout_cd = #{entity.inoutCd},","A.inout_cd, ","@ApiModelProperty(value = \"입출고구분\") private String inoutCd;",".inoutCd(entity.getInoutCd())"]
["INOUT_QTY","INT","11",null,"입출고수량","inoutQty","#{entity.inoutQty}, ","inout_qty = #{entity.inoutQty},","A.inout_qty, ","@ApiModelProperty(value = \"입출고수량\") private String inoutQty;",".inoutQty(entity.getInoutQty())"]
["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())"]
["CHG_DVSN","VARCHAR","4",null,"변경구분(재고이동/구매입고/반품입고/구매출고/반품출고/판매출고/재고실사)","chgDvsn","#{entity.chgDvsn}, ","chg_dvsn = #{entity.chgDvsn},","A.chg_dvsn, ","@ApiModelProperty(value = \"변경구분(재고이동/구매입고/반품입고/구매출고/반품출고/판매출고/재고실사)\") private String chgDvsn;",".chgDvsn(entity.getChgDvsn())"]
["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.stck_mgnt_dtl_no, A.brand_id, A.whs_id, A.location, A.item_id, A.item_nm, A.inout_cd, A.inout_qty, A.whs_mgnt_unq_no, A.rtn_mgnt_unq_no, A.chg_dvsn, 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 stck_mgnt_dtl_hist A\nWHERE A.stck_mgnt_dtl_no = #{entity.stckMgntDtlNo}\nAND A.brand_id = #{entity.brandId}\nAND A.whs_id = #{entity.whsId}\nAND A.location = #{entity.location}\nAND A.item_id = #{entity.itemId}"]
["등록","INSERT INTO stck_mgnt_dtl_hist\n(stck_mgnt_dtl_no, brand_id, whs_id, location, item_id, item_nm, inout_cd, inout_qty, whs_mgnt_unq_no, rtn_mgnt_unq_no, chg_dvsn, sys_reg_dttm, sys_reg_id, sys_chg_dttm, sys_chg_id)\nVALUES \n(#{entity.stckMgntDtlNo}, #{entity.brandId}, #{entity.whsId}, #{entity.location}, #{entity.itemId}, #{entity.itemNm}, #{entity.inoutCd}, #{entity.inoutQty}, #{entity.whsMgntUnqNo}, #{entity.rtnMgntUnqNo}, #{entity.chgDvsn}, NOW(), #{entity.sysRegId}, NOW(), #{entity.sysChgId})"]
["수정","UPDATE stck_mgnt_dtl_hist SET\nstck_mgnt_dtl_no = #{entity.stckMgntDtlNo},\nbrand_id = #{entity.brandId},\nwhs_id = #{entity.whsId},\nlocation = #{entity.location},\nitem_id = #{entity.itemId},\nitem_nm = #{entity.itemNm},\ninout_cd = #{entity.inoutCd},\ninout_qty = #{entity.inoutQty},\nwhs_mgnt_unq_no = #{entity.whsMgntUnqNo},\nrtn_mgnt_unq_no = #{entity.rtnMgntUnqNo},\nchg_dvsn = #{entity.chgDvsn},\nsys_reg_dttm = NOW(),\nsys_reg_id = #{entity.sysRegId},\nsys_chg_dttm = NOW(),\nsys_chg_id = #{entity.sysChgId}\nWHERE stck_mgnt_dtl_no = #{entity.stckMgntDtlNo}\nAND brand_id = #{entity.brandId}\nAND whs_id = #{entity.whsId}\nAND location = #{entity.location}\nAND item_id = #{entity.itemId}"]
["삭제","DELETE FROM stck_mgnt_dtl_hist\nWHERE stck_mgnt_dtl_no = #{entity.stckMgntDtlNo}\nAND brand_id = #{entity.brandId}\nAND whs_id = #{entity.whsId}\nAND location = #{entity.location}\nAND item_id = #{entity.itemId}"]