------ LEARNING TEAM C---POS410 - October-November 2007 - Shelly Hervey, Alicia Pike, Rick Keeton, Patrick Horton

------ Create Team C Database named Kudler_Team_C by Shelly Hervey--------------------------------------------------------------------------

CREATE DATABASE kudler_Team_c
ON (NAME=kudler_Team_c_dat,
FILENAME='C:\kudlerteamc.mdf',
SIZE=10,
MAXSIZE=100,
FILEGROWTH=5)

-------- Create Team C Tables:  Property, Departments, Account_Types and Chart_of_Accounts by Shelly Hervey-------------------------------

USE kudler_team_C
CREATE TABLE Property
(Property_ID VARCHAR (25) NOT NULL,
Address_1 VARCHAR (40),
Address_2 VARCHAR (40),
City VARCHAR (25),
State VARCHAR (2),
Zip VARCHAR (5)
PRIMARY KEY (Property_ID));

CREATE TABLE Departments
(Dept_ID VARCHAR (3)NOT NULL,
Department VARCHAR (40),
PRIMARY KEY (Dept_ID));

CREATE TABLE Account_Types
(Account_Type_ID VARCHAR (2) NOT NULL,
Account_Type VARCHAR (50),
PRIMARY KEY (Account_Type_ID));

CREATE TABLE Chart_of_Accounts
(Account_Code VARCHAR (12) NOT NULL,
Description VARCHAR (100),
Short_Description VARCHAR (100),
Balance MONEY,
Dept_ID VARCHAR (3),
Account_Type_ID VARCHAR (2),
Property_ID VARCHAR (25),
PRIMARY KEY (Account_Code));

-------- Insert Data into Table:  Property by Shelly Hervey--------------------------------------------------------------------------

INSERT INTO [kudler_team_c].[dbo].[Property]
([Property_ID], [Address_1], [Address_2], [City], [State], [Zip])
VALUES
('Corporate', 'Torrey Pines Road and Prospect Place', 'Rosen Shopping Center', 'La Jolla', 'CA', '92037')
INSERT INTO [kudler_team_c].[dbo].[Property]
([Property_ID], [Address_1], [Address_2], [City], [State], [Zip])
VALUES
('LaJolla', 'Torrey Pines Road and Prospect Place', 'Rosen Shopping Center', 'La Jolla', 'CA', '92037')
INSERT INTO [kudler_team_c].[dbo].[Property]
([Property_ID], [Address_1], [Address_2], [City], [State], [Zip])
VALUES
('Del Mar', 'Flower Hill Dr & San Andreas Dr Ste 146', 'Curley Commons', 'Del Mar', 'CA', '92014')
INSERT INTO [kudler_team_c].[dbo].[Property]
([Property_ID], [Address_1], [Address_2], [City], [State], [Zip])
VALUES
('Encinitas', 'West G Street & 2nd Street', 'Thompson Colonnade', 'Encinitas', 'CA', '92024')

-------- Insert Data into Table: Departments by Shelly Hervey--------------------------------------------------------------------------

