insert into genuser (name,password,raccessap,raccessar,raccessgl,raccesspay,raccessinv,raccessest,raccessfix,raccessimp,waccessap,waccessar,waccessgl,waccesspay,waccessinv,waccessest,waccessfix,waccessimp,saccessap,saccessar,saccessgl,saccesspay,saccessinv,saccessest,saccessfix,saccessimp,supervisor,active) values ('admin','password','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1');


insert into genstylesheet (name,filename) values ('Blue Heaven', 'blueheaven');
insert into genstylesheet (name,filename) values ('Earth Tones', 'earthtones');
insert into genstylesheet (name,filename) values ('Black and White', 'bw');
insert into genstylesheet (name,filename) values ('Cool Gray', 'coolgray');
insert into genstylesheet (name,filename) values ('Unix Terminal', 'unixterm');
insert into genstylesheet (name,filename) values ('Hot Tomato', 'tomato');

insert into menucategory (id, name, orderflag, menu, description, accessar, accessinv, accessest, extvend, extcust) values (1, 'Order Entry', 1, 1, 'Provides an easy means for you to enter orders for: Standard Items; Custom one-time Print Jobs; or New Standard Items to be printed. All of these order types can also be edited and updated. Also, you can enter/update customer information or print lists of customers. Simply click on the appropriate section.', 1, 1, 1, 1, 1);
insert into menucategory (id, name, orderflag, menu, description, accessar, accessinv, accessest, extvend, extcust) values (2, 'Order Lists', 2, 1, 'Check on open orders or item, or look to see when an order or item was shipped. By drilling down from the order shipped list, you can see the tracking number, or bring up a copy of the packing slip. Performance statistics track on-time performance for orders.', 1, 1, 1, 1, 1);
insert into menucategory (id, name, orderflag, menu, description, accessar, nonext) values (3, 'Order Processing', 3, 1, 'Track progress of order through plant from initial receipt to QC and ship', 1, 1);
insert into menucategory (id, name, orderflag, menu, description, accessar, nonext) values (4, 'Billing', 4, 1, 'Write Invoices, check customer accounts, view summaries of billing info, aging data.', 1, 1);
insert into menucategory (id, name, orderflag, menu, description, accessinv) values (5, 'Inventory', 5, 1, 'Enter/Change Item information and run item reports.', 1);
insert into menucategory (id, name, orderflag, menu, description, accessap, accessinv, extvend) values (6, 'Vendors', 6, 1, 'Enter/Change Vendor information, run lists or labels, and update vendor login users.', 1, 1, 1);
insert into menucategory (id, name, orderflag, menu, description, accessinv) values (7, 'Purchasing', 7, 1, 'Receive items into inventory either directly, or by first issuing a PO and tracking status. After PO is received, vendor billing information can be transferred to payables.', 1);
insert into menucategory (id, name, orderflag, menu, description, accessap) values (8, 'Payables', 8, 1, 'Manage your accounts payables by tracking open bills and aging of payables. Write checks for specific invoices, or for all invoices grouped by date range.', 1);
insert into menucategory (id, name, orderflag, menu, description, accesspay) values (9, 'Payroll', 9, 1, 'Calculate payrolls, write checks, track vacation, sick leave, etc. Write 941, W2 and other payroll reports.', 1);
insert into menucategory (id, name, orderflag, menu, description, accessgl) values (10, 'General Ledger', 10, 1, '', 1);
insert into menucategory (id, name, orderflag, menu, description, supervisor) values (11, 'Admin', 11, 1, 'Add Internal Users, adjust their rights, import data from external database, and set up Document Categories to allow easier searches for Documents.', 1);
insert into menucategory (id, name, orderflag, menu, description, nonsupervisor) values (12, 'Preferences', 12 , 1, '', 1);
insert into menucategory (id, name, orderflag, menu, description, setupar) values (13, 'AR Setup', 15 , 0, 'Enter/Update all the necessary standards on which quoting and scheduling are based, carriers used, etc.', 1);
insert into menucategory (id, name, orderflag, menu, description, setupap) values (14, 'AP Setup', 16 , 0, 'Enter/Update Vendor Terms, checking account info, and GL accounts for tie-ins.', 1);
insert into menucategory (id, name, orderflag, menu, description, setupest) values (15, 'Print Management Setup', 17 , 0, 'Enter/Update all the necessary standards on which quoting and scheduling are based, carriers used, etc.', 1);
insert into menucategory (id, name, orderflag, menu, description, setuppay) values (16, 'Payroll Setup', 18 , 0, 'Enter/Update Taxes, deductions, pension plans, etc. on which payroll is based.', 1);
insert into menucategory (id, name, orderflag, menu, description, setupgl) values (17, 'General Ledger Setup', 19 , 0, 'Set the fiscal year for your company. Account types you should NOT change unless you are VERY sure you understand the implications of changing them.', 1);
insert into menucategory (id, name, orderflag, menu, description, setupinv) values (18, 'Inventory Setup', 20 , 0, 'Enter Unit, Location, Category, etc. information about how the inventory is to be organized.', 1);

