{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Control","Notes","Options","Template","Template_H","UPKJRNL","UPKJRNL_H","DECIMALS","DECIMALS_H"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":107,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Options","index":2,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Control","index":0,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Spreadsheet Journal Import"]

{"sheet":"Notes","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Notes"]

{"sheet":"Template","index":3,"n_rows":10,"n_cols":29,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,"%,OS",null,"JOURNAL_ID","JOURNAL_DATE","UNPOST_SEQ","JOURNAL_LINE","BUSINESS_UNIT","LEDGER","SPEEDTYPE_KEY","FUND_CODE","DEPTID","CLASS_FLD","PROGRAM_CODE","ACCOUNT","CHARTFIELD1","CHARTFIELD2","BUDGET_REF","BUSINESS_UNIT_PC","PROJECT_ID","ACTIVITY_ID","RESOURCE_TYPE","RESOURCE_CATEGORY","RESOURCE_SUB_CAT","ANALYSIS_TYPE","MONETARY_AMOUNT","LINE_DESCR","JRNL_LN_REF"]
[null,"Spreadsheet Journal Import"]
[null,"Journal Header",null,null,null,"Date",null,"Sys ID","Unit","Journal ID","Date","Description"]
[]
[]
[null,"Journal Lines"]
[null,"Sys ID",null,null,"Journal ID",null,null,"Line #","Unit","Ledger","Speed Type","   Fund","    Dept Id","  SID","   Program","Account","Chartfield 1","Chartfield 2","Budget Ref","  PCBU","Project","Activity","Source","Category","Sub Cat.","Analysis Type"," Amount","Line Desription","Line Reference"]
[null,null,null,"Hunit",null,"Date","Seq #"]
["%,OH",null,null,null,null,null,null,null,null,"   Select fields to copy from a previous line by marking the checkboxes under each field.  "]
["%,OA",null,"U"]

{"sheet":"Template_H","index":4,"n_rows":2,"n_cols":29,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"%,OS","SEQNO","BUSINESS_UNIT","JOURNAL_ID","JOURNAL_DATE","DESCR254","LEDGER_GROUP","LEDGER","SOURCE","OPRID","FOREIGN_CURRENCY","CUR_EFFDT","RT_TYPE","RATE_MULT","REVERSAL_CD","REVERSAL_DATE","AUTO_GEN_LINES","ADJUSTING_ENTRY","ACCOUNTING_PERIOD","GL_ADJUST_TYPE","JOURNAL_CLASS","IU_TRAN_CD","ALC","DOC_TYPE","DOC_SEQ_NBR","FISCAL_YEAR","KK_AMOUNT_TYPE","TRANS_REF_NUM"]
["%,OH","Control Code","System ID","Unit","Journal ID","Date","Descr","Ledger Grp","Ledger","Source","Operator","Currency","Effective Date","Rate Type","Rate","Reversal","Reversal Date","AutoGenLines","Adj Entry","Period","Adj type","Journal Class","Transaction Code","Agency Location Code","Doc Type","Doc Seq Nbr","Fiscal Year","KK Amount Type","Reference Number"]

{"sheet":"UPKJRNL","index":5,"n_rows":13,"n_cols":29,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"%,OS",null,"JOURNAL_ID","JOURNAL_DATE","UNPOST_SEQ","JOURNAL_LINE","BUSINESS_UNIT","LEDGER","SPEEDTYPE_KEY","FUND_CODE","DEPTID","CLASS_FLD","PROGRAM_CODE","ACCOUNT","CHARTFIELD1","CHARTFIELD2","BUDGET_REF","BUSINESS_UNIT_PC","PROJECT_ID","ACTIVITY_ID","RESOURCE_TYPE","RESOURCE_CATEGORY","RESOURCE_SUB_CAT","ANALYSIS_TYPE","MONETARY_AMOUNT","LINE_DESCR","JRNL_LN_REF"]
[null,"Spreadsheet Journal Import"]
[null,"Journal Header",null,null,null,"Date",null,"Sys ID","Unit","Journal ID","Date","Description"]
[null,null,null,null,null,null,null,1028,"STATE","OSCDAB0001",41276,"Journal Entry Description"]
[]
[null,"Journal Lines"]
[null,"Sys ID",null,null,"Journal ID",null,null,"Line #","Unit","Ledger","Speed Type","   Fund","    Dept Id","  SID","   Program","Account","Chartfield 1","Chartfield 2","Budget Ref","  PCBU","Project","Activity","Source","Category","Sub Cat.","Analysis Type"," Amount","Line Desription","Line Reference"]
[null,null,null,"Hunit",null,"Date","Seq #"]
["%,OH",null,null,null,null,null,null,null,null,"   Select fields to copy from a previous line by marking the checkboxes under each field.  "]
["%,OA",null,"U"]
[null,1028,"U"]
[null,1028,"C","STATE","OSCDAB0001","2013-01-02",0,1,"STATE","MOD_ACCRL","DOT_TF",null,null,null,null,"54060",null,null,null,null,null,null,null,null,null,null,1]
[null,1028,"C","STATE","OSCDAB0001","2013-01-02",0,2,"STATE","MOD_ACCRL","DOT_TF",null,null,null,null,"10404",null,null,null,null,null,null,null,null,null,null,-1]

{"sheet":"UPKJRNL_H","index":6,"n_rows":3,"n_cols":29,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"%,OS","SEQNO","BUSINESS_UNIT","JOURNAL_ID","JOURNAL_DATE","DESCR254","LEDGER_GROUP","LEDGER","SOURCE","OPRID","FOREIGN_CURRENCY","CUR_EFFDT","RT_TYPE","RATE_MULT","REVERSAL_CD","REVERSAL_DATE","AUTO_GEN_LINES","ADJUSTING_ENTRY","ACCOUNTING_PERIOD","GL_ADJUST_TYPE","JOURNAL_CLASS","IU_TRAN_CD","ALC","DOC_TYPE","DOC_SEQ_NBR","FISCAL_YEAR","KK_AMOUNT_TYPE","TRANS_REF_NUM"]
["%,OH","Control Code","System ID","Unit","Journal ID","Date","Descr","Ledger Grp","Ledger","Source","Operator","Currency","Effective Date","Rate Type","Rate","Reversal","Reversal Date","AutoGenLines","Adj Entry","Period","Adj type","Journal Class","Transaction Code","Agency Location Code","Doc Type","Doc Seq Nbr","Fiscal Year","KK Amount Type","Reference Number"]
[null,"C",1028,"STATE","OSCDAB0001","2013-01-02","Journal Entry Description","MOD_ACCRL","","OSC","COREBragaDon","","2013-01-02","",0,"N",null,"N","N",null,"","","","","","",null,7,""]

{"sheet":"DECIMALS","index":7,"n_rows":13,"n_cols":29,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"%,OS",null,"JOURNAL_ID","JOURNAL_DATE","UNPOST_SEQ","JOURNAL_LINE","BUSINESS_UNIT","LEDGER","SPEEDTYPE_KEY","FUND_CODE","DEPTID","CLASS_FLD","PROGRAM_CODE","ACCOUNT","CHARTFIELD1","CHARTFIELD2","BUDGET_REF","BUSINESS_UNIT_PC","PROJECT_ID","ACTIVITY_ID","RESOURCE_TYPE","RESOURCE_CATEGORY","RESOURCE_SUB_CAT","ANALYSIS_TYPE","MONETARY_AMOUNT","LINE_DESCR","JRNL_LN_REF"]
[null,"Spreadsheet Journal Import"]
[null,"Journal Header",null,null,null,"Date",null,"Sys ID","Unit","Journal ID","Date","Description"]
[null,null,null,null,null,null,null,1027,"STATE","NEXT",41243,"TEST DECIMAL PLACES"]
[]
[null,"Journal Lines"]
[null,"Sys ID",null,null,"Journal ID",null,null,"Line #","Unit","Ledger","Speed Type","   Fund","    Dept Id","  SID","   Program","Account","Chartfield 1","Chartfield 2","Budget Ref","  PCBU","Project","Activity","Source","Category","Sub Cat.","Analysis Type"," Amount","Line Desription","Line Reference"]
[null,null,null,"Hunit",null,"Date","Seq #"]
["%,OH",null,null,null,null,null,null,null,null,"   Select fields to copy from a previous line by marking the checkboxes under each field.  "]
["%,OA",null,"U"]
[null,1027,"U"]
[null,1027,"C","STATE","NEXT","2012-11-30",0,1,"STATE","MOD_ACCRL",null,"11000","AES48013","10020","00000","54060",null,null,"2013","NONPC","AES_NONPROJECT",null,null,null,null,null,1.23]
[null,1027,"C","STATE","NEXT","2012-11-30",0,2,"STATE","MOD_ACCRL",null,"11000","AES48013","10020",null,"10404",null,null,null,null,null,null,null,null,null,null,-1.23]

{"sheet":"DECIMALS_H","index":8,"n_rows":3,"n_cols":29,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"%,OS","SEQNO","BUSINESS_UNIT","JOURNAL_ID","JOURNAL_DATE","DESCR254","LEDGER_GROUP","LEDGER","SOURCE","OPRID","FOREIGN_CURRENCY","CUR_EFFDT","RT_TYPE","RATE_MULT","REVERSAL_CD","REVERSAL_DATE","AUTO_GEN_LINES","ADJUSTING_ENTRY","ACCOUNTING_PERIOD","GL_ADJUST_TYPE","JOURNAL_CLASS","IU_TRAN_CD","ALC","DOC_TYPE","DOC_SEQ_NBR","FISCAL_YEAR","KK_AMOUNT_TYPE","TRANS_REF_NUM"]
["%,OH","Control Code","System ID","Unit","Journal ID","Date","Descr","Ledger Grp","Ledger","Source","Operator","Currency","Effective Date","Rate Type","Rate","Reversal","Reversal Date","AutoGenLines","Adj Entry","Period","Adj type","Journal Class","Transaction Code","Agency Location Code","Doc Type","Doc Seq Nbr","Fiscal Year","KK Amount Type","Reference Number"]
[null,"C",1027,"STATE","NEXT","2012-11-30","TEST DECIMAL PLACES","MOD_ACCRL","","OSC","COREBragaDon","","2012-11-30","",0,"N",null,"N","N",null,"","","","","","",null,7,""]