siccodes.txt

国外的一套开源CRM

insert into sic_code (sic_code_id,sic_Category, sic_description, created_by, created_date, modified_by, modified_date) values (0111, "Wheat", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_Category, sic_description, created_by, created_date, modified_by, modified_date) values (0112, "Rice", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_Category, sic_description, created_by, created_date, modified_by, modified_date) values (0115, "Corn", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_Category, sic_description, created_by, created_date, modified_by, modified_date) values (0116, "Soybeans", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0119, "Cash Grains", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0131, "Cotton", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0132, "Tobacco", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0133, "Sugarcane and Sugar Beets", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0134, "Irish Potatoes", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0139, "Field Crops", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0161, "Vegetables and Melons", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0171, "Berry Crops", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0172, "Grapes", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0173, "Tree Nuts", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0174, "Citrus Fruits", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0175, "Deciduous Tree Fruits", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0179, "Fruits and Tree Nuts", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0181, "Ornamental Nursery Products", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0182, "Food Crops Grown Under Cover", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0191, "General Farms", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0211, "Beef Cattle Feedlots", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0212, "Beef Cattle", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0213, "Hogs", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0214, "Sheep and Goats", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0219, "General Livestock", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0241, "Dairy Farms", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0251, "Broiler", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0252, "Chicken Eggs", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0253, "Turkeys and Turkey Eggs", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0254, "Poultry Hatcheries", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0259, "Poultry and Eggs", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0271, "Fur-bearing Animals and Rabbits", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0272, "Horses and Other Equines", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0273, "Animal Aquaculture", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0279, "Animal Specialties", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0291, "General Farms", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0711, "Soil Preparation Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0721, "Crop Planting and Protection", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0722, "Crop Harvesting", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0723, "Crop Preparation Services For Market", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0724, "Cotton Ginning", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0741, "Veterinary Services For Livestock", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0742, "Veterinary Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0751, "Livestock Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0752, "Animal Specialty Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0761, "Farm Labor Contractors", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0762, "Farm Management Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0781, "Landscape Counseling and Planning", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0782, "Lawn and Garden Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0783, "Ornamental Shrub and Tree Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0811, "Timber Tracts", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0831, "Forest Products", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0851, "Forestry Services", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0912, "Finfish", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0913, "Shellfish", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0919, "Miscellaneous Marine Products", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0921, "Fish Hatcheries and Preserves", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (0971, "Hunting", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into sic_code (sic_code_id,sic_description, sic_category, created_by, created_date, modified_by, modified_date) values (1011, "Iron Ores", '', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');