insert into menufunction (id, menucategoryid, name, link, orderflag, accessar,leftimageurl) values (1, 1, 'New Order Standard Items', 'arordadd.php', 1, 1,'images/menu/orderentry.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar,leftimageurl) values (2, 1, 'View/Change Standard Order', 'arordupd.php', 2, 1,'images/menu/orderentry.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessest,leftimageurl) values (3, 1, 'New PAR', 'estquoteaddform.php', 3, 1,'images/menu/customprint2.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessest,leftimageurl) values (4, 1, 'View/Change PAR', 'estquoteaddsearch.php', 4, 1,'images/menu/customprint2.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessest,leftimageurl) values (5, 1, 'New Ad-hoc Print Order', 'estquoteadd.php', 5, 1,'images/menu/customprint.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessest,leftimageurl) values (6, 1, 'View/Change Ad-hoc Print Order', 'estquoteupd.php', 6, 1,'images/menu/customprint.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, accessest, extcust,leftimageurl) values (7, 1, 'Add/Update Customer', 'arcustupd.php', 7, 1, 1, 1,'images/menu/personnel.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, accessest,leftimageurl) values (8, 1, 'List Customers', 'arcustlist.php', 8, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, accessest, extcust,leftimageurl) values (9, 1, 'Add/Update External Users', 'arcustextuser.php', 9, 1, 1, 1,'images/menu/employees.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (10, 1, 'Setup Functions for Print Management', 'explain.php?menucategoryid=15', 10, 1,'images/menu/setup.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, extcust,leftimageurl) values (11, 2, 'Open Orders', 'arorderlist.php', 1, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, extcust,leftimageurl) values (12, 2, 'Orders Shipped', 'arordershiplst.php', 2, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, extcust,leftimageurl) values (13, 2, 'Open Items on Orders', 'arorderitemlst.php', 3, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, extcust,leftimageurl) values (14, 2, 'Items Shipped', 'arordershipitemlst.php', 4, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, extcust,leftimageurl) values (15, 2, 'Performance Statistics', 'arorderstatlst.php', 5, 1, 1,'images/menu/graph2.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (16, 3, 'Check In/Out Orders', 'arorderckout.php', 1, 1, 1,'images/menu/checkmark.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (17, 3, 'Fill Order Start/Stop', 'arorderfill.php', 2, 1, 1,'images/menu/trafficlight.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (18, 3, 'Enter New Shipment', 'arordshipadd.php', 3, 1, 1,'images/menu/qc-ship.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (19, 3, 'View Shipped Orders', 'arordshipview.php', 4, 1, 1,'images/menu/openorders.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (20, 3, 'Order Processing Status', 'arorderstatuslst.php', 5, 1, 1,'images/menu/graph2.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (21, 4, 'Add Invoice', 'arinvoiceadd.php', 1, 1, 1,'images/menu/invoice.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (151, 4, 'Update Invoice', 'arinvoiceupd.php', 2, 1, 1,'images/menu/invoice.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (22, 4, 'Summary of Invoices', 'arinvoicesum.php', 3, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (23, 4, 'View Customer Account', 'arinvoicerepcust.php', 4, 1, 1,'images/menu/rollodex.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (24, 4, 'Aging Report', 'arinvoicerepaging.php', 5, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (152, 4, 'Aging Details', 'arinvoicerepaging.php?detail=1', 5, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (25, 4, 'Statements', 'arinvoicestate.php', 6, 1, 1,'images/menu/Clipboard__Note.jpg');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (153, 4, 'Calculate Interest', 'arinvoicecalcint.php', 7, 1, 1,'images/menu/dollar.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (26, 4, 'Enter Payments', 'arinvoicepay.php', 7, 1, 1,'images/menu/dollar.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (27, 4, 'Payment Reports', 'arinvoicereppay.php', 8, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessar, nonext,leftimageurl) values (28, 4, 'Sales Tax Reports', 'arinvoicereptax.php', 9, 1, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar, nonext,leftimageurl) values (29, 4, 'Setup Functions for Receivables', 'explain.php?menucategoryid=13', 10, 1, 1,'images/menu/setup.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (30, 5, 'Item Maintenance', 'invitemupd.php', 1, 1,'images/menu/Write0a.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (31, 5, 'Item Suppliers', 'invitemvendupd.php', 2, 1,'images/menu/personnel3.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (32, 5, 'Item Summaries', 'invitemlstsum.php', 3, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (33, 5, 'Item Prices', 'invitemlstprice.php', 4, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (34, 5, 'Item Status', 'invitemlststatus.php', 5, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (35, 5, 'Item Usage History', 'invitemlstusage.php', 6, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (36, 5, 'BOM List', 'invitemlstcomp.php', 7, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (37, 5, 'Item Distribution', 'invitemlstdist.php', 8, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (38, 5, 'Physical Inventory', 'invitemlstphys.php', 9, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (39, 5, 'Inventory Valuation', 'invitemlstval.php', 10, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (40, 5, 'Setup Functions for Inventory', 'explain.php?menucategoryid=18', 11, 1,'images/menu/setup.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accessap, accessinv, extvend,leftimageurl) values (41, 6, 'Vendor Maintenance', 'apvendupd.php', 1, 1, 1, 1,'images/menu/personnel.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap, accessinv, nonext,leftimageurl) values (42, 6, 'Vendor Lists/Labels', 'apvendlist.php', 2, 1, 1, 1,'images/menu/labels.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap, accessinv, extvend,leftimageurl) values (43, 6, 'Add/Update Enternal Vendor Users', 'apvendextuser.php', 3, 1, 1, 1,'images/menu/employees.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (44, 7, 'New Purchase Order', 'invpoadd.php', 1, 1,'images/menu/statemt.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (45, 7, 'Update PO', 'invpoupd.php', 2, 1,'images/menu/statemt.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (46, 7, 'Receive Items on PO', 'invporecv.php', 3, 1,'images/menu/graphicdesign.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (47, 7, 'Completed PO to AP', 'invpotoap.php', 4, 1,'images/menu/createform.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (48, 7, 'PO Lists', 'invpolist.php', 5, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (49, 7, 'Receive without PO', 'invitemrecadd.php', 6, 1,'images/menu/boxin.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessinv,leftimageurl) values (50, 7, 'List Items Received', 'invitemreclist.php', 7, 1,'images/menu/page.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (51, 8, 'New Vendor Bill', 'apbilladd.php', 1, 1,'images/menu/log.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (52, 8, 'View/Change Bills', 'apbillupd.php', 2, 1,'images/menu/log.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (53, 8, 'Write Checks Specific', 'apbillpay.php?specific=1', 3, 1,'images/menu/Block3.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (54, 8, 'Write Checks by Date', 'apbillpay.php', 4, 1,'images/menu/Block3.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (55, 8, 'View/Cancel Checks', 'apchecking.php', 5, 1,'images/menu/qc.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (56, 8, 'Lists of Checks', 'apchecklist.php', 6, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (57, 8, 'Payables Lists', 'apbilllist.php', 7, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (58, 8, 'Summary Aging', 'apbilllistaging.php', 8, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (59, 8, 'Detail Aging', 'apbilllistaging.php?detail=1', 9, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (60, 8, 'Discount Aging', 'apbilllistdiscaging.php', 10, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessap,leftimageurl) values (61, 8, 'Setup Functions for Payables', 'explain.php?menucategoryid=14', 11, 1,'images/menu/setup.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (62, 9, 'Log Hours', 'prloghours.php', 1, 1,'images/menu/clockout.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (63, 9, 'Calculate/Pay Taxes', 'prcalchours.php', 2, 1,'images/menu/calculator2.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (64, 9, 'Write Checks', 'prcheckwrite.php', 3, 1,'images/menu/Block3.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (65, 9, 'Check Summary One Period', 'prchecksum.php', 4, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (66, 9, 'Check Summary Multiple Periods', 'prchecksumgroup.php', 5, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (67, 9, 'Add/Update Employees', 'premployeeupd.php', 6, 1,'images/menu/interview.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (68, 9, 'Employee Deductions', 'premplded.php', 7, 1,'images/menu/interview.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (69, 9, 'Employee Phone List', 'prempllist.php?type=phone', 8, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (70, 9, 'Name/Address/Phone List', 'prempllist.php?type=nap', 9, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (71, 9, 'Birthday List', 'prempllist.php?type=bday', 10, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (72, 9, 'General Info List', 'prempllist.php?type=gen', 11, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (73, 9, 'Employee Pay by Week', 'prempllist.php?type=hpw', 12, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (74, 9, 'Employee Pay by Month', 'prempllist.php?type=hpm', 13, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (75, 9, 'Employee Pay by Quarter', 'prempllist.php?type=hpq', 14, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (76, 9, 'Write Employee Review', 'premplreviewupd.php', 15, 1,'images/menu/awards.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (77, 9, 'Print 941', 'pr941.php', 16, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accesspay,leftimageurl) values (78, 9, 'Print W2s', 'prw2.php', 17, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (79, 9, 'Setup Functions for Payroll', 'explain.php?menucategoryid=16', 16, 1,'images/menu/setup.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (80, 10, 'New Journal Entries', 'gljouradd.php', 1, 1,'images/menu/reports.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (81, 10, 'Edit Jounal Entries', 'gljourupd.php', 2, 1,'images/menu/reports.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (82, 10, 'Post Journals Now', 'glpostadd.php', 3, 1,'images/menu/boxin.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (83, 10, 'Reverse Journal Postings', 'glpostupd.php', 4, 1,'images/menu/boxout.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (84, 10, 'Profit and Loss Statement', 'glrepincome.php', 5, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (85, 10, 'Balance Sheet', 'glrepbalance.php', 6, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (86, 10, 'Account Activity', 'glrepactivity.php', 7, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (87, 10, 'Budget Variance', 'glrepbudvariance.php', 8, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (88, 10, 'Journal Reports', 'glrepjournal.php', 9, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (89, 10, 'My Pie Charts', 'glpieadd.php', 10, 1,'images/menu/piechart.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (90, 10, 'Edit Chart of Accounts', 'glacctupd.php', 11, 1,'images/menu/org_chart.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (91, 10, 'Chart of Accounts List', 'glacctlst.php', 12, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (92, 10, 'Add Update Budgets', 'glbudadd.php', 13, 1,'images/menu/file_cab.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, accessgl,leftimageurl) values (93, 10, 'Budget List', 'glbudlst.php', 14, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupgl,leftimageurl) values (94, 10, 'Setup Functions for General Ledger', 'explain.php?menucategoryid=17', 15, 1,'images/menu/setup.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, supervisor,leftimageurl) values (95, 11, 'Users and Rights', 'genuserupd.php', 1, 1,'images/menu/personnel3.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, supervisor,leftimageurl) values (96, 11, 'Client Companies', 'gencompanyupd.php', 2, 1,'images/menu/Shake0a.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, supervisor,leftimageurl) values (97, 11, 'Document Categories', 'admindocmgmtcatupd.php', 3, 1,'images/menu/signpost.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, supervisor,leftimageurl) values (98, 11, 'Import Customers', 'importcustomer.php', 4, 1,'images/menu/chainlink.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, nonsupervisor) values (99, 12, 'User Info and Rights', 'genuserupd.php', 1, 1);

insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (100, 13, 'Company Options', 'adminarcompanyupd.php', 1, 1,'images/menu/Build1.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (101, 13, 'Sales Taxes', 'adminarsalestaxupd.php', 2, 1,'images/menu/balance.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (102, 13, 'Tax Exemption Categories', 'adminartaxexupd.php', 3, 1,'images/menu/balance.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (103, 13, 'Quote Comment Table', 'adminarquotecomupd.php', 4, 1,'images/menu/Note.jpg');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (104, 13, 'Sales Personnel', 'adminarsalesmanupd.php', 5, 1,'images/menu/employees.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (105, 13, 'Invoice Terms', 'adminarinvtermsupd.php', 6, 1,'images/menu/terms.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (106, 13, 'Standard GL Accounts', 'adminarglacct.php', 7, 1,'images/menu/stdglaccts.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (107, 13, 'Shipping Carriers/Methods', 'adminarcarrierupd.php', 8, 1,'images/menu/delivery.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupar,leftimageurl) values (108, 13, 'Sales Units', 'admininvunitnameupd.php', 1, 1,'images/menu/cone.gif');



insert into menufunction (id, menucategoryid, name, link, orderflag, setupap,leftimageurl) values (109, 14, 'Vendor Terms', 'adminappaytermsupd.php', 1, 1,'images/menu/terms.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupap,leftimageurl) values (110, 14, 'Standard GL Accounts', 'adminapglacct.php', 2, 1,'images/menu/stdglaccts.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupap,leftimageurl) values (111, 14, 'Checking Accounts', 'adminapchkacctupd.php', 3, 1,'images/menu/Block3.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (112, 15, 'Cost Centers/Machines', 'adminestcostcenterupd.php', 1, 1,'images/menu/puzzle.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (115, 15, 'Inks Database', 'adminestquoteinkupd.php', 4, 1,'images/menu/inks.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (116, 15, 'General Ink Info', 'adminestquotegenink.php', 5, 1,'images/menu/inks.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (117, 15, 'Standard Sizes', 'adminestquotestdsizeupd.php', 6, 1,'images/menu/stdsizes.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (118, 15, 'Print Stocks', 'estquotestockupd.php', 7, 1,'images/menu/writepads.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (119, 15, 'Work Types', 'adminestquoteworktypeupd.php', 8, 1,'images/menu/decision.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (120, 15, 'Add/Update Notes for Quote', 'adminestquotequotenotesupd.php', 9, 1,'images/menu/Note.jpg');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (124, 15, 'Shipping Carriers/Methods', 'adminarcarrierupd.php', 11, 1,'images/menu/delivery.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (122, 15, 'Print Pricing', 'estprpricelstupd.php', 12, 1,'images/menu/cashregister.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (123, 15, 'Nonprint Pricing', 'estnpupd.php', 13, 1,'images/menu/cashregister.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (121, 15, 'Print Tools Add/Update', 'estprpricetoolsupd.php', 14, 1,'images/menu/tolls.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupest,leftimageurl) values (150, 15, 'Cut/Trim Operations', 'estprgeneralupd.php', 14, 1,'images/menu/tolls.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (125, 16, 'Checking Accounts', 'adminapchkacctupd.php', 1, 1,'images/menu/Block3.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (126, 16, 'Pay Types', 'adminprpaytypeupd.php', 2, 1,'images/menu/drama.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (127, 16, 'Deduction Groups', 'adminprdedgroupupd.php', 3, 1,'images/menu/colordots.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (128, 16, 'Add New Tax', 'adminprtaxtypeadd.php', 4, 1,'images/menu/unhappyface.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (129, 16, 'View/Update Tax', 'adminprtaxtypeupd.php', 5, 1,'images/menu/unhappyface.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (130, 16, 'Enter/Update Tax Tables', 'adminprtaxtypedtl.php', 6, 1,'images/menu/unhappyface.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (131, 16, 'General Factors', 'adminprgendat.php', 7, 1,'images/menu/sloppyfiles.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (132, 16, 'General Benefits (Pay)', 'adminprben.php', 8, 1,'images/menu/happyface.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (133, 16, 'General Deductions', 'adminprded.php', 9, 1,'images/menu/unhappyface.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (134, 16, 'Company Contributions', 'adminprcon.php', 10, 1,'images/menu/nc2.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (135, 16, 'Pension Plans', 'adminprpens.php', 11, 1,'images/menu/gift.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (136, 16, 'Rating Scale For Reviews', 'adminpremplreviewratingupd.php', 12, 1,'images/menu/awards.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setuppay,leftimageurl) values (137, 16, 'Standard GL Accounts', 'adminprglacct.php', 13, 1,'images/menu/stdglaccts.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, setupgl,leftimageurl) values (138, 17, 'Set Fiscal Year', 'adminglcompanyupd.php', 1, 1,'images/menu/calendar.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupgl,leftimageurl) values (139, 17, 'Account Types', 'adminglaccttypeupd.php', 2, 1,'images/menu/stdglaccts.gif');

insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (140, 18, 'Inventory Units', 'admininvunitnameupd.php', 1, 1,'images/menu/cone.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (141, 18, 'Plant Locations', 'admininvlocationupd.php', 2, 1,'images/menu/Build1.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (142, 18, 'Standard GL Accounts', 'admininvglacct.php', 3, 1,'images/menu/stdglaccts.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (143, 18, 'Purge Out-Date Files', 'admininvattachupd.php', 4, 1,'images/menu/103-BTN.GIF');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (144, 18, 'Item Categories', 'invitemcatupd.php', 5, 1,'images/menu/wheel.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (145, 18, 'Category Lists', 'invitemcatlst.php', 6, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (146, 18, 'Pricing Levels', 'invlevelupd.php', 7, 1,'images/menu/lookup2.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (147, 18, 'Price Level List', 'invlevellst.php', 8, 1,'images/menu/page.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (148, 18, 'Standard Markup', 'invmarkupupd.php', 9, 1,'images/menu/money1.gif');
insert into menufunction (id, menucategoryid, name, link, orderflag, setupinv,leftimageurl) values (149, 18, 'Markups List', 'invmarkuplst.php', 10, 1,'images/menu/page.gif');

insert into menupage (menufunctionid, name, orderflag, setupap) values (115, 'adminapchkacctadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupap) values (115, 'adminapchkacctupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupap) values (110, 'adminapglacct.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupap) values (109, 'adminappaytermsadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupap) values (109, 'adminappaytermsupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (107, 'adminarcarrieradd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (107, 'adminarcarriermethupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (107, 'adminarcarrierupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (100, 'adminarcompanyupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (106, 'adminarglacct.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (105, 'adminarinvtermsadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (105, 'adminarinvtermsupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (103, 'adminarquotecomadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (103, 'adminarquotecomupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (104, 'adminarsalesmanadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (104, 'adminarsalesmanupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (101, 'adminarsalestaxadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (101, 'adminarsalestaxupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (102, 'adminartaxexadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupar) values (102, 'adminartaxexupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, supervisor) values (97, 'admindocmgmtcatadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, supervisor) values (97, 'admindocmgmtcatupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (112, 'adminestcostcenteradd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (112, 'adminestcostcentersubtypeadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (112, 'adminestcostcentersubtypeupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (112, 'adminestcostcenterupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (112, 'adminestmachineadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (112, 'adminestmachineupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (116, 'adminestquotegenink.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (115, 'adminestquoteinkadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (115, 'adminestquoteinkupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (120, 'adminestquotequotenotesadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (121, 'adminestquotequotenotesupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (117, 'adminestquotestdsizeadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (117, 'adminestquotestdsizeupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (118, 'adminestquotestockcolor.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (118, 'adminestquotestockcost.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (119, 'adminestquoteworktypeadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (119, 'adminestquoteworktypeaddl.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (119, 'adminestquoteworktypestdqty.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupest) values (119, 'adminestquoteworktypeupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupgl) values (139, 'adminglaccttypeadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupgl) values (139, 'adminglaccttypeupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupgl) values (138, 'adminglcompanyupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupinv) values (143, 'admininvattachupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupinv) values (142, 'admininvglacct.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupinv) values (141, 'admininvlocationadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupinv) values (141, 'admininvlocationupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupinv) values (140, 'admininvunitnamenadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setupinv) values (140, 'admininvunitnameupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (132, 'adminprben.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (134, 'adminprcon.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (133, 'adminprded.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (127, 'adminprdedgroupadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (127, 'adminprdedgroupupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (136, 'adminpremplreviewratingadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (136, 'adminpremplreviewratingupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (131, 'adminprgendat.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (137, 'adminprglacct.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (126, 'adminprpaytypeadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (126, 'adminprpaytypeupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (135, 'adminprpens.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (128, 'adminprtaxtypeadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (130, 'adminprtaxtypedtl.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, setuppay) values (129, 'adminprtaxtypeupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (51, 'apbilladd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (57, 'apbilllist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (58, 'apbilllistaging.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (60, 'apbilllistdiscaging.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (54, 'apbillpay.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (52, 'apbillupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (55, 'apchecking.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (56, 'apchecklist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (41, 'apvendadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (42, 'apvendcsvlist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (43, 'apvendextuser.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (42, 'apvendlist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (42, 'apvendlistview.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessap) values (41, 'apvendupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (7, 'arcustadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (8, 'arcustcsvlist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (9, 'arcustextuser.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (8, 'arcustlist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (8, 'arcustlistview.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (7, 'arcustupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (21, 'arinvoiceadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (21, 'arinvoiceaddcogs.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (153, 'arinvoicecalcint.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (26, 'arinvoicepay.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (24, 'arinvoicerepaging.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (23, 'arinvoicerepcust.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (27, 'arinvoicereppay.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (28, 'arinvoicereptax.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (25, 'arinvoicestate.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (22, 'arinvoicesum.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (151, 'arinvoiceupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (1, 'arordadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (16, 'arorderckout.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (17, 'arorderfill.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (13, 'arorderitemlst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (11, 'arorderlst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (14, 'arordershipitemlst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (12, 'arordershiplst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (15, 'arorderstatlst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (20, 'arorderstatuslst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (18, 'arordpicktick.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (18, 'arordshipadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (19, 'arordshipview.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessar) values (2, 'arordupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (123, 'estnpadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (123, 'estnpoperations.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (123, 'estnpoperationsize.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (123, 'estnpoperationsoptions.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (123, 'estnpoperationssizeaddl.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (123, 'estnpupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelstadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelststockusageadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelststockusagecolor.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelststockusageconsumables.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelststockusageprice.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelststockusagestockadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelststockusagestockupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelststockusageupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricelstupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricetoolsadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estprpricetoolsupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (5, 'estquoteadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (6, 'estquoteupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estquotepricelstadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estquotepricelstcolor.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estquotepricelstprice.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estquotepricelststockadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estquotepricelststockupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (122, 'estquotepricelstupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (118, 'estquotestockadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessest) values (118, 'estquotestockupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, supervisor) values (96, 'gencompanyadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, supervisor) values (96, 'gencompanyupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, supervisor) values (95, 'genuseradd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, supervisor) values (95, 'genuserupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (90, 'glacctadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (90, 'glacctadd1.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (90, 'glacctadd2.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (90, 'glacctadd3.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (90, 'glacctadd4.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (91, 'glacctlst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (91, 'glacctlst1.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (90, 'glacctupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (92, 'glbudadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (93, 'glbudlst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (80, 'gljouradd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (80, 'gljouradd1.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (80, 'gljouradd2.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (81, 'gljourupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (81, 'gljourupd1.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (89, 'glpie.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (89, 'glpieadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (82, 'glpostadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (83, 'glpostupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (86, 'glrepactivity.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (85, 'glrepbalance.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (87, 'glrepbudvariance.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (84, 'glrepincome.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessgl) values (88, 'glrepjournal.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, supervisor) values (98, 'importcustomer.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (30, 'invitemadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (30, 'invitemadd1.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (30, 'invitemadd2.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (144, 'invitemcatadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (145, 'invitemcatlst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (144, 'invitemcatupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (36, 'invitemlstcomp.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (37, 'invitemlstdist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (38, 'invitemlstphys.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (33, 'invitemlstprice.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (34, 'invitemlststatus.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (32, 'invitemlstsum.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (35, 'invitemlstusage.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (49, 'invitemrecadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (50, 'invitemreclist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (30, 'invitemupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (30, 'invitemupd1.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (31, 'invitemvendupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (146, 'invleveladd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (147, 'invlevellst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (146, 'invlevelupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (148, 'invmarkupadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (149, 'invlmarkuplst.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (148, 'invmarkupupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (44, 'invpoadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (48, 'invpolist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (46, 'invporecv.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (47, 'invpotoap.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (45, 'invpoupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accessinv) values (48, 'invpoview.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (77, 'pr941.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (63, 'prcalchours.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (65, 'prchecksum.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (66, 'prchecksumgroup.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (65, 'prcheckvoid.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (64, 'prcheckwrite.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (68, 'premplded.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (72, 'prempllist.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (67, 'premployeeadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (67, 'premployeeupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (76, 'premplreviewadd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (76, 'premplreviewupd.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (62, 'prloghours.php', 1, 1);
insert into menupage (menufunctionid, name, orderflag, accesspay) values (78, 'prw2.php', 1, 1);

insert into glaccount (name,description,accounttypeid) values ('100','Setup Account - Edit Me','1');

insert into gencompany (name) values ('My Company - Edit Me');

insert into accounttype (id,description) values ('10','Current Assets');
insert into accounttype (id,description) values ('11','Fixed Assets');
insert into accounttype (id,description) values ('13','Other Assets');
insert into accounttype (id,description) values ('21','Current Liabilities');
insert into accounttype (id,description) values ('22','Long Term Liabilities');
insert into accounttype (id,description) values ('23','Other Liabilities');
insert into accounttype (id,description) values ('30','Capital');
insert into accounttype (id,description) values ('40','Retained Earnings');
insert into accounttype (id,description) values ('50','Sales');
insert into accounttype (id,description) values ('60','Sales Adjustments');
insert into accounttype (id,description) values ('70','Cost of Goods Sold');
insert into accounttype (id,description) values ('80','Expenses');
insert into accounttype (id,description) values ('90','Other Income and Expense');

insert into glcompany (id,fiscalbeginmonth) values ('1','1');

insert into unitname (unitname) values ('each');

insert into inventorylocation (companyid,gencompanyid) values ('7','1');

insert into markupset (description, companyid) values ('Standard','1');

insert into markupsetlevel (pricelevelid,markupsetid,markuppercent) values ('1','1','20');

insert into pricelevel (description,companyid) values ('Standard','1');

insert into vendor (paytocompanyid,orderfromcompanyid,paytermsid,gencompanyid) values ('5','5','1','1');


insert into company (companyname) values ('My Salesman - Edit Me');
insert into company (companyname) values ('UPS');
insert into company (companyname) values ('FedEX');
insert into company (companyname) values ('USPS');
insert into company (companyname) values ('My Vendor - Edit Me');
insert into company (companyname) values ('My Customer - Edit Me');
insert into company (companyname) values ('My Location - Edit Me');

insert into customer (companyid,salesglacctid,salesmanid,servicerepid,invoicetermsid,quotecommentid,gencompanyid) values ('6','1','1','1','1','1','1');

insert into shipto (companyid,shiptocompanyid) values ('1','6');

insert into salesman (companyid,payrollid,commissionrate,commissionbase,servicerep,salesman,gencompanyid) values ('1','0','0','0','1','1','1');

insert into quotecomment (comments) values ('Quote Valid for 60 Days');

insert into invoiceterms (verbal,discountpercent,discountdays,discountdayofmonth,netduedays,ar,ap) values ('Net 30 Days','0','0','0','30','1','1');

insert into salestax (taxname,taxrate,taxbase,glacctid) values ('State','0','1','1');

insert into taxexempt (exemptname) values ('Non-profit Organization');
insert into taxexempt (exemptname) values ('Wholesale');

insert into carrier (companyid,trackingurlbase,trackingurlvarname) values ('2','https://wwwapps.ups.com/etracking/tracking.cgi?tracknums_displayed=5&TypeOfInquiryNumber=T&HTMLVersion=4.0&track.x=15&track.y=6&','InquiryNumber1');
insert into carrier (companyid,trackingurlbase,trackingurlvarname) values ('3','http://www.fedex.com/cgi-bin/tracking?action=track&language=english&cntry_code=us&initial=x&','tracknumbers');
insert into carrier (companyid,trackingurlbase,trackingurlvarname) values ('4','http://www.usps.com/cgi-bin/cttgate/ontrack.cgi?','tracknbr');

insert into carrierservice (carrierid,description) values ('1','Ground');
insert into carrierservice (carrierid,description) values ('2','Ground');
insert into carrierservice (carrierid,description) values ('3','Priority Mail');

insert into prpaytype (id,name,description,gencompanyid) values (1,'ST','Straight Time',1);
insert into prpaytype (id,name,description,gencompanyid) values (2,'OT','Overtime',1);
insert into prpaytype (id,name,description,gencompanyid) values (3,'DT','Doubletime',1);
insert into prpaytype (id,name,description,vacation,gencompanyid) values (4,'VAC','Vacation',1,1);
insert into prpaytype (id,name,description,sick,gencompanyid) values (5,'SICK','Sick Leave',1,1);

insert into prperiod (numperyear,name) values ('52','Weekly');
insert into prperiod (numperyear,name) values ('26','Bi-Weekly');
insert into prperiod (numperyear,name) values ('24','Semi-Monthly');
insert into prperiod (numperyear,name) values ('12','Monthly');

insert into docmgmtcategory (name) values ('Spec Sheet');

insert into genstate (id,stateinit,statename) values (1,'AL','Alabama');
insert into genstate (id,stateinit,statename) values (2,'AK','Alaska');
insert into genstate (id,stateinit,statename) values (3,'AZ','Arizona');
insert into genstate (id,stateinit,statename) values (4,'AR','Arkansas');
insert into genstate (id,stateinit,statename) values (5,'CA','California');
insert into genstate (id,stateinit,statename) values (6,'CO','Colorado');
insert into genstate (id,stateinit,statename) values (7,'CT','Connecticut');
insert into genstate (id,stateinit,statename) values (8,'DE','Delaware');
insert into genstate (id,stateinit,statename) values (9,'FL','Florida');
insert into genstate (id,stateinit,statename) values (10,'GA','Georgia');
insert into genstate (id,stateinit,statename) values (11,'HI','Hawaii');
insert into genstate (id,stateinit,statename) values (12,'ID','Idaho');
insert into genstate (id,stateinit,statename) values (13,'IL','Illinois');
insert into genstate (id,stateinit,statename) values (14,'IN','Indiana');
insert into genstate (id,stateinit,statename) values (15,'IA','Iowa');
insert into genstate (id,stateinit,statename) values (16,'KS','Kansas');
insert into genstate (id,stateinit,statename) values (50,'KY','Kentucky');
insert into genstate (id,stateinit,statename) values (51,'LA','Louisiana');
insert into genstate (id,stateinit,statename) values (17,'ME','Maine');
insert into genstate (id,stateinit,statename) values (18,'MD','Maryland');
insert into genstate (id,stateinit,statename) values (19,'MA','Massachusetts');
insert into genstate (id,stateinit,statename) values (20,'MI','Michigan');
insert into genstate (id,stateinit,statename) values (21,'MN','Minnesota');
insert into genstate (id,stateinit,statename) values (22,'MS','Mississippi');
insert into genstate (id,stateinit,statename) values (23,'MO','Missouri');
insert into genstate (id,stateinit,statename) values (24,'MT','Montana');
insert into genstate (id,stateinit,statename) values (25,'NE','Nebraska');
insert into genstate (id,stateinit,statename) values (26,'NV','Nevada');
insert into genstate (id,stateinit,statename) values (27,'NH','New Hampshire');
insert into genstate (id,stateinit,statename) values (28,'NJ','New Jersey');
insert into genstate (id,stateinit,statename) values (29,'NM','New Mexico');
insert into genstate (id,stateinit,statename) values (30,'NY','New York');
insert into genstate (id,stateinit,statename) values (31,'NC','North Carolina');
insert into genstate (id,stateinit,statename) values (32,'ND','North Dakota');
insert into genstate (id,stateinit,statename) values (33,'OH','Ohio');
insert into genstate (id,stateinit,statename) values (34,'OK','Oklahoma');
insert into genstate (id,stateinit,statename) values (35,'OR','Oregon');
insert into genstate (id,stateinit,statename) values (36,'PA','Pennsylvania');
insert into genstate (id,stateinit,statename) values (37,'RI','Rhode Island');
insert into genstate (id,stateinit,statename) values (38,'SC','South Carolina');
insert into genstate (id,stateinit,statename) values (39,'SD','South Dakota');
insert into genstate (id,stateinit,statename) values (40,'TN','Tennessee');
insert into genstate (id,stateinit,statename) values (41,'TX','Texas');
insert into genstate (id,stateinit,statename) values (42,'UT','Utah');
insert into genstate (id,stateinit,statename) values (43,'VT','Vermont');
insert into genstate (id,stateinit,statename) values (44,'VA','Virginia');
insert into genstate (id,stateinit,statename) values (45,'WA','Washington');
insert into genstate (id,stateinit,statename) values (46,'DC','Washington, DC');
insert into genstate (id,stateinit,statename) values (47,'WV','West Virginia');
insert into genstate (id,stateinit,statename) values (48,'WI','Wisconsin');
insert into genstate (id,stateinit,statename) values (49,'WY','Wyoming');
insert into genstate (id,stateinit,statename) values (52,'PR','Puerto Rico');
insert into genstate (id,stateinit,statename) values (53,'NF','Newfoundland');
insert into genstate (id,stateinit,statename) values (54,'NS','Nova Scotia');
insert into genstate (id,stateinit,statename) values (55,'ON','Ontario');
insert into genstate (id,stateinit,statename) values (56,'PE','Prince Edward');
insert into genstate (id,stateinit,statename) values (57,'PQ','Quebec');
insert into genstate (id,stateinit,statename) values (58,'SK','Saskatchewan');
insert into genstate (id,stateinit,statename) values (59,'NT','Northwest Territories');
insert into genstate (id,stateinit,statename) values (60,'YT','Yukon Terrirory');

INSERT INTO zipcode VALUES (401,'NY','Pleasantville',41.0758,-73.473);
INSERT INTO zipcode VALUES (501,'NY','Holtsville',40.4855,-73.024);
INSERT INTO zipcode VALUES (544,'NY','Holtsville',40.4855,-73.024);