- Print
- PDF
SQL Designer Fields for Compliance: Itemization, Validation Notice/Dates, In Window Contacts, Restriction and Preferred Contact
Article summary
Did you find this summary helpful?
Thank you for your feedback
SQL Designer Itemization Fields Available
account.consent_to_contact_date_age,
account.consent_to_contact_date_expires,
account.consent_to_contact_date,
account.in_window_all_contact_attempts,
account.in_window_all_contacts,
account.in_window_connected_calls,
account.in_window_email_contacts,
account.in_window_emails_sent,
account.in_window_letter_contacts,
account.in_window_letters_sent,
account.in_window_phone_contacts,
account.in_window_right_party_contacts,
account.in_window_text_contacts,
account.in_window_texts_sent,
account.last_in_window_update,
account.restricted
bundle_phone_log.consent_to_contact,
bundle.in_window_all_contact_attempts,
bundle.in_window_all_contacts,
bundle.in_window_connected_calls,
bundle.in_window_email_contacts,
bundle.in_window_emails_sent,
bundle.in_window_letter_contacts,
bundle.in_window_letters_sent,
bundle.in_window_phone_contacts,
bundle.in_window_right_party_contacts,
bundle.in_window_text_contacts,
bundle.in_window_texts_sent,
Bundle.last_in_window_update
client.itemization_date_source,
client.itemization_description
Debt_phone_log.consent_to_contact
debt.consent_to_contact_date_age,
debt.consent_to_contact_date_expires,
debt.consent_to_contact_date,
debt.in_window_all_contact_attempts,
debt.in_window_all_contacts,
debt.in_window_connected_calls,
debt.in_window_email_contacts,
debt.in_window_emails_sent,
debt.in_window_letter_contacts,
debt.in_window_letters_sent,
debt.in_window_phone_contacts,
debt.in_window_right_party_contacts,
debt.in_window_text_contacts,
debt.in_window_texts_sent,
debt.itemization_adjustments_balance,
debt.itemization_creditor_name,
debt.itemization_current_balance,
debt.itemization_date_source,
debt.itemization_date,
debt.itemization_description,
debt.itemization_fee_balance,
debt.itemization_interest_balance,
debt.itemization_owing_balance,
debt.itemization_payments_balance,
debt.itemization_received_balance,
debt.last_in_window_update,
debt.restricted,
debt.validation_notice_end_date,
debt.validation_notice_returned_date,
debt.validation_notice_sent_date_age,
debt.validation_notice_sent_date
demographic_phone.prior_express_consent
easy_loader.phone_prior_express_consent
email_queue.consent_to_contact
itemization_trans.amount,
itemization_trans.bucket,
itemization_trans.client_id,
itemization_trans.create_date,
itemization_trans.created_by,
itemization_trans.customer_id,
itemization_trans.debt_id,
itemization_trans.itemization_trans_id,
itemization_trans.last_update,
itemization_trans.last_updated_by,
itemization_trans.note,
itemization_trans.operator,
itemization_trans.receiver,
itemization_trans.trans_date,
itemization_trans.type
letter_config.category
txt_msg_log.consent_to_contact
Was this article helpful?