{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["표지","개정이력","인터페이스명세서","Sheet1"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":8,"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-01-08"]
[{"$nulls":10},"작성자","김덕규"]

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

{"sheet":"인터페이스명세서","index":2,"n_rows":206,"n_cols":19,"rows_kept":206,"cut":false,"hidden":false,"merged":[[68,0,68,1],[68,2,68,4],[68,6,68,8],[129,0,129,1],[129,2,129,8],[130,0,130,8],[130,9,130,17],[127,0,127,1],[127,2,127,4],[127,6,127,8],[128,0,128,1],[128,2,128,8],[69,0,69,1],[69,2,69,4],[69,6,69,8],[70,0,70,1],[70,2,70,4],[70,6,70,8],[71,0,71,1],[71,2,71,8],[72,0,72,1],[72,2,72,8],[73,0,73,8],[73,9,73,17],[10,9,10,17],[26,0,26,1],[26,2,26,4],[26,6,26,8],[27,0,27,1],[27,2,27,4],[27,6,27,8],[31,9,31,17],[28,0,28,1],[28,2,28,4],[28,6,28,8],[29,0,29,1],[29,2,29,8],[30,0,30,1],[30,2,30,8],[9,0,9,1],[9,2,9,8],[10,0,10,8],[31,0,31,8],[5,6,5,8],[7,6,7,8],[6,0,6,1],[6,6,6,8],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,8],[8,0,8,1],[5,0,5,1],[7,0,7,1],[81,0,81,1],[81,2,81,4],[81,6,81,8],[151,2,151,8],[152,0,152,1],[152,2,152,8],[82,0,82,1],[82,2,82,4],[82,6,82,8],[83,0,83,1],[83,2,83,4],[83,6,83,8],[125,0,125,1],[125,2,125,4],[125,6,125,8],[126,0,126,1],[126,2,126,4],[126,6,126,8],[163,6,163,8],[86,9,86,17],[84,0,84,1],[84,2,84,8],[85,0,85,1],[85,2,85,8],[86,0,86,8],[148,0,148,1],[148,2,148,4],[148,6,148,8],[149,0,149,1],[149,6,149,8],[150,0,150,1],[150,2,150,4],[150,6,150,8],[151,0,151,1],[153,0,153,8],[153,9,153,17],[163,0,163,1],[163,2,163,4],[168,9,168,17],[166,0,166,1],[166,2,166,8],[167,0,167,1],[167,2,167,8],[168,0,168,8],[164,0,164,1],[164,2,164,4],[164,6,164,8],[165,0,165,1],[165,2,165,4],[165,6,165,8],[186,0,186,1],[186,2,186,8],[187,0,187,1],[187,2,187,8],[188,0,188,8],[188,9,188,17],[183,0,183,1],[183,2,183,4],[183,6,183,8],[184,0,184,1],[184,2,184,4],[184,6,184,8],[185,0,185,1],[185,2,185,4],[185,6,185,8]]}
[]
[]
[]
[]
[]
["I/F번호",null,"IF_01",null,null,"설명","브랜드 정보 송신"]
["송신시스템명",null,"온라인",null,null,"수신시스템명","TB_IF_Brand"]
["처리형태",null,"Batch",null,null,"I/F방식","JDBC"]
["발생빈도",null,"1일 1회"]
["비고"]
["송신",{"$nulls":8},"수신"]
["No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고","No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고"]
[null,"BRAND_NO","브랜드번호(WMS 연동용)",null,null,"int(10) unsigned",null,null,null,"1","BrandNo","브랜드 넘버","PK","N","int(4)","○"]
[null,"BRAND_ENM","브랜드영문명",null,null,"varchar(50)",null,null,null,"2","BrandName","브랜드 명",null,"N","nvarchar(100)","○"]
[{"$nulls":9},"3","BrandLogo","브랜드 로고",null,null,"nvarchar(100)","X"]
[{"$nulls":9},"4","BrandDescription","브랜드 정보",null,null,"nvarchar(2,000)","X"]
[null,"REG_DT","등록일시",null,null,"timestamp",null,null,null,"5","DateCreated","생성일",null,null,"datetime(8)","○"]
[null,"USE_YN","사용여부(Y:사용)",null,null,"char(1)",null,null,null,"6","StatusCd","상태",null,null,"nvarchar(20)","○",null,"Y:정상, N:사용안함"]
[{"$nulls":9},"7","MgmtBrandName","관리 브랜드 명",null,null,"nvarchar(100)","X"]
[{"$nulls":9},"8","FCategoryNo","카테고리 번호",null,null,"int(4)","X"]
[{"$nulls":9},"9","FCategoryName","카테고리 명",null,null,"nvarchar(50)","X"]
[{"$nulls":9},"10","LinkUrl","링크 주소",null,null,"nvarchar(200)","X"]
[{"$nulls":9},"11","BrandImage","이미지",null,null,"nvarchar(100)","X"]
[{"$nulls":9},"12","HTMLContents","내용",null,null,"text(16)","X"]
[null,"BRAND_CD","브랜드코드",null,null,"varchar(4)",null,null,null,"13"," BRAND_CD","브랜드코드",null,null,"nvarchar(4)","온라인용"]
[{"$nulls":9},"14","DateUpdated","수정일",null,null,"datetime(8)","온라인용"]
["I/F번호",null,"IF_02",null,null,"설명","업체 정보 송신"]
["송신시스템명",{"$nulls":4},"수신시스템명","TB_IF_Provider"]
["처리형태",null,"Batch",null,null,"I/F방식","JDBC"]
["발생빈도",null,"1일 1회"]
["비고"]
["송신",{"$nulls":8},"수신"]
["No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고","No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고"]
[null,"PROVIER_NO","ProvierNo(WMS)",null,null,"int(10) unsigned",null,null,null,"1","ProviderNo","공급처 번호","PK","N","int(4)","○"]
[{"$nulls":9},"2","VendorNo","협력사 번호",null,"N","int(4)","X",null,"기본값?"]
[null,"SUPPLY_COMP_NM","공급업체명",null,null,"varchar(100)",null,null,null,"3","ProviderName","공급처 명",null,"N","nvarchar(100)","○"]
[null,"SELL_FEE_RATE","판매수수료율",null,null,"float(5,2) unsigned",null,null,null,"4","MarginRate","마진율",null,null,"float(8)","X"]
[{"$nulls":9},"5","SaleMarginRate","세일마진율",null,null,"float(8)","X"]
[{"$nulls":9},"6","CategoryTypeCd","분류코드",null,null,"nvarchar(50)","○",null,"품목 or 전신카테"]
[null,"DISTRIBUTION_GB","유통구분(공콩코드 G065)",null,null,"varchar(20)",null,null,null,"7","DistributionCd","유통구분",null,null,"nvarchar(50)","○"]
[null,"SETTLE_DAY","정산일(공통코드G075)",null,null,"varchar(20)",null,null,null,"8","SettleTypeCd","정산주기",null,null,"nvarchar(20)","X"]
[null,"CS_CHARGE_NM","CS담당자명",null,null,"varchar(50)",null,null,null,"9","CSChargeName","CS담당자명",null,null,"nvarchar(20)","X"]
[null,"CS_CHARGE_TELNO","CS담당자전화번호",null,null,"varchar(20)",null,null,null,"10","CSChargeTelNum","CS담당자 전화번호",null,null,"nvarchar(20)","X"]
[null,"SETTLE_CHARGE_NM","정산담당자명",null,null,"varchar(50)",null,null,null,"11","SettleChargeName","정산담당자명",null,null,"nvarchar(20)","X"]
[null,"SETTLE_CHARGE_TELNO","정산담당자전화번호",null,null,"varchar(20)",null,null,null,"12","SettleChargeTelNum","정산담당자 전화번호",null,null,"nvarchar(20)","X"]
[{"$nulls":9},"13","SettleChargeCellNum","정산담당자 핸드폰",null,null,"nvarchar(20)","X"]
[null,"SETTLE_CHARGE_EMAIL","정산담당자이메일",null,null,"varchar(100)",null,null,null,"14","SettleChargeEmail","정산담당자 이메일",null,null,"nvarchar(100)","X"]
[null,"ACCOUNT_NO","계좌번호",null,null,"varchar(20)",null,null,null,"15","BankAccountInfo","은행계좌정보",null,null,"nvarchar(200)","X"]
[{"$nulls":9},"16","ChargeName","처리담당자 이름",null,null,"nvarchar(20)","○",null,null,"md 문의"]
[{"$nulls":9},"17","ChargeTelNum","처리담당자 전화번호",null,null,"nvarchar(20)","X"]
[{"$nulls":9},"18","ChargeCellNum","처리담당자 핸드폰",null,null,"nvarchar(20)","○"]
[{"$nulls":9},"19","ChargeEmail","처리담당자 이메일",null,null,"nvarchar(100)","X"]
[null,"RTN_LOC_ZIPCODE","반품처우편번호",null,null,"varchar(6)",null,null,null,"20","ReturnPostalCode","반송처 우편번호",null,null,"char(10)","X"]
[null,"RTN_LOC_BASE_ADDR","반품처기본주소",null,null,"varchar(200)",null,null,null,"21","ReturnAddr1","반송처 주소",null,null,"nvarchar(100)","X"]
[null,"RTN_LOC_DTL_ADDR","반품처상세주소",null,null,"varchar(200)",null,null,null,"22","ReturnAddr2","반송처 상세 주소",null,null,"nvarchar(100)","X"]
[null,"REG_NO","등록자번호",null,null,"int(10) unsigned",null,null,null,"23","UserIdCreatedBy","등록자 아이디",null,null,"nvarchar(50)","X"]
[null,"USER_NM","사용자명",null,null,"varchar(50)",null,null,null,"24","UserNameCreatedBy","등록자 명",null,null,"nvarchar(50)","X"]
[null,"REG_DT","등록일시",null,null,"timestamp",null,null,null,"25","DateCreated","생성일",null,null,"datetime(8)","X"]
[null,"UPD_DT","수정일시",null,null,"timestamp",null,null,null,"26","DateLastModified","수정일",null,null,"datetime(8)","X"]
[null,"USE_YN","사용여부(Y:사용)",null,null,"char(1)",null,null,null,"27","StatusCd","상태",null,"N","nvarchar(20)","○",null,"Y:정상\nN:사용중지\n대기(미사용)"]
[null,"USER_ID","사용자ID",null,null,"varchar(20)",null,null,null,"28","SCMLoginId","SCM 로그인 아이디",null,null,"nvarchar(50)","X"]
[null,"PASSWD","비밀번호",null,null,"varchar(200)",null,null,null,"29","SCMPwd","SCM 비밀번호",null,null,"nvarchar(100)","X"]
[{"$nulls":9},"30","ChannelId","채널 ID",null,null,"nvarchar(50)","X"]
[null,"ECONTRACT_YN","전자계약여부",null,null,"char(1)",null,null,null,"31","IsBillTrans","전자세금계산서 사용 구분",null,null,"bit(1)","X"]
[{"$nulls":9},"32","AdminMemo","관리자 메모",null,null,"nvarchar(1,000)","X"]
[{"$nulls":9},"33","StockMgmtTypeCd","재고관리 유형",null,null,"nvarchar(10)","○",null,"WMS\nVENDOR\nSCM\nYES24","wms먼, 자사 업체만"]
[{"$nulls":10},"ReturnAddrNew",null,null,null,"nvarchar(100)",null,null,"dev 에는 존재 \n테이블에 존재하는지 확인"]
[null,"SUPPLY_COMP_CD","공급업체코드(공급업체)",null,null,"varchar(20)",null,null,null,"34","SUPPLY_COMP_CD","공급업체코드(공급업체)",null,null,"nvarchar(20)","온라인용"]
["I/F번호",null,"IF_03",null,null,"설명","브랜드업체관계정보 송신"]
["송신시스템명",{"$nulls":4},"수신시스템명","TB_IF_BrandProviderXref"]
["처리형태",null,"Batch",null,null,"I/F방식","JDBC"]
["발생빈도",null,"1회/일"]
["비고"]
["송신",{"$nulls":8},"수신"]
["No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고","No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고"]
[null,"BRAND_NO","브랜드번호(WMS 연동용)",null,null,"int(10) unsigned",null,null,null,"1","BrandNo","브랜드 넘버",null,"N","int(4)","○"]
[null,"PROVIER_NO","ProvierNo(WMS)",null,null,"int(10) unsigned",null,null,null,"2","ProviderNo","공급처 넘버",null,"N","int(4)","○"]
[null,"BRAND_CD","브랜드코드",null,null,"varchar(4)",null,null,null,"3","BRAND_CD","브랜드코드",null,null,"nvarchar(4)","온라인용"]
[null,"SUPPLY_COMP_CD","공급업체코드(공급업체)",null,null,"varchar(20)",null,null,null,"4","SUPPLY_COMP_CD","공급업체코드(공급업체)",null,null,"nvarchar(20)","온라인용"]
[{"$nulls":10},"DateCreated","생성일",null,null,"datetime(8)","온라인용"]
[{"$nulls":10},"DateUpdated","수정일",null,null,"datetime(8)","온라인용"]
["I/F번호",null,"IF_04",null,null,"설명","상품정보 송신"]
["송신시스템명",{"$nulls":4},"수신시스템명","TB_IF_Product"]
["처리형태",null,"Batch",null,null,"I/F방식","JDBC"]
["발생빈도",null,"1회/일"]
["비고"]
["송신",{"$nulls":8},"수신"]
["No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고","No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고"]
[null,"PRODUCT_NO","ProductNo(WMS)",null,null,"int(10) unsigned",null,null,null,"1","ProductNo","상품 번호","PK",null,"int(4)","○",null,"WMS 생성"]
[null,"PRODUCT_CODE","ProductCode(WMS)",null,null,"int(10) unsigned",null,null,null,"2","ProductCode","상품 코드","U",null,"nvarchar(50)","○",null,"WMS 생성"]
[{"$nulls":9},"3","CategoryNo","카테고리 번호",null,null,"int(4)","X"]
[null,"GOODS_NM","상품명",null,null,"varchar(200)",null,null,null,"4","ProductName","상품명",null,null,"nvarchar(255)","○",null,"WMS 생성"]
[null,"GOODS_NUM","품번(자사상품만 사용)",null,null,"varchar(20)",null,null,null,"5","Model (품번)","모델명",null,null,"nvarchar(50)","○",null,"미생성"]
[{"$nulls":9},"6","ModelNo","모델번호",null,null,"nvarchar(50)","○",null,"WMS 생성"]
[{"$nulls":9},"7","Manufacture","제조원",null,null,"nvarchar(50)","X",null,"WMS 생성"]
[null,"ORIGIN_CD","원산지코드(공통코드G076)",null,null,"varchar(20)",null,null,null,"8","Origin","원산지",null,null,"nvarchar(20)","X"]
[null,"SEASON_CD","시즌코드(공통코드G006)",null,null,"varchar(20)",null,null,null,"9","SeasonCd","시즌구분",null,null,"nvarchar(20)","X"]
[null,"SEX_GB","성별구분(공통코드G007)",null,null,"varchar(20)",null,null,null,"10","SexualTypeCd","성별구분",null,null,"nvarchar(20)","X"]
[null,"BRAND_NO","브랜드번호(WMS 연동용)",null,null,"int(10) unsigned",null,null,null,"11","BrandNo","브랜드 번호",null,null,"int(4)","○",null,"WMS 생성"]
[null,"BRAND_ENM","브랜드영문명",null,null,"varchar(50)",null,null,null,"12","BrandName","브랜드 명",null,null,"nvarchar(50)","○"]
[null,"PROVIER_NO","ProvierNo(WMS)",null,null,"int(10) unsigned",null,null,null,"13","ProviderNo","공급처 번호",null,null,"int(4)","○",null,"WMS 생성"]
[{"$nulls":9},"14","MdNo",null,null,null,"int(4)","X"]
[null,"DISTRIBUTION_GB","유통구분(공콩코드 G065)",null,null,"varchar(20)",null,null,null,"15","DistributionCd","유통구분",null,null,"nvarchar(20)","X",null,"WMS 생성"]
[{"$nulls":9},"16","DeliveryUnitNo","물류단위 번호",null,null,"int(4)","X"]
[null,"RETURNABLE_YN","반품가능여부",null,null,"char(1)",null,null,null,"17","ReturnTypeCd","반품구분",null,null,"nvarchar(20)","X"]
[null,"REG_DT","등록일시",null,null,"timestamp",null,null,null,"18","DateSystemRegister","시스템 등록 일자",null,null,"datetime(8)","X"]
[null,"UPD_DT","수정일시",null,null,"timestamp",null,null,null,"19","DateLastModified","수정일",null,null,"datetime(8)","X"]
[null,"GOODS_STAT","상품상태(공통코드G008)",null,null,"varchar(20)",null,null,null,"20","StatusCd","관리 상태",null,null,"nvarchar(20)","○",null,"반출지시\n삭제 : G008_99\n입고완료\n판매중 : G008_90\n판매중지 => 시즌아웃 명칭 변경 사용\n품절 : G008_70\n승인보류 : G008_20\n승인대기 : G008_40"]
[{"$nulls":9},"21","SellingStatusCd","판매 상태",null,null,"nvarchar(20)","X"]
[null,"TAX_GB","과세구분(10:과세, 20:비과세)",null,null,"varchar(2)",null,null,null,"22","TaxTypeCd","과세 유형",null,null,"nvarchar(20)","X"]
[null,"GOODS_TYPE","상품타입(공통코드G056)",null,null,"varchar(20)",null,null,null,"23","ProductTypeCd","상품 타입",null,null,"nvarchar(20)","○",null,"일반 : 사용\n신규 : 미사용\n\n세트 : 미사용\n사은품 : 미사용"]
[null,"FORMAL_GB","정상이월구분(공통코드G009)",null,null,"varchar(20)",null,null,null,"24","CarryOverTypeCd","이월 상품 구분",null,null,"nvarchar(20)","X"]
[{"$nulls":9},"25","RelationProducts","연관상품 등록번호",null,null,"nvarchar(100)","X"]
[null,"GOODS_SNM","상품검색명",null,null,"varchar(4000)",null,null,null,"26","Searchkeyword","검색어",null,null,"nvarchar(255)","X"]
[{"$nulls":9},"27","AdminMemo","관리자 메모",null,null,"nvarchar(500)","X"]
[null,"REG_NO","등록자번호",null,null,"int(10) unsigned",null,null,null,"28","UserIdCreatedBy","생성자ID",null,null,"nvarchar(50)","X"]
[null,"USER_NM","사용자명",null,null,"varchar(50)",null,null,null,"29","UserNameCreatedBy","생성자 이름",null,null,"nvarchar(50)","X"]
[null,"UPD_NO","수정자번호",null,null,"int(10) unsigned",null,null,null,"30","UserIdUpdatedBy","수정자 ID",null,null,"nvarchar(50)","X"]
[null,"USER_NM","사용자명",null,null,"varchar(50)",null,null,null,"31","UserNameUpdatedBy","수정자 이름",null,null,"nvarchar(50)","X"]
[null,"SUPPLY_GOODS_CD","공급업체상품코드(원코드)",null,null,"varchar(20)",null,null,null,"32","VendorProductCode","업체상품코드",null,null,"nvarchar(50)","○",null,null,"문의"]
[{"$nulls":9},"33","SKUCode88","88코드",null,null,"nvarchar(13)","○",null,"WMS에서 생성","미 적용"]
[null,"GOODS_CD","상품코드",null,null,"varchar(20)",null,null,null,"34","GOODS_CD","상품코드",null,null,"varchar(20)","온라인용"]
[null,"BRAND_CD","브랜드코드",null,null,"varchar(4)",null,null,null,"35","BRAND_CD","브랜드코드",null,null,"nvarchar(4)","온라인용"]
[null,"SUPPLY_COMP_CD","공급업체코드(공급업체)",null,null,"varchar(20)",null,null,null,"36","SUPPLY_COMP_CD","공급업체코드(공급업체)",null,null,"nvarchar(20)","온라인용"]
[null,"SYS_IMG_NM","상품이미지",null,null,"varchar(200)",null,null,"대표색상의 대표이미지","37","SYS_IMG_NM","상품이미지",null,null,"nvarchar(200)",null,null,"//image.style24.com/Upload/ProductImage 제외, / 제외"]
["I/F번호",{"$nulls":4},"설명","옵션및 재고 수신"]
["송신시스템명",{"$nulls":4},"수신시스템명","TB_IF_ProductSKU"]
["처리형태",null,"Batch",null,null,"I/F방식","JDBC"]
["발생빈도",null,"1회/시"]
["비고"]
["송신",{"$nulls":8},"수신"]
["No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고","No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고"]
[null,"SKUCode","옵션 코드","PK",null,"nvarchar(50)",{"$nulls":4},"SKUCode","옵션 코드","PK",null,"varchar(50)"]
[null,"SKUModelNo","옵션 모델 번호",null,null,"nvarchar(50)",{"$nulls":4},"SKUModelNo","옵션 모델 번호",null,null,"varchar(50)"]
[null,"ProductNo","상품 번호","FK",null,"int(4)",{"$nulls":4},"ProductNo","상품 번호",null,null,"int(4)"]
[null,"ProductCode","상품 코드",null,null,"nvarchar(50)",{"$nulls":4},"ProductCode","상품 코드",null,null,"varchar(50)"]
[null,"Option1","옵션1(색상)",null,null,"nvarchar(50)",{"$nulls":4},"Option1","옵션1(색상)",null,null,"varchar(50)"]
[null,"Option2","옵션2(사이즈)",null,null,"nvarchar(50)",{"$nulls":4},"Option2","옵션2(사이즈)",null,null,"varchar(50)"]
[null,"Option3","옵션3(스타일)",null,null,"nvarchar(50)",{"$nulls":4},"Option3","옵션3(스타일)",null,null,"varchar(50)",null,null,"미사용"]
[null,"SellingStockAmount","판매재고수량",null,null,"int(4)",{"$nulls":4},"SellingStockAmount","판매재고수량",null,null,"int(4)"]
[null,"SellingStockTypeCd","판매재고유형",null,null,"nvarchar(20)",{"$nulls":4},"SellingStockTypeCd","판매재고유형",null,null,"varchar(20)"]
[null,"LimitStockAmount",null,null,null,"int(4)",{"$nulls":4},"LimitStockAmount",null,null,null,"int(4)"]
[null,"VendorSKUModelNo","업체옵션모델번호",null,null,"nvarchar(50)",{"$nulls":4},"VendorSKUModelNo","업체옵션모델번호",null,null,"varchar(50)"]
[null,"VendorSKUCode","업체옵션코드",null,null,"nvarchar(50)",{"$nulls":4},"VendorSKUCode","업체옵션코드",null,null,"varchar(50)"]
[null,"IsVirtualStock",null,null,null,"bit(1)",{"$nulls":4},"IsVirtualStock",null,null,null,"bit(1)"]
[null,"DateVirtualStock",null,null,null,"datetime(8)",{"$nulls":4},"DateVirtualStock",null,null,null,"timestamp"]
[null,"SKUCode88","88코드",null,null,"nvarchar(13)",{"$nulls":4},"SKUCode88","88코드",null,null,"varchar(13)"]
[{"$nulls":10},"UPD_DT","수정일",null,null,"timestamp"]
["I/F번호",null,"IF_05",null,null,"설명","입고정보 수신"]
["송신시스템명",{"$nulls":4},"수신시스템명","TB_IF_IncomeLot"]
["처리형태",null,"Batch",null,null,"I/F방식","JDBC"]
["발생빈도",null,"1회/일"]
["비고",null,"02시 이후 스케쥴 등록"]
["송신",{"$nulls":8},"수신"]
["No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고","No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고"]
[null,"LotNo","입고 번호","PK",null,"bigint(8)",null,null,null,"1","LotNo","입고 번호","PK",null,"int(10) unsigned"]
[null,"PurchaseNo","발주 번호",null,null,"int(4)",null,null,null,"2","PurchaseNo","발주 번호",null,null,"int(10) unsigned"]
[null,"ProviderNo","공급처 번호",null,null,"int(4)",null,null,null,"3","ProviderNo","공급처 번호",null,null,"int(10) unsigned"]
[null,"ProviderName","공급처 명",null,null,"nvarchar(255)",null,null,null,"4","ProviderName","공급처 명",null,null,"varchar(100)"]
[null,"BrandNo","브랜드 번호",null,null,"int(4)",null,null,null,"5","BrandNo","브랜드 번호",null,null,"int(10) unsigned"]
[null,"BrandName","브랜드 명",null,null,"nvarchar(255)",null,null,null,"6","BrandName","브랜드 명",null,null,"varchar(100)"]
[null,"DateIncome","생성일",null,null,"datetime(8)",null,null,null,"7","DateIncome","생성일",null,null,"timestamp"]
[{"$nulls":9},"8","UPD_DT","수정일",null,null,"timestamp"]
["I/F번호",null,"IF_05",null,null,"설명","입고상품정보 수신"]
["송신시스템명",{"$nulls":4},"수신시스템명","TB_IF_IncomeLotItem"]
["처리형태",null,"Batch",null,null,"I/F방식","JDBC"]
["발생빈도",null,"1회/일"]
["비고",null,"02시 이후 스케쥴 등록"]
["송신",{"$nulls":8},"수신"]
["No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고","No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고"]
["1","LotNo","입고 번호","PK",null,"bigint(8)",null,null,null,"1","LotNo","입고 번호","PK",null,"int(10) unsigned"]
["2","ItemNo","입고 항목 번호","PK",null,"bigint(8)",null,null,null,"2","ItemNo","입고 항목 번호","PK",null,"int(10) unsigned"]
["3","WMSItemNo",null,null,null,"int(4)",null,null,null,"3","WMSItemNo",null,null,null,"int(10) unsigned"]
["4","DateIncome","생성일",null,null,"datetime(8)",null,null,null,"4","DateIncome",null,null,null,"int(10) unsigned"]
["5","ProductNo","상품 번호",null,null,"nvarchar(50)",null,null,null,"5","ProductNo","상품 번호",null,null,"varchar(50)"]
["6","ProductCode","상품 코드",null,null,"nvarchar(255)",null,null,null,"6","ProductCode","상품 코드",null,null,"varchar(255)"]
["7","ProductName","상품 명",null,null,"nvarchar(20)",null,null,null,"7","ProductName","상품 명",null,null,"varchar(20)"]
["8","SKUCode","옵션 코드",null,null,"nvarchar(50)",null,null,null,"8","SKUCode","옵션 코드",null,null,"int(10) unsigned"]
["9","NormalQty","일반 수량",null,null,"nvarchar(100)",null,null,null,"9","NormalQty","일반 수량",null,null,"smallint(5) unsigned"]
["10","BrokenQty","불량 수량",null,null,"money(8)",null,null,null,"10","BrokenQty","불량 수량",null,null,"smallint(5) unsigned"]
["11","TotalQty","총 수량",null,null,"int(4)",null,null,null,"11","TotalQty","총 수량",null,null,"smallint(5) unsigned"]
["12","ModelNo","모델번호",null,null,"nvarchar(50)",null,null,"추기","12","ModelNo","모델번호",null,null,"nvarchar(50)"]
[{"$nulls":9},"13","UPD_DT","수정일",null,null,"timestamp"]
["I/F번호",null,"IF_06",null,null,"설명","실측사이즈정보"]
["송신시스템명",{"$nulls":4},"수신시스템명","TB_IF_Measurement"]
["처리형태",null,"Batch",null,null,"I/F방식","JDBC"]
["발생빈도",null,"1회/일"]
["비고"]
["송신",{"$nulls":8},"수신"]
["No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고","No","필드","필드명","PK","NULL","타입자릿수","기타","엔티티명","비고"]
["1","SKUCode","옵션 번호","PK",null,"nvarchar(50)",null,null,null,"1","SKUCode","옵션 번호","PK",null,"int(10) unsigned"]
["2","ProductNo","상품 번호",null,null,"int(4)",null,null,null,"2","ProductNo","상품 번호",null,null,"int(10) unsigned"]
["3","ProductCode","상품 코드",null,null,"nvarchar(50)",null,null,null,"3","ProductCode","상품 코드",null,null,"varchar(50)"]
["4","TypeCd","상하의 타입",null,null,"nvarchar(20)",null,null,"상의, 하의","4","TypeCd","상하의 타입","PK",null,"varchar(20)",null,null,"상의 / 하의"]
["5","WashingMethod","세탁방법",null,null,"nvarchar(50)",null,null,null,"5","WashingMethod","세탁방법",null,null,"varchar(50)"]
["6","Value1","치수 1",null,null,"decimal(9)",null,null,null,"6","Value1","치수 1",null,null,"int(10) unsigned",null,null,"가슴둘레/허리둘레"]
["7","Value2","치수 2",null,null,"decimal(9)",null,null,null,"7","Value2","치수 2",null,null,"int(10) unsigned",null,null,"어깨너비/밑위"]
["8","Value3","치수 3",null,null,"decimal(9)",null,null,null,"8","Value3","치수 3",null,null,"int(10) unsigned",null,null,"팔길이/엉덩이둘레"]
["9","Value4","치수 4",null,null,"decimal(9)",null,null,null,"9","Value4","치수 4",null,null,"int(10) unsigned",null,null,"총길이/허벅지둘레"]
["10","Value5","치수 5",null,null,"decimal(9)",null,null,null,"10","Value5","치수 5",null,null,"int(10) unsigned",null,null,"    /총길이"]
["11","Memo","메모",null,null,"nvarchar(1,000)",null,null,null,"11","Memo","메모",null,null,"varchar(1000)"]
["12","DateInserted","생성일",null,null,"datetime(8)",null,null,null,"12","DateInserted","WMS등록일",null,null,"timestamp"]
["13","DateLastModified","수정일",null,null,"datetime(8)",null,null,null,"13","DateLastModified","WMS수정일",null,null,"timestamp"]
["14","IsUse","사용여부",null,null,"bit(1)",null,null,"1 : 사용, 0 미사용","14","IsUse","사용여부",null,null,"CHAR(1)",null,null,"Y : 1, N : 0"]
["15","UserLastModified","수정자",null,null,"int(4)",null,null,null,"15","UserLastModified","WMS수정자",null,null,"int(10) unsigned"]
[{"$nulls":9},"16","UPD_DT","수정일",null,null,"timestamp"]

{"sheet":"Sheet1","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,3,0],[4,0,5,0],[6,0,8,0]]}
["테이블","항목","AS-IS","TO_BE"]
["TB_IF_Provider","CategoryTypeCd","공통 테이블에 세팅되어 있습니다. \nselect top 100 * from iSTYLE24_mall.dbo.TB_SYS_SystemCode with(nolock)\nwhere FieldName = 'CategoryTypeCd' and tableName = 'TB_ven_Provider'","전시 대분류(1엡스)","(정지혜과장 확인)"]
[null,"ChargeName ","데이터 확인해보니 chargename과 settlechargename이 다른 경우가 있어 정산 담당자로 입력하면 안됩니다 ",null,"김덕규 이사님 협의 후 진행"]
[null,"DistributionCd","제휴\n자사\n입점\n사업\n위탁\n구매대행","G065_10 자사-제조 => 자사\nG065_11 자사-사입 => 사입\nG065_12 자사-위탁 => 위탁\nG065_20 입점-위탁 => 입점","(정지혜과장 확인)"]
["TB_IF_Product","StatusCd","반출지시 총 4102건 확인됩니다. \n2015년 위탁 4건 \n2012년~2013년 사입 \n2006년~2008년 위탁","반출지시 미적용","반출지시 의미\n미사용처리로 해도 되는지 =>  ok (정지혜과장 확인)"]
[null,"VendorProductCode ","2011년 이전 데이터에 존재합니다. (총 7904건)\nTB_CAT_Product.statuscd = 삭제 \nTB_CAT_Product.SellingStatusCd = ‘화장품등록’","null 처리","슬로우에서 사용컬럼"]
["TB_IF_ProductSKU","LimitStockAmount ","mall에서 넘기고 있음(0이나 -1으로 세팅값고정되는 경우 있음)","0처리","슬로우에서 미사용컬럼"]
[null,"IsVirtualStock","mall에서 안넘기고 있음, 2011년 이전 데이터만 존재","0 처리","슬로우에서 사용컬럼"]
[null,"DateVirtualStock","mall에서 안넘기고 있음, 2011년 이전 데이터만 존재"]
["TB_IF_Measurement","Value1 ~ Value5","상의 \n가슴둘레 : value1 \n어깨너비 : Value2 \n팔길이 : Value3 \n총길이 : value4 \n\n하의 \n허리둘레 : value1 \n밑위 :value2 \n엉덩이둘레: value3 \n허벅지둘레: value4 \n총길이 : value5","동일처리"]