INSERT INTO [kudler_team_c].[dbo].[Departments]
([Dept_ID], [Department])
VALUES
('1', 'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Departments]
([Dept_ID], [Department])
VALUES
('2', 'Bakery')
INSERT INTO [kudler_team_c].[dbo].[Departments]
([Dept_ID], [Department])
VALUES
('3', 'Meet & Seafood')
INSERT INTO [kudler_team_c].[dbo].[Departments]
([Dept_ID], [Department])
VALUES
('4', 'Produce')
INSERT INTO [kudler_team_c].[dbo].[Departments]
([Dept_ID], [Department])
VALUES
('5', 'Cheese & Dairy')
INSERT INTO [kudler_team_c].[dbo].[Departments]
([Dept_ID], [Department])
VALUES
('6', 'Wine')

-------- Insert Data into Table: Account_Types by Shelly Hervey--------------------------------------------------------------------------

INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('1', 'Current Assets')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('2', 'Fixed Assets')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('3', 'Other Assets')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('4', 'Current Liabilities')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('5', 'Long Term Liabilities')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('6', 'Capital')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('7', 'Revenue')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('8', 'Cost of Goods Sold')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('9', 'Expenses')
INSERT INTO [kudler_team_c].[dbo].[Account_Types]
([Account_Type_ID], [Account_Type])
VALUES
('10', 'Other Income')

-------- Insert Data into Table: Chart_of_Accounts by Shelly Hervey--------------------------------------------------------------------------

INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100001',	'Petty Cash',	'Operating Cash - La Jolla', 	'100',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100002',	'Petty Cash',	'Operating Cash - Del Mar',	'101',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100003',	'Petty Cash',	'Operating Cash - Encinitas',	'102',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100020',	'Bradley Bank',	'Checking Accounting - La Jolla',	'106',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100021',	'Kelsey Bank',	'Checking Accounting- Del Mar',	'107',		'1','1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100022',	'Downey Bank',	'Checking Accounting - Encinitas',	'108',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100030',	'La Jolla - Payroll',	'Bank Account',	'109',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100031',	'Del Mar - Payroll',	'Bank Account',	'110',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100032',	'Encinitas - Payroll',	'Bank Account',	'111',		'1','4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100040',	'La Jolla - Workers Comp',	'Workers Compensation',	'112',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100041',	'Del Mar - Workers Comp',	'Workers Compensation',	'200',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('100042',	'Encinitas - Workers Comp',	'Workers Compensation',	'201',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('111000',	'Accounts Receivable',	'La Jolla',	'202',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('112000',	'Accounts Receivable',	'Del Mar',	'204',		'1', '1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('113000',	'Accounts Receivable',	'Encinitas',	'206',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('121000',	'Rustic Baguette',	'La Jolla Bakery Department Merchandise Inventory',	'208',	'2',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('121001',	'Challah',	'La Jolla Bakery Department Merchandise Inventory',	'209',	'2',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('123000',	'Angus Beef',	'La Jolla Meat and Seafood Merchandise Inventory',	'225',	'3',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('123001',	'Wild Turkey',	'La Jolla Meat and Seafood Merchandise Inventory',	'226',	'3',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('125000',	'Gala Apples',	'La Jolla Produce Merchandise Inventory',	'321',	'4',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('125001',	'Fuji Apples',	'La Jolla Produce Merchandise Inventory',	'322',	'4',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('127001',	'Cheddar',	'La Jolla Cheese & Dairy Merchandise Inventory',	'339',	'5',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('127006',	'Provolone',	'La Jolla Cheese & Dairy Merchandise Inventory',	'344',	'5',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('129000',	'Red Wines',	'La Jolla Wine Merchandise Inventory',	'374',	'6',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('129001',	'White Wines',	'La Jolla Wine Merchandise Inventory',	'375',	'6',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('131000',	'Rustic Baguette',	'Del Mar Bakery Department Merchandise Inventory',	'381',	'2',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('131001',	'Challah',	'Del Mar Bakery Department Merchandise Inventory',	'382',	'2',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('133000',	'Angus Beef',	'Del Mar Meat and Seafood Merchandise Inventory',	'398',	'3',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('133001',	'Wild Turkey',	'Del Mar Meat and Seafood Merchandise Inventory',	'399',	'3',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('135000',	'Gala Apples',	'Del Mar Produce Merchandise Inventory',	'421',	'4',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('135001',	'Fuji Apples',	'Del Mar Produce Merchandise Inventory',	'422',	'4',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('137001',	'Cheddar',	'Del Mar Cheese & Dairy Merchandise Inventory',	'439',	'5',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('137006',	'Provolone',	'Del Mar Cheese & Dairy Merchandise Inventory',	'444',	'5',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('139000',	'Red Wines',	'Del Mar Wine Merchandise Inventory',	'474', '6',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('139001',	'White Wines',	'Del Mar Wine Merchandise Inventory',	'475',	'6',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('141000',	'Rustic Baguette',	'Encinitas Bakery Department Merchandise Inventory',	 '2', '481',		'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('141001',	'Challah',	'Encinitas Bakery Department Merchandise Inventory',	'482', '2',		'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('143000',	'Angus Beef',	'Encinitas Meat and Seafood Merchandise Inventory',	'498',	'3',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('143001',	'Wild Turkey',	'Encinitas Meat and Seafood Merchandise Inventory',	'499',	'3',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('145000',	'Gala Apples',	'Encinitas Produce Merchandise Inventory',	'521',	'4',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('145001',	'Fuji Apples',	'Encinitas Produce Merchandise Inventory',	'522',	'4',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('147001',	'Cheddar',	'Encinitas Cheese & Dairy Merchandise Inventory',	'539',	'5',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('147006',	'Provolone',	'Encinitas Cheese & Dairy Merchandise Inventory',	'544',	'5',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('149000',	'Red Wines',	'Encinitas Wine Merchandise Inventory',	'574',	'6',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('149001',	'White Wines',	'Encinitas Wine Merchandise Inventory',	'575',	'6',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('161000',	'Notes Receivable',	'La Jolla',	'590',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('162000',	'Notes Receivable',	'Del Mar',	'591',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('163000',	'Notes Receivable',	'Encinitas',	'592',	'1',	'1',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('171000',	'Vehicle',	'La Jolla',	'593',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('171001',	'Accumulated Depreciation - Vehicle',	'La Jolla',	'594',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('172000',	'Vehicle',	'Del Mar',	'595',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('172001',	'Accumulated Depreciation - Vehicle',	'Del Mar',	'596',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('173000',	'Vehicle',	'Encinitas',	'597',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('173001',	'Accumulated Depreciation - Vehicle',	'Encinitas',	'598',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('174000',	'Furniture and Fixtures',	'La Jolla',	'599',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('174001',	'Accumulated Depreciation - Furniture & Fixtures',	'La Jolla',	'600',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('175000',	'Furniture and Fixtures',	'Del Mar',	'601',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('175001',	'Accumulated Depreciation - Furniture & Fixtures',	'Del Mar',	'602', '1',		'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('176000',	'Furniture and Fixtures',	'Encinitas',	'603',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('176001',	'Accumulated Depreciation - Furniture & Fixtures',	'Encinitas',	'604',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('177000',	'Equipment',	'La Jolla',	'605',		'1','2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('177001',	'Accumulated Depreciation - Equipment',	'La Jolla',	'606',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('178000',	'Equipment',	'Del Mar',	'607',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('178001',	'Accumulated Depreciation - Equipment',	'Del Mar',	'608',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('179000',	'Equipment',	'Encinitas',	'609',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('179001',	'Accumulated Depreciation - Equipment',	'Encinitas',	'610',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('181000',	'Goodwill',	'La Jolla',	'611',	'1',	'3',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('182000',	'Goodwill',	'Del Mar',	'612',	'1',	'3',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('183000',	'Goodwill',	'Encinitas',	'613',	'1',	'3',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200001',	'Boardman Fine Foods',	'La Jolla Bakery Department Vendor',	'614',	'2',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200002',	'Boardman Fine Foods',	'Del Mar Bakery Department Vendor',	'615',	'2',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200003',	'Boardman Fine Foods',	'Encinitas Bakery Department Vendor',	'616',	'2',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200021',	'Litteral Exotic Meat and Seafood',	'La Jolla Meat and Seafood Vendor',	'620',	'3',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200022',	'Litteral Exotic Meat and Seafood',	'Del Mar Meat and Seafood Vendor',	'621',	'3',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200023',	'Litteral Exotic Meat and Seafood',	'Encinitas Meat and Seafood Vendor',	'622',	'3',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200031',	'Tenney Fresh Produce',	'La Jolla Produce Vendor',	'623',	'4',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200033',	'Melancon Farm Fresh Produce',	'Encinitas Produce Vendor',	'625',	'4',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200041',	'Martins Dairy',	'La Jolla Cheese & Dairy Vendor',	'626',	'5',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200042',	'Martins Dairy',	'Del Mar Cheese & Dairy Vendor',	'500',	'5',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200043',	'Martins Dairy',	'Encinitas Cheese & Dairy Vendor',	'501',	'5',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200061',	'Killgore Spirits',	'La Jolla Wine Vendor',	'505',	'6',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200062',	'Killgore Spirits',	'Del Mar Wine Vendor',	'506',	'6',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('200063',	'Killgore Spirits',	'Encinitas Wine Vendor',	'507',	'6',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('210001',	'La Jolla Sales Tax',	'La Jolla Sales Tax Payable',	'5111',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('210003',	'Del Mar Sales Tax',	'Del Mar Sales Tax Payable',	'5212',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('210004',	'Encinitas Sales',	'Encinitas Sales Tax Payable',	'5613',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('220001',	'Federal Income Tax Withholding (W/H)-Payroll',	'Federal Tax W/H',	'514',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('220002',	'State Income Tax W/H - Payroll',	'State Tax W/H',	'515',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('220003',	'FICA Withholding - Payroll',	'FICA W/H',	'516',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('230011',	'Federal Tax W/H Disability',	'Federal W/H Disability',	'517',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('230012',	'Federal Tax W/H Occupational Accident (OA) Insurance',	'Federal W/H OA',	'518',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('230013',	'State Income Tax W/H - Disability',	'State W/H Disability',	'519',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('230014',	'State Income Tax W/H - OA',	'State W/H OA',	'520',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('230015',	'FICA Tax W/H - Disability',	'FICAW/H Dis',	'521',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('230016',	'FICA Tax W/H - OA',	'FICAW/H OA',	'522',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('240001',	'Accrued Wages Payable',	'La Jolla',	'62523',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('240002',	'Accrued Wages Payable',	'Del Mar',	'55524',	'1',	'4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('240003',	'Accrued Wages Payable',	'Encinitas',	'38525',	'1', '4',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('300001',	'Owners Equity',	'La Jolla',	'34538', '1', '6', 'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('300002',	'Owners Equity',	'Del Mar',	'55239',	'1',	'6',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('300003',	'Owners Equity',	'Encinitas',	'55540',	'1',	'6',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('310001',	'Net Profit',	'La Jolla',	'25441',	'1',	'6',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('310002',	'Net Profit',	'Del Mar',	'11542',	'1',	'6',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('310003',	'Net Profit',	'Encinitas',	'51443',	'1',	'6',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400001',	'Rustic Baguette',	'La Jolla Bakery Department Sales',	'544',	'2',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400002',	'Challah',	'La Jolla Bakery Department Sales',	'545',	'2',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400101',	'Angus Beef',	'La Jolla Meat n Seafood Sales',	'561',	'3',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400102',	'Wild Turkey',	'La Jolla Meat n Seafood Sales',	'562',	'3',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400201',	'Gala Apples',	'La Jolla Produce Sales',	'584',	'4',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400202',	'Fuji Apples',	'La Jolla Produce Sales',	'585',	'4',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400301',	'Cheddar',	'La Jolla Cheese & Dairy Sales',	'602',	'5',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400306',	'Provolone',	'La Jolla Cheese & Dairy Sales',	'607',	'5',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400401',	'Red Wines',	'La Jolla Wine Sales',	'637',	'6',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('400402',	'White Wines',	'La Jolla Wine Sales',	'638',	'6',	'7',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410001',	'Rustic Baguette',	'Del Mar Bakery Department Sales',	'644',	'2',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410002',	'Challah',	'Del Mar Bakery Department Sales',	'645',	'2',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410003',	'Calamata Olive Bread',	'Del Mar Bakery Department Sales',	'646',	'2',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410018',	'Angus Beef',	'Del Mar Meat and Seafood Sales',	'661',	'3',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410019',	'Wild Turkey',	'Del Mar Meat and Seafood Sales',	'662',	'3',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410041',	'Gala Apples',	'Del Mar Produce Sales',	'684',	'4',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410042',	'Fuji Apples',	'Del Mar Produce Sales',	'685',	'4',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410059',	'Cheddar',	'Del Mar Cheese & Dairy Sales',	'702',	'5',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410064',	'Provolone',	'Del Mar Cheese & Dairy Sales',	'707',	'5',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410094',	'Red Wines',	'Del Mar Wine Sales',	'737',	'6',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('410095',	'White Wines',	'Del Mar Wine Sales',	'738',	'6',	'7',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420001',	'Rustic Baguette',	'Encinitas Bakery Department Sales',	'744',	'2',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420002',	'Challah',	'Encinitas Bakery Department Sales',	'745',	'2',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420018',	'Angus Beef',	'Encinitas Meat and Seafood Department Sales',	'761',	'3',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420019',	'Wild Turkey',	'Encinitas Meat and Seafood Department Sales',	'762',	'3',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420041',	'Gala Apples',	'Encinitas Produce Sales',	'784',	'4',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420042',	'Fuji Apples',	'Encinitas Produce Sales',	'785',	'4',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420059',	'Cheddar',	'Encinitas Cheese & Dairy Sales',	'802',	'5',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420064',	'Provolone',	'Encinitas Cheese & Dairy Sales',	'807',	'5',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420094',	'Red Wines',	'Encinitas Wine Sales',	'1022',	'6',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('420095',	'White Wines',	'Encinitas Wine Sales',	'1023',	'6',	'7',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500001',	'Rustic Baguette',	'La Jolla Bakery Department Purchases',	'8200',	'2',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500002',	'Challah',	'La Jolla Bakery Department Purchases',	'8300',	'2',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500018',	'Angus Beef',	'La Jolla Meat and Seafood Purchases',	'45',	'3',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500019',	'Wild Turkey',	'La Jolla Meat and Seafood Purchases',	'50',	'3',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500041',	'Gala Apples',	'La Jolla Produce Purchases',	'160',	'4',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500042',	'Fuji Apples',	'La Jolla Produce Purchases',	'165',	'4',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500059',	'Cheddar',	'La Jolla Cheese & Dairy Purchases',	'250',	'5',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500064',	'Provolone',	'La Jolla Cheese & Dairy Purchases',	'275',	'5',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500094',	'Red Wines',	'La Jolla Wine Purchases',	'425',	'6',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500095',	'White Wines',	'La Jolla Wine Purchases',	'430',	'6',	'8',	'La Jolla')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500101',	'Rustic Baguette',	'Del Mar Bakery Department Purchases',	'460',	'2',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500102',	'Challah',	'Del Mar Bakery Department Purchases',	'465',	'2',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500118',	'Angus Beef',	'Del Mar Meat and Seafood Purchases',	'545',	'3',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500119',	'Wild Turkey',	'Del Mar Meat and Seafood Purchases',	'550',	'3',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500141',	'Gala Apples',	'Del Mar Produce Purchases',	'660',	'4',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500142',	'Fuji Apples',	'Del Mar Produce Purchases',	'665',	'4',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500159',	'Cheddar',	'Del Mar Cheese & Dairy Purchases',	'750',	'5',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500164',	'Provolone',	'Del Mar Cheese & Dairy Purchases',	',775',	'5',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500194',	'Red Wines',	'Del Mar Wine Purchases',	'925',	'6',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500195',	'White Wines',	'Del Mar Wine Purchases',	'930',	'6',	'8',	'Del Mar')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500201',	'Rustic Baguette',	'Encinitas Bakery Department Purchases',	'960',	'2',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500202',	'Challah',	'Encinitas Bakery Department Purchases',	'965',	'2',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500218',	'Angus Beef',	'Encinitas Meat and Seafood Department Purchases',	'1045',	'3',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500219',	'Wild Turkey',	'Encinitas Meat and Seafood Department Purchases',	'1050',	'3',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500241',	'Gala Apples',	'Encinitas Produce Purchases',	'1160',	'4',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500242',	'Fuji Apples',	'Encinitas Produce Purchases',	'1165',	'4',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500259',	'Cheddar',	'Encinitas Cheese & Dairy Purchases',	'1100',	'5',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500264',	'Provolone',	'Encinitas Cheese & Dairy Purchases',	'1600',	'5',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500294',	'Red Wines',	'Encinitas Wine Purchases',	'4600',	'6',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('500295',	'White Wines',	'Encinitas Wine Purchases',	'4700',	'6',	'8',	'Encinitas')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510001',	'Boardman Fine Foods',	'La Jolla Bakery Department Freight-in',	'40',	'2',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510002',	'Boardman Fine Foods',	'Del Mar Bakery Department Freight-in',	'50', 	'2',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510003',	'Boardman Fine Foods',	'Encinitas Bakery Department Freight-in',	'60',	'2',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510021',	'Litteral Exotic Meat and Seafood',	'La Jolla Meat and Seafood Freight-in',	'100',	'3',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510022',	'Litteral Exotic Meat and Seafood',	'Del Mar Meat and Seafood Freight-in',	'110',	'3',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510023',	'Litteral Exotic Meat and Seafood',	'Encinitas Meat and Seafood Freight-in',	'120',	'3',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510031',	'Tenney Fresh Produce',	'La Jolla Produce Freight-in',	'130',	'4',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510041',	'Curley	Del Mar Produce', 'Freight-in',	'140',	'4',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510051',	'Melancon Farm Fresh Produce',	'Encinitas Produce Freight-in',	'150', '4',		'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510061',	'Martins Dairy',	'La Jolla Cheese & Dairy Freight-in',	'160',	'5',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510062',	'Martins Dairy',	'Del Mar Cheese & Dairy Freight-in',	'170',	'5',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510063',	'Martins Dairy',	'Encinitas Cheese & Dairy Freight-in',	'180',	'5',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510081',	'Killgore Spirits',	'La Jolla Wine Freight-in',	'220',	'6',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510082',	'Killgore Spirits',	'Del Mar Wine Freight-in',	'230',	'6',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('510083',	'Killgore Spirits',	'Encinitas Wine Freight-in', 	'240',	'6',	'8',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520001',	'Advertising',	'La Jolla',	'280',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520002',	'Advertising',	'Del Mar',	'290',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520003',	'Advertising',	'Encinitas',	'300',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520061',	'Credit Card Fees',	'La Jolla',	'450',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520062',	'Credit Card Fees',	'Del Mar',	'460',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520063',	'Credit Card Fees',	'Encinitas',	'470',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520071',	'HR Payroll Outsource',	'Corporate',	'480',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520081',	'Depreciation - Vehicle',	'La Jolla',	'490',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520082',	'Depreciation - Vehicle',	'Del Mar',	'500', '1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520083',	'Depreciation - Vehicle',	'Encinitas',	'510',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520091',	'Depreciation - Furniture & Fixtures',	'La Jolla',	'520',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520092',	'Depreciation - Furniture & Fixtures',	'Del Mar',	'530',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520093',	'Depreciation - Furniture & Fixtures',	'Encinitas',	'540',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520101',	'Depreciation - Equipment',	'La Jolla',	'550',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520102',	'Depreciation - Equipment',	'Del Mar',	'560',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520103',	'Depreciation - Equipment',	'Encinitas',	'570',	'1',	'2',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520131',	'Insurance',	'La Jolla',	'610',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520132',	'Insurance',	'Del Mar',	'620',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520133',	'Insurance',	'Encinitas',	'630',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520171',	'Miscellaneous',	'La Jolla',	'730',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520172',	'Miscellaneous',	'Del Mar',	'740',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520173',	'Miscellaneous',	'Encinitas',	'750',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520181',	'Office Expenses',	'La Jolla',	'760',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520182',	'Office Expenses',	'Del Mar',	'770',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520183',  'Office Expenses',	'Encinitas',	'780',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520211',	'Permits and Licenses',	'La Jolla',	'850',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520212',	'Permits and Licenses',	'Del Mar',	'860',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520213',	'Permits and Licenses',	'Encinitas',	'870', '1',		'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520261',	'Telephone',	'La Jolla',	'1000',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520262',	'Telephone',	'Del Mar',	'1010',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520263',	'Telephone',	'Encinitas',	'1020',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520281',	'Utilities',	'La Jolla',	'1060',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520282',	'Utilities',	'Del Mar',	'1070',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520283',	'Utilities',	'Encinitas',	'1080',		'1', '9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520291',	'Vehicle Expenses',	'La Jolla',	'1090',		'1','9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520292',	'Vehicle Expenses',	'Del Mar',	'1100',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520293',	'Vehicle Expenses',	'Encinitas',	'1110',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520301',	'Wages',	'La Jolla',	'1120',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520302',	'Wages',	'Del Mar',	'1130',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('520303',	'Wages',	'Encinitas',	'1140',	'1',	'9',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('600001',	'Gain (Loss) on Sale of Assets',	'La Jolla',	'1150',	'1',	'10',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('600002',	'Gain (Loss) on Sale of Assets',	'Del Mar',	'1160', '1',		'10',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('600003',	'Gain (Loss) on Sale of Assets',	'Encinitas',	'1170',	'1',	'10',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('610001',	'Interest Income',	'La Jolla',	'1180',	'1',	'10',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('610002',	'Interest Income',	'Del Mar',	'1190',	'1',	'10',	'Corporate')
INSERT INTO [kudler_team_c].[dbo].[Chart_of_Accounts]
([Account_Code], [Description], [Short_Description], [Balance], [Dept_ID], [Account_Type_ID], [Property_ID])
VALUES
('610003',	'Interest Income',	'Encinitas', '1200',	'1', '10',	'Corporate')