{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["선불","후불","선불 (2)","후불 (2)"],"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":"선불","index":0,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,10,0,16],[0,18,0,20],[0,4,0,8]]}
[{"$nulls":4},"여신관리기본정보(매장)",{"$nulls":5},"여신관리상세이력",{"$nulls":7},"여신관리입금처리"]
["일자","내용","금액",null,"계좌잔액(충전)","신용한도금액","충전한도금액","사용금액합계","가수금합계",null,"입출금일자","입지구분","매체구분","결제유형","거래금액","거래전잔액","거래후잔액",null,"입금일자","입금금액","상태"]
["2022-10-11","충전-카드결제",1000000,null,1000000,null,5000000,null,null,null,"2022-10-11","입금","카드","충전결제",1000000,0,1000000]
["2022-10-11","충전-계좌이체",1000000,null,2000000,null,5000000,null,null,null,"2022-10-11","입금","계좌","충전결제",1000000,1000000,2000000]
["2022-10-11","충전-일반결제",800000,null,2000000,null,5000000,{"$nulls":11},"2022-10-11",800000,"입금요청(매장)"]
[{"$nulls":4},2800000,null,5000000,null,null,null,"2022-10-11","입금","일반","충전결제",800000,2000000,2800000,null,"2022-10-11",800000,"입금승인(브랜드)"]
[]
["2022-10-11","구매요청1",900000,null,2800000,null,5000000,900000]
["2022-10-11","정산완료1",900000,null,1900000,null,5000000,0,null,null,"2022-10-13","지급","대체","정산지급",900000,2800000,1900000]
[]
["2022-10-12","구매요청2",1000000,null,1900000,null,5000000,1000000]
["2022-10-12","구매요청2 반려",1000000,null,1900000,null,5000000,0]
[]
["2022-10-12","구매요청3",800000,null,1900000,null,5000000,800000]
["2022-10-12","정산완료3 - 사용금액합계 차감은 구매요청금액",700000,null,1200000,null,5000000,0,null,null,"2022-10-12","지급","대체","정산지급",700000,1900000,1200000]
[]
["2022-10-12","구매요청3",800000,null,1900000,null,5000000,800000]
["2022-10-12","정산완료3 - 가수금으로 처리",700000,null,1100000,null,5000000,0,100000,null,"2022-10-12","지급","대체","정산지급",700000,1900000,1200000]
[]
["2022-10-13","구매요청4-1",300000,null,1200000,null,5000000,300000]
["2022-10-13","구매요청4-2",400000,null,1200000,null,5000000,700000]
["2022-10-13","정산요청4",700000,null,500000,null,5000000,0,null,null,"2022-10-13","지급","대체","정산지급",700000,1200000,500000]
[]
["2022-10-14","구매요청5-임시저장",1500000,null,500000,null,5000000]
["2022-10-14","충전-카드결제-충전부족금액",1000000,null,1500000,null,5000000,null,null,null,"2022-10-14","입금","카드","충전결제",1000000,500000,1500000]
["2022-10-14","구매요청5",1500000,null,1500000,null,5000000,1500000]
["2022-10-14","정산요청5",1500000,null,0,null,5000000,0,null,null,"2022-10-14","지급","대체","정산지급",1500000,1500000,0]

