{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Table"],"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":"Table","index":0,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,0,1,10],[9,0,9,13],[18,0,18,9]]}
["As-is 정산메뉴 파일 비교(CID : naver, 1/1 매출 기준)"]
["BOS 정산메뉴(자사용)"]
["OrderNo","ChannelCd","IssuetypeCd","DateOrdered","DateCreated","DateSales","상품총액","아이머니사용액","CouponDiscount","상품권사용액","정산대상액"]
[19496048,"naver","정상","2021-01-01 21:00:50","2021-01-01 21:01:06","2021-01-01 21:01:06",52000,0,7800,0,44200]
[19496016,"naver","정상","2021-01-01 19:15:31","2021-01-01 19:16:38","2021-01-01 19:16:38",28500,0,0,0,28500]
[19496014,"naver","정상","2021-01-01 19:10:28","2021-01-01 19:11:34","2021-01-01 19:11:34",42500,0,2980,0,39520]
[19495947,"naver","정상","2021-01-01 15:35:19","2021-01-01 15:35:41","2021-01-01 15:35:41",39060,0,0,0,39060]
["*정산대상액 = 상품총액 - 아이머니사용액 - CouponDiscount - 상품권사용액"]
[]
["SCM 정산메뉴(제휴사용)"]
["OrderNo","IssueTypeCd","DateSales","DatePaid","ItemTotal","DeliveryCost","UsedMileage","UsedOCBPoint","CouponDiscount","ChannelCd","CustomerName","ProductSummary","DateOrdered","DateCancel"]
[19496048,"정상","2021-01-01T21:01:06.673+09:00","2021-01-01T21:01:06.54+09:00",52000,0,0,0,7800,"naver","박상수","[모이몰른] 포포 우주복 MMW1NZUU09 [겨울] 외 4건","2021-01-01T21:00:50.81+09:00"]
[19496016,"정상","2021-01-01T19:16:38.043+09:00","2021-01-01T19:16:37.96+09:00",28500,0,0,0,0,"naver","김기도","[쉬즈미스(SHESMISS)] 미니멀 LUX 테일러드카라 롱 자켓 (택가격:278000원) 외 2건","2021-01-01T19:15:31.543+09:00"]
[19496014,"정상","2021-01-01T19:11:34.82+09:00","2021-01-01T19:11:34.58+09:00",42500,0,0,0,2980,"naver","고종환","유니 NBA팀 넘버링 테크팩 맨투맨 (N183TS120P) 외 1건","2021-01-01T19:10:28.993+09:00"]
[19495947,"정상","2021-01-01T15:35:41.73+09:00","2021-01-01T15:35:41.6+09:00",39060,2500,0,0,0,"naver","권지영","랑콤 듀얼 피니시 파우더 앤 파운데이션 205 19g","2021-01-01T15:35:19.207+09:00"]
["*정산대상액 = 항목 없음"]
[]
["To-be 정산메뉴 파일 양식"]
["BOS / SCM 통일"]
["일자","주문상태","주문번호","유입채널","판매가","쿠폰할인","포인트","상품권사용액","결제액(VAT포함)","매출액(VAT제외)"]
["2021-01-01 21:00:50","결제완료",19496048,"naver",52000,7800,0,0,44200,{"$f":"I21/1.1","v":40181.818181818177}]
["2021-01-01 19:15:31","취소완료",19496016,"naver",28500,0,0,0,28500,{"$f":"I22/1.1","v":25909.090909090908}]
["2021-01-01 19:10:28","반품완료",19496014,"naver",42500,2980,0,0,39520,35927.272727272728]
["2021-01-01 15:35:19","결제완료",19495947,"naver",39060,0,0,0,39060,35509.090909090904]
["*정산대상액 = 매출액(VAT제외)"]
[]
["ㄴ일자 : 결제/취반품이 실제 발생한 일자(취반품은 소급하지 않고 취반품 발생한 일자로 마이너스 누적)"]
["ㄴ결제완료 : 주문 후 결제까지 이루어진 상태"]
["ㄴ취소완료 : 결제 후 배송 전 환불이 이루어진 상태"]
["ㄴ반품완료 : 결제 후 배송되어 반품 및 환불이 이루어진 상태"]
["ㄴ주문번호 : 장바구니 결제 단위 주문번호"]
["ㄴ유입채널 : 제휴채널명(현재 CID)"]
["ㄴ판매가 : 정상 판매가로 BOS 상 '상품금액 합계'(배송비 제외)"]
["ㄴ쿠폰할인 : 쿠폰 또는 즉시할인의 방법으로 할인혜택을 제공하는 금액(상품쿠폰, 장바구니쿠폰, 다다익선, KCP결제쿠폰 등)"]
["ㄴ포인트 : 아이포인트 사용액"]
["ㄴ상품권사용액 : 상품권 사용액"]
["ㄴ결제액 : 당일 결제완료된 상품주문총액 (판매가-쿠폰할인-포인트-상품권)"]
["ㄴ매출액 : 결제액 / 1.1"]