{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["표지","개정이력","배치목록"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":9,"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":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,11,2,12],[3,11,3,12],[4,11,4,12]]}
[]
[]
[{"$nulls":10},"Version","V0.1"]
[{"$nulls":10},"개정일자","2021-05-24"]
[{"$nulls":10},"작성자","김덕규"]

{"sheet":"개정이력","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["개정 이력"]
["버전","개정일자","[1]개정사유","[2]개정내역","작성자","승인자"]
["0.1","2021-05-24","제정","최초 제정","김덕규","박중재"]
{"$rows_empty":23}
["[1] 개정 사유: 제정 또는 개정 내용이 이전 문서에 대해 추가/수정/삭제인지 선택 기입"]
["[2] 개정 내역: 개정이 발생하는 페이지 번호와 변경 내용을 기술"]

{"sheet":"배치목록","index":2,"n_rows":59,"n_cols":22,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,9,1,9],[0,10,0,15],[0,16,1,16],[0,8,1,8],[0,7,1,7],[0,2,0,6]]}
["No","배치명","배치ID(크론탭ID)",{"$nulls":4},"Controller Request Mapping","업무\n구분","발생\n빈도","크론 스케줄",{"$nulls":5},"비고"]
[null,null,"기존 명칭","대분류","중분류","소분류","FULL 배치ID",null,null,null,"초","분","시","일","월","연"]
[1,"상품 혜택 생성","cron.goods.benefit","goods","benefit","create",{"$f":"\"cron.\"&D3&\".\"&E3&\".\"&F3","v":"cron.goods.benefit.create"},{"$f":"\"/\"&D3&\"/\"&SUBSTITUTE(E3,\".\",\"/\")&\"/\"&F3","v":"/goods/benefit/create"},"상품","1회/시",0,35,"*","*","*","*",null,null,null,"cron.goods.benefit.create","상품 혜택 생성","/goods/benefit/create"]
[2,"상품 즉시할인가 생성","cron.goods.benefit.price","goods","benefit.price","create",{"$f":"\"cron.\"&D4&\".\"&E4&\".\"&F4","v":"cron.goods.benefit.price.create"},"/goods/benefit/price/create","상품","1회/시",0,30,"*","*","*","*",null,null,null,"cron.goods.benefit.price.create","상품 즉시할인가 생성","/goods/benefit/price/create"]
[3,"네이버EP 전체상품 생성","cron.naver.ep.all.goods","goods","ep.naver.all.goods","create","cron.goods.ep.naver.all.goods.create","/goods/ep/naver/all/goods/create","상품","1회/일",0,40,4,"*","*","*",null,null,null,"cron.goods.ep.naver.all.goods.create","네이버EP 전체상품 생성","/goods/ep/naver/all/goods/create"]
[4,"상품 예약타이틀명(세일링문구) 적용","cron.goods.titlename.reserve","goods","reserve.titlename","apply","cron.goods.reserve.titlename.apply",{"$f":"\"/\"&D6&\"/\"&SUBSTITUTE(E6,\".\",\"/\")&\"/\"&F6","v":"/goods/reserve/titlename/apply"},"상품","1회/시",0,1,"*","*","*","*",null,null,null,"cron.goods.reserve.titlename.apply","상품 예약타이틀명(세일링문구) 적용","/goods/reserve/titlename/apply"]
[5,"상품 예약가격 적용","cron.goods.price.reserve","goods","reserve.price","apply","cron.goods.reserve.price.apply","/goods/reserve/price/apply","상품","1회/시",0,35,"*","*","*","*",null,null,null,"cron.goods.reserve.price.apply","상품 예약가격 적용","/goods/reserve/price/apply"]
[6,"상품 연관상품 스코어링","cron.goods.relate.score","goods","relgoods","scoring","cron.goods.relgoods.scoring","/goods/relgoods/scoring","상품","1회/시",0,5,"*","*","*","*",null,null,null,"cron.goods.relgoods.scoring","상품 연관상품 스코어링","/goods/relgoods/scoring"]
[7,"상품 검색어 생성","cron.goods.search.keyword","goods","keyword","create","cron.goods.keyword.create","/goods/keyword/create","상품","1회/일",0,1,"*","*","*","*",null,null,null,"cron.goods.keyword.create","상품 검색어 생성","/goods/keyword/create"]
[8,"상품 요약정보 생성","cron.goods.summary","goods","summary","create","cron.goods.summary.create","/goods/summary/create","상품","1회/일",0,1,"*","*","*","*","주간판매수량 등",null,null,"cron.goods.summary.create","상품 요약정보 생성","/goods/summary/create"]
[9,"소셜상품의 가격 적용","cron.social.socialGoodsJob","goods","social.price","apply","cron.goods.social.price.apply","/goods/social/price/apply","상품","1회/시",0,0,2,"*","*","*",null,null,null,"cron.goods.social.price.apply","소셜상품의 가격 적용","/goods/social/price/apply"]
[10,"WMS 입고상품 수신","cron.goods.wms.incomelot","goods","wms.incomelot","receive","cron.goods.wms.incomelot.receive","/goods/wms/incomelot/receive","상품","1회/일",0,1,"*","*","*","*","전일자 기준 , p_dailyWarehousingInfo_inTB_IF_IncomeLot(02:30) 실행후 ",null,null,"cron.goods.wms.incomelot.receive","WMS 입고상품 수신","/goods/wms/incomelot/receive"]
[11,"WMS 상품재고 수신","cron.goods.wms.goods.stock","goods","wms.stock","receive","cron.goods.wms.stock.receive","/goods/wms/stock/receive","상품","1회/일",0,1,"*","*","*","*","cron.goods.shop.stock.receive 실행후 재고배치 실행",null,null,"cron.goods.wms.stock.receive","WMS 상품재고 수신","/goods/wms/stock/receive"]
[12,"ERP 매장재고 수신","cron.delivery.tsbShopGoodsStockJob","goods","shop.stock","receive",{"$f":"\"cron.\"&D14&\".\"&E14&\".\"&F14","v":"cron.goods.shop.stock.receive"},"/goods/shop/stock/receive","상품","1회/시",0,5,"*","*","*","*",null,null,null,"cron.goods.shop.stock.receive","ERP 매장재고 수신","/goods/shop/stock/receive"]
[13,"WMS 실측사이즈 수신","cron.goods.wms.measurement","goods","wms.measurement","receive","cron.goods.wms.measurement.receive","/goods/wms/measurement/receive","상품","1회/일",0,1,"*","*","*","*",null,null,null,"cron.goods.wms.measurement.receive","WMS 실측사이즈 수신","/goods/wms/measurement/receive"]
[14,"WMS 업체/브랜드 송신","cron.goods.wms.brandprovider","goods","wms.brandprovider","send","cron.goods.wms.brandprovider.send","/goods/wms/brandprovider/send","상품","1회/일",0,1,"*","*","*","*",null,null,null,"cron.goods.wms.brandprovider.send","WMS 업체/브랜드 송신","/goods/wms/brandprovider/send"]
[15,"WMS 상품정보 송신","cron.goods.wms.goods","goods","wms.goods","send","cron.goods.wms.goods.send","/goods/wms/goods/send","상품","1회/일",0,1,"*","*","*","*",null,null,null,"cron.goods.wms.goods.send","WMS 상품정보 송신","/goods/wms/goods/send"]
[null,null,null,"goods","search.all","create","cron.goods.search.all.create","/goods/search/all/create","상품","1회/일","0","0","2","*","*","*","얘저10분실행"]
[null,null,null,"goods","search.section","create","cron.goods.search.section.create","/goods/search/section/create","상품","1회/시","0","10","*","*","*","*","cron.goods.benefit.create\ncron.goods.benefit.price.create\ncron.goods.reserve.titlename.apply\ncron.goods.social.price.apply\ncron.goods.wms.stock.receive\n실행후"]
[16,"휴면예정회원 생성","cron.customer.dormant.schedule","customer","dormant","create","cron.customer.dormant.create","/customer/dormant/create","회원","1회/일","0","0","10","*","*","*",null,null,null,"cron.customer.dormant.create","휴면예정회원 생성","/customer/dormant/create"]
[17,"휴면회원 처리","cron.customer.dormant.transform","customer","dormant","transform","cron.customer.dormant.transform","/customer/dormant/transform","회원","1회/일","0","0","10","*","*","*",null,null,null,"cron.customer.dormant.transform","휴면회원 처리","/customer/dormant/transform"]
[18,"탈퇴회원 처리","cron.customer.secede.process","customer","secede","transform","cron.customer.secede.transform","/customer/secede/transform","회원","1회/일","0","0","10","*","*","*",null,null,null,"cron.customer.secede.transform","탈퇴회원 처리","/customer/secede/transform"]
[19,"개인정보이용내역안내","cron.customer.privacy.policy.notice","customer","privacy.info","notify","cron.customer.privacy.info.notify","/customer/privacy/info/notify","회원","1회/일","0","0","10","*","*","*","가입일로부터 1년 시점에 발송",null,null,"cron.customer.privacy.info.notify","개인정보이용내역안내","/customer/privacy/info/notify"]
[20,"마케팅정보수신동의안내","cron.customer.marketing.agreement.notice","customer","marketing.info","notify","cron.customer.marketing.info.notify","/customer/marketing/info/notify","회원","1회/일","0","0","10","*","*","*","마케팅정보수신동의자에 한해 발송\n가입일로부터 2년 시점에 발송",null,null,"cron.customer.marketing.info.notify","마케팅정보수신동의안내","/customer/marketing/info/notify"]
[21,"회원등급변경","cron.customer.grade.change","customer","grade","change","cron.customer.grade.change","/customer/grade/change","회원","1회/월","0","0","10","*","*","*",null,null,null,"cron.customer.grade.change","회원등급변경","/customer/grade/change"]
[22,"넷퍼시메일솔루션 회원정보 연동","cron.customer.netpathy.sync","customer","netpathy.mail","sync","cron.customer.netpathy.mail.sync","/customer/netpathy/mail/sync","회원","1회/월","0","0","10","*","*","*","넷퍼시메일솔루션용 회원정보 생성 -> 넷퍼시에서 해당 정보 수신 후 처리",null,null,"cron.customer.netpathy.mail.sync","넷퍼시메일솔루션 회원정보 연동","/customer/netpathy/mail/sync"]
[23,"자동구매확정","cron.marketing.auto.buy.confirm","customer","auto.buy","confirm","cron.customer.auto.buy.confirm","/customer/auto/buy/confirm","마케팅","1회/일",0,"30",1,"*","*","*","구매 예정포인트 지급",null,null,"cron.customer.auto.buy.confirm","자동구매확정","/customer/auto/buy/confirm"]
[24,"생일쿠폰 다운로드 안내","cron.marketing.birthday.coupon.notice","customer","birth.coupon","notify","cron.customer.birth.coupon.notify","/customer/birth/coupon/notify","마케팅","1회/월","0","10","5","1","*","*","당월 생일인 회원을 대상으로 매월 1일에 발송",null,null,"cron.customer.birth.coupon.notify","생일쿠폰 다운로드 안내","/customer/birth/coupon/notify"]
[25,"복귀할인쿠폰발급안내","cron.marketing.comback.coupon.notice","customer","comback.coupon","notify","cron.customer.comback.coupon.notify","/customer/comback/coupon/notify","마케팅","1회/월","0","20","5","5","*","*","매월 5일에 발송",null,null,"cron.customer.comback.coupon.notify","복귀할인쿠폰발급안내","/customer/comback/coupon/notify"]
[26,"포인트 소멸 처리","cron.marketing.expire.point","customer","point","expire","cron.customer.point.expire","/customer/point/expire","마케팅","1회/일",0,"30",1,"*","*","*",null,null,null,"cron.customer.point.expire","포인트 소멸 처리","/customer/point/expire"]
[27,"포인트 소멸예정 안내","cron.marketing.expect.point","customer","point.expect","notify",{"$f":"\"cron.\"&D31&\".\"&E31&\".\"&F31","v":"cron.customer.point.expect.notify"},{"$f":"\"/\"&D31&\"/\"&SUBSTITUTE(E31,\".\",\"/\")&\"/\"&F31","v":"/customer/point/expect/notify"},"마케팅","1회/일",0,"0","10","*","*","*","시간…?",null,null,"cron.customer.point.expect.notify","포인트 소멸 예정 안내","/customer/point/expect/notify"]
[28,"상품권 소멸 처리","cron.marketing.expire.giftcard","customer","giftcard","expire",{"$f":"\"cron.\"&D32&\".\"&E32&\".\"&F32","v":"cron.customer.giftcard.expire"},{"$f":"\"/\"&D32&\"/\"&SUBSTITUTE(E32,\".\",\"/\")&\"/\"&F32","v":"/customer/giftcard/expire"},"마케팅","1회/일",0,"30",1,"*","*","*",null,null,null,"cron.customer.giftcard.expire","상품권 소멸 처리","/customer/giftcard/expire"]
[29,"상품권 소멸예정 안내","cron.marketing.expect.giftcard","customer","giftcard.expect","notify",{"$f":"\"cron.\"&D33&\".\"&E33&\".\"&F33","v":"cron.customer.giftcard.expect.notify"},"/customer/giftcard/expect/notify","마케팅","1회/일",0,"0","10","*","*","*","시간…?",null,null,"cron.customer.giftcard.expect.notify","상품권 소멸 예정 안내","/customer/giftcard/expect/notify"]
[30,"쿠폰 소멸예정 안내","cron.marketing.expect.coupon","customer","coupon.expect","notify",{"$f":"\"cron.\"&D34&\".\"&E34&\".\"&F34","v":"cron.customer.coupon.expect.notify"},{"$f":"\"/\"&D34&\"/\"&SUBSTITUTE(E34,\".\",\"/\")&\"/\"&F34","v":"/customer/coupon/expect/notify"},"마케팅","1회/일",0,"0","10","*","*","*","시간…?",null,null,"cron.customer.coupon.expect.notify","쿠폰 소멸 예정 안내","/customer/coupon/expect/notify"]
[31,"상품평등록안내 발송","cron.marketing.review.guide","customer","review.register","notify","cron.customer.review.register.notify","/customer/review/register/notify","마케팅","1회/일","0","20","5","5","*","*",null,null,null,"cron.customer.review.register.notify","상품평등록안내 발송","/customer/review/register/notify"]
[32,"카테고리 갱신","cron.display.category.refresh","display","category","refresh","cron.display.category.refresh","/display/category/refresh","전시","1회/시",0,"30",1,"*","*","*",null,null,null,"cron.display.category.refresh","카테고리 갱신","/display/category/refresh"]
[33,"카테고리별 재고 생성","cron.display.category.stock","display","category.stock","create","cron.display.category.stock.create","/display/category/stock/create","전시","1회/시","0","5/10","*","*","*","*",null,null,null,"cron.display.category.stock.create","카테고리별 재고 생성","/display/category/stock/create"]
[34,"카테고리별 검색필터 생성","cron.display.category.filter","display","category.filter","create","cron.display.category.filter.create","/display/category/filter/create","전시","1회/시","0","45","*","*","*","*",null,null,null,"cron.display.category.filter.create","카테고리별 검색필터 생성","/display/category/filter/create"]
[35,"만료기간 지난 장바구니 삭제","cron.marketing.cart.expiration","order","cart.deadline","expire","cron.order.cart.deadline.expire","/order/cart/deadline/expire","주문","1회/일","0","10","5","1","*","*",null,null,null,"cron.order.cart.deadline.expire","만료기간 지난 장바구니 삭제","/order/cart/deadline/expire"]
[36,"무통장(가상계좌) 입금대기 알림","job.shop.WbaDepositWatingNotiJob","order","deposit.waiting","notify","cron.order.deposit.waiting.notify","/order/deposit/waiting/notify","주문","1회/일","0","0","15","*","*","*",null,null,null,"cron.order.deposit.waiting.notify","무통장(가상계좌) 입금대기 알림","/order/deposit/waiting/notify"]
[37,"무통장결제 입금기한 만료건 주문 취소","cron.order.deposit.expiration","order","deposit.deadline","expire","cron.order.deposit.deadline.expire",{"$f":"\"/\"&D41&\"/\"&SUBSTITUTE(E41,\".\",\"/\")&\"/\"&F41","v":"/order/deposit/deadline/expire"},"주문","1회/시",0,"30",1,"*","*","*",null,null,null,"cron.order.deposit.deadline.expire","무통장결제 입금기한 만료건 주문 취소","/order/deposit/deadline/expire"]
[38,"선물하기 배송지 등록기한 만료건 주문 취소","cron.order.gift.expiration","order","gift.deadline","expire","cron.order.gift.deadline.expire","/order/gift/deadline/expire","주문","1회/시","0","10","5","1","*","*",null,null,null,"cron.order.gift.deadline.expire","선물하기 배송지 등록기한 만료건 주문 취소","/order/gift/deadline/expire"]
[39,"KCP PG 정산 데이터 수신","cron.pg.kcp.settle.receive","order","pg.kcp.settle","receive","cron.order.pg.kcp.settle.receive","/order/pg/kcp/settle/receive","주문","1회/일","0","0","3","*","*","*",null,null,null,"cron.order.pg.kcp.settle.receive","KCP PG 정산 데이터 수신","/order/pg/kcp/settle/receive"]
[40,"네이버페이 주문형 약 10가지","cron.pg.naverpay.","order","pg.naverpay…",null,"cron.order.pg.naverpay….","/order/pg/naverpay…/","주문","1회/분","0","0","3","*","*","*","20분 배치",null,null,"cron.delivery.shot.deliveryzone.refresh","총알배송 권역정보 갱신","/delivery/shot/deliveryzone/refresh"]
[41,"총알배송 권역정보 갱신","cron.delivery.tsbDailyDeliveryZoneJob","delivery","shot.deliveryzone","refresh","cron.delivery.shot.deliveryzone.refresh","/delivery/shot/deliveryzone/refresh","배송","1회/일",0,0,"11","*","*","*",null,null,null,"cron.delivery.loc.assign","출고처 지정 및 출고 지시","/delivery/loc/assign"]
[42,"출고처 지정 및 출고 지시","cron.delivery.tsbDeliveryOrderJob","delivery","loc","assign","cron.delivery.loc.assign","/delivery/loc/assign","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.delivery.wms.outgoing.exception.receive","WMS 출고예외 수신","/delivery/wms/outgoing/exception/receive"]
[43,"WMS 출고예외 수신","cron.delivery.tsbDeliveryExcRcvJob","delivery","wms.outgoing.exception","receive","cron.delivery.wms.outgoing.exception.receive","/delivery/wms/outgoing/exception/receive","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.delivery.wms.outgoing.result.receive","WMS 출고결과 수신","/delivery/wms/outgoing/result/receive"]
[44,"WMS 출고결과 수신","cron.delivery.tsbDeliveryOrderRsltJob","delivery","wms.outgoing.result","receive","cron.delivery.wms.outgoing.result.receive","/delivery/wms/outgoing/result/receive","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.delivery.wms.invoice.receive","WMS 운송장번호 수신","/delivery/wms/invoice/receive"]
[45,"WMS 운송장번호 수신","cron.delivery.tsbInvoiceNoRcvJob","delivery","wms.invoice","receive","cron.delivery.wms.invoice.receive","/delivery/wms/invoice/receive","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.delivery.sweettracker.invoice.retrieve","스윗트래커 송장상태 조회","/delivery/sweettracker/invoice/retrieve"]
[46,"스윗트래커 송장상태 조회","cron.delivery.tsbSweetTrackerJob","delivery","sweettracker.invoice","retrieve","cron.delivery.sweettracker.invoice.retrieve","/delivery/sweettracker/invoice/retrieve","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.delivery.auto.soldout.cancel","자동품절취소","/delivery/auto/soldout/cancel"]
[47,"자동품절취소","cron.delivery.tsbSoldoutCancelJob","delivery","auto.soldout","cancel","cron.delivery.auto.soldout.cancel","/delivery/auto/soldout/cancel","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.withdraw.wms.request","WMS 회수요청","/withdraw/wms/request"]
[48,"WMS 회수요청","cron.delivery.tsbWithdrawRequestJob","withdraw","wms","request",{"$f":"\"cron.\"&D52&\".\"&E52&\".\"&F52","v":"cron.withdraw.wms.request"},{"$f":"\"/\"&D52&\"/\"&SUBSTITUTE(E52,\".\",\"/\")&\"/\"&F52","v":"/withdraw/wms/request"},"배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.withdraw.wms.ingoing.exception.receive","WMS 회수입고예외 수신","/withdraw/wms/ingoing/exception/receive"]
[49,"WMS 회수입고예외 수신","cron.delivery.tsbWithdrawExcRcvJob","withdraw","wms.ingoing.exception","receive","cron.withdraw.wms.ingoing.exception.receive","/withdraw/wms/ingoing/exception/receive","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.withdraw.wms.ingoing.exception.result.receive","WMS 회수입고예외 결과 수신","/withdraw/wms/ingoing/exception/result/receive"]
[50,"WMS 회수입고예외 결과 수신","cron.delivery.tsbWithdrawExcRsltJob","withdraw","wms.ingoing.exception.result","receive","cron.withdraw.wms.ingoing.exception.result.receive","/withdraw/wms/ingoing/exception/result/receive","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.withdraw.wms.ingoing.result.receive","WMS 회수입고결과 수신","/withdraw/wms/ingoing/result/receive"]
[51,"WMS 회수입고결과 수신","cron.delivery.tsbWithdrawRsltJob","withdraw","wms.ingoing.result","receive","cron.withdraw.wms.ingoing.result.receive","/withdraw/wms/ingoing/result/receive","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.withdraw.cj.invoice.receive","CJ 회수송장번호 수신","/withdraw/cj/invoice/receive"]
[52,"CJ 회수송장번호 수신","cron.delivery.tsbWithdrawInvoiceJob","withdraw","cj.invoice","receive","cron.withdraw.cj.invoice.receive","/withdraw/cj/invoice/receive","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.withdraw.cj.status.receive","CJ 회수상태 수신","/withdraw/cj/status/receive"]
[53,"CJ 회수상태 수신","cron.delivery.tsbWithdrawInvoiceStatJob","withdraw","cj.status","receive","cron.withdraw.cj.status.receive","/withdraw/cj/status/receive","배송","1회/시",0,5,1,"*","*","*",null,null,null,"cron.statistics.aflink.inflow.create","제휴채널 유입통계 생성","/statistics/aflink/inflow/create"]
[54,"제휴채널 유입통계 생성","cron.statistics.inflow","statistics","aflink.inflow","create","cron.statistics.aflink.inflow.create","/statistics/aflink/inflow/create","통계","1회/시",0,5,1,"*","*","*",null,null,null,"cron.statistics.aflink.inflow.yesterday.create","제휴채널 유입통계 전일자 생성","/statistics/aflink/inflow/yesterday/create"]
[55,"제휴채널 유입통계 전일자 생성","cron.statistics.inflow.yesterday","statistics","aflink.inflow.yesterday","create","cron.statistics.aflink.inflow.yesterday.create","/statistics/aflink/inflow/yesterday/create","통계","1회/일",0,5,1,"*","*","*"]