{"sheet":"후불","index":1,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,10,0,16],[0,18,0,20],[0,4,0,8]]}
[{"$nulls":4},"여신관리기본정보",{"$nulls":5},"여신관리상세이력",{"$nulls":7},"여신관리입금처리"]
["일자","내용","금액",null,"계좌잔액","신용한도금액","사용가능한도","사용금액합계","가수금합계",null,"입출금일자","입지구분","매체구분","결제유형","거래금액","거래전잔액","거래후잔액",null,"입금일자","입금금액","상태"]
["2022-10-11","구매요청1-1",1000000,null,0,2000000,{"$f":"F3-H3+I3+E3","v":1000000},1000000]
["2022-10-11","구매요청1-2",700000,null,0,2000000,{"$f":"F4-H4+I4+E4","v":300000},1700000]
["2022-10-11","정산요청1",1700000,null,0,2000000,300000,1700000]
["2022-10-11","정산요청결제1",1700000,null,1700000,2000000,2000000,1700000,null,null,"2022-10-11","입금","카드","정산결제",1700000,0,1700000]
["2022-10-11","정산완료1",1700000,null,0,2000000,2000000,0,null,null,"2022-10-11","지급","대체","정산지급",1700000,1700000,0]
[{"$nulls":6},0]
["2022-10-12","구매요청2",1200000,null,0,2000000,800000,1200000]
["2022-10-12","정산요청2",1200000,null,0,2000000,800000,1200000]
["2022-10-12","정산요청결제2",1200000,null,1200000,2000000,2000000,1200000,null,null,"2022-10-12","입금","계좌","정산결제",1200000,0,1200000]
["2022-10-12","정산완료2",1200000,null,0,2000000,2000000,0,null,null,"2022-10-12","지급","대체","정산지급",1200000,1200000,0]
[{"$nulls":6},0]
["2022-10-13","구매요청3",800000,null,0,2000000,1200000,800000]
["2022-10-13","정산요청3",800000,null,0,2000000,1200000,800000]
["2022-10-13","정산요청결제3-입금후 입금요청",800000,null,0,2000000,1200000,800000,{"$nulls":10},"2022-10-13",800000,"입금요청"]
["2022-10-13","정산요청결제3-입금요청 건 승인",800000,null,800000,2000000,2000000,800000,null,null,"2022-10-13","입금","일반","정산결제",800000,0,800000,null,"2022-10-13",800000,"입금승인"]
["2022-10-13","정산완료3",800000,null,0,2000000,2000000,0,null,null,"2022-10-13","지급","대체","정산지급",800000,800000,0]
[{"$nulls":6},0]
["2022-10-14","구매요청4-1",1000000,null,0,2000000,1000000,1000000]
["2022-10-14","구매요청4-2",900000,null,0,2000000,100000,1900000]
["2022-10-14","구매요청4-3",1500000,null,0,2000000,100000,1900000]
["2022-10-14","선결제4 - 계좌잔액으로 처리",1400000,null,1400000,2000000,1500000,1900000,null,null,"2022-10-14","입금","카드","선결제",1400000,0,1400000]
["2022-10-14","구매요청4-3",1500000,null,1400000,2000000,0,3400000]
["2022-10-14","정산요청4",3400000,null,1400000,2000000,0,3400000]
["2022-10-14","정산요청결제4",2000000,null,3400000,2000000,2000000,3400000,null,null,"2022-10-14","입금","계좌","정산결제",2000000,1400000,3400000]
["2022-10-14","정산완료4",3400000,null,0,2000000,2000000,0,null,null,"2022-10-14","지급","대체","정산지급",3400000,3400000,0]
[{"$nulls":6},0]
["2022-10-14","구매요청4-1",1000000,null,0,2000000,1000000,1000000]
["2022-10-14","구매요청4-2",900000,null,0,2000000,100000,1900000]
["2022-10-14","구매요청4-3",1500000,null,0,2000000,100000,1900000]
["2022-10-14","선결제4 - 가수금으로 처리",1400000,null,0,2000000,1500000,1900000,1400000,null,"2022-10-14","입금","카드","선결제",1400000,0,1400000]
["2022-10-14","구매요청4-3",1500000,null,0,2000000,0,3400000,1400000]
["2022-10-14","정산요청4",3400000,null,0,2000000,0,3400000,1400000]
["2022-10-14","정산요청결제4",2000000,null,2000000,2000000,2000000,3400000,1400000,null,"2022-10-14","입금","계좌","정산결제",2000000,0,2000000]
["2022-10-14","정산완료4",3400000,null,0,2000000,2000000,0,0,null,"2022-10-14","지급","대체","정산지급",3400000,3400000,0]

