{"text_format":"2","workbook":"xlsx","n_sheets":19,"sheets":["TB_IF_Brand","TB_IF_BrandProviderXref","TB_IF_Provider","TB_IF_DeliveryException","TB_IF_DeliveryExceptionItem","TB_IF_DeliveryOrder","TB_IF_DeliveryOrderItem","TB_IF_IncomeLot","TB_IF_IncomeLotItem","TB_IF_Measurement","TB_IF_OrderAllocStock","TB_IF_Product","TB_IF_ProductSKU","TB_IF_SetProduct","TB_IF_PurchaseOrder","TB_IF_PurchaseOrderBrand_Xref","TB_IF_RecallDelivery","TB_IF_RecallDeliveryItem","TB_IF_DailyDeliveryZone"],"not_rendered":{"charts":0,"images":0,"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":"TB_IF_Brand","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","BrandNo","브랜드 넘버","int",4]
[null,"BrandName","브랜드 명","nvarchar",100]
[null,"BrandLogo","브랜드 로고","nvarchar",100]
[null,"BrandDescription","브랜드 정보","nvarchar",2000]
[null,"DateCreated","생성일","datetime",8]
[null,"StatusCd","상태","nvarchar",20]
[null,"MgmtBrandName","관리 브랜드 명","nvarchar",100]
[null,"FCategoryNo","카테고리 번호","int",4]
[null,"FCategoryName","카테고리 명","nvarchar",50]
[null,"LinkUrl","링크 주소","nvarchar",200]
[null,"BrandImage","이미지","nvarchar",100]
[null,"HTMLContents","내용","text",16]

{"sheet":"TB_IF_BrandProviderXref","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
[null,"BrandNo","브랜드 넘버","int",4]
[null,"ProviderNo","공급처 넘버","int",4]

{"sheet":"TB_IF_Provider","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","ProviderNo","공급처 번호","int",4]
[null,"VendorNo","협력사 번호","int",4]
[null,"ProviderName","공급처 명","nvarchar",100]
[null,"MarginRate","마진율","float",8]
[null,"SaleMarginRate","세일마진율","float",8]
[null,"CategoryTypeCd","분류코드","nvarchar",50]
[null,"DistributionCd","유통구분","nvarchar",50]
[null,"SettleTypeCd","정산주기","nvarchar",20]
[null,"CSChargeName","CS담당자명","nvarchar",20]
[null,"CSChargeTelNum","CS담당자 전화번호","nvarchar",20]
[null,"SettleChargeName","정산담당자명","nvarchar",20]
[null,"SettleChargeTelNum","정산담당자 전화번호","nvarchar",20]
[null,"SettleChargeCellNum","정산담당자 핸드폰","nvarchar",20]
[null,"SettleChargeEmail","정산담당자 이메일","nvarchar",100]
[null,"BankAccountInfo","은행계좌정보","nvarchar",200]
[null,"ChargeName","처리담당자 이름","nvarchar",20]
[null,"ChargeTelNum","처리담당자 전화번호","nvarchar",20]
[null,"ChargeCellNum","처리담당자 핸드폰","nvarchar",20]
[null,"ChargeEmail","처리담당자 이메일","nvarchar",100]
[null,"ReturnPostalCode","반송처 우편번호","char",10]
[null,"ReturnAddr1","반송처 주소","nvarchar",100]
[null,"ReturnAddr2","반송처 상세 주소","nvarchar",100]
[null,"UserIdCreatedBy","등록자 아이디","nvarchar",50]
[null,"UserNameCreatedBy","등록자 명","nvarchar",50]
[null,"DateCreated","생성일","datetime",8]
[null,"DateLastModified","수정일","datetime",8]
[null,"StatusCd","상태","nvarchar",20]
[null,"SCMLoginId","SCM 로그인 아이디","nvarchar",50]
[null,"SCMPwd","SCM 비밀번호","nvarchar",100]
[null,"ChannelId","채널 ID","nvarchar",50]
[null,"IsBillTrans","전자세금계산서 사용 구분","bit",1]
[null,"AdminMemo","관리자 메모","nvarchar",1000]
[null,"StockMgmtTypeCd","재고관리 유형","nvarchar",10]
[null,"ReturnAddrNew","반송처 도로명 주소","nvarchar",100]

{"sheet":"TB_IF_DeliveryException","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","DeliveryExceptionNo","배송 예외 번호","bigint",8]
[null,"DeliveryOrderNo","배송 주문 번호","bigint",8]
[null,"StatusCd","상태","nvarchar",20]
[null,"AdminMemo","관리자 메모","nvarchar",2000]
[null,"UserIdCreated","생성자 아이디","nvarchar",50]
[null,"UserNameCreated","생성자 이름","nvarchar",50]
[null,"DateCreated","생성일","datetime",8]
[null,"UserIdModified","수정자 아이디","nvarchar",50]
[null,"UserNameModified","수정자 이름","nvarchar",50]
[null,"DateLastModified","수정일","datetime",8]

{"sheet":"TB_IF_DeliveryExceptionItem","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","DeliveryExceptionItemNo","배송 예외 항목 번호","bigint",8]
[null,"IFDeliveryExceptionItemNo",null,"bigint",8]
["FK","DeliveryExceptionNo","배송 예외 번호","bigint",8]
[null,"DeliveryOrderItemNo","주문 항목 번호","bigint",8]
[null,"ExceptionQty","예외 수량","int",4]
[null,"ReasonCd","사유","nvarchar",20]
[null,"IFDeliveryOrderItemNo",null,"bigint",8]

{"sheet":"TB_IF_DeliveryOrder","index":5,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","DeliveryOrderNo","배송 번호","bigint",8]
[null,"OrderGUID","주문서 고유번호","uniqueidentifier",16]
[null,"OrderNo","주문번호","bigint",8]
[null,"DeliveryTypeCd","배송타입형태","nvarchar",20]
[null,"IssueTypeCd","주문타입","nvarchar",20]
[null,"DeliveryUnitNo","물류단위 번호","int",4]
[null,"DateIssued","배송 데이터 수집일","datetime",8]
[null,"DateReceived","접수일","datetime",8]
[null,"DateSent","상품 발송 일","datetime",8]
[null,"StatusCd","배송 상태","nvarchar",20]
[null,"LoginId","로그인 아이디","nvarchar",50]
[null,"CustomerName","주문자 명","nvarchar",50]
[null,"DateOrdered","주문 일","datetime",8]
[null,"Grade","회원 등급","nvarchar",20]
[null,"Receiver","주문자","nvarchar",50]
[null,"ReceiverTelNum","주문자 전화번호","nvarchar",20]
[null,"ReceiverCellNum","주문자 핸드폰 번호","nvarchar",20]
[null,"DeliveryPostalCode","우편번호","char",10]
[null,"DeliveryAddr1","기본 주소","nvarchar",100]
[null,"DeliveryAddr2","상세 주소","nvarchar",100]
[null,"LogisticsNo","택배사 고유번호","int",4]
[null,"LogisticsName","택배사 명","nvarchar",100]
[null,"DeliveryMemo","배송 메모","nvarchar",1000]
[null,"ProductSummary","상품명","nvarchar",500]
[null,"ExceptionDesc","배송 예외 설명","nvarchar",255]
[null,"IsCancel","배송 취소 여부","bit",1]
[null,"IsChangeAddress","배송지 변경 여부","bit",1]
[null,"IsReOrder","재주문 여부","bit",1]
[null,"IsTransferCompleted",null,"bit",1]
[null,"OrderPath","주문 경로","char",2]
[null,"DeliveryClassCd","배송 형태 (당일)","nvarchar",20]
[null,"ShippingTypeCd","출고 구분","nvarchar",20]
[null,"ExchangeNo","배송 예외 번호","int",4]
[null,"IsBeautyDelivery","선물 포장 여부","bit",1]
[null,"VendorOrderNo",null,"nvarchar",50]
[null,"DeliveryAddrNew","도로명 주소","nvarchar",100]

{"sheet":"TB_IF_DeliveryOrderItem","index":6,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","DeliveryOrderItemNo","주문서 항목 고유 번호","bigint",8]
["FK","DeliveryOrderNo","주문서 고유번호","bigint",8]
[null,"ProviderNo","공급자 번호","int",4]
[null,"ProductNo","상품 번호","int",4]
[null,"ProductCode","상품 코드","nvarchar",50]
[null,"ProductName","상품 명","nvarchar",255]
[null,"ProductTypeCd","상품 타입","nvarchar",20]
[null,"SKUCode","옵션 코드","nvarchar",50]
[null,"SKUValue","옵션 값","nvarchar",100]
[null,"UnitPrice","단가","money",8]
[null,"SetProductNo","세트상품 번호","int",4]
[null,"Qty","수량","int",4]
[null,"StatusCd","배송상태","nvarchar",20]
[null,"DateReceived","접수일","datetime",8]
[null,"DateSent","상품발송일","datetime",8]
[null,"DateCompleted","배송완료일","datetime",8]
[null,"DateLastModified","수정일","datetime",8]
[null,"ExceptionDesc","예외","nvarchar",500]
[null,"IsCancel","취소","bit",1]
[null,"VendorProductCode",null,"nvarchar",50]
[null,"VendorSKUCode",null,"nvarchar",50]
[null,"VendorSKUModelNo",null,"nvarchar",50]
[null,"StockMgmtTypeCd","재고관리 타입","nvarchar",50]

{"sheet":"TB_IF_IncomeLot","index":7,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","LotNo","입고 번호","bigint",8]
[null,"PurchaseNo","발주 번호","int",4]
[null,"ProviderNo","공급처 번호","int",4]
[null,"ProviderName","공급처 명","nvarchar",255]
[null,"BrandNo","브랜드 번호","int",4]
[null,"BrandName","브랜드 명","nvarchar",255]
[null,"DateIncome","생성일","datetime",8]

{"sheet":"TB_IF_IncomeLotItem","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","LotNo","입고 번호","bigint",8]
["PK","ItemNo","입고 항목 번호","bigint",8]
[null,"WMSItemNo",null,"int",4]
[null,"DateIncome","입고 번호","int",4]
[null,"ProductNo","상품 번호","nvarchar",50]
[null,"ProductCode","상품 코드","nvarchar",255]
[null,"ProductName","상품 명","nvarchar",20]
[null,"SKUCode","옵션 코드","nvarchar",50]
[null,"NormalQty","일반 수량","nvarchar",100]
[null,"BrokenQty","불량 수량","money",8]
[null,"TotalQty","총 수량","int",4]

{"sheet":"TB_IF_Measurement","index":9,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","SKUCode","옵션 번호","nvarchar",50]
[null,"ProductNo","상품 번호","int",4]
[null,"ProductCode","상품 코드","nvarchar",50]
[null,"TypeCd","상하의 타입","nvarchar",20]
[null,"WashingMethod","세탁방법","nvarchar",50]
[null,"Value1","치수 1","decimal",9]
[null,"Value2","치수 2","decimal",9]
[null,"Value3","치수 3","decimal",9]
[null,"Value4","치수 4","decimal",9]
[null,"Value5","치수 5","decimal",9]
[null,"Memo","메모","nvarchar",1000]
[null,"DateInserted","생성일","datetime",8]
[null,"DateLastModified","수정일","datetime",8]
[null,"IsUse","사용여부","bit",1]
[null,"UserLastModified","수정자","int",4]

{"sheet":"TB_IF_OrderAllocStock","index":10,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","ProductCode","상품 코드","nvarchar",50]
["PK","SKUCode","옵션 코드","nvarchar",50]
[null,"ProductNo","상품 번호","int",4]
[null,"PreAllocQty",null,"int",4]
[null,"AllocQty","자사 수량","int",4]
[null,"IfQty","제휴 수량","int",4]

{"sheet":"TB_IF_Product","index":11,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","ProductNo","상품 번호","int",4]
["U","ProductCode","상품 코드","nvarchar",50]
[null,"CategoryNo","카테고리 번호","int",4]
[null,"ProductName","상품명","nvarchar",255]
[null,"Model","모델명","nvarchar",50]
[null,"ModelNo","모델번호","nvarchar",50]
[null,"Manufacture","제조원","nvarchar",50]
[null,"Origin","원산지","nvarchar",20]
[null,"SeasonCd","시즌구분","nvarchar",20]
[null,"SexualTypeCd","성별구분","nvarchar",20]
[null,"BrandNo","브랜드 번호","int",4]
[null,"BrandName","브랜드 명","nvarchar",50]
[null,"ProviderNo","공급처 번호","int",4]
[null,"MdNo",null,"int",4]
[null,"DistributionCd","유통구분","nvarchar",20]
[null,"DeliveryUnitNo","물류단위 번호","int",4]
[null,"ReturnTypeCd","반품구분","nvarchar",20]
[null,"DateSystemRegister","시스템 등록 일자","datetime",8]
[null,"DateLastModified","수정일","datetime",8]
[null,"StatusCd","관리 상태","nvarchar",20]
[null,"SellingStatusCd","판매 상태","nvarchar",20]
[null,"TaxTypeCd","과세 유형","nvarchar",20]
[null,"ProductTypeCd","상품 타입","nvarchar",20]
[null,"CarryOverTypeCd","이월 상품 구분","nvarchar",20]
[null,"RelationProducts","연관상품 등록번호","nvarchar",100]
[null,"Searchkeyword","검색어","nvarchar",255]
[null,"AdminMemo","관리자 메모","nvarchar",500]
[null,"UserIdCreatedBy","생성자ID","nvarchar",50]
[null,"UserNameCreatedBy","생성자 이름","nvarchar",50]
[null,"UserIdUpdatedBy","수정자 ID","nvarchar",50]
[null,"UserNameUpdatedBy","수정자 이름","nvarchar",50]
[null,"VendorProductCode","업체상품코드","nvarchar",50]
[null,"SKUCode88","88코드","nvarchar",13]

{"sheet":"TB_IF_ProductSKU","index":12,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","SKUCode","옵션 코드","nvarchar",50]
[null,"SKUModelNo","옵션 모델 번호","nvarchar",50]
["FK","ProductNo","상품 번호","int",4]
[null,"ProductCode","상품 코드","nvarchar",50]
[null,"Option1","옵션1(색상)","nvarchar",50]
[null,"Option2","옵션2(사이즈)","nvarchar",50]
[null,"Option3","옵션3(스타일)","nvarchar",50]
[null,"SellingStockAmount","판매재고수량","int",4]
[null,"SellingStockTypeCd","판매재고유형","nvarchar",20]
[null,"LimitStockAmount",null,"int",4]
[null,"VendorSKUModelNo","업체옵션모델번호","nvarchar",50]
[null,"VendorSKUCode","업체옵션코드","nvarchar",50]
[null,"IsVirtualStock",null,"bit",1]
[null,"DateVirtualStock",null,"datetime",8]
[null,"SKUCode88","88코드","nvarchar",13]

{"sheet":"TB_IF_SetProduct","index":13,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","ProductNo","상품 번호","int",4]
["PK","MemberProductNo",null,"int",4]
[null,"MemberSettlePrice",null,"money",8]
[null,"MemberSettleMarginRate",null,"float",8]

{"sheet":"TB_IF_PurchaseOrder","index":14,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","PurchaseNo","발주 번호","int",4]
[null,"PurchaseTitle","제목","nvarchar",255]
[null,"ProviderNo","공급처 번호","int",4]
[null,"ProviderName","공급처 명","nvarchar",255]
[null,"DistributionCd","유통구분","nvarchar",20]
[null,"TotalPayment","총 사입액","money",8]
[null,"IsPayment","대금지급여부","bit",1]
[null,"TotalProductQty","상품총수","int",4]
[null,"TotalSKUQty","SKU총수","int",4]
[null,"StatusCd","상태","nvarchar",20]
[null,"DateOrdered","발주일","datetime",8]
[null,"DateFirstIncome","최초입고일","datetime",8]
[null,"DateCompleted","완료일","datetime",8]
[null,"ChargeMD","담당MD","nvarchar",50]
[null,"DateCreated","생성일","datetime",8]
[null,"UserIdCreated","등록자 ID","nvarchar",50]
[null,"UserNameCreated","등록자 이름","nvarchar",50]
[null,"DateModified","수정일","datetime",8]
[null,"UserIdModified","수정자 ID","nvarchar",50]
[null,"UserNameModified","수정자 이름","nvarchar",50]

{"sheet":"TB_IF_PurchaseOrderBrand_Xref","index":15,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
[null,"BrandNo","브랜드 번호","int",4]
[null,"BrandName","브랜드 명","nvarchar",255]
[null,"MgmtBrandName","브랜드 관리 명","nvarchar",255]
[null,"BrandStatusCd","상태","nvarchar",20]
[null,"PurchaseNo","발주 번호","int",4]

{"sheet":"TB_IF_RecallDelivery","index":16,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","RecallNo","반품 번호","bigint",8]
[null,"OrderExceptionNo","주문 예외 번호","bigint",8]
[null,"RecallTypeCd","반품 타입","nvarchar",20]
[null,"Receiver","받는자","nvarchar",50]
[null,"ReceiverTelNum","받는자 전화번호","nvarchar",50]
[null,"ReceiverCellNum","받는자 핸드폰 번호","nvarchar",50]
[null,"DeliveryPostalCode","우편 번호","char",10]
[null,"DeliveryAddr1","기본 주소","nvarchar",255]
[null,"DeliveryAddr2","상세 주소","nvarchar",255]
[null,"OrderNo","주문 번호","bigint",8]
[null,"OrderGUID","주문 고유 번호","nvarchar",50]
[null,"CustomerName","주문자","nvarchar",50]
[null,"LoginId","아이디","nvarchar",50]
[null,"CSMemo","CS 메모","text",16]
[null,"DateCSMemoUpdated","CS 메모 변경일","datetime",8]
[null,"WMSMemo","WMS 메모","text",16]
[null,"DateWMSMemoUpdated","WMS 메모 변경일","datetime",8]
[null,"DateCreated","생성일","datetime",8]
[null,"IsDeleted","삭제 여부","bit",1]
[null,"DateDeleted","삭제일","datetime",8]
[null,"DeliveryAddrNew","도로명 주소","nvarchar",100]

{"sheet":"TB_IF_RecallDeliveryItem","index":17,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","RecallItemNo","반품 항목 번호","bigint",8]
[null,"RecallNo","반품 번호","bigint",8]
[null,"ProductNo","상품 번호","int",4]
[null,"ProductCode","상품 코드","nvarchar",50]
[null,"ProductName","상품명","nvarchar",255]
[null,"SKUCode","옵션 코드","nvarchar",50]
[null,"SKUValue","옵션 내용","nvarchar",255]
[null,"RecallQty","수량","int",4]
[null,"StatusCd","상태","nvarchar",20]
[null,"DateCompleted","완료일","datetime",8]
[null,"LogisticsName","택배사 명","nvarchar",50]
[null,"RecallInvoiceNo","반품 명세서","nvarchar",50]

{"sheet":"TB_IF_DailyDeliveryZone","index":18,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Key","Field","Contents","Type","Length"]
["PK","ZIP_NO","우편번호","nvarchar",6]
[null,"PND_BRAN",null,"nvarchar",7]
[null,"PND_BRAN_NM",null,"nvarchar",30]
[null,"OPER_ABOVE_BRAN",null,"nvarchar",8]
[null,"TR_BRAN_NM",null,"nvarchar",30]
[null,"CITY_DO","시도","nvarchar",30]
[null,"GU_GUN","구군","nvarchar",4]
[null,"DONG_YUP_MEUN","동읍면","nvarchar",4]
[null,"DELIVERY_TIME",null,"nvarchar",2]
[null,"DELIVERY_PROBABILITY",null,"nvarchar",3]
[null,"DELIVERYCLASSCD",null,"nvarchar",20]
[null,"ISUSE","사용여부","bit",1]
[null,"DATELASTUPDATE","수정일","datetime",8]