View: dbo.Vendor_View | |||
View definition | |||
create view dbo.Vendor_View as select vendor_KEY = V.vendor_KEY, client_KEY = V.client_KEY, vendor_name = V.vendor_name, vendor_id = V.vendor_id, ein_ssn = V.ein_ssn, payee_name = V.payee_name, status = V.status, exclude_from_fee_calculations = V.exclude_from_fee_calculations, contact_KEY = V.contact_KEY, default_payment__checkbook_KEY = V.default_payment__checkbook_KEY, default__vendor_payment_method_KEY = V.default__vendor_payment_method_KEY, print_stub = V.print_stub, auto_consolidate_for_payment = V.auto_consolidate_for_payment, auto_select_for_payment_when_due = V.auto_select_for_payment_when_due, lead_days = V.lead_days, is_paycard_recipient = V.is_paycard_recipient, direct_deposit_method_KEY = V.direct_deposit_method_KEY, direct_deposit_amount_percent = V.direct_deposit_amount_percent, direct_deposit_distribution_method_KEY = V.direct_deposit_distribution_method_KEY, vendor_id_sortable = V.vendor_id_sortable, date_tin_verified = V.date_tin_verified, description = V.description, inactive_reason = V.inactive_reason, date_inactive = V.date_inactive, vendor_account_number = V.vendor_account_number, current__vendor_type_KEY = V.current__vendor_type_KEY, default_payment__memo = V.default_payment__memo, use_same_checkbook_as_paychecks = V.use_same_checkbook_as_paychecks, zero_liability_created_date = V.zero_liability_created_date, ap__gl_account_KEY = V.ap__gl_account_KEY, purchase_order_number = V.purchase_order_number, vendor_payment_memo = V.vendor_payment_memo, payment_term_KEY = V.payment_term_KEY, online_bill_pay_vendor_ID = V.online_bill_pay_vendor_ID, export__quick_books_payee_KEY = V.export__quick_books_payee_KEY, payment_reminder_note = V.payment_reminder_note, include_payment_worksheet = V.include_payment_worksheet, -- This column is included to support filter formula as well as to handle active and inactive status. active_status_KEY = CASE WHEN V.date_inactive IS NULL OR V.date_inactive > GetDate() THEN 1 /* ACTIVE */ ELSE 2 /*INACTIVE*/ END from dbo.Vendor V | |||