| View Name: | ba_bi_role_view |
| View Number: | 5819 |
| Group: | Billing Manager |
| Description: | Used in 'billable items' tab in 'billing arranegement overview' screen, to display all billable items for that billing arrangement. 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 |
|---|---|---|---|---|
| ba_description | blg_argmnt | description | Billing arrangements description. The name is used for the sending of the bill, the description is the BAR description | |
| ba_name | blg_argmnt | name | Name of billing arrangement | |
| ba_objid | blg_argmnt | objid | Billing Arrangement internal record number | |
| ba_status | blg_argmnt | status | Status of billing arrangement, e.g. Active, Close | |
| bi_expiry_date | billable_itm | expiry_date | Expiration date to be used only for limited time agreements | |
| bi_objid | billable_itm | objid | billable_itm internal record number | |
| bi_pre_post_type | billable_itm | pre_post_type | Pre and Post paid payments; 0=Post Paid, 1=Pre paid; default=0 | |
| bi_start_date | billable_itm | start_date | The beginning of the item's effective date | |
| billable_itm | billable_itm | billable_itm | Valid values should be taken from the product catalogue. Valid values from catalogue is the service/EGI/subscriber | |
| bus_org_objid | bus_org | objid | Bus_org internal record number | |
| role_name | ba_bi_role | role_name | Name of the role | |
| role_objid | ba_bi_role | objid | con_pym_accnt_role internal record number | 3 (UNIQUE) |
| site_part_objid | site_part | objid | Site_part internal record number |
Join From | Join To |
|---|---|
| (ba_bi_role).ba_bi_role2billable_itm | (billable_itm).billable_itm2ba_bi_role |
| (ba_bi_role).ba_bi_role2blg_argmnt | (blg_argmnt).blg_argmnt2ba_bi_role |
| (blg_argmnt).ba_child2bus_org | (bus_org).child2blg_argmnt |
| (billable_itm).billable_itm2site_part | (site_part).site_part2billable_itm |
| ba_bi_role_view | |||