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

Collection Advisor
HIPAA One® Certified Seal
ACA Member DBA RMA