{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["總表","版次說明"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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","formulas":"cached_only"}

{"sheet":"總表","index":0,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,1,6]],"flags":["formulas_cached_only"]}
["客戶衍生性金融商品月報資料檔案(C01)之「資料邏輯檢核表」"]
[]
["檢核編號","補件放寬","訊息","檢核說明","檢核條件（if）","檢核限制（then）","檢核訊息"]
["C01-1",null,"E","檢核統編邏輯是否正確，不正確者剔退處理","(3) 邏輯=true",null,"統編邏輯不正確"]
["C01-2",null,"E","同一批次中，「資料所屬年月+銀行別+統編+分行類別」需為唯一，不可重複","(4)=A","(1)+(2)+(3)+(14)不能重複","同一資料所屬年月及同一銀行別、同一統編及同一分行類別之檔案不得重複報送","2016/06/01 修正"]
["C01-3",null,"E","不存在相同資料不得異動","(4)=C","資料庫中存在與欲異動資料欄位(((1)+(2)+(3)+(14))一致資料","不存在相同資料，無法異動","2016/06/01 修正"]
["C01-4",null,"E","不存在相同資料不得刪除","(4)=D","資料庫中存在與欲刪除資料欄位(((1)+(2)+(3)+(14))一致資料","不存在相同資料，無法刪除","2016/06/01 修正"]
["C01-5",null,"E","違約事件註記=\"Y\"時，違約事件年月=資料所屬年月","(12)=\"Y\" AND (13)<>(1)","(13)=資料所屬年月","違約事件註記=\"Y\"時，違約事件年月與資料所屬年月不同","2014/10/14 修正"]
["C01-6",null,"E","違約事件註記=\"Y\"時，違約事件年月不得為空白","(12)=\"Y\"","(13)<>\"\"","違約事件註記=\"Y\"時，違約事件年月不得為空白"]
["C01-7",null,"E","違約事件註記=\"N\"時，違約事件年月應為空白","(12)=\"N\"","(13)=\"\"","違約事件註記=\"N\"時，違約事件年月應為空白"]
["C01-8",null,"E","同一違約事件註記不得重複報送。","(12)=\"Y\" AND (4)='A'\n(每月10日未上線前的上月底之餘額資料不適用該檢核邏輯)","(2)+(3)+(13)+(14)不得與資料庫存在相同資料","同一違約事件註記不得重複報送","2016/06/01 修正"]
["C01-9",null,"E","「額度動支金額-申報用」與「額度動支金額-管理用」兩者皆大於零且「額度動支金額-申報用」=「額度動支金額-管理用」時，額度動支金額-管理用原則應為'2'","(8)=(9) AND \n((8)>0 AND (9)>0)","(10)='2'","額度動支金額-申報用=額度動支金額-管理用時，額度動支金額-管理用原則，額度動支金額-管理用原則應為'2'","2014/10/21 刪除"]
["C01-10",null,"E","存在相同資料不得新增","(4)=A(每月10日未上線前的上月底之餘額資料不適用該檢核邏輯)","資料庫中不得存在與欲異動資料欄位(((1)+(2)+(3)+(14))一致資料","存在相同資料，無法新增","1.2016/06/01修正\n2.因C01-10與C01-2檢核相同，因此在問與答集中將兩者合併處理。"]
["C01-11",null,"E","違約事件註記=\"Y\"時，核給額度、額度動支金額-申報用、額度動支金額-管理用應為零","(12)=\"Y\" ","(5)=0 AND (8)=0 AND (9)=0","違約事件註記=\"Y\"時，核給額度、額度動支金額-申報用、額度動支金額-管理用應為零","2014/12/5 新增"]

{"sheet":"版次說明","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[[5,0,10,0],[5,1,10,1]],"flags":["formulas_cached_only"]}
[]
["版次","生效日期","發行或修訂說明"]
["V1","103.10.1"]
["V2",103.11,"1.C01-1文字酌修\n2.修正C01-5 檢核\n3.修正C01-8 檢核\n4.新增C01-10 檢核"]
["V3",null,"1.新增C01-11 檢核"]
["V4",105.06,"1.修正C01-2檢核"]
[null,null,"2.修正C01-3檢核"]
[null,null,"3.修正C01-4檢核"]
[null,null,"4.修正C01-5檢核"]
[null,null,"5.修正C01-8檢核"]
[null,null,"6.修正C01-10檢核"]