{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overview","Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"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":"Overview","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"General Ledger - 1-7 Ledger Sub Accounts "]
[]
[null,"The following template should be used to import one or more GL Ledger Sub Accounts into Sage 100 Contractor.  "]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","GLLSA",null,"GLLSA","GLLSA"]
[null,"lgract","Required **","Numeric",null,null,"Ledger Account"]
[null,"subact","Required **","Numeric",null,null,"Sub Account"]
[null,"lngnme","Required","String (50)",null,null,"GL Account Name"]
[null,"shtnme","Required","String (30)",null,null,"GL Short Name"]
[null,"ntetxt",null,"Text",null,null,"Notes"]
[]
[null,"** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor"]
[]
[null,"File Example:"]
[null,"filetype,lgract,subact,lngnme,shtnme,ntetxt"]
[null,"GLLSA,7951,1,\"Tax Exp - sub a\",\"Tax Exp - sub a\",\"\""]
[null,"GLLSA,7951,2,\"Tax Exp - sub b\",\"Tax Exp - sub b\",\"\""]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sample Template",null,"Note: you may delete any column from this template that is not used or needed other than the Required Columns"]
[]
[]
[null,"Filetype Code","GL Account No","GL Sub \nAccount No","GL Account Name","GL Short Name","Notes"]
[null,"GLLA","Numeric","Numeric","String (50)","String (30)","Text"]
[]
[]
["First Line of File==>","filetype","lgract","subact","lngnme","shtnme","ntetxt"]
[null,"GLLSA",7951,1,"Tax Exp - sub a","Tax Exp - sub a"]
[null,"GLLSA",7951,2,"Tax Exp - sub b","Tax Exp - sub b"]