{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["목록","출고_교환_프로세스","WMS_IF TABLE"],"not_rendered":{"charts":0,"images":4,"macros":0,"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":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,16,1],[17,1,24,1]]}
[]
[]
["No.","구분","명칭","job/ html","비고"]
[1,"배치","총알배송 권역정보","TsbDailyDeliveryZoneJob.java"]
[2,null,"출고처지정 및 배송(출고)지시","TsbDeliveryOrderJob.java","수행후 [상품준비중] 변경"]
[3,null,"WMS 출고예외 수신(재고없음)","TsbDeliveryExcRcvJob.java","수행후 [품절대상]"]
[4,null,"WMS 송장번호 수신","TsbInvoiceNoRcvJob.java","수행후 [배송준비중] 변경"]
[5,null,"WMS 출고결과 수신","TsbDeliveryOrderRsltJob.java","수행후 [배송중] 변경"]
[6,null,"스윗트래커  배송 추적 요청","TsbSweetTrackerJob.java"]
[7,null,"자동품절취소","TsbSoldoutCancelJob.java","18-22 시간배치"]
[8,null,"WMS 회수요청","TsbWithdrawRequestJob.java","wms_if DB에 적제  WMS_IF DB 상태값 '입고대기'"]
[9,null,"CJ 회수송장번호 수신","TsbCjWithdrawInvoiceJob.java","CJ DB  회수송장번호 수신,  cj회수송장 상태값은  회수지시목록 cj회수상태 항목에서 확인가능 \ndata는 tb_order_change 에 등록 "]
[10,null,"CJ 회수상태 수신","TsbCjWithdrawInvoiceStatJob.java","사용안함, CJ 회수송장번호 수신 에 포함."]
[11,null,"WMS 회수입고예외 수신","TsbWithdrawExcRcvJob.java","예외케이스중 예외사유코드(08.10) 확정전 품절,불량 일경우 품절대상 "]
[12,null,"WMS 회수입고예외결과 송신","TsbWithdrawExcRsltJob.java","사용안함, 화면에서 제어하기로함."]
[13,null,"WMS 회수입고결과 수신","TsbWithdrawRsltJob.java","교환일경우  원주문취소, 교환품 출고 /  반품일경우  환불컨펌대상"]
[14,null,"매장상품재고 수신","TsbShopGoodsStockJob.java","한세드림,MK 매장상품재고 API 이용 tb_shop_goods_stock -- 현재 사용중지"]
[15,"화면\n(BOS)","배송목록","DeliveryListForm.html","자사상품기준, 자사몰,제휴몰   수동 송장번호 변경기능, 배송완료 기능 "]
[16,null,"출고금지상품관리","BangoodsListForm.html","출고금지상품 조회및 수동 등록 , 매장POS 화면에서 거부시 자동등록 "]
[17,null,"출고처지정관리","AssignListForm.html","수동으로 출고처지정 및 취소 (매장에 출고금지상품등록된 내역 상관없음)"]
[18,null,"회수지시목록","WithdrawDirectiveListForm.html","BOS 기준 교환,반품 신청건에 대한 내역 조회 (회수송장번호 확인 및 CJ회수상태 확인가능)"]
[19,null,"wms회수목록","WmsWithdrawListForm.html","WMS_IF DB 기준 회수요청 내역을 확인  wms_if  db 상태항목에서  입고대기, 입고완료 확인가능\n입고대기 - bos에서 wms_if  db 등록시 입고대기 로 등록함.\n입고완료 - wms(물류) 에서 상품검수 후 정상적인경우  입고완료로 변경(wms내부로직 수행후)\n"]
[20,null,"wms회수예외관리","WithdrawExceptionListForm.html","회수상품이 입고 되었을때 상품검수중 예외사항이 발생되면 "]
[21,null,"환불관리","RefundRegisterListForm.html","반품에대한 환불컨펌"]
[22,null,"배송목록(입점)","DeliveryListScmForm.html","배송목록 (입점상품기준)  입점업체 팝업 확인 필요!  -- 배포전임. \n\nTsaBusinessDao.java\nTsaDeliveryDao.java\nTsaBusinessService.java\nTsaDeliveryService.java\nTsaBusinessController.java\nTsaDeliveryController.java\nDelivery.java\nTsaBusiness.xml\nTsaDelivery.xml\n\nadmin.popup.js\nSupplyCompanyPopupForm2.html\nDeliveryListScmForm.html\n"]
[23,"화면\n(SCM)","매장POS","PosMainForm.html","직송매장 사용 화면   - 오픈되어있지 않음.\n출고확정시 재공이동 API 임시 주석으로 처리되어있음. 테스트시 주석제거 필요! "]

