type = (d) domestic (f) foreign conv_tp_LP = Converted to Limited Partnership qualify_LP = qualification to LLP ce_ (As in ce_addres1 etc...) = chief executive office is_ (As in is_addres1 etc...) = in state office ag_ (As in ag_addres1 etc...) = registered agent in VT p_ (As in p_lname etc...) = partners file number = fn_prefix + file_no Structure for table: GP.DBF Field Field Name Type Width Dec Index Collate Nulls 1 name Character 40 No 2 status Character 1 No 3 fn_prefix Character 1 No 4 file_no Character 7 No 5 type Character 1 No 6 state Character 2 No 7 date_form Date 9 No 8 denial Logical 1 No 9 disolution Date 8 No 10 merger Date 8 No 11 amendment Date 8 No 12 conv_to_lp Date 8 No 13 qualify_lp Date 8 No 14 terminate Date 8 No 15 ce_addres1 Character 37 No 16 ce_addres2 Character 37 No 17 ce_city Character 23 No 18 ce_state Character 2 No 19 ce_zip Character 10 No 20 is_addres1 Character 37 No 21 is_addres2 Character 37 No 22 is_city Character 23 No 23 is_state Character 2 No 24 is_zip Character 10 No 25 ag_addres1 Character 37 No 26 ag_addres2 Character 37 No 27 ag_city Character 23 No 28 ag_state Character 2 No 29 ag_zip Character 10 No 30 p_lname1 Character 20 No 31 p_fname1 Character 15 No 32 p_lname2 Character 20 No 33 p_fname2 Character 15 No 34 p_lname3 Character 20 No 35 p_fname3 Character 15 No 36 p_lname4 Character 20 No 37 p_fname4 Character 15 No 38 p_lname5 Character 20 No 39 p_fname5 Character 15 No 40 last_updte Date 8 No Total 604