{"sheet":"선불 (2)","index":2,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,3,0,8],[0,10,0,15],[0,17,0,19]]}
[null,null,null,"여신관리기본정보",{"$nulls":6},"여신관리상세이력",{"$nulls":6},"여신관리입금처리"]
["일자","내용","금액","선불","충전잔액","신용한도금액","충전한도금액","사용금액합계","가수금합계",null,"입출금일자","입지구분","매체구분","거래금액","거래전잔액","거래후잔액",null,"입금일자","입금금액","상태"]
[{"$nulls":8},0,{"$nulls":6},{"$f":"N3+O3","v":0},null,"2022-10-05",1000000,"입금요청"]
["2022-10-05","구매요청금액1",1000000,null,1000000,0,10000000,1000000,null,null,"2022-10-05","입금","계좌이체",1000000,0,1000000,null,"2022-10-05",1000000,"입금승인"]
[{"$nulls":17},"2022-10-06",1500000,"입금요청"]
["2022-10-06","구매요청금액2",1500000,null,2500000,null,10000000,2500000,null,null,"2022-10-06","입금","계좌이체",1500000,1000000,2500000,null,"2022-10-06",1500000,"입금승인"]
["2022-10-08","정산요청",2500000,null,2500000,null,10000000,2500000]
["2022-10-08","정산지급",2500000,null,0,null,10000000,0,0,null,"2022-10-08","지급","정산지급",2500000,2500000,0]
[]
["2022-10-09","구매요청금액3",1200000,null,1200000,null,10000000,1200000,0,null,"2022-10-09","입금","카드결제",1200000,0,1200000]
["2022-10-11","정산요청",1200000,null,1200000,null,10000000,1200000]
["2022-10-11","정산지급",1200000,null,0,null,10000000,0,null,null,"2022-10-11","지급","정산지급",1200000,1200000,0]
[]
["2022-10-12","구매요청금액4",1300000,null,1300000,null,10000000,1300000,null,null,"2022-10-12","입금","가상계좌",1300000,0,1300000]
["2022-10-13","정산요청",1300000,null,1300000,null,10000000,1300000]
["2022-10-13","정산지급",1300000,null,0,null,10000000,0,null,null,"2022-10-13","지급","정산지급",1300000,1300000,0]
[]
[]
[]
[]
[]
[{"$nulls":8},0,{"$nulls":8},"2022-10-05",1000000,"입금요청"]
["2022-10-05","구매요청금액1",1000000,null,1000000,0,10000000,1000000,null,null,"2022-10-05","입금","계좌이체",1000000,0,1000000,null,"2022-10-05",1000000,"입금승인"]
[{"$nulls":17},"2022-10-06",1500000,"입금요청"]
["2022-10-06","구매요청금액2",1500000,null,2500000,null,10000000,2500000,null,null,"2022-10-06","입금","계좌이체",1500000,1000000,2500000,null,"2022-10-06",1500000,"입금승인"]
["2022-10-07","구매요청반려(가수금)",500000,null,2000000,null,10000000,2000000,500000,null,"2022-10-07","지급","가수금",500000,2500000,2000000]
["2022-10-08","정산요청",2000000,null,2000000,null,10000000,2000000,500000]
["2022-10-08","정산지급",2000000,null,0,null,10000000,0,500000,null,"2022-10-08","지급","정산지급",2000000,2000000,0]
[]
["2022-10-09","구매요청금액3",1200000,null,700000,null,10000000,1200000,500000,null,"2022-10-09","입금","카드결제",700000,0,700000]
["2022-10-09","구매요청금액3",1200000,null,1200000,null,10000000,1200000,0,null,"2022-10-09","입금","가수금",500000,700000,1200000]
["2022-10-10","구매요청반려(가수금)",300000,null,900000,null,10000000,900000,300000,null,"2022-10-10","지급","가수금",300000,1200000,900000]
["2022-10-11","정산요청",1200000,null,900000,null,10000000,900000,300000]
["2022-10-11","정산지급",900000,null,0,null,10000000,0,300000,null,"2022-10-11","지급","정산지급",900000,900000,0]
[]
["2022-10-12","구매요청금액4",1300000,null,1000000,null,10000000,1300000,300000,null,"2022-10-12","입금","카드결제",1000000,0,1000000]
["2022-10-12","구매요청금액4",1300000,null,1300000,null,10000000,1300000,0,null,"2022-10-12","입금","가수금",300000,1000000,1300000]
["2022-10-13","정산요청",1300000,null,1300000,null,10000000,1300000]
["2022-10-13","정산지급",1300000,null,0,null,10000000,0,null,null,"2022-10-13","지급","정산지급",1300000,1300000,0]

{"sheet":"후불 (2)","index":3,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,3,0,8],[0,10,0,15],[0,17,0,19]]}
[null,null,null,"여신관리기본정보",{"$nulls":6},"여신관리상세이력",{"$nulls":6},"여신관리입금처리"]
["일자","내용","금액","후불","계좌잔액","신용한도금액","사용가능한도","사용금액합계","가수금합계",null,"입출금일자","입지구분","매체구분","거래금액","거래전잔액","거래후잔액",null,"입금일자","입금금액","상태"]
["2022-10-05","구매요청금액1",1000000,null,null,10000000,{"$f":"F3-H3","v":9000000},1000000,0]
["2022-10-06","구매요청금액2",1500000,null,null,10000000,{"$f":"F4-H4","v":7500000},2500000]
["2022-10-08","정산요청",2500000,null,null,10000000,7500000,2500000,{"$nulls":9},"2022-10-08",2500000,"입금요청"]
["2022-10-08","정산요청",2500000,null,2500000,10000000,7500000,2500000,null,null,"2022-10-08","입금","계좌이체",2500000,0,2500000,null,"2022-10-08",2500000,"입금승인"]
["2022-10-08","정산지급",2500000,null,0,10000000,10000000,0,0,null,"2022-10-08","지급","정산지급",2500000,2500000,0]
[]
["2022-10-11","구매요청금액3",1200000,null,0,10000000,8800000,1200000]
["2022-10-12","정산요청",1200000,null,0,10000000,8800000,1200000]
["2022-10-13","정산요청",1200000,null,1200000,10000000,8800000,1200000,null,null,"2022-10-13","입금","카드결제",1200000,0,1200000]
["2022-10-13","정산지급",1200000,null,0,10000000,10000000,0,null,null,"2022-10-13","지급","정산지급",1200000,1200000,0]
[]
["2022-10-14","구매요청금액4",1300000,null,0,10000000,8700000,1300000]
["2022-10-14","구매요청반려(일부)",200000,null,null,10000000,8900000,1100000]
["2022-10-15","정산요청",1100000,null,0,10000000,8900000,1100000]
["2022-10-16","정산요청",1100000,null,1100000,10000000,8900000,1100000,null,null,"2022-10-16","입금","카드결제",1100000,0,1100000]
["2022-10-16","정산지급",1100000,null,0,10000000,10000000,0,null,null,"2022-10-16","지급","정산지급",1100000,1100000,0]