{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["인터페이스 대상","IF_08_총알배송권역정보(항목정의)","IF_09_출고요청(항목정의)","IF_09","IF_10_출고예외(항목정의)","IF_11_출고송장번호(항목정의)","IF_11","IF_12_출고결과(항목정의)","IF_17_회수요청(항목정의)","IF_19_회수입고결과(항목정의)","IF_20_회수입고예외(항목정의)","IF_21_회수입고예외 결과","IF_21","출고처지정건 재고차감"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":18,"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":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,7],[1,8,1,11],[1,12,2,12]]}
[]
["I/F\n번호","송신",null,null,null,"전달",null,null,"수신",null,null,null,"비고"]
[null,"일련\n번호","송신시스템명","프로세스명","PGM-ID","처리\n형태","I/F\n방식","발생\n빈도","일련\n번호","수신시스템명","프로세스명","PGM-ID"]
["IF_08",1,"WMS","총알배송권역 수신",null,"Batch","DB Link","1회/일",1,"온라인몰 배치","총알배송권역 송신",null,"총알배송을 위한 권역정보 수신"]
["IF_09",1,"온라인몰 배치","출고요청",null,"Batch","DB Link",null,1,"WMS","자동 출고 지시",null,"주문완료 및 회수상품 컨펌 시 출고대상 데이터 전송"]
["IF_10",1,"WMS","출고예외",null,"Batch","DB Link",null,1,"온라인몰 배치","출고예외 수신",null,"출고지시시 재고부족건"]
["IF_11",1,"WMS","송장번호 등록",null,"Batch","DB Link",null,1,"온라인몰 배치","송장번호 수신"]
["IF_12",1,"WMS","출고결과 등록",null,"Batch","DB Link",null,1,"온라인몰 배치","출고결과 수신"]
["IF_17",1,"온라인몰 배치","회수요청정보",null,"Batch","DB Link",null,1,"WMS","회수요청정보 수신",null,"교환,반품 회수정보 전송"]
["IF_19",1,"WMS","회수입고결과 등록",null,"Batch","DB Link",null,1,"온라인몰 배치","회수입고결과 수신",null,"회수입고정보(정상,예외)"]
["IF_20",1,"WMS","회수입고예외 등록",null,"Batch","DB Link",null,1,"온라인몰 배치","회수입고예외 수신",null,"출고지시 예외 및 반품대기건"]
["IF_21",1,"온라인몰 배치","회수입고예외 결과",null,"Batch","DB Link",null,1,"WMS","회수입고예외결과 수신",null,"출고지시 예외 및 반품대기건"]

{"sheet":"IF_08_총알배송권역정보(항목정의)","index":1,"n_rows":17,"n_cols":25,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,23,3,23],[2,24,3,24],[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],[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]]}
["인터페이스 ID : IF_08",{"$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"]
[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]

{"sheet":"IF_09_출고요청(항목정의)","index":2,"n_rows":85,"n_cols":33,"rows_kept":85,"cut":false,"hidden":false,"merged":[[44,14,76,14],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,24,3,24],[4,14,43,14],[2,13,3,13],[2,14,3,14],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,12,3,12],[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,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11]]}
["인터페이스 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,{"$nulls":12},260260]
[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,"추가"]
[]
[]
[]
[{"$nulls":15},"Qty",null,"단품 총수량 "]
[]
[{"$nulls":15},"SetQty",null,"세트상품 수량 "]
[]
[{"$nulls":15},"SetItemQty",null,"세트 구성 수량"]

{"sheet":"IF_09","index":3,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":13}
[{"$nulls":5},"IsReOrder"]
[null,"교환"]
[]
[null,"USP_ORD_OrderExchangeIssueDeliveryOrder_I",null,null,null,1]
[]
[]
[null,"USP_ORD_OrderIssueDeliveryOrder_BOS_I",null,null,null,0]
[null,"USP_ORD_OrderIssueDeliveryOrder_I",null,null,null,0]
[]
[null,"주문예외 정보를 기반으로 물류단위별 재배송지시서를 생성한다."]
[]
[null,"USP_CS_ORDER_EXCEPTION_ISSUE_DELIVERYORDER_I",null,null,null,1]
[]
[null,13,"CJ대한통운"]
[null,18,"CJ택배"]
[null,29,"CJ 대한통운"]
[null,30,"대한통운택배"]
{"$rows_empty":16}
[null,"교환"]
[]
[null,"USP_ORD_OrderExchangeIssueDeliveryOrder_I"]
{"$rows_empty":18}
[{"$nulls":5},"주문번호","주문상세번호"]
[{"$nulls":5},1001]

{"sheet":"IF_10_출고예외(항목정의)","index":4,"n_rows":27,"n_cols":25,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,12,3,12],[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,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,23,3,23],[2,24,3,24],[2,13,3,13],[2,14,3,14],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[4,14,17,14],[18,14,27,14],[2,20,3,20],[2,21,3,21],[2,22,3,22]]}
["인터페이스 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,"추가"]

{"sheet":"IF_11_출고송장번호(항목정의)","index":5,"n_rows":19,"n_cols":25,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,24,3,24],[4,14,17,14],[2,13,3,13],[2,14,3,14],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,12,3,12],[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,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11]]}
["인터페이스 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]

{"sheet":"IF_11","index":6,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["USP_ORD_DeliveryInvoiceForSCM_I","해당","사용여부확인","호출되는곳?"," INSERT INTO\n  dbo.TB_ORD_DeliveryInvoice WITH (ROWLOCK)\n  (\n   DeliveryOrderNo,\n   DeliveryOrderItemNo,\n   Qty,\n   LogisticsNo,\n   BoxType,\n   InvoiceNo,\n   DateShip,\n   AdminMemo\n  )\n VALUES\n  (\n   @DeliveryOrderNo,\n   @DeliveryOrderItemNo,\n   @Qty - @CancelQty,\n   @LogisticsNo,\n   'N/A',\n   @InvoiceNo,\n   @CurrentDate,\n   'N/A'  \n  )"]
["USP_ORD_DeliveryInvoiceDetail_U","해당","사용여부확인","호출되는곳?"," UPDATE iSTYLE24_Mall.dbo.TB_ORD_DeliveryInvoice\n    SET LogisticsNo = @LogisticsNo\n      , InvoiceNo = @InvoiceNo\n  WHERE ItemNo = @ItemNo"]
["USP_ORD_DeliveryInvoiceBatch_I","해당","사용여부확인","호출되는곳?"," INSERT INTO\n  TB_ORD_DeliveryInvoice WITH (ROWLOCK)\n  (\n   DeliveryOrderNo,\n   DeliveryOrderItemNo,\n   Qty,\n   LogisticsNo,\n   BoxType,\n   InvoiceNo,\n   DateShip\n  )\n SELECT\n  DISTINCT\n  T.DeliveryOrderNo,\n  T.DeliveryOrderItemNo,\n  DI.Qty - DI.CancelQty,\n  L.LogisticsNo,\n  'N/A',\n  T.InvoiceNo,\n  @CurrentDate"]
["USP_ORD_DeliveryInvoiceInvoiceNo_U","해당","사용여부확인","호출되는곳?"," UPDATE\n  TB_ORD_DeliveryInvoice WITH (ROWLOCK)\n SET\n  InvoiceNo = @InvoiceNo,\n  AdminMemo = @AdminMemo\n WHERE\n  ItemNo = @ItemNo"]
["USP_ORD_DeliveryCompleteForWMS_I","해당","사용여부확인","호출되는곳?"," INSERT INTO\n  TB_ORD_DeliveryInvoice WITH (ROWLOCK)\n  (\n   DeliveryOrderNo,\n   DeliveryOrderItemNo,\n   Qty,\n   LogisticsNo,\n   BoxType,\n   InvoiceNo,\n   DateShip,\n   AdminMemo\n  )\n SELECT\n  @DeliveryOrderNo,\n  DI.DeliveryOrderItemNo,\n  DI.Qty - DI.CancelQty,\n  @LogisticsNo,\n  'N/A',\n  @InvoiceNo,\n  @CurrentDate,\n  'N/A' \n FROM"]
["USP_ORD_DeliveryInvoice_I","해당","사용여부확인","호출되는곳?\n(2006-08-01 이후 수정이력없음)"," INSERT INTO\n  TB_ORD_DeliveryInvoice WITH (ROWLOCK)\n  (\n   DeliveryOrderNo,\n   DeliveryOrderItemNo,\n   Qty,\n   LogisticsNo,\n   BoxType,\n   InvoiceNo,\n   DateShip,\n   AdminMemo\n  )\n VALUES\n  (\n   @DeliveryOrderNo,\n   @DeliveryOrderItemNo,\n   @Qty - @CancelQty,\n   @LogisticsNo,\n   @BoxType,\n   @InvoiceNo,\n   GETDATE(),\n   @AdminMemo  \n  )"]
["USP_ORD_DeliveryInvoice_U","해당","사용여부확인","호출되는곳?\n(2006-08-01 이후 수정이력없음)"," UPDATE\n  TB_ORD_DeliveryInvoice WITH (ROWLOCK)\n SET\n  DateCompleted = GETDATE()\n WHERE\n  ItemNo = @ItemNo"]
["USP_ORD_DeliverySentOutForWMS_I","해당","사용중","WMS에서 호출해서 사용하고 있음 (출고확정) "," INSERT INTO dbo.TB_ORD_DeliveryInvoice WITH (ROWLOCK) (\n  DeliveryOrderNo, DeliveryOrderItemNo, Qty, LogisticsNo, BoxType, InvoiceNo\n  , DateShip, AdminMemo\n )\n  SELECT\n   @DeliveryOrderNo, DI.DeliveryOrderItemNo, DI.Qty-DI.CancelQty, @LogisticsNo, 'N/A', @InvoiceNo\n   , @CurrentDate, 'N/A' \n  FROM\n   dbo.TB_ORD_DeliveryOrderItem As DI WITH (NOLOCK) INNER JOIN dbo.TB_ORD_DeliveryOrder As D WITH (NOLOCK)\n   ON DI.DeliveryOrderNo=D.DeliveryOrderNo\n  WHERE\n   D.OrderNo=@OrderNo AND D.DeliveryTypeCd='WMS' AND D.IssueTypeCd='정상'"]
[]
[]
[]
["TB_ORD_DeliveryInvoice",null,null,null,"TB_ORD_DeliveryInvoiceItem"]
[]
[]
[]
[]
[]
[{"$nulls":5},"세트상품코드","구성품"]
[{"$nulls":5},"A","A-1",2]
[{"$nulls":6},"A-2",1]
[{"$nulls":6},"A-3",1]

{"sheet":"IF_12_출고결과(항목정의)","index":7,"n_rows":77,"n_cols":25,"rows_kept":77,"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,11,3,11],[2,12,3,12],[4,14,42,14],[2,13,3,13],[2,14,3,14],[2,23,3,23],[2,24,3,24],[43,14,76,14],[2,16,3,16],[2,17,3,17],[2,20,3,20],[2,21,3,21],[2,22,3,22]]}
["인터페이스 ID : IF_12",{"$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_DELIVERYORDER","DeliveryOrderNo","배송 번호","배송 번호","bigint",8]
[{"$nulls":15},"OrderGUID","주문서 고유번호","주문서 고유번호","uniqueidentifier",16]
[{"$nulls":15},"OrderNo","주문번호","주문번호","bigint",8]
[{"$nulls":15},"DeliveryTypeCd","배송타입형태","배송타입형태","nvarchar",20,null,null,null,"wms"]
[{"$nulls":15},"IssueTypeCd","주문타입","주문타입","nvarchar",20,null,null,null,"정상,취소"]
[{"$nulls":15},"DeliveryUnitNo","물류단위 번호","물류단위 번호","int",4,null,null,null,"?"]
[{"$nulls":15},"DateIssued","배송 데이터 수집일","배송 데이터 수집일","datetime",8,null,null,null,"생성시 일자"]
[{"$nulls":15},"DateReceived","접수일","접수일","datetime",8,null,null,null,"출고지시 접수일(배치)     wms"]
[{"$nulls":15},"DateSent","상품 발송 일","상품 발송 일","datetime",8,null,null,null,"발송완료일때               (wms)"]
[{"$nulls":15},"StatusCd","배송 상태","배송 상태","nvarchar",20,null,null,null,"10,: 배송지시 20: 출고지시, 30: 출고확정, 60: 취소"]
[{"$nulls":15},"LoginId","로그인 아이디","로그인 아이디","nvarchar",50]
[{"$nulls":15},"CustomerName","주문자 명","주문자 명","nvarchar",50]
[{"$nulls":15},"DateOrdered","주문 일","주문 일","datetime",8]
[{"$nulls":15},"Grade","회원 등급","회원 등급","nvarchar",20]
[{"$nulls":15},"Receiver","주문자","주문자","nvarchar",50]
[{"$nulls":15},"ReceiverTelNum","주문자 전화번호","주문자 전화번호","nvarchar",20]
[{"$nulls":15},"ReceiverCellNum","주문자 핸드폰 번호","주문자 핸드폰 번호","nvarchar",20]
[{"$nulls":15},"DeliveryPostalCode","우편번호","우편번호","char",10]
[{"$nulls":15},"DeliveryAddr1","기본 주소","기본 주소","nvarchar",100]
[{"$nulls":15},"DeliveryAddr2","상세 주소","상세 주소","nvarchar",100]
[{"$nulls":15},"LogisticsNo","택배사 고유번호","택배사 고유번호","nvarchar",10,null,null,null,"wms 택배사 코드 관리??"]
[{"$nulls":15},"LogisticsName","택배사 명","택배사 명","nvarchar",100]
[{"$nulls":15},"DeliveryMemo","배송 메모","배송 메모","nvarchar",1000]
[{"$nulls":15},"ProductSummary","상품명","상품명","nvarchar",500]
[{"$nulls":15},"ExceptionDesc","배송 예외 설명","배송 예외 설명","nvarchar",255,null,null,null,"로직상 취소시 들어가게 되어있으나  개발 DB상 null 밖에 없음."]
[{"$nulls":15},"IsCancel","배송 취소 여부","배송 취소 여부","bit",1]
[{"$nulls":15},"IsChangeAddress","배송지 변경 여부","배송지 변경 여부","bit",1]
[{"$nulls":15},"IsReOrder","재주문 여부","재주문 여부","bit",1,null,null,null,"교환과  주문예외를  재 주문시"]
[{"$nulls":15},"IsTransferCompleted",null,null,"bit",1,null,null,null,"사용X 확인필요!"]
[{"$nulls":15},"OrderPath","주문 경로","주문 경로","char",2]
[{"$nulls":15},"DeliveryClassCd","배송 형태 (당일)","배송 형태 (당일)","nvarchar",20,null,null,null,"당일배송구분  10 일반, 20 당일"]
[{"$nulls":15},"ShippingTypeCd","출고 구분","출고 구분","nvarchar",20,null,null,null,"출고구분 10 일반, 20 교환"]
[{"$nulls":15},"ExchangeNo","배송 예외 번호","배송 예외 번호","int",4,null,null,null,"출고구분 20 교환일때  사용 "]
[{"$nulls":15},"IsBeautyDelivery","선물 포장 여부","선물 포장 여부","bit",1]
[{"$nulls":15},"VendorOrderNo",null,null,"nvarchar",50,null,null,null,"사용 X  확인필요!"]
[{"$nulls":15},"DeliveryAddrNew","도로명 주소","도로명 주소","nvarchar",100]
[{"$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":15},"PayGb",null,"페이구분","nvarchar",20,null,null,null,"추가   페이구분:  KCP , NAVER"]
[{"$nulls":14},"TB_IF_DELIVERYORDERITEM","DeliveryOrderItemNo","주문서 항목 고유 번호","배송항목번호","bigint",8]
[{"$nulls":15},"DeliveryOrderNo","주문서 고유번호","배송번호","bigint",8]
[{"$nulls":15},"ProviderNo","공급자 번호","공급자 번호","int",4]
[{"$nulls":15},"ProductNo","상품 번호","상품 번호","int",4]
[{"$nulls":15},"ProductCode","상품 코드","상품 코드","nvarchar",50]
[{"$nulls":15},"ProductName","상품 명","상품 명","nvarchar",255]
[{"$nulls":15},"ProductTypeCd","상품 타입","상품 타입","nvarchar",20]
[{"$nulls":15},"SKUCode","옵션 코드","옵션 코드","nvarchar",50]
[{"$nulls":15},"SKUValue","옵션 값","옵션 값","nvarchar",100]
[{"$nulls":15},"UnitPrice","단가","단가","money",8]
[{"$nulls":15},"SetProductNo","세트상품 번호","세트상품 번호","int",4]
[{"$nulls":15},"Qty","수량","수량","int",4]
[null,null,null,"TB_ORDER_DETAIL","ORD_DTL_STAT","배송상세상태",{"$nulls":9},"StatusCd","배송상태","배송상태","nvarchar",20,null,null,null,"10,: 배송지시 20: 출고지시, 30: 출고확정, 60: 취소\n현재 TB_ORD_DeliveryOrderItem 직접 하고있음 차후 현 컬럼에 update "]
[{"$nulls":15},"DateReceived","접수일","접수일","datetime",8,null,null,null," 현재 TB_ORD_DeliveryOrderItem 직접 하고있음 차후 현 컬럼에 update "]
[null,null,null,"TB_ORDER_DETAIL","DELV_STDT","배송시작일",{"$nulls":9},"DateSent","상품발송일","상품발송일","datetime",8]
[{"$nulls":15},"DateCompleted","배송완료일","배송완료일","datetime",8]
[{"$nulls":15},"DateLastModified","수정일","수정일","datetime",8]
[{"$nulls":15},"ExceptionDesc","예외","예외","nvarchar",500,null,null,null,"배송취소, 배송예외일경우 update / 개발DB상 다 null임."]
[{"$nulls":15},"IsCancel",null,"취소","bit",1]
[{"$nulls":15},"VendorProductCode",null,null,"nvarchar",50,null,null,null,"사용 X  확인필요!"]
[{"$nulls":15},"VendorSKUCode",null,null,"nvarchar",50,null,null,null,"사용 X  확인필요!"]
[{"$nulls":15},"VendorSKUModelNo",null,null,"nvarchar",50,null,null,null,"사용 X  확인필요!"]
[{"$nulls":15},"StockMgmtTypeCd","재고관리 타입","재고관리 타입","nvarchar",50,null,null,null,"WMS   (YES24 사용안함)"]
[{"$nulls":15},"Cqty",null,"취소수량","int",4,null,null,null,"추가"]
[{"$nulls":15},"GiftYn",null,"사은품여부","nvarchar",1,null,null,null,"추가"]
[{"$nulls":15},"SetProductCode",null,"세트상품코드","nvarchar",50,null,null,null,"추가"]
[{"$nulls":15},"SetProductYn",null,"세트상품여부","nvarchar",1,null,null,null,"추가"]
[{"$nulls":15},"SetproductName",null,"세트상품명","nvarchar",255,null,null,null,"추가"]
[{"$nulls":15},"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},"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"]

{"sheet":"IF_17_회수요청(항목정의)","index":8,"n_rows":49,"n_cols":33,"rows_kept":49,"cut":false,"hidden":false,"merged":[[32,14,48,14],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,24,3,24],[4,14,27,14],[2,13,3,13],[2,14,3,14],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,12,3,12],[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,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11]]}
["인터페이스 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":12},260260]
[{"$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},"추가"]

{"sheet":"IF_19_회수입고결과(항목정의)","index":9,"n_rows":49,"n_cols":33,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,12,3,12],[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,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[32,14,49,14],[2,24,3,24],[2,13,3,13],[2,14,3,14],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[4,14,31,14]]}
["인터페이스 ID : IF_19",{"$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_RECALLDELIVERY","RecallNo","반품 번호","반품 번호","bigint",8]
[{"$nulls":15},"OrderExceptionNo","주문 예외 번호","주문 예외 번호","bigint",8]
[{"$nulls":15},"RecallTypeCd","반품 타입","반품 타입","nvarchar",20,null,null,null,"10: 일반입고 20:  교환입고"]
[{"$nulls":15},"Receiver","받는자","받는자","nvarchar",50]
[{"$nulls":15},"ReceiverTelNum","받는자 전화번호","받는자 전화번호","nvarchar",50]
[{"$nulls":15},"ReceiverCellNum","받는자 핸드폰 번호","받는자 핸드폰 번호","nvarchar",50]
[{"$nulls":15},"DeliveryPostalCode","우편 번호","우편 번호","char",10]
[{"$nulls":15},"DeliveryAddr1","기본 주소","기본 주소","nvarchar",255]
[{"$nulls":15},"DeliveryAddr2","상세 주소","상세 주소","nvarchar",255]
[{"$nulls":15},"OrderNo","주문 번호","주문 번호","bigint",8]
[{"$nulls":15},"OrderGUID","주문 고유 번호","주문 고유 번호","nvarchar",50]
[{"$nulls":15},"CustomerName","주문자","주문자","nvarchar",50]
[{"$nulls":15},"LoginId","아이디","아이디","nvarchar",50]
[{"$nulls":15},"CSMemo","CS 메모","CS 메모","text",16]
[{"$nulls":15},"DateCSMemoUpdated","CS 메모 변경일","CS 메모 변경일","datetime",8]
[null,null,null,"tb_order_change","WH_MEMO","물류메모",{"$nulls":9},"WMSMemo","WMS 메모","WMS 메모","text",16]
[{"$nulls":15},"DateWMSMemoUpdated","WMS 메모 변경일","WMS 메모 변경일","datetime",8]
[{"$nulls":15},"DateCreated","생성일","생성일","datetime",8]
[{"$nulls":15},"IsDeleted","삭제 여부","삭제 여부","bit",1]
[{"$nulls":15},"DateDeleted","삭제일","삭제일","datetime",8]
[{"$nulls":15},"DeliveryAddrNew","도로명 주소","도로명 주소","nvarchar",100]
[{"$nulls":15},"RecallRequestYn",null,"회수요청여부","nvarchar",1,null,null,null,"추가 Y/N  Y일경우만 회수요청"]
[{"$nulls":11},2,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},"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":14},"TB_IF_RECALLDELIVERYITEM","RecallItemNo","반품 항목 번호","반품 항목 번호","bigint",8]
[{"$nulls":15},"RecallNo","반품 번호","반품 번호","bigint",8,{"$nulls":12},260260]
[{"$nulls":15},"ProductNo","상품 번호","상품 번호","int",4]
[{"$nulls":15},"ProductCode","상품 코드","상품 코드","nvarchar",50]
[{"$nulls":15},"ProductName","상품명","상품명","nvarchar",255]
[{"$nulls":15},"SKUCode","옵션 코드","옵션 코드","nvarchar",50]
[{"$nulls":15},"SKUValue","옵션 내용","옵션 내용","nvarchar",255]
[{"$nulls":15},"RecallQty","수량","수량","int",4]
[{"$nulls":15},"StatusCd","상태","상태","nvarchar",20,null,null,null,"입고대기, 입고완료"]
[null,null,null,"tb_order_change_detail","WD_EDDT",{"$nulls":6},"회수완료일시",null,null,null,"DateCompleted","완료일","완료일","datetime",8]
[{"$nulls":15},"LogisticsName","택배사 명","택배사 명","nvarchar",50]
[{"$nulls":15},"LogisticsCode",null,"택배사 코드 ","nvarchar",10,null,null,null,"추가 "]
[{"$nulls":15},"RecallInvoiceNo","반품 명세서","반품 명세서(회수운송장번호)","nvarchar",50]
[{"$nulls":15},"OrderDtlNo",null,"주문상세번호","bigint",8,null,null,null,"추가"]
[{"$nulls":15},"InvoiceNo",null,"원운송장번호","nvarchar",50,null,null,null,"추가"]
[{"$nulls":11},2,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},"추가"]

{"sheet":"IF_20_회수입고예외(항목정의)","index":10,"n_rows":56,"n_cols":33,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,12,3,12],[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,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,22,3,22],[2,23,3,23],[2,24,3,24],[2,13,3,13],[2,14,3,14],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[4,14,28,14],[29,14,46,14],[47,14,63,14],[2,20,3,20],[2,21,3,21]]}
["인터페이스 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":10},260260]
[{"$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":12},260260]
[{"$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},"추가"]

{"sheet":"IF_21_회수입고예외 결과","index":11,"n_rows":55,"n_cols":33,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,12,3,12],[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,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,23,3,23],[2,24,3,24],[4,14,27,14],[2,13,3,13],[2,14,3,14],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[28,14,45,14],[46,14,62,14],[2,20,3,20],[2,21,3,21],[2,22,3,22]]}
["인터페이스 ID : IF_21",{"$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":14},"TB_IF_RecallException","RecallExceptionNo",null,"반품 예외 번호","bigint",8,null,"PK"]
[{"$nulls":15},"DeliveryOrderNo",null,"배송번호","bigint",8]
[{"$nulls":15},"OrderNo",null,"주문번호","bigint",8]
[{"$nulls":15},"CustomerName",null,"고객명","nvarchar",50]
[{"$nulls":15},"StatusCd",null,"상태코드","nvarchar",20,null,null,null,"대기, 완료"]
[{"$nulls":15},"LogisticsName",null,"택배사명","nvarchar",100]
[{"$nulls":15},"InvoiceNo",null,"회수송장번호","nvarchar",50]
[{"$nulls":15},"ChargeType",null,"요금타입","nvarchar",50,null,null,null,"선불, 착불, 미동봉"]
[{"$nulls":15},"ChargeAmount",null,"요금총액","money",8]
[{"$nulls":15},"UserIdCreated",null,"생성자ID","nvarchar",50]
[{"$nulls":15},"UserNameCreated",null,"생성자명","nvarchar",50]
[{"$nulls":15},"DateCreated",null,"생성일자","datetime",8]
[{"$nulls":15},"UserIdModified",null,"수정자ID","nvarchar",50]
[{"$nulls":15},"UserNameModified",null,"수정자명","nvarchar",50]
[{"$nulls":15},"DateLastModified",null,"수성일","datetime",8]
[{"$nulls":11},"2: mall처리",null,null,null,"CSenCloseFee",null,"C/S동봉비","money",8,null,null,null,"추가"]
[{"$nulls":11},"NOW()",null,null,null,"CSMemo",null,"C/S메모","text",2000,null,null,null,"추가"]
[{"$nulls":15},"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},"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,"추가"]
[]
[]
[{"$nulls":14},"TB_IF_RecallExceptionItem","RecallExceptionItemNo",null,"반품예외항목번호","bigint",8,null,"PK"]
[{"$nulls":15},"RecallExceptionNo",null,"반품 예외 번호","bigint",8,null,"FK",{"$nulls":10},260260]
[{"$nulls":15},"DeliveryOrderItemNo",null,"배송항목번호","bigint",8]
[{"$nulls":15},"ProductNo",null,"상품번호","int",4]
[{"$nulls":15},"ProductCode",null,"상품코드","nvarchar",50]
[{"$nulls":15},"ProductName",null,"상품명","nvarchar",255]
[{"$nulls":15},"SKUCode",null,"옵션코드","nvarchar",50]
[{"$nulls":15},"SKUValue",null,"옵션내용","nvarchar",100]
[{"$nulls":15},"ExceptionQty",null,"예외수량","int",4]
[{"$nulls":15},"ReasonCd",null,"예외사유","nvarchar",100]
[{"$nulls":15},"OrderDtlNo",null,"주문상세번호","bigint",8,null,null,null,"추가"]
[{"$nulls":11},"2: 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,"추가"]
[]
[]
[]
[{"$nulls":14},"TB_IF_RecallExceptionMemo","RecallExceptionMemoNo",null,"반품 예외메모번호","bigint",8]
[{"$nulls":15},"RecallExceptionNo",null,"반품예외번호","bigint",8,{"$nulls":12},260260]
[{"$nulls":15},"MemoType",null,"메모타입","nvarchar",50,null,null,null,"WMS"]
[{"$nulls":15},"AdminMemo",null,"메모내용","nvarchar",2000]
[{"$nulls":15},"UserIdCreated",null,"생성자ID","nvarchar",50]
[{"$nulls":15},"UserNameCreated",null,"생성자명","nvarchar",50]
[{"$nulls":15},"DateCreated",null,"생성일","datetime",8]
[{"$nulls":11},"2: 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},"추가"]

{"sheet":"IF_21","index":12,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"항목명","코드","코드명","비고","AS-IS 처리방법"]
[null,"미등록사유코드",0,"타택배착불",null,"1. 자사상품) 배송비 받고  처리  /  2. 타상품) 택배비 입금하면 배송 - 수기처리"]
[null,"미등록사유코드",1,"반품 미접수",null,"1차 문자로 통보 ,  반품접수    예외) 착용 및 훼손 상품일경우 고객반송(물류에서 수기송장) - 수기처리","반품요청"]
[null,"미등록사유코드",2,"미착",null,"10개  9개만들어온경우   1개에 대해  고객에 문자통보 , 9개 반품 1개 철회 OR 취소후 9개 반품 (주문팀 확인 후 회신)"]
[null,"미등록사유코드",3,"과착",null,"5상품주문  4개상품 반품  실물은 5개상품 들어옴  1개에 대해 문자통보  5개 반품처리     1개건 반품접수 ","반품요청"]
[null,"미등록사유코드",4,"배송비 미동봉",null," 차감후 환불,   휴대폰일경우 금액입금받고 전체 환불 "]
[null,"미등록사유코드",5,"다른상품 반품",null,"a상품 반품접수    b상품 입고  -> a상품 반품취소, b상품은 반품접수 -> 환불 "]
[null,"미등록사유코드",6,"배송비 일부동봉",null,"1차.문자통보 차감 환불 "]
[null,"미등록사유코드",7,"맞교환","사용안함"]
[null,"미등록사유코드",8,"확정 전 품절(재고없음)",null,"자동 품절취소"]
[null,"미등록사유코드",9,"확정 후 품절",null,"반품접수 ->    메시지는 품절메세지   "]
[null,"미등록사유코드",10,"확정 전 불량",null,"자동 품절취소"]
[null,"미등록사유코드",11,"확정 후 불량","반품","반품접수 ->  메시지는 품절메세지   "]
[null,"미등록사유코드",12,"확정 전 이미지틀림",null,"자동 품절취소                                                   p.s 추후 사용안하는 방향 "]
[null,"미등록사유코드",13,"확정 후 이미지틀림",null,"반품접수 ->  메시지는 품절메세지                        p.s 추후 사용안하는 방향 "]
[null,"미등록사유코드",15,"기타(메모없음, 메모이상 등)","사용안함"]
[]
[]
[]
[{"$nulls":5},"반품시 TB_IF_RECALLDELIVERY  TB_IF_RECALLDELIVERYITEM 만 처리하면 되는지???"]

{"sheet":"출고처지정건 재고차감","index":13,"n_rows":10,"n_cols":25,"rows_kept":10,"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,11,3,11],[2,12,3,12],[4,14,31,14],[2,13,3,13],[2,14,3,14],[2,23,3,23],[2,24,3,24],[2,16,3,16],[2,17,3,17],[2,20,3,20],[2,21,3,21],[2,22,3,22]]}
["인터페이스 ID : ",{"$nulls":4},"인터페이스 명 : WMS출고처지정 재고차감"]
["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_DELIFIX_QTY","OrderNo",null,"주문번호","bigint",8,null,"Y"]
[{"$nulls":15},"OrderDtlNo",null,"주문상세번호","bigint",8,null,"Y"]
[{"$nulls":15},"SKUCode",null,"SKUCode","nvarchar",50,null,"Y"]
[{"$nulls":15},"ProductNo",null,"상품번호","int",4]
[{"$nulls":15},"Qty",null,"수량","int",4]
[{"$nulls":15},"DateCreated",null,"등록일","datetime",8]