| View Name: | con_ppb_role_view |
| View Number: | 5855 |
| Group: | Billing Manager |
| Description: | To brings all the contacts that related to the specific prepaid bucket. Used pre-paid bucket overview screen in contact tab. Used in ppb_overview.jsp JSP page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| con_e_mail | contact | e_mail | Contact's primary e-mail address | |
| con_first_name | contact | first_name | Contact's first name | |
| con_last_name | contact | last_name | Contact's last name | |
| con_objid | contact | objid | Contact internal record number | |
| con_phone | contact | phone | Contact's phone number which includes area code, number, and extension | |
| con_title | contact | title | Contact's professional title | |
| ppb_name | pp_bucket | name | A name for the pre paid bucket | |
| ppb_objid | pp_bucket | objid | PP_bucket internal record number | |
| role_name | con_ppb_role | role_name | Name of the role | |
| role_objid | con_ppb_role | objid | Con_ppb_role internal record number | 3 (UNIQUE) |
Join From | Join To |
|---|---|
| (con_ppb_role).con_ppb_role2pp_bucket | (pp_bucket).pp_bucket2con_ppb_role |
| (con_ppb_role).con_ppb_role2contact | (contact).contact2con_ppb_role |
| con_ppb_role_view | |||