SQL Designer Fields for Compliance: Itemization, Validation Notice/Dates, In Window Contacts, Restriction and Preferred Contact
    • 17 Nov 2023
    • 1 Minute to read
    • Contributors
    • PDF

    SQL Designer Fields for Compliance: Itemization, Validation Notice/Dates, In Window Contacts, Restriction and Preferred Contact

    • PDF

    Article summary

    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?

    What's Next
    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.
    ESC

    Eddy AI, facilitating knowledge discovery through conversational intelligence