{"sheet":"출고_교환_프로세스","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"WMS_IF TABLE","index":2,"n_rows":264,"n_cols":25,"rows_kept":264,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,11],[1,12,1,23],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,18,3,18],[2,19,3,19],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,23,3,23],[2,16,3,16],[2,17,3,17],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,11,3,11],[2,12,3,12],[4,14,20,14],[2,13,3,13],[2,14,3,14],[27,12,28,12],[25,0,25,4],[26,0,26,11],[26,12,26,23],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,28,6],[27,7,28,7],[27,8,28,8],[27,9,28,9],[27,10,28,10],[27,11,28,11],[69,14,101,14],[27,20,28,20],[27,21,28,21],[27,22,28,22],[27,23,28,23],[27,24,28,24],[29,14,68,14],[27,13,28,13],[27,14,28,14],[27,16,28,16],[27,17,28,17],[27,18,28,18],[27,19,28,19],[107,24,108,24],[107,13,108,13],[107,14,108,14],[107,16,108,16],[107,17,108,17],[107,18,108,18],[107,19,108,19],[109,14,122,14],[123,14,132,14],[107,20,108,20],[107,21,108,21],[107,22,108,22],[107,12,108,12],[105,0,105,4],[106,0,106,11],[106,12,106,23],[107,0,108,0],[107,1,108,1],[107,2,108,2],[107,3,108,3],[107,4,108,4],[107,5,108,5],[107,6,108,6],[107,7,108,7],[107,8,108,8],[107,9,108,9],[107,10,108,10],[107,11,108,11],[107,23,108,23],[137,12,138,12],[135,0,135,4],[136,0,136,11],[136,12,136,23],[137,0,138,0],[137,1,138,1],[137,2,138,2],[137,3,138,3],[137,4,138,4],[137,5,138,5],[137,6,138,6],[137,7,138,7],[137,8,138,8],[137,9,138,9],[137,10,138,10],[137,11,138,11],[137,24,138,24],[139,14,152,14],[137,13,138,13],[137,14,138,14],[137,16,138,16],[137,17,138,17],[137,18,138,18],[137,19,138,19],[137,20,138,20],[137,21,138,21],[137,22,138,22],[137,23,138,23],[159,13,160,13],[159,14,160,14],[159,16,160,16],[159,17,160,17],[159,18,160,18],[159,19,160,19],[159,12,160,12],[157,0,157,4],[158,0,158,11],[158,12,158,23],[159,0,160,0],[159,1,160,1],[159,2,160,2],[159,3,160,3],[159,4,160,4],[159,5,160,5],[159,6,160,6],[159,7,160,7],[159,8,160,8],[159,9,160,9],[159,10,160,10],[159,11,160,11],[255,14,271,14],[210,20,211,20],[210,21,211,21],[189,14,205,14],[159,20,160,20],[159,21,160,21],[159,22,160,22],[159,23,160,23],[159,24,160,24],[161,14,184,14],[210,24,211,24],[210,13,211,13],[210,14,211,14],[210,16,211,16],[210,17,211,17],[210,18,211,18],[210,19,211,19],[212,14,236,14],[237,14,254,14],[210,12,211,12],[208,0,208,4],[209,0,209,11],[209,12,209,23],[210,0,211,0],[210,1,211,1],[210,2,211,2],[210,3,211,3],[210,4,211,4],[210,5,211,5],[210,6,211,6],[210,7,211,7],[210,8,211,8],[210,9,211,9],[210,10,211,10],[210,11,211,11],[210,22,211,22],[210,23,211,23]]}
["인터페이스 ID : IF_08",{"$nulls":4},"인터페이스 명 : 총알배송권역정보"]
["Receiver(수신) : MALL",{"$nulls":11},"Sender(송신) : WMS"]
["NO","System","Object\n유형","Object 명","Field","Field 명","Type","길이","Null허용","Key","입출력","비고","System","Object\n유형","Object 명",null,"Field","Field 명","Type","길이","Null허용","Key","디폴트","비고"]
[{"$nulls":15},"X-path"]
[1,"MALL","TABLE","TB_DAILY_DELIVERY_ZONE","ZIP_NO","우편번호",{"$nulls":6},"WMS_IF","TABLE","TB_IF_DailyDeliveryZone","ZIP_NO",null,"우편번호","nvarchar",6]
[2,null,null,null,"PND_BRAN",{"$nulls":10},"PND_BRAN",null,"터미널코드","nvarchar",7]
[3,null,null,null,"PND_BRAN_NM",{"$nulls":10},"PND_BRAN_NM",null,"지역명","nvarchar",30]
[4,null,null,null,"OPER_ABOVE_BRAN",{"$nulls":10},"OPER_ABOVE_BRAN",null,null,"nvarchar",8]
[5,null,null,null,"TR_BRAN_NM",{"$nulls":10},"TR_BRAN_NM",null,null,"nvarchar",30]
[6,null,null,null,"CITY_DO","시도",{"$nulls":9},"CITY_DO",null,"시도","nvarchar",30]
[7,null,null,null,"GU_GUN","구군",{"$nulls":9},"GU_GUN",null,"구군","nvarchar",4]
[8,null,null,null,"DONG_YUP_MEUN","동읍면",{"$nulls":9},"DONG_YUP_MEUN",null,"동읍면","nvarchar",4]
[9,null,null,null,"DELIVERY_TIME",{"$nulls":10},"DELIVERY_TIME",null,null,"nvarchar",2]
[10,null,null,null,"DELIVERY_PROBABILITY",{"$nulls":10},"DELIVERY_PROBABILITY",null,null,"nvarchar",3]
[11,null,null,null,"DELIVERYCLASSCD",{"$nulls":10},"DELIVERYCLASSCD",null,"10:일반 20: 당일","nvarchar",20]
[12,null,null,null,"ISUSE","사용여부",{"$nulls":9},"ISUSE",null,"0: 미사용 1: 사용","bit",1]
[13,null,null,null,"DATELASTUPDATE","수정일",{"$nulls":9},"DATELASTUPDATE",null,"수정일","datetime",8]
{"$rows_empty":8}
["인터페이스 ID : IF_09",{"$nulls":4},"인터페이스 명 : 출고요청"]
["Receiver(수신) : MALL",{"$nulls":11},"Sender(송신) : WMS",{"$nulls":11},"SAMPLE"]
["NO","System","Object\n유형","Object 명","Field","Field 명","Type","길이","Null허용","Key","입출력","비고","System","Object\n유형","Object 명",null,"Field","Field 명","Type","길이","Null허용","Key","디폴트","비고"]
[{"$nulls":15},"X-path"]
[null,"MALL",{"$nulls":9},"채번","WMS_IF","TABLE","TB_IF_DeliveryOrder","DeliveryOrderNo","배송 번호","배송 번호","bigint",8]
[{"$nulls":11},"null",null,null,null,"OrderGUID","주문서 고유번호","주문서 고유번호","uniqueidentifier",16,null,null,null," 사용여부 확인필요!  P_wReturnRegister_Retrieve_Master (select 사용중)"]
[null,null,null,"tb_order","ORD_NO","주문번호",{"$nulls":9},"OrderNo","주문번호","주문번호","bigint",8]
[{"$nulls":11},"WMS",null,null,null,"DeliveryTypeCd","배송타입형태","배송타입형태","nvarchar",20,null,null,null,"wms"]
[{"$nulls":11},"정상",null,null,null,"IssueTypeCd","주문타입","주문타입","nvarchar",20,null,null,null,"정상,취소"]
[{"$nulls":11},"null",null,null,null,"DeliveryUnitNo","물류단위 번호","물류단위 번호","int",4,null,null,null,"?  wms사용안함."]
[{"$nulls":11},"NOW()",null,null,null,"DateIssued","배송 데이터 수집일","배송 데이터 수집일","datetime",8,null,null,null,"생성시 일자"]
[{"$nulls":11},"null",null,null,null,"DateReceived","접수일","접수일","datetime",8,null,null,null,"출고지시 접수일(배치)     wms"]
[{"$nulls":11},"null",null,null,null,"DateSent","상품 발송 일","상품 발송 일","datetime",8,null,null,null,"발송완료일때               (wms)"]
[{"$nulls":11},10,null,null,null,"StatusCd","배송 상태","배송 상태","nvarchar",20,null,null,null,"10,: 배송지시 20: 출고지시, 30: 출고확정, 60: 취소"]
[null,null,null,"tb_customer","CUST_ID","로그인 아이디",{"$nulls":5},"CUST_NO = tb_order.CUST_NO ",null,null,null,"LoginId","로그인 아이디","로그인 아이디","nvarchar",50]
[null,null,null,"tb_order","ORD_NM","주문자명",{"$nulls":9},"CustomerName","주문자 명","주문자 명","nvarchar",50]
[null,null,null,"tb_order","ORD_DT","주문일",{"$nulls":9},"DateOrdered","주문 일","주문 일","datetime",8]
[null,null,null,"tb_customer","CUST_GRADE","회원등급",{"$nulls":5},"CUST_NO = tb_order.CUST_NO ",null,null,null,"Grade","회원 등급","회원 등급","nvarchar",20]
[null,null,null,"tb_delivery_addr","RECIP_NM","수령자명",{"$nulls":9},"Receiver","주문자","주문자","nvarchar",50]
[null,null,null,"tb_delivery_addr","RECIP_TELNO","수령자 전화번호",{"$nulls":9},"ReceiverTelNum","주문자 전화번호","주문자 전화번호","nvarchar",20]
[null,null,null,"tb_delivery_addr","RECIP_PHNNO","수령자 휴대전화번호",{"$nulls":9},"ReceiverCellNum","주문자 핸드폰 번호","주문자 핸드폰 번호","nvarchar",20]
[null,null,null,"tb_delivery_addr","RECIP_ZIPCODE","수령자 우편번호",{"$nulls":9},"DeliveryPostalCode","우편번호","우편번호","char",10]
[null,null,null,"tb_delivery_addr","RECIP_BASE_ADDR","수령자 기본주소",{"$nulls":9},"DeliveryAddr1","기본 주소","기본 주소","nvarchar",100]
[null,null,null,"tb_delivery_addr","RECIP_DTL_ADDR","수령자 상세주소",{"$nulls":9},"DeliveryAddr2","상세 주소","상세 주소","nvarchar",100]
[{"$nulls":11},29,null,null,null,"LogisticsNo","택배사 고유번호","택배사 고유번호","nvarchar",10,null,null,null,"wms 택배사 코드 관리하고있음."]
[{"$nulls":11},"cj 대한통운",null,null,null,"LogisticsName","택배사 명","택배사 명","nvarchar",100,null,null,null,"mall에서 입력한 택배사정보를 WMS에서 사용하는지 확인필요!"]
[null,null,null,"tb_delivery_addr","DELV_MEMO","배송메모",{"$nulls":9},"DeliveryMemo","배송 메모","배송 메모","nvarchar",1000]
[{"$nulls":11},"예) 심플 폴로 니트 GN 외 1건",null,null,null,"ProductSummary","상품명","상품명","nvarchar",500,null,null,null,"확인필요!"]
[{"$nulls":11},"null",null,null,null,"ExceptionDesc","배송 예외 설명","배송 예외 설명","nvarchar",255,null,null,null,"로직상 취소시 들어가게 되어있으나  개발 DB상 null 밖에 없음."]
[{"$nulls":11},0,null,null,null,"IsCancel","배송 취소 여부","배송 취소 여부","bit",1]
[{"$nulls":11},0,null,null,null,"IsChangeAddress","배송지 변경 여부","배송지 변경 여부","bit",1]
[{"$nulls":11},0,null,null,null,"IsReOrder","재주문 여부","재주문 여부","bit",1,null,null,null,"교환과  주문예외를  재 주문시 사용되고있음."]
[{"$nulls":11},"null",null,null,null,"IsTransferCompleted",null,null,"bit",1,null,null,null,"사용X 확인필요!"]
[null,null,null,"tb_extmall","EXTMALL_NM","제휴몰명",{"$nulls":5},"EXTMALL_ID = tb_order_detail.EXTMALL_ID",null,null,null,"OrderPath","주문 경로","주문 경로","char",2]
[null,null,null,"tb_order_detail","SHOT_DELV_YN","총알배송여부",{"$nulls":9},"DeliveryClassCd","배송 형태 (당일)","배송 형태 (당일)","nvarchar",20,null,null,null,"당일배송구분  10 일반, 20 당일"]
[{"$nulls":11},10,null,null,null,"ShippingTypeCd","출고 구분","출고 구분","nvarchar",20,null,null,null,"출고구분 10 일반, 20 교환"]
[{"$nulls":11},"null",null,null,null,"ExchangeNo","배송 예외 번호","배송 예외 번호","int",4,null,null,null,"출고구분 20 교환일때  사용    -- 현재 사용 안함."]
[{"$nulls":11},0,null,null,null,"IsBeautyDelivery","선물 포장 여부","선물 포장 여부","bit",1,null,null,null,"포장여부 사용안함.  디폴트 0 "]
[{"$nulls":11},"null",null,null,null,"VendorOrderNo",null,null,"nvarchar",50,null,null,null,"사용 X  확인필요!"]
[null,null,null,"tb_order","RECIP_BASE_ADDR","도로명 주소",{"$nulls":9},"DeliveryAddrNew","도로명 주소","도로명 주소","nvarchar",100]
[{"$nulls":11},"N",null,null,null,"IfYn",null,"I/F여부","nvarchar",1,null,null,"N","추가"]
[{"$nulls":11},"null",null,null,null,"IfDate",null,"I/F일자","datetime",8,null,null,null,"추가"]
[{"$nulls":15},"PayGb",null,"페이구분","nvarchar",20,null,null,null,"추가   페이구분:  KCP , NAVER"]
[]
[{"$nulls":11},"채번",null,null,"TB_IF_DeliveryOrderItem","DeliveryOrderItemNo","주문서 항목 고유 번호","배송항목번호","bigint",8]
[null,null,null,"TB_IF_DeliveryOrder","DeliveryOrderNo","배송번호",{"$nulls":9},"DeliveryOrderNo","주문서 고유번호","배송번호","bigint",8]
[null,null,null,"tb_supply_company","PROVIDER_NO","공급자 번호",{"$nulls":9},"ProviderNo","공급자 번호","공급자 번호","int",4]
[null,null,null,"tb_order_detail","PRODUCT_NO",{"$nulls":10},"ProductNo","상품 번호","상품 번호","int",4]
[null,null,null,"tb_order_detail","PRODUCT_CODE",{"$nulls":10},"ProductCode","상품 코드","상품 코드","nvarchar",50]
[null,null,null,"tb_goods","GOODS_NM","상품명",{"$nulls":9},"ProductName","상품 명","상품 명","nvarchar",255]
[null,null,null,"tb_order_detail",{"$nulls":7},"일반",null,null,null,"ProductTypeCd","상품 타입","상품 타입","nvarchar",20,null,null,null,"일반,사은품,세트, 신규, 공백 "]
[null,null,null,"tb_order_detail_item","OPT_CD",{"$nulls":10},"SKUCode","옵션 코드","옵션 코드","nvarchar",50]
[null,null,null,"tb_order_detail_item","OPT_CD1 + OPT_CD2",{"$nulls":10},"SKUValue","옵션 값","옵션 값","nvarchar",100]
[null,null,null,"tb_order_detail","CURR_PRICE",{"$nulls":10},"UnitPrice","단가","단가(판매가)","money",8,null,null,null,"?"]
[{"$nulls":11},"null",null,null,null,"SetProductNo","세트상품 번호","세트상품 번호","int",4,null,null,null,"?"]
[null,null,null,"tb_order_detail\ntb_order_detail_item","ORD_QTY * \nITEM_QTY",{"$nulls":10},"Qty","수량","수량","int",4]
[{"$nulls":11},10,null,null,null,"StatusCd","배송상태","배송상태","nvarchar",20,null,null,null,"10,: 배송지시 20: 출고지시, 30: 출고확정, 60: 취소"]
[{"$nulls":11},"null",null,null,null,"DateReceived","접수일","접수일","datetime",8,null,null,null," 현재 TB_ORD_DeliveryOrderItem 직접 하고있음 차후 현 컬럼에 update "]
[{"$nulls":11},"null",null,null,null,"DateSent","상품발송일","상품발송일","datetime",8]
[{"$nulls":11},"null",null,null,null,"DateCompleted","배송완료일","배송완료일","datetime",8]
[{"$nulls":11},"NOW()",null,null,null,"DateLastModified","수정일","수정일","datetime",8]
[{"$nulls":11},"null",null,null,null,"ExceptionDesc","예외","예외","nvarchar",500,null,null,null,"배송취소, 배송예외일경우 update / 개발DB상  null임. 운영도 null임"]
[{"$nulls":11},0,null,null,null,"IsCancel",null,"취소","bit",1]
[{"$nulls":11},"null",null,null,null,"VendorProductCode",null,null,"nvarchar",50,null,null,null,"사용 X  확인필요!"]
[{"$nulls":11},"null",null,null,null,"VendorSKUCode",null,null,"nvarchar",50,null,null,null,"사용 X  확인필요!"]
[{"$nulls":11},"null",null,null,null,"VendorSKUModelNo",null,null,"nvarchar",50,null,null,null,"사용 X  확인필요!"]
[{"$nulls":11},"WMS",null,null,null,"StockMgmtTypeCd","재고관리 타입","재고관리 타입","nvarchar",50,null,null,null,"WMS   (YES24 사용안함)"]
[{"$nulls":11},"사은품일경우 Y /  기본 N",null,null,null,"GiftYn",null,"사은품여부","nvarchar",1,null,null,null,"추가"]
[null,null,null,"tb_order_detail","GOODS_CD","상품코드",{"$nulls":5},"세트상품일경우만",null,null,null,"SetProductCode",null,"세트상품코드","nvarchar",50,null,null,null,"추가"]
[{"$nulls":4},"GOODS_TYPE","상품타입  (G056_S)",{"$nulls":5},"세트상품일경우만 Y ,    기본  N",null,null,null,"SetProductYn",null,"세트상품여부","nvarchar",1,null,null,null,"추가"]
[null,null,null,"tb_goods","GOODS_NM","상품명",{"$nulls":5},"세트상품일경우만 ",null,null,null,"SetproductName",null,"세트상품명","nvarchar",255,null,null,null,"추가"]
[null,null,null,"tb_order_detail","ORD_DTL_NO","주문상세번호",{"$nulls":9},"OrderDtlNo",null,"주문상세번호","bigint",8,null,null,null,"추가  사은품인경우 사은품상세번호 "]
[{"$nulls":15},"SetQty",null,"세트 수량","int",4,null,null,null,"추가"]
[{"$nulls":15},"SetItemQty",null,"세트 구성수량","int",4,null,null,null,"추가"]
[{"$nulls":11},"N",null,null,null,"IfYn",null,"I/F여부","nvarchar",1,null,null,"N","추가"]
[{"$nulls":11},"null",null,null,null,"IfDate",null,"I/F일자","datetime",8,null,null,null,"추가"]
[{"$nulls":6},"DATE",{"$nulls":8},"Cqty",null,"취소수량","int",4,null,null,0,"추가"]
[]
[]
[]
["인터페이스 ID : IF_10",{"$nulls":4},"인터페이스 명 : 출고예외"]
["Receiver(수신) : MALL",{"$nulls":11},"Sender(송신) : WMS",{"$nulls":11},"SAMPLE"]
["NO","System","Object\n유형","Object 명","Field","Field 명","Type","길이","Null허용","Key","입출력","비고","System","Object\n유형","Object 명",null,"Field","Field 명","Type","길이","Null허용","Key","디폴트","비고"]
[{"$nulls":15},"X-path"]
[null,null,null,"tb_order_delivery_exception","IF_DELIVERY_EXCEPTION_NO","배송 예외 번호(WMS)",{"$nulls":8},"TB_IF_DeliveryException","DeliveryExceptionNo",null,"배송 예외 번호","bigint",8]
[{"$nulls":4},"IF_DELIVERY_ORDER_NO","배송번호(WMS)",{"$nulls":9},"DeliveryOrderNo",null,"배송번호","bigint",8]
[{"$nulls":4},"STATUS_CD","배송예외 상태",{"$nulls":9},"StatusCd",null,"상태","nvarchar",20,null,null,null,"예외접수"]
[{"$nulls":4},"ADMIN_MEMO","관리자 메모",{"$nulls":9},"AdminMemo",null,"관리자 메모","nvarchar",2000]
[{"$nulls":4},"REG_NO","등록자NO",{"$nulls":9},"UserIdCreated",null,"생성자 아이디","nvarchar",50]
[{"$nulls":15},"UserNameCreated",null,"생성자 이름","nvarchar",50]
[{"$nulls":4},"REG_DT","등록일시",{"$nulls":9},"DateCreated",null,"생성일","nvarchar",8]
[{"$nulls":4},"UPD_NO","수정자NO",{"$nulls":9},"UserIdModified",null,"수정자 아이디","nvarchar",50]
[{"$nulls":15},"UserNameModified",null,"수정자 이름","nvarchar",50]
[{"$nulls":4},"UPD_DT","수정일시",{"$nulls":9},"DateLastModified",null,"수정일","datetime",8]
[{"$nulls":4},"ORD_NO","주문번호",{"$nulls":9},"OrderNo",null,"주문번호","bigint",8,null,null,null,"추가"]
[{"$nulls":11},"Y",null,null,null,"IfYn",null,"I/F여부","nvarchar",1,null,null,"N","추가"]
[{"$nulls":11},"NOW()",null,null,null,"IfDate",null,"I/F일자","datetime",8,null,null,null,"추가"]
[{"$nulls":6},"DATE"]
[null,null,null,"tb_order_delivery_exception_item","IF_DELIVERY_EXCEPTION_ITEM_NO","배송예외 항목번호(WMS)",{"$nulls":8},"TB_IF_DeliveryExceptionItem","DeliveryExceptionItemNo",null,"배송 예외 항목 번호","bigint",8,null,"PK"]
[{"$nulls":4},"IF_DELIVERY_EXCEPTION_NO","배송예외 번호 (WMS)",{"$nulls":9},"DeliveryExceptionNo",null,"배송 예외 번호","bigint",8]
[{"$nulls":4},"IF_DELIVERY_ORDER_ITEM_NO","배송항목번호(WMS)",{"$nulls":9},"DeliveryOrderItemNo",null,"배송 항목 번호","bigint",8,null,"FK"]
[{"$nulls":15},"MallDeliveryOrderItemNo",null,null,"bigint",8,null,null,null,"개발DB  null만 존재"]
[{"$nulls":4},"EXCEPTION_QTY","예외수량",{"$nulls":9},"ExceptionQty",null,"예외 수량","int",4]
[{"$nulls":4},"REASON_CD","사유코드",{"$nulls":9},"ReasonCd",null,"사유","nvarchar",20,null,null,null,"재고부족"]
[{"$nulls":4},"ORD_DTL_NO","주문상세번호",{"$nulls":9},"OrderDtlNo",null,"주문상세번호","bigint",8,null,null,null,"추가"]
[{"$nulls":11},"Y",null,null,null,"IfYn",null,"I/F여부","nvarchar",1,null,null,"N","추가"]
[{"$nulls":11},"NOW()",null,null,null,"IfDate",null,"I/F일자","datetime",8,null,null,null,"추가"]
[]
[]
[]
["인터페이스 ID : IF_11",{"$nulls":4},"인터페이스 명 : 출고송장번호 수신"]
["Receiver(수신) : MALL",{"$nulls":11},"Sender(송신) : WMS",{"$nulls":11},"SAMPLE"]
["NO","System","Object\n유형","Object 명","Field","Field 명","Type","길이","Null허용","Key","입출력","비고","System","Object\n유형","Object 명",null,"Field","Field 명","Type","길이","Null허용","Key","디폴트","비고"]
[{"$nulls":15},"X-path"]
[{"$nulls":12},"WMS_IF","TABLE","TB_IF_DeliveryInvoice","InvoiceNoSeq","배송 번호","송장번호SEQ","bigint",8]
[null,null,null,"TB_ORDER_DETAIL_INVOICE","ORD_NO","주문번호",{"$nulls":5},"TB_IF_DeliveryOrder 참조 \nOrderNo (주문번호)",null,null,null,"orderNo","주문서 고유번호","주문번호","bigint",8]
[null,null,null,"TB_ORDER_DETAIL","SHIP_COMP_CD","배송업체코드",{"$nulls":9},"orderDtlNo",null,"주문상세번호",null,null,"Y"]
[{"$nulls":15},"LogisticsNo","주문번호","택배사고유넘버","nvarchar",10]
[null,null,null,"TB_ORDER_DETAIL_INVOICE\nTB_ORDER_DETAIL","INVOICE_NO","송장번호",{"$nulls":9},"InvoiceNo","주문타입","송장번호","nvarchar",50]
[{"$nulls":15},"DateShip","물류단위 번호","배송시작일","datetime",8]
[{"$nulls":15},"DateCompleted","배송 데이터 수집일","배송완료일","datetime",8]
[{"$nulls":15},"Qty",null,"주문수량","int",4]
[null,null,null,"TB_ORDER_DETAIL_INVOICE","ORD_DTL_NO","주문상세번호",{"$nulls":5},"TB_IF_DeliveryOrderItem 참조 OrderDtlNo (주문상세번호)",null,null,null,"DateFirstCreated",null,"초기생성일","datetime"]
[{"$nulls":15},"DateLastModified",null,"마지막수정일","datetime"]
[{"$nulls":15},"IfYn",null,"I/F여부","nvarchar",1,null,null,"N ","mall에서 데이터 수신여부"]
[{"$nulls":15},"IfDate",null,"I/F일자","datetime",{"$nulls":4},"mall에서 데이터 수신일자"]
[{"$nulls":11},"Y",null,null,null,"AddInvoiceYn",null,"추가 송장여부 ","nvarchar",1]
[{"$nulls":11},"NOW()",null,null,null,"ProductNo",null,"상품 번호","int",4]
[{"$nulls":6},"DATE",{"$nulls":8},"SKUCode",null,"옵션 코드","nvarchar",50]
[]
[]
[]
["인터페이스 ID : IF_17",{"$nulls":4},"인터페이스 명 : 회수요청"]
["Receiver(수신) : MALL",{"$nulls":11},"Sender(송신) : WMS",{"$nulls":11},"SAMPLE"]
["NO","System","Object\n유형","Object 명","Field","Field 명","Type","길이","Null허용","Key","입출력","비고","System","Object\n유형","Object 명",null,"Field","Field 명","Type","길이","Null허용","Key","디폴트","비고"]
[{"$nulls":15},"X-path"]
[{"$nulls":11},"채번","WMS_IF","TABLE","TB_IF_RECALLDELIVERY","RecallNo","반품 번호","반품 번호","bigint",8]
[null,null,null,"tb_order_change","ORD_CHG_SQ","주문변경번호",{"$nulls":9},"OrderExceptionNo","주문 예외 번호","주문 예외 번호","bigint",8,null,null,null,"TB_ORD_OrderException.ExceptionNo -> tobe -> tb_order_change.ORD_CHG_SQ"]
[null,null,null,"tb_order_change","CHG_GB","변경구분",{"$nulls":5},"G680_30 반품요청, G680_40 교환요청",null,null,null,"RecallTypeCd","반품 타입","반품 타입","nvarchar",20,null,null,null,"10: 일반입고 20: 교환"]
[null,null,null,"tb_order_change","CHGER_NM","변경자명",{"$nulls":9},"Receiver","받는자","받는자","nvarchar",50]
[null,null,null,"tb_order_change","CHGER_TELNO","변경자 전화번호",{"$nulls":9},"ReceiverTelNum","받는자 전화번호","받는자 전화번호","nvarchar",50]
[null,null,null,"tb_order_change","CHGER_PHNNO","변경자 휴대폰번호",{"$nulls":9},"ReceiverCellNum","받는자 핸드폰 번호","받는자 핸드폰 번호","nvarchar",50]
[null,null,null,"tb_order_change","CHGER_ZIP_NO","변경자 우편번호",{"$nulls":9},"DeliveryPostalCode","우편 번호","우편 번호","char",10]
[null,null,null,"tb_order_change","CHGER_BASE_ADDR","변경자 기본주소",{"$nulls":9},"DeliveryAddr1","기본 주소","기본 주소","nvarchar",255]
[null,null,null,"tb_order_change","CHGER_DTL_ADDR","변경자 상세주소",{"$nulls":9},"DeliveryAddr2","상세 주소","상세 주소","nvarchar",255]
[null,null,null,"tb_order","ORD_NO","주문번호 ",{"$nulls":9},"OrderNo","주문 번호","주문 번호","bigint",8]
[{"$nulls":15},"OrderGUID","주문 고유 번호","주문 고유 번호","nvarchar",50,null,null,null,"?"]
[null,null,null,"tb_order","ORD_NM","주문자명",{"$nulls":9},"CustomerName","주문자","주문자","nvarchar",50]
[null,null,null,"tb_customer","CUST_ID","로그인 아이디",{"$nulls":5},"CUST_NO = tb_order.REG_NO",null,null,null,"LoginId","아이디","아이디","nvarchar",50]
[null,null,null,"tb_order_change","CHG_MEMO","메모",{"$nulls":9},"CSMemo","CS 메모","CS 메모","text",16]
[null,null,null,"tb_order_change","UPD_DT","수정일",{"$nulls":9},"DateCSMemoUpdated","CS 메모 변경일","CS 메모 변경일","datetime",8]
[{"$nulls":15},"WMSMemo","WMS 메모","WMS 메모","text",16]
[{"$nulls":15},"DateWMSMemoUpdated","WMS 메모 변경일","WMS 메모 변경일","datetime",8]
[{"$nulls":11},"NOW()",null,null,null,"DateCreated","생성일","생성일","datetime",8]
[{"$nulls":11},0,null,null,null,"IsDeleted","삭제 여부","삭제 여부","bit",1]
[{"$nulls":11},"null",null,null,null,"DateDeleted","삭제일","삭제일","datetime",8]
[null,null,null,"tb_order_change","CHGER_BASE_ADDR","도로명 주소",{"$nulls":9},"DeliveryAddrNew","도로명 주소","도로명 주소","nvarchar",100]
[{"$nulls":11},"기본 Y  예외일경우 N",null,null,null,"RecallRequestYn",null,"회수요청여부","nvarchar",1,null,null,null,"추가 Y/N  Y일경우만 회수요청"]
[{"$nulls":11},0,null,null,null,"IfStat",null,"I/F상태","nvarchar",1,null,null,null,"추가=> 0: 회수요청 1: 택배사전송 2: 회수완료 3: 수신완료"]
[{"$nulls":11},"NOW()",null,null,null,"IfDate",null,"I/F일자","datetime",{"$nulls":4},"추가"]
[{"$nulls":15},"chgerRtnMemo",null,"반품메모","nvarchar",2000,null,null,null,"추가"]
[{"$nulls":15},"encloseFee",null,"동봉비","money",8,null,null,null,"추가"]
[{"$nulls":15},"CodFee",null,"착불비","money",8,null,null,null,"추가"]
[{"$nulls":15},"PayGb",null,"페이구분","nvarchar",20,null,null,null,"추가   페이구분:  KCP , NAVER"]
[{"$nulls":11},"채번",null,null,"TB_IF_RECALLDELIVERYITEM","RecallItemNo","반품 항목 번호","반품 항목 번호","bigint",8]
[null,null,null,"TB_IF_RECALLDELIVERY","RecallNo","반품번호",{"$nulls":9},"RecallNo","반품 번호","반품 번호","bigint",8]
[null,null,null,"tb_order_detail","PRODUCT_NO","상품번호",{"$nulls":9},"ProductNo","상품 번호","상품 번호","int",4]
[null,null,null,"tb_order_detail","PRODUCT_CODE","상품코드",{"$nulls":9},"ProductCode","상품 코드","상품 코드","nvarchar",50]
[null,null,null,"tb_goods","GOODS_NM","상품명",{"$nulls":9},"ProductName","상품명","상품명","nvarchar",255]
[null,null,null,"tb_order_detail_item","OPT_CD","옵션코드",{"$nulls":9},"SKUCode","옵션 코드","옵션 코드","nvarchar",50]
[null,null,null,"tb_order_detail_item","OPT_CD1 + OPT_CD2","옵션 내용",{"$nulls":9},"SKUValue","옵션 내용","옵션 내용","nvarchar",255]
[null,null,null,"tb_order_change_detail","CHG_QTY","변경수량",{"$nulls":9},"RecallQty","수량","수량","int",4]
[{"$nulls":11},"입고대기",null,null,null,"StatusCd","상태","상태","nvarchar",20,null,null,null,"입고대기, 입고완료"]
[{"$nulls":15},"DateCompleted","완료일","완료일","datetime",8]
[{"$nulls":15},"LogisticsName","택배사 명","택배사 명","nvarchar",50]
[{"$nulls":15},"LogisticsCode",null,"택배사 코드 ","nvarchar",10,null,null,null,"추가 "]
[null,null,null,"tb_order_detail","ORD_DTL_NO","주문상세번호",{"$nulls":9},"RecallInvoiceNo","반품 명세서","반품 명세서(회수운송장번호)","nvarchar",50]
[null,null,null,"tb_order_detail","INVOICE_NO","원운송장번호",{"$nulls":9},"OrderDtlNo",null,"주문상세번호","bigint",8,null,null,null,"추가"]
[{"$nulls":11},0,null,null,null,"InvoiceNo",null,"원운송장번호","nvarchar",50,null,null,null,"추가"]
[{"$nulls":11},"NOW()",null,null,null,"IfStat",null,"I/F상태","nvarchar",1,null,null,null,"추가=> 0: 회수요청 1: 택배사전송 2: 회수완료 3: 수신완료"]
[{"$nulls":15},"IfDate",null,"I/F일자","datetime",{"$nulls":4},"추가"]
[]
[]
["인터페이스 ID : IF_20",{"$nulls":4},"인터페이스 명 : 회수입고예외"]
["Receiver(수신) : MALL",{"$nulls":11},"Sender(송신) : WMS",{"$nulls":11},"SAMPLE"]
["NO","System","Object\n유형","Object 명","Field","Field 명","Type","길이","Null허용","Key","입출력","비고","System","Object\n유형","Object 명",null,"Field","Field 명","Type","길이","Null허용","Key","입출력","비고"]
[{"$nulls":15},"X-path"]
[null,null,null,"tb_order_recall_exception","RECALL_EXCEPTION_NO","반품예외번호",{"$nulls":8},"TB_IF_RecallException","RecallExceptionNo",null,"반품 예외 번호","bigint",8,null,"PK"]
[{"$nulls":4},"DELIVERY_ORDER_NO","배송번호",{"$nulls":9},"DeliveryOrderNo",null,"배송번호","bigint",8]
[{"$nulls":4},"ORDER_NO","주문번호",{"$nulls":9},"OrderNo",null,"주문번호","bigint",8]
[{"$nulls":4},"CUSTOMER_NAME","고객명",{"$nulls":9},"CustomerName",null,"고객명","nvarchar",50]
[{"$nulls":4},"STATUS_CD","상태",{"$nulls":9},"StatusCd",null,"상태코드","nvarchar",20,null,null,null,"대기, 완료"]
[{"$nulls":4},"LOGISTICS_NAME","택배사명",{"$nulls":9},"LogisticsName",null,"택배사명","nvarchar",100]
[{"$nulls":4},"INVOICE_NO","회수송장번호",{"$nulls":9},"InvoiceNo",null,"회수송장번호","nvarchar",50]
[{"$nulls":4},"CHARGE_TYPE","요금타입",{"$nulls":9},"ChargeType",null,"요금타입","nvarchar",50,null,null,null,"선불, 착불, 미동봉"]
[{"$nulls":4},"CHARGE_AMOUNT","요금총액",{"$nulls":9},"ChargeAmount",null,"요금총액","money",8]
[{"$nulls":4},"USER_ID_CREATED","생성자ID",{"$nulls":9},"UserIdCreated",null,"생성자ID","nvarchar",50]
[{"$nulls":4},"USER_NAME_CREATED","생성자명",{"$nulls":9},"UserNameCreated",null,"생성자명","nvarchar",50]
[{"$nulls":4},"DATE_CREATED","생성일시",{"$nulls":9},"DateCreated",null,"생성일자","datetime",8]
[{"$nulls":4},"USER_ID_MODIFIED","수정자ID",{"$nulls":9},"UserIdModified",null,"수정자ID","nvarchar",50]
[{"$nulls":4},"USER_NAME_MODIFIED","수정자명",{"$nulls":9},"UserNameModified",null,"수정자명","nvarchar",50]
[{"$nulls":4},"DATE_LAST_MODIFIED","수정일시",{"$nulls":9},"DateLastModified",null,"수성일","datetime",8]
[{"$nulls":11},"1: mall 수신",null,null,null,"CSenCloseFee",null,"C/S동봉비","money",8,null,null,null,"추가"]
[{"$nulls":11},"NOW()",null,null,null,"CSMemo",null,"C/S메모","text",16,null,null,null,"추가"]
[{"$nulls":4},"RECALL_STAT","반품대기처리상태",{"$nulls":5},"P:대기 S: 완료",null,null,null,"IfStat",null,"I/F상태","nvarchar",{"$nulls":4},"0: wms 등록, 1: mall 수신, 2: mall처리, 3: wms 처리완료"]
[{"$nulls":15},"IfDate",null,"I/F일자","datetime",{"$nulls":4},"추가"]
[{"$nulls":15},"encloseFee",null,"동봉비","money",8,null,null,null,"추가"]
[{"$nulls":15},"CodFee",null,"착불비","money",8,null,null,null,"추가"]
[{"$nulls":15},"PayGb",null,"페이구분","nvarchar",20,null,null,null,"추가   페이구분:  KCP , NAVER"]
[{"$nulls":15},"OrderExceptionNo","주문 예외 번호","주문 예외 번호","bigint",8,null,null,null,"추가"]
[]
[]
[null,null,null,"tb_order_recall_exception_item","RECALL_EXCEPTION_ITEM_NO","반품예외항목번호",{"$nulls":8},"TB_IF_RecallExceptionItem","RecallExceptionItemNo",null,"반품예외항목번호","bigint",8,null,"PK"]
[{"$nulls":4},"RECALL_EXCEPTION_NO","반품예외번호",{"$nulls":9},"RecallExceptionNo",null,"반품 예외 번호","bigint",8,null,"FK"]
[{"$nulls":4},"DELIVERY_ORDER_ITEM_NO","배송항목번호",{"$nulls":9},"DeliveryOrderItemNo",null,"배송항목번호","bigint",8]
[{"$nulls":4},"PRODUCT_NO","상품번호",{"$nulls":9},"ProductNo",null,"상품번호","int",4]
[{"$nulls":4},"PRODUCT_CODE","상품코드",{"$nulls":9},"ProductCode",null,"상품코드","nvarchar",50]
[{"$nulls":4},"PRODUCT_NAME","상품명",{"$nulls":9},"ProductName",null,"상품명","nvarchar",255]
[{"$nulls":4},"SKU_CODE","옵션코드",{"$nulls":9},"SKUCode",null,"옵션코드","nvarchar",50]
[{"$nulls":4},"SKU_VALUE","옵션내용",{"$nulls":9},"SKUValue",null,"옵션내용","nvarchar",100]
[{"$nulls":4},"EXCEPTION_QTY","예외수량",{"$nulls":9},"ExceptionQty",null,"예외수량","int",4]
[{"$nulls":4},"REASON_CD","예외사유",{"$nulls":9},"ReasonCd",null,"예외사유","nvarchar",100]
[{"$nulls":4},"ORDER_DTL_NO","주문상세번호",{"$nulls":9},"OrderDtlNo",null,"주문상세번호","bigint",8,null,null,null,"추가"]
[{"$nulls":11},"1: mall 수신",null,null,null,"IfStat",null,"I/F상태","nvarchar",{"$nulls":4},"0: wms 등록, 1: mall 수신, 2: mall처리, 3: wms 처리완료"]
[{"$nulls":11},"NOW()",null,null,null,"IfDate",null,"I/F일자","datetime",{"$nulls":4},"추가"]
[{"$nulls":15},"Qty",null,"주문수량 ","int",4,null,null,null,"추가"]
[{"$nulls":15},"ReasonCode",null,"예외사유코드","nvarchar",10,null,null,null,"추가"]
[]
[]
[]
[null,null,null,"tb_order_recall_exception_memo","RECALL_EXCEPTION_MEMO_NO","반품예외메모번호",{"$nulls":8},"TB_IF_RecallExceptionMemo","RecallExceptionMemoNo",null,"반품 예외메모번호","bigint",8]
[{"$nulls":4},"RECALL_EXCEPTION_NO","반품예외번호",{"$nulls":9},"RecallExceptionNo",null,"반품예외번호","bigint",8]
[{"$nulls":4},"MEMO_TYPE","메모타입",{"$nulls":9},"MemoType",null,"메모타입","nvarchar",50,null,null,null,"WMS"]
[{"$nulls":4},"ADMIN_MEMO","메모내용",{"$nulls":9},"AdminMemo",null,"메모내용","nvarchar",2000]
[{"$nulls":4},"USER_ID_CREATED","생성자ID",{"$nulls":9},"UserIdCreated",null,"생성자ID","nvarchar",50]
[{"$nulls":4},"USER_NAME_CREATED","생성자명",{"$nulls":9},"UserNameCreated",null,"생성자명","nvarchar",50]
[{"$nulls":4},"DATE_CREATED","생성일시",{"$nulls":9},"DateCreated",null,"생성일","datetime",8]
[{"$nulls":11},"1: mall 수신",null,null,null,"IfStat",null,"I/F상태","nvarchar",{"$nulls":4},"0: wms 등록, 1: mall 수신, 2: mall처리, 3: wms 처리완료"]
[{"$nulls":11},"NOW()",null,null,null,"IfDate",null,"I/F일자","datetime",{"$nulls":4},"추가"]