| Key Table Sorted By Database File Number |
| File | Key Name | Record | Key Field |
| d00_collect.033 | de_active_key | Debtor | Mode, Name |
| d00_collect.034 | de_cos_name_key | Cosigner | Name |
| d00_collect.035 | de_cosigner_key | Cosigner | Contact |
| d00_collect.036 | de_contact_key | Debtor | Contact |
| d00_collect.037 | de_name_key | Debtor | Name |
| d00_collect.038 | cl_name_key | Client | Name |
| d00_collect.039 | de_summary_flags_key | Debtor | Summary Flags |
| d00_collect.040 | de_cos_uid_key | Cosigner | UID |
| d00_collect.041 | dt_uid_key | Dbtag | UID |
| d00_collect.042 | cl_uid_key | Client | UID |
| d00_collect.043 | at_uid_key | Attachment | UID |
| d00_collect.044 | co_uid_key | Contact | UID |
| d00_collect.044 | clco_uid_key | Client Contact | UID |
| d00_collect.044 | atco_uid_key | Attachment Contact | UID |
| d00_collect.044 | dcco_uid_key | Debtor Cosigner Contact | UID |
| d00_collect.044 | asco_uid_key | Client Cosigner Contact | UID |
| d00_collect.044 | caco_uid_key | Client Attachment Contact | UID |
| d00_collect.045 | ce_uid_key | Contact Event | UID |
| d00_collect.046 | il_uid_key | Invoice Line | UID |
| d00_collect.047 | in_uid_key | Invoice | UID |
| d00_collect.048 | ds_uid_key | Debtor Status | UID |
| d00_collect.049 | tt_uid_key | Transaction Type | UID |
| d00_collect.050 | da_uid_key | Nxday | UID |
| d00_collect.051 | tr_uid_key | Transaction | UID |
| d00_collect.051 | cltr_uid_key | Client Transaction | UID |
| d00_collect.052 | de_uid_key | Debtor | UID |
| d00_collect.053 | de_country_key | Debtor | Country |
| d00_collect.054 | de_cos_cell_phone_key | Cosigner | Cell |
| d00_collect.055 | de_cos_other_phone_key | Cosigner | Other Phone |
| d00_collect.056 | de_cos_business_phone_key | Cosigner | POE # |
| d00_collect.057 | de_cos_phone_key | Cosigner | Home |
| d00_collect.058 | de_cell_phone_key | Debtor | Cell |
| d00_collect.059 | de_other_phone_key | Debtor | Other Phone |
| d00_collect.060 | de_home_phone_key | Debtor | Home |
| d00_collect.061 | de_work_phone_key | Debtor | POE # |
| d00_collect.062 | de_number_key | Debtor | File |
| d00_collect.063 | cl_number_key | Client | # |
| d00_collect.064 | dt_date_key | Dbtag | Date |
| d00_collect.065 | co_done_date_key | Contact | Done Date |
| d00_collect.065 | clco_done_date_key | Client Contact | Done Date |
| d00_collect.065 | atco_done_date_key | Attachment Contact | Done Date |
| d00_collect.065 | dcco_done_date_key | Debtor Cosigner Contact | Done Date |
| d00_collect.065 | asco_done_date_key | Client Cosigner Contact | Done Date |
| d00_collect.065 | caco_done_date_key | Client Attachment Contact | Done Date |
| d00_collect.066 | da_date_key | Nxday | Daysheet Date |
| d00_collect.067 | de_cos_dob_key | Cosigner | DOB |
| d00_collect.068 | de_dob_key | Debtor | DOB |
| d00_collect.069 | tr_posted_date_key | Transaction | Posted Date |
| d00_collect.069 | cltr_posted_date_key | Client Transaction | Posted Date |
| d00_collect.070 | de_listed_date_key | Debtor | Listed |
| d00_collect.071 | de_close_date_key | Debtor | Closed |
| d00_collect.072 | tr_payment_date_key | Transaction | Payment Date |
| d00_collect.072 | cltr_payment_date_key | Client Transaction | Payment Date |
| d00_collect.073 | co_date_key | Contact | Due Date |
| d00_collect.073 | clco_date_key | Client Contact | Due Date |
| d00_collect.073 | atco_date_key | Attachment Contact | Due Date |
| d00_collect.073 | dcco_date_key | Debtor Cosigner Contact | Due Date |
| d00_collect.073 | asco_date_key | Client Cosigner Contact | Due Date |
| d00_collect.073 | caco_date_key | Client Attachment Contact | Due Date |
| d00_collect.074 | de_cl_account_key | Debtor | Acct # |
| d00_collect.075 | de_cos_sin_key | Cosigner | SSN |
| d00_collect.076 | de_sin_key | Debtor | SSN |
| d00_collect.077 | de_collector_key | Debtor | Collector |
| d00_collect.078 | con_whocreated | Contact | Originator, Created Date |
| d00_collect.078 | clcon_whocreated | Client Contact | Originator, Created Date |
| d00_collect.078 | atcon_whocreated | Attachment Contact | Originator, Created Date |
| d00_collect.078 | dccon_whocreated | Debtor Cosigner Contact | Originator, Created Date |
| d00_collect.078 | ascon_whocreated | Client Cosigner Contact | Originator, Created Date |
| d00_collect.078 | cacon_whocreated | Client Attachment Contact | Originator, Created Date |
| d00_collect.079 | de_cos_dl_key | Cosigner | DL |
| d00_collect.080 | de_dl_key | Debtor | DL |
| d00_collect.081 | de_cos_city_key | Cosigner | City |
| d00_collect.082 | de_city_key | Debtor | City |
| d00_collect.083 | de_cos_state_key | Cosigner | State |
| d00_collect.084 | de_state_key | Debtor | State |
| d00_collect.085 | de_cos_zip_key | Cosigner | ZIP |
| d00_collect.086 | de_zip_key | Debtor | ZIP |
| d00_collect.087 | de_group_ids_key | Debtor | Group ID, Member, Flags |
| d00_collect.088 | con_dawhodonetype | Contact | Type, Completed, Collector, Due Date |
| d00_collect.088 | clcon_dawhodonetype | Client Contact | Type, Completed, Collector, Due Date |
| d00_collect.088 | atcon_dawhodonetype | Attachment Contact | Type, Completed, Collector, Due Date |
| d00_collect.088 | dccon_dawhodonetype | Debtor Cosigner Contact | Type, Completed, Collector, Due Date |
| d00_collect.088 | ascon_dawhodonetype | Client Cosigner Contact | Type, Completed, Collector, Due Date |
| d00_collect.088 | cacon_dawhodonetype | Client Attachment Contact | Type, Completed, Collector, Due Date |
| d00_collect.089 | con_whodone | Contact | Collector, Done Date |
| d00_collect.089 | clcon_whodone | Client Contact | Collector, Done Date |
| d00_collect.089 | atcon_whodone | Attachment Contact | Collector, Done Date |
| d00_collect.089 | dccon_whodone | Debtor Cosigner Contact | Collector, Done Date |
| d00_collect.089 | ascon_whodone | Client Cosigner Contact | Collector, Done Date |
| d00_collect.089 | cacon_whodone | Client Attachment Contact | Collector, Done Date |
| d00_collect.090 | con_doneopdate | Contact | Completed, Collector, Due Date |
| d00_collect.090 | clcon_doneopdate | Client Contact | Completed, Collector, Due Date |
| d00_collect.090 | atcon_doneopdate | Attachment Contact | Completed, Collector, Due Date |
| d00_collect.090 | dccon_doneopdate | Debtor Cosigner Contact | Completed, Collector, Due Date |
| d00_collect.090 | ascon_doneopdate | Client Cosigner Contact | Completed, Collector, Due Date |
| d00_collect.090 | cacon_doneopdate | Client Attachment Contact | Completed, Collector, Due Date |
| d00_collect.091 | con_whotydate | Contact | Collector, Type, Due Date |
| d00_collect.091 | clcon_whotydate | Client Contact | Collector, Type, Due Date |
| d00_collect.091 | atcon_whotydate | Attachment Contact | Collector, Type, Due Date |
| d00_collect.091 | dccon_whotydate | Debtor Cosigner Contact | Collector, Type, Due Date |
| d00_collect.091 | ascon_whotydate | Client Cosigner Contact | Collector, Type, Due Date |
| d00_collect.091 | cacon_whotydate | Client Attachment Contact | Collector, Type, Due Date |
| d00_collect.092 | con_opdatime | Contact | Completed, Type, Due Date |
| d00_collect.092 | clcon_opdatime | Client Contact | Completed, Type, Due Date |
| d00_collect.092 | atcon_opdatime | Attachment Contact | Completed, Type, Due Date |
| d00_collect.092 | dccon_opdatime | Debtor Cosigner Contact | Completed, Type, Due Date |
| d00_collect.092 | ascon_opdatime | Client Cosigner Contact | Completed, Type, Due Date |
| d00_collect.092 | cacon_opdatime | Client Attachment Contact | Completed, Type, Due Date |
| d00_collect.093 | tt_code_key | Transaction Type | Code |
| d00_collect.094 | ds_code_key | Debtor Status | Code |
| d00_collect.095 | at_detail_1_key | Attachment | Index 1 |
| d00_collect.096 | at_detail_2_key | Attachment | Index 2 |
| d00_collect.097 | at_date_2_key | Attachment | Date 2 |
| d00_collect.097 | at_date_1_key | Attachment | Date 1 |
| d00_collect.098 | in_date_key | Invoice | Date |
| d00_collect.099 | cp_code_key | Contact Plan | Code |
| d00_collect.100 | de_cos_email_key | Cosigner | Email |
| d00_collect.101 | de_email_key | Debtor | Email |
| d00_collect.102 | tr_receipt_number_key | Transaction | Receipt # |
| d00_collect.102 | cltr_receipt_number_key | Client Transaction | Receipt # |
| d00_collect.103 | tr_invoice_number_key | Transaction | Invoice # |
| d00_collect.103 | cltr_invoice_number_key | Client Transaction | Invoice # |
| d00_collect.104 | cl_user_1_key | Client | User 1 |
| d00_collect.105 | de_status_key | Debtor | Status |
| d00_collect.106 | cl_alt_number_key | Client | Alt # |
| d00_collect.107 | cl_ownedby_number_key | Client | OwnedBy # |
| d00_collect.108 | cl_category_key | Client | C1 |
| d00_collect.109 | cl_category_1_key | Client | C2 |
| d00_collect.110 | cl_category_2_key | Client | C3 |
| d00_collect.111 | de_category_key | Debtor | C1 |
| d00_collect.112 | de_category_1_key | Debtor | C2 |
| d00_collect.113 | de_category_2_key | Debtor | C3 |
| d00_collect.114 | de_owned_by_debtor_key | Debtor | OwnedBy |
| d00_collect.115 | tr_category_key | Transaction | C1 |
| d00_collect.115 | cltr_category_key | Client Transaction | C1 |
| d00_collect.116 | tr_category_1_key | Transaction | C2 |
| d00_collect.116 | cltr_category_1_key | Client Transaction | C2 |
| d00_collect.117 | tr_category_2_key | Transaction | C3 |
| d00_collect.117 | cltr_category_2_key | Client Transaction | C3 |
| d00_collect.118 | tt_category_key | Transaction Type | C1 |
| d00_collect.119 | tt_category_1_key | Transaction Type | C2 |
| d00_collect.120 | de_cos_category_key | Cosigner | C1 |
| d00_collect.121 | de_cos_category_1_key | Cosigner | C2 |
| d00_collect.122 | de_cos_category_2_key | Cosigner | C3 |
| d00_collect.123 | bk_category_key | Bank | C1 |
| d00_collect.124 | add_uid_key | Address Lookup | UID |
| d00_collect.125 | ph_uid_key | Phone | UID |
| d00_collect.126 | em_uid_key | Email | UID |
| d00_collect.127 | bk_uid_key | Bank | UID |
| d00_collect.128 | cu_uid_key | Currency Lookup | UID |
| d00_collect.129 | cp_uid_key | Contact Plan | UID |
| d00_collect.130 | bkacc_uid_key | Bank Account | UID |
| d00_collect.131 | bkacc_category_key | Bank Account | C1 |
| d00_collect.132 | bk_routing_no_key | Bank | Routing # |
| d00_collect.133 | cu_category_key | Currency Lookup | C1 |
| d00_collect.134 | ph_category_key | Phone | C1 |
| d00_collect.135 | ds_category_key | Debtor Status | C1 |
| d00_collect.136 | de_type_key | Debtor | Type |
| d00_collect.137 | de_salesman_key | Debtor | Sales |
| d00_collect.138 | de_clerk_key | Debtor | Clerk |
| d00_collect.139 | cu_date_key | Currency Lookup | Date |
| d00_collect.140 | co_category_key | Contact | C1 |
| d00_collect.140 | clco_category_key | Client Contact | C1 |
| d00_collect.140 | atco_category_key | Attachment Contact | C1 |
| d00_collect.140 | dcco_category_key | Debtor Cosigner Contact | C1 |
| d00_collect.140 | asco_category_key | Client Cosigner Contact | C1 |
| d00_collect.140 | caco_category_key | Client Attachment Contact | C1 |
| d00_collect.141 | co_category_1_key | Contact | C2 |
| d00_collect.141 | clco_category_1_key | Client Contact | C2 |
| d00_collect.141 | atco_category_1_key | Attachment Contact | C2 |
| d00_collect.141 | dcco_category_1_key | Debtor Cosigner Contact | C2 |
| d00_collect.141 | asco_category_1_key | Client Cosigner Contact | C2 |
| d00_collect.141 | caco_category_1_key | Client Attachment Contact | C2 |
| d00_collect.142 | as_cos_uid_key | Client Cosigner | UID |
| d00_collect.143 | as_cos_name_key | Client Cosigner | Name |
| d00_collect.144 | as_cosigner_key | Client Cosigner | Contact |
| d00_collect.145 | as_cos_phone_key | Client Cosigner | Phone |
| d00_collect.146 | as_cos_business_phone_key | Client Cosigner | POE# |
| d00_collect.147 | as_cos_other_phone_key | Client Cosigner | Other Phone |
| d00_collect.148 | as_cos_cell_phone_key | Client Cosigner | Cell |
| d00_collect.149 | as_cos_email_key | Client Cosigner | Email |
| d00_collect.150 | as_cos_sin_key | Client Cosigner | SSN |
| d00_collect.151 | as_cos_dl_key | Client Cosigner | DL |
| d00_collect.152 | as_cos_dob_key | Client Cosigner | DOB |
| d00_collect.153 | as_cos_city_key | Client Cosigner | City |
| d00_collect.154 | as_cos_state_key | Client Cosigner | State |
| d00_collect.155 | as_cos_zip_key | Client Cosigner | ZIP |
| d00_collect.156 | as_cos_category_key | Client Cosigner | C1 |
| d00_collect.157 | as_cos_category_1_key | Client Cosigner | C2 |
| d00_collect.158 | cl_at_uid_key | Client Attachment | UID |
| d00_collect.159 | cl_at_detail_1_key | Client Attachment | Index 1 |
| d00_collect.160 | cl_at_detail_2_key | Client Attachment | Index 2 |
| d00_collect.161 | cl_at_date_1_key | Client Attachment | Date 1 |
| d00_collect.162 | cl_at_date_2_key | Client Attachment | Date 2 |
|
Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.
Please click this link to send us your comments: helpinfo@collect.org