{"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":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"version: 2023-10-22"]
[]
[null,"Accounts Payable - 4-4 Vendors"]
[]
[null,"The following template should be used to import one or more Vendors into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","APVEND",null,"APVEND","APVEND"]
[null,"recnum","Required","Numeric","Header",201701,"Vendor No"]
[null,"vndnme","Required(I)","String (75)","Header","Capital Ventures","Vendor Name"]
[null,"shtnme","Required(I)","String (30)","Header","Cap Vent","Vendor Short Name"]
[null,"vndtyp","**","Numeric","Header",null,"Vendor Type"]
[null,"ownnme",null,"String (50)","General","John Biggins","Owner Name"]
[null,"addrs1",null,"String (50)","General",null,"Vendor Addr 1"]
[null,"addrs2",null,"String (50)","General",null,"Vendor Addr 2"]
[null,"ctynme",null,"String (50)","General",null,"Vendor City"]
[null,"state_",null,"String (2)","General",null,"Vendor State"]
[null,"zipcde",null,"String (10)","General",null,"Vendor Zip"]
[null,"minsts","**","Numeric","General","0=None;1=Minority Owned;2=Women Owned;3=Disabled Vet","Minority Type"]
[null,"taxdst","**","Numeric","General",null,"Tax District"]
[null,"usrdf1",null,"String (50)","General",null,"User Def1"]
[null,"usrdf2",null,"String (50)","General",null,"User Def2"]
[null,"fedidn","***","String (64)","Financial","[Encrypted Field]","Federal ID No"]
[null,"steidn",null,"String (20)","Financial",null,"State ID No"]
[null,"resnum",null,"String (30)","Financial",null,"Resale No"]
[null,"actnum",null,"String (30)","Financial",null,"Account No"]
[null,"licnum",null,"String (30)","Financial",null,"License No"]
[null,"intrnl",null,"Numeric","Financial","0-No;1=Yes","Internal Vendor"]
[null,"prt199","**","Numeric","Financial","US Edition: 0-Undetermined; 1-Nonemployee Comp; 2-Rent; 3-Attorney; 4-Interest; 5-Medical; 6-Dividends; 7-No 1099\nNon-US: 0-Undetermined; 1-Nonemployee Comp; 2-Rent; 3-Attorney; 4-Interest; 5-No 1099","1099 Type"]
[null,"elc199",null,"Numeric","Financial","0-No;1=Yes","Aatrix Electronic 1099 Consent"]
[null,"eml199",null,"String (75)","Financial",null,"Aatrix Email Recipient"]
[null,"dscrte",null,"Numeric (3,2)","Invoice Defaults",null,"Discount Rate"]
[null,"dscdte",null,"String (6)","Invoice Defaults","##DY,##TH or ##MO","Discount Terms"]
[null,"duedte",null,"String (6)","Invoice Defaults","##DY,##TH or ##MO","Due Terms"]
[null,"cmprte",null,"Numeric (3,2)","Invoice Defaults",null,"Work Comp Rate"]
[null,"utxrte",null,"Numeric (3,2)","Invoice Defaults",null,"Use Tax Rate"]
[null,"lgrdft","**","Numeric","Invoice Defaults",null,"Ledger Account"]
[null,"cdedft","**","Numeric (12,3)","Invoice Defaults",null,"Cost Code"]
[null,"typdft","**","Numeric","Invoice Defaults","0-None; 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Udf6; 7-Udf7; 8-Udf8; 9-Udf9","Cost Type"]
[null,"stsdft","**","Numeric","Invoice Defaults","0-None; 1-Open; 2-Review; 3-Dispute","Invoice Status"]
[null,"wrndft","**","Numeric","Invoice Defaults","0-None; 1-Warn if no PO; 2-Warn if no Subcontract; 4-Require PO; 5-Require Subcontract; 6-Require PO or Subcontract","PO Warning"]
[null,"utwarn","**","Numeric","Invoice Defaults","0-None; 1-Warn if no Use Tax; 2-Require Use Tax","Use Tax Warning"]
[null,"hotlst",null,"Numeric","Invoice Defaults","0-No;1=Yes","Put on the Hot List"]
[null,"dupchk",null,"Numeric","Invoice Defaults","0-No;1=Yes","Allow duplicate invoice no"]
[null,"sepchk",null,"Numeric","Invoice Defaults","0-No;1=Yes","Separate check for each invoice"]
[null,"rfptyp","**","Numeric","Other Defaults",null,"RFP Type"]
[null,"rfpdsc",null,"String (50)","Other Defaults",null,"RFP Description"]
[null,"ordtyp","**","Numeric","Other Defaults",null,"Purchase Order Type"]
[null,"orddsc",null,"String (50)","Other Defaults",null,"Purchase Order Description"]
[null,"contyp","**","Numeric","Other Defaults",null,"Subcontract Type"]
[null,"condsc",null,"String (50)","Other Defaults",null,"Subcontract Description"]
[null,"paymth","**","Numeric","Other Defaults","0-None; 2-Check; 2-Credit Card; 3-ACH Payment; 4-Online Banking; 5-Manual Check; 6-Voucher","Preferred Payment Method"]
[null,"dirdep",null,"Numeric","ACH Pmt","0-No;1=Yes","Enable ACH payment"]
[null,"prente","**","Numeric","ACH Pmt","1=Prenote;2=10 day wait;3=Active;4=Inactive","ACH Account Status"]
[null,"acttyp","**","Numeric","ACH Pmt","1=Checking;2=Savings","ACH Account Type"]
[null,"rtnmbr",null,"String (9)","ACH Pmt",null,"ACH Routing No"]
[null,"bnkact",null,"String (64)","ACH Pmt",null,"ACH Bank Account No"]
[null,"acheml",null,"String (75)","ACH Pmt",null,"ACH Email Rec To"]
[null,"ntetxt",null,"Text","Header",null,"Notes"]
[]
[null,"Required(I) - required for Inserts only"]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"*** Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF"]
[null,"1) Go To 7-1 Company Information"]
[null,"2) Click Options, then Database Security Encryption"]
[null,"3) Select \"OFF\""]
[]
[null,"File Example:"]
[null,"filetype,recnum,vndnme,shtnme,vndtyp"]
[null,"APVEND,19001,ABC Contracting, ABC Cont,2"]
[null,"APVEND,19002,DF Construction, DF Const,2"]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":53,"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","Vendor No","Vendor Name","Vendor Short Name","Vendor Type","Owner Name","Vendor Addr 1","Vendor Addr 2","Vendor City","Vendor State","Vendor Zip","Minority Type","Tax District","User Def1","User Def2","Federal ID No ***","State ID No","Resale No","Account No","License No","Internal Vendor","1099 Type","Aatrix Electronic 1099 Consent","Aatrix Email Recipient","Discount Rate","Discount Terms","Due Terms","Work Comp Rate","Use Tax Rate","Ledger Account","Cost Code","Cost Type","Invoice Status","PO Warning","Use Tax Warning","Put on the Hot List","Allow duplicate invoice no","Separate check for each invoice","RFP Type","RFP Description","Purchase Order Type","Purchase Order Description","Subcontract Type","Subcontract Description","Preferred Payment Method","Enable ACH payment","ACH Account Status","ACH Account Type","ACH Routing No","ACH Bank Account No","ACH Email Rec To","Notes"]
[null,"APVEND","Numeric","String (75)","String (30)","Numeric","String (50)","String (50)","String (50)","String (50)","String (2)","String (10)","Numeric","Numeric","String (50)","String (50)","String (64)","String (20)","String (30)","String (30)","String (30)","Numeric","Numeric","Numeric","String (75)","Numeric (3,2)","String (6)","String (6)","Numeric (3,2)","Numeric (3,2)","Numeric","Numeric (12,3)","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","String (50)","Numeric","String (50)","Numeric","String (50)","Numeric","Numeric","Numeric","Numeric","String (9)","String (64)","String (75)","Text"]
[null,null,"Header","Header","Header","Header","General","General","General","General","General","General","General","General","General","General","Financial","Financial","Financial","Financial","Financial","Financial","Financial","Financial","Financial","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Invoice Defaults","Other Defaults","Other Defaults","Other Defaults","Other Defaults","Other Defaults","Other Defaults","Other Defaults","ACH Pmt","ACH Pmt","ACH Pmt","ACH Pmt","ACH Pmt","ACH Pmt","Header"]
[]
["First Line of File==>","filetype","recnum","vndnme","shtnme","vndtyp","ownnme","addrs1","addrs2","ctynme","state_","zipcde","minsts","taxdst","usrdf1","usrdf2","fedidn","steidn","resnum","actnum","licnum","intrnl","prt199","elc199","eml199","dscrte","dscdte","duedte","cmprte","utxrte","lgrdft","cdedft","typdft","stsdft","wrndft","utwarn","hotlst","dupchk","sepchk","rfptyp","rfpdsc","ordtyp","orddsc","contyp","condsc","paymth","dirdep","prente","acttyp","rtnmbr","bnkact","acheml","ntetxt"]
[null,"APVEND",301,"123 Contractors",123,null,"John",null,null,"Irvine"]
[null,"APVEND",302,"ABC Contractors","ABC",null,"Jack",null,null,"Costa Mesa"]