View: policy.voucher_verification_policy_scrud_view

Schema policy
Materialized View Name voucher_verification_policy_scrud_view
Owner postgres
Tablespace DEFAULT
Description
 CREATE OR REPLACE VIEW policy.voucher_verification_policy_scrud_view
 AS
 SELECT voucher_verification_policy.user_id,
    users.user_name,
    voucher_verification_policy.can_verify_sales_transactions,
    voucher_verification_policy.sales_verification_limit,
    voucher_verification_policy.can_verify_purchase_transactions,
    voucher_verification_policy.purchase_verification_limit,
    voucher_verification_policy.can_verify_gl_transactions,
    voucher_verification_policy.gl_verification_limit,
    voucher_verification_policy.can_self_verify,
    voucher_verification_policy.self_verification_limit,
    voucher_verification_policy.effective_from,
    voucher_verification_policy.ends_on,
    voucher_verification_policy.is_active
   FROM policy.voucher_verification_policy
   JOIN office.users ON voucher_verification_policy.user_id = users.user_id;