View Name:pay_means_con_v
View Number:5841
Group:Morder
Description:Provides pay means details of contact. Used in immediate payment.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_pay_means_con_v
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpay_meansobjidPay means internal record number 
id_numberpay_meansid_numberCredit card number 
cc_typepay_meanscc_typeCredit card number 
cc_namepay_meanscc_nameCredit card name 
cc_exp_mopay_meanscc_exp_moCredit card expiration month 
cc_exp_yrpay_meanscc_exp_yrCredit card expiration year 
means_typepay_meansmeans_typeThe payment option for this line item 
conrole_objidcon_pym_roleobjidContact payment role internal record number 3 (UNIQUE)
con_objidcontactobjidContact internal record number 
last_fourpay_meanslast_fourLast four digits of the pay_means id_number 
bank_namepay_meansbank_nameName of the bank 
account_ownerpay_meansaccount_ownerName of account owner 
authorization_nopay_meansauthorization_noThe authorization number, as was given by the bank or CC company, to direct debit the account 

Joins:

Join FromJoin To
(con_pym_role).cn_pm_role2pay_means(pay_means).pay_means2con_pym_role
(con_pym_role).cn_pm_role2contact(contact).contact2con_pym_role
My Recent Objects
pay_means_con_v      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user