Data And Key Files In Collect!
File Name	Contents	Key Name	Key On Values	Record	Index
d00_collect.000	contact_rec			Contact
d00_collect.001	contplan_rec			Contact Plan
d00_collect.002	daysheet_rec			Daysheet
d00_collect.003	client_rec			Client
d00_collect.004	debtor_rec			Debtor
d00_collect.005	transact_rec			Transaction
d00_collect.006	notes_rec;			Notes
d00_collect.007	invoice_rec			Invoice
d00_collect.008	status_rec			Debtor Status
d00_collect.009	trantype_rec			Transaction Type
d00_collect.010	cosigner_rec			Cosigner
d00_collect.011	attach_rec			Attachment
d00_collect.012	address_rec			Address
d00_collect.013	phone_rec			Phone
d00_collect.014	email_rec			Email
d00_collect.015	bank_rec			Bank
d00_collect.016	bank_account_rec			Bank Account
d00_collect.017	currency_rec			Currency
d00_collect.018	dbtag_rec			Dbtag
d00_collect.019	cl_transaction_rec			Client Transaction
d00_collect.020	cl_contact_rec			Client Contact
d00_collect.021	at_contact_rec			Attachment Contact
d00_collect.022	cos_contact_rec			Cosigner Contact
d00_collect.023	cl_attachment_rec			Client Attachment
d00_collect.024	associated_rec			Client Cosigner
d00_collect.025	as_contacts_rec			Client Cosigner Contact
d00_collect.026	cat_contacts_rec			Client Attachment Contact
d00_collect.027	cl_noteblob			Client Notes
d00_collect.028	de_noteblob			Debtor Notes
d00_collect.029	tr_blob			Transaction
d00_collect.030	co_attachment_blob			Contact Attachment
d00_collect.031	at_blob			Attachment
d00_collect.032	cl_at_blob			Client Attachment
d00_collect.033	de_active_key	de_active_key	Mode, Name	Debtor	Optional
d00_collect.034	de_cos_name_key	de_cos_name_key	Name	Cosigner	Optional
d00_collect.035	de_cos_cosigner_name_key	de_cosigner_key	Contact	Cosigner	Optional
d00_collect.036	de_contact_name_key	de_contact_key	Contact	Debtor	Optional
d00_collect.037	de_name_key	de_name_key	Name	Debtor	Optional
d00_collect.038	cl_names_key	cl_name_key	Name	Client	Optional
d00_collect.039	de_summary_flags_key	de_summary_flags_key	Summary Flags	Debtor	Optional
d00_collect.040	de_cos_uid_key	de_cos_uid_key	UID	Cosigner	Optional
d00_collect.041	dt_uid_key	dt_uid_key	UID	Dbtag	Optional
d00_collect.042	cl_uid_key	cl_uid_key	UID	Client	Optional
d00_collect.043	at_uid_key	at_uid_key	UID	Attachment	Optional
d00_collect.044	co_uid_key	co_uid_key	UID	Contact	Optional
d00_collect.044	co_uid_key	clco_uid_key	UID	Client Contact	Optional
d00_collect.044	co_uid_key	atco_uid_key	UID	Attachment Contact	Optional
d00_collect.044	co_uid_key	dcco_uid_key	UID	Debtor Cosigner Contact	Optional
d00_collect.044	co_uid_key	asco_uid_key	UID	Client Cosigner Contact	Optional
d00_collect.044	co_uid_key	caco_uid_key	UID	Client Attachment Contact	Optional
d00_collect.045	ce_uid_key	ce_uid_key	UID	Contact Event	Optional
d00_collect.046	il_uid_key	il_uid_key	UID	Invoice Line	Optional
d00_collect.047	in_uid_key	in_uid_key	UID	Invoice	Optional
d00_collect.048	ds_uid_key	ds_uid_key	UID	Debtor Status	Optional
d00_collect.049	tt_uid_key	tt_uid_key	UID	Transaction Type	Optional
d00_collect.050	da_uid_key	da_uid_key	UID	Nxday	Optional
d00_collect.051	tr_uid_key	tr_uid_key	UID	Transaction	Optional
d00_collect.051	tr_uid_key	cltr_uid_key	UID	Client Transaction	Optional
d00_collect.052	de_uid_key	de_uid_key	UID	Debtor	Optional
d00_collect.053	de_country_key	de_country_key	Country	Debtor	Optional
d00_collect.054	de_cos_cell_phone_key	de_cos_cell_phone_key	Cell	Cosigner	Optional
d00_collect.055	de_cos_other_phone_key	de_cos_other_phone_key	Other Phone	Cosigner	Optional
d00_collect.056	de_cos_buiss_phone_key	de_cos_business_phone_key	POE #	Cosigner	Optional
d00_collect.057	de_cos_phone_key	de_cos_phone_key	Home	Cosigner	Optional
d00_collect.058	de_cell_phone_key	de_cell_phone_key	Cell	Debtor	Optional
d00_collect.059	de_other_phone_key	de_other_phone_key	Other Phone	Debtor	Optional
d00_collect.060	de_home_phone_key	de_home_phone_key	Home	Debtor	Optional
d00_collect.061	de_work_phone_key	de_work_phone_key	POE #	Debtor	Optional
d00_collect.062	de_number_key	de_number_key	File	Debtor	Optional
d00_collect.063	cl_number_key	cl_number_key	#	Client	Optional
d00_collect.064	dt_dates_key	dt_date_key	Date	Dbtag	Optional
d00_collect.065	co_done_date_key	co_done_date_key	Done Date	Contact	Optional
d00_collect.065	co_done_date_key	clco_done_date_key	Done Date	Client Contact	Optional
d00_collect.065	co_done_date_key	atco_done_date_key	Done Date	Attachment Contact	Optional
d00_collect.065	co_done_date_key	dcco_done_date_key	Done Date	Debtor Cosigner Contact	Optional
d00_collect.065	co_done_date_key	asco_done_date_key	Done Date	Client Cosigner Contact	Optional
d00_collect.065	co_done_date_key	caco_done_date_key	Done Date	Client Attachment Contact	Optional
d00_collect.066	da_date_key	da_date_key	Daysheet Date	Nxday	Optional
d00_collect.067	de_cos_dob_key	de_cos_dob_key	DOB	Cosigner	Optional
d00_collect.068	de_dob_key	de_dob_key	DOB	Debtor	Optional
d00_collect.069	tr_posted_date_key	tr_posted_date_key	Posted Date	Transaction	Optional
d00_collect.069	tr_posted_date_key	cltr_posted_date_key	Posted Date	Client Transaction	Optional
d00_collect.070	de_listed_date_key	de_listed_date_key	Listed	Debtor	Optional
d00_collect.071	de_closed_date_key	de_close_date_key	Closed	Debtor	Optional
d00_collect.072	tr_payment_date_key	tr_payment_date_key	Payment Date	Transaction	Optional
d00_collect.072	tr_payment_date_key	cltr_payment_date_key	Payment Date	Client Transaction	Optional
d00_collect.073	co_duedate_key	co_date_key	Due Date	Contact	Optional
d00_collect.073	co_duedate_key	clco_date_key	Due Date	Client Contact	Optional
d00_collect.073	co_duedate_key	atco_date_key	Due Date	Attachment Contact	Optional
d00_collect.073	co_duedate_key	dcco_date_key	Due Date	Debtor Cosigner Contact	Optional
d00_collect.073	co_duedate_key	asco_date_key	Due Date	Client Cosigner Contact	Optional
d00_collect.073	co_duedate_key	caco_date_key	Due Date	Client Attachment Contact	Optional
d00_collect.074	de_cl_account_key	de_cl_account_key	Acct #	Debtor	Optional
d00_collect.075	de_cos_sin_key	de_cos_sin_key	SSN	Cosigner	Optional
d00_collect.076	de_sin_key	de_sin_key	SSN	Debtor	Optional
d00_collect.077	de_collector_key	de_collector_key	Collector	Debtor	Optional
d00_collect.078	conidx6_key	con_whocreated	Originator, Created Date	Contact	Optional
d00_collect.078	conidx6_key	clcon_whocreated	Originator, Created Date	Client Contact	Optional
d00_collect.078	conidx6_key	atcon_whocreated	Originator, Created Date	Attachment Contact	Optional
d00_collect.078	conidx6_key	dccon_whocreated	Originator, Created Date	Debtor Cosigner Contact	Optional
d00_collect.078	conidx6_key	ascon_whocreated	Originator, Created Date	Client Cosigner Contact	Optional
d00_collect.078	conidx6_key	cacon_whocreated	Originator, Created Date	Client Attachment Contact	Optional
d00_collect.079	de_cos_dl_key	de_cos_dl_key	DL	Cosigner	Optional
d00_collect.080	de_dl_key	de_dl_key	DL	Debtor	Optional
d00_collect.081	de_cos_city_key	de_cos_city_key	City	Cosigner	Optional
d00_collect.082	de_city_key	de_city_key	City	Debtor	Optional
d00_collect.083	de_cos_state_key	de_cos_state_key	State	Cosigner	Optional
d00_collect.084	de_state_key	de_state_key	State	Debtor	Optional
d00_collect.085	de_cos_zip_key	de_cos_zip_key	ZIP	Cosigner	Optional
d00_collect.086	de_zip_key	de_zip_key	ZIP	Debtor	Optional
d00_collect.087	de_group_id_key	de_group_ids_key	Group ID, Member, Flags	Debtor	Optional
d00_collect.088	conidx1_key	con_dawhodonetype	Type, Completed, Collector, Due Date	Contact	Optional
d00_collect.088	conidx1_key	clcon_dawhodonetype	Type, Completed, Collector, Due Date	Client Contact	Optional
d00_collect.088	conidx1_key	atcon_dawhodonetype	Type, Completed, Collector, Due Date	Attachment Contact	Optional
d00_collect.088	conidx1_key	dccon_dawhodonetype	Type, Completed, Collector, Due Date	Debtor Cosigner Contact	Optional
d00_collect.088	conidx1_key	ascon_dawhodonetype	Type, Completed, Collector, Due Date	Client Cosigner Contact	Optional
d00_collect.088	conidx1_key	cacon_dawhodonetype	Type, Completed, Collector, Due Date	Client Attachment Contact	Optional
d00_collect.089	conidx2_key	con_whodone	Collector, Done Date	Contact	Optional
d00_collect.089	conidx2_key	clcon_whodone	Collector, Done Date	Client Contact	Optional
d00_collect.089	conidx2_key	atcon_whodone	Collector, Done Date	Attachment Contact	Optional
d00_collect.089	conidx2_key	dccon_whodone	Collector, Done Date	Debtor Cosigner Contact	Optional
d00_collect.089	conidx2_key	ascon_whodone	Collector, Done Date	Client Cosigner Contact	Optional
d00_collect.089	conidx2_key	cacon_whodone	Collector, Done Date	Client Attachment Contact	Optional
d00_collect.090	conidx3_key	con_doneopdate	Completed, Collector, Due Date	Contact	Optional
d00_collect.090	conidx3_key	clcon_doneopdate	Completed, Collector, Due Date	Client Contact	Optional
d00_collect.090	conidx3_key	atcon_doneopdate	Completed, Collector, Due Date	Attachment Contact	Optional
d00_collect.090	conidx3_key	dccon_doneopdate	Completed, Collector, Due Date	Debtor Cosigner Contact	Optional
d00_collect.090	conidx3_key	ascon_doneopdate	Completed, Collector, Due Date	Client Cosigner Contact	Optional
d00_collect.090	conidx3_key	cacon_doneopdate	Completed, Collector, Due Date	Client Attachment Contact	Optional
d00_collect.091	conidx4_key	con_whotydate	Collector, Type, Due Date	Contact	Optional
d00_collect.091	conidx4_key	clcon_whotydate	Collector, Type, Due Date	Client Contact	Optional
d00_collect.091	conidx4_key	atcon_whotydate	Collector, Type, Due Date	Attachment Contact	Optional
d00_collect.091	conidx4_key	dccon_whotydate	Collector, Type, Due Date	Debtor Cosigner Contact	Optional
d00_collect.091	conidx4_key	ascon_whotydate	Collector, Type, Due Date	Client Cosigner Contact	Optional
d00_collect.091	conidx4_key	cacon_whotydate	Collector, Type, Due Date	Client Attachment Contact	Optional
d00_collect.092	conidx5_key	con_opdatime	Completed, Type, Due Date	Contact	Optional
d00_collect.092	conidx5_key	clcon_opdatime	Completed, Type, Due Date	Client Contact	Optional
d00_collect.092	conidx5_key	atcon_opdatime	Completed, Type, Due Date	Attachment Contact	Optional
d00_collect.092	conidx5_key	dccon_opdatime	Completed, Type, Due Date	Debtor Cosigner Contact	Optional
d00_collect.092	conidx5_key	ascon_opdatime	Completed, Type, Due Date	Client Cosigner Contact	Optional
d00_collect.092	conidx5_key	cacon_opdatime	Completed, Type, Due Date	Client Attachment Contact	Optional
d00_collect.093	tt_code_key	tt_code_key	Code	Transaction Type	Optional
d00_collect.094	ds_code_key	ds_code_key	Code	Debtor Status	Optional
d00_collect.095	at_detail_1_key	at_detail_1_key	Index 1	Attachment	Optional
d00_collect.096	at_detail2_key	at_detail_2_key	Index 2	Attachment	Optional
d00_collect.097	at_dates_key	at_date_2_key	Date 2	Attachment	Optional
d00_collect.097	at_dates_key	at_date_1_key	Date 1	Attachment	Optional
d00_collect.098	in_date_key	in_date_key	Date	Invoice	Optional
d00_collect.099	cp_code_key	cp_code_key	Code	Contact Plan	Optional
d00_collect.100	de_cos_email_key	de_cos_email_key	Email	Cosigner	Optional
d00_collect.101	de_email_key	de_email_key	Email	Debtor	Optional
d00_collect.102	tr_receipt_key	tr_receipt_number_key	Receipt #	Transaction	Optional
d00_collect.102	tr_receipt_key	cltr_receipt_number_key	Receipt #	Client Transaction	Optional
d00_collect.103	tr_invoice_key	tr_invoice_number_key	Invoice #	Transaction	Optional
d00_collect.103	tr_invoice_key	cltr_invoice_number_key	Invoice #	Client Transaction	Optional
d00_collect.104	cl_user1_key	cl_user_1_key	User 1	Client	Optional
d00_collect.105	de_status_key	de_status_key	Status	Debtor	Optional
d00_collect.106	cl_alt_number_key	cl_alt_number_key	Alt #	Client	Optional
d00_collect.107	cl_client_owner_key	cl_ownedby_number_key	OwnedBy #	Client	Optional
d00_collect.108	cl_category_key	cl_category_key	C1	Client	INDEX
d00_collect.109	cl_category_1_key	cl_category_1_key	C2	Client	Optional
d00_collect.110	cl_category_2_key	cl_category_2_key	C3	Client	Optional
d00_collect.111	de_category_key	de_category_key	C1	Debtor	INDEX
d00_collect.112	de_category_1_key	de_category_1_key	C2	Debtor	Optional
d00_collect.113	de_category_2_key	de_category_2_key	C3	Debtor	Optional
d00_collect.114	de_owned_by_debtor_key	de_owned_by_debtor_key	OwnedBy	Debtor	Optional
d00_collect.115	tr_category_key	tr_category_key	C1	Transaction	INDEX
d00_collect.115	tr_category_key	cltr_category_key	C1	Client Transaction	Optional
d00_collect.116	tr_category_1_key	tr_category_1_key	C2	Transaction	Optional
d00_collect.116	tr_category_1_key	cltr_category_1_key	C2	Client Transaction	Optional
d00_collect.117	tr_category_2_key	tr_category_2_key	C3	Transaction	Optional
d00_collect.117	tr_category_2_key	cltr_category_2_key	C3	Client Transaction	Optional
d00_collect.118	tt_category_key	tt_category_key	C1	Transaction Type	INDEX
d00_collect.119	tt_category_1_key	tt_category_1_key	C2	Transaction Type	INDEX
d00_collect.120	de_cos_category_key	de_cos_category_key	C1	Cosigner	INDEX
d00_collect.121	de_cos_category_1_key	de_cos_category_1_key	C2	Cosigner	Optional
d00_collect.122	de_cos_category_2_key	de_cos_category_2_key	C3	Cosigner	Optional
d00_collect.123	bk_category_key	bk_category_key	C1	Bank	Optional
d00_collect.124	add_uid_key	add_uid_key	UID	Address Lookup	Optional
d00_collect.125	ph_uid_key	ph_uid_key	UID	Phone	Optional
d00_collect.126	em_uid_key	em_uid_key	UID	Email	Optional
d00_collect.127	bk_uid_key	bk_uid_key	UID	Bank	Optional
d00_collect.128	cu_uid_key	cu_uid_key	UID	Currency Lookup	Optional
d00_collect.129	cp_uid_key	cp_uid_key	UID	Contact Plan	Optional
d00_collect.130	bkacc_uid_key	bkacc_uid_key	UID	Bank Account	INDEX
d00_collect.131	bkacc_category_key	bkacc_category_key	C1	Bank Account	Optional
d00_collect.132	bk_routing_key	bk_routing_no_key	Routing #	Bank	INDEX
d00_collect.133	cu_category_key	cu_category_key	C1	Currency Lookup	Optional
d00_collect.134	ph_category_key	ph_category_key	C1	Phone	Optional
d00_collect.135	ds_category_key	ds_category_key	C1	Debtor Status	INDEX
d00_collect.136	de_type_key	de_type_key	Type	Debtor	Optional
d00_collect.137	de_salesman_key	de_salesman_key	Sales	Debtor	Optional
d00_collect.138	de_clerk_key	de_clerk_key	Clerk	Debtor	Optional
d00_collect.139	cu_date_key	cu_date_key	Date	Currency Lookup	Optional
d00_collect.140	co_category_key	co_category_key	C1	Contact	INDEX
d00_collect.140	co_category_key	clco_category_key	C1	Client Contact	Optional
d00_collect.140	co_category_key	atco_category_key	C1	Attachment Contact	Optional
d00_collect.140	co_category_key	dcco_category_key	C1	Debtor Cosigner Contact	Optional
d00_collect.140	co_category_key	asco_category_key	C1	Client Cosigner Contact	Optional
d00_collect.140	co_category_key	caco_category_key	C1	Client Attachment Contact	Optional
d00_collect.141	co_category_1_key	co_category_1_key	C2	Contact	INDEX
d00_collect.141	co_category_1_key	clco_category_1_key	C2	Client Contact	Optional
d00_collect.141	co_category_1_key	atco_category_1_key	C2	Attachment Contact	Optional
d00_collect.141	co_category_1_key	dcco_category_1_key	C2	Debtor Cosigner Contact	Optional
d00_collect.141	co_category_1_key	asco_category_1_key	C2	Client Cosigner Contact	Optional
d00_collect.141	co_category_1_key	caco_category_1_key	C2	Client Attachment Contact	Optional
d00_collect.142	as_cos_uid_key	as_cos_uid_key	UID	Client Cosigner	Optional
d00_collect.143	as_cos_name_key	as_cos_name_key	Name	Client Cosigner	Optional
d00_collect.144	as_cos_cosigner_name_key	as_cosigner_key	Contact	Client Cosigner	Optional
d00_collect.145	as_cos_phone_key	as_cos_phone_key	Phone	Client Cosigner	Optional
d00_collect.146	as_cos_business_phone_key	as_cos_business_phone_key	POE#	Client Cosigner	Optional
d00_collect.147	as_cos_other_phone_key	as_cos_other_phone_key	Other Phone	Client Cosigner	Optional
d00_collect.148	as_cos_cell_phone_key	as_cos_cell_phone_key	Cell	Client Cosigner	Optional
d00_collect.149	as_cos_email_key	as_cos_email_key	Email	Client Cosigner	Optional
d00_collect.150	as_cos_sin_key	as_cos_sin_key	SSN	Client Cosigner	Optional
d00_collect.151	as_cos_dl_key	as_cos_dl_key	DL	Client Cosigner	Optional
d00_collect.152	as_cos_dob_key	as_cos_dob_key	DOB	Client Cosigner	Optional
d00_collect.153	as_cos_city_key	as_cos_city_key	City	Client Cosigner	Optional
d00_collect.154	as_cos_state_key	as_cos_state_key	State	Client Cosigner	Optional
d00_collect.155	as_cos_zip_key	as_cos_zip_key	ZIP	Client Cosigner	Optional
d00_collect.156	as_cos_category_key	as_cos_category_key	C1	Client Cosigner	Optional
d00_collect.157	as_cos_category_1_key	as_cos_category_1_key	C2	Client Cosigner	Optional
d00_collect.158	cl_at_uid_key	cl_at_uid_key	UID	Client Attachment	Optional
d00_collect.159	cl_at_detail_1_key	cl_at_detail_1_key	Index 1	Client Attachment	Optional
d00_collect.160	cl_at_detail_2_key	cl_at_detail_2_key	Index 2	Client Attachment	Optional
d00_collect.161	cl_at_dates_key	cl_at_date_1_key	Date 1	Client Attachment	Optional
d00_collect.162	cl_at_dates_2_key	cl_at_date_2_key	Date 2	Client Attachment	Optional