SQL View Name:bus_org_blg_rel_items
SQL View Number:5836
Group:Billing Manager
Base Table:bus_org
Description:Related billable items associated with a contact. Used by isales/account/blg_related_items_list.jsp JSP page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsComment
bus_org_objidLONGint   DIRECT BusOrg internal record number 
devLONGint   DIRECT Row version number for mobile distribution purposes 
idCHARvarchar 80  Entity id 
item_subtype_idLONGint   DIRECT The subtype id for sort order of results and type label 
item_type_idLONGint   DIRECT The type id for the defined object. 
nameCHARvarchar 80  Entity Name 
objidLONGint3  DIRECT Entity internal record number 

SQL:

((select
5694 as item_type_id,
0 as item_subtype_id,
table_fin_accnt.objid as objid,
table_fin_accnt.name as name,
'' as id,
table_fin_accnt.fa_child2bus_org as bus_org_objid,
table_fin_accnt.dev as dev
from table_fin_accnt)
union
(select
5695 as item_type_id,
1 as item_subtype_id,
table_blg_argmnt.objid as objid,
table_blg_argmnt.name as name,
'' as id,
table_blg_argmnt.ba_child2bus_org as bus_org_objid,
table_blg_argmnt.dev as dev
from table_blg_argmnt)
union
(select
5752 as item_type_id,
2 as item_subtype_id,
table_pp_bucket.objid as objid,
table_pp_bucket.name as name,
'' as id,
table_pp_bucket.pp_bucket2bus_org as bus_org_objid,
table_pp_bucket.dev as dev
from table_pp_bucket)
union
(select
5440 as item_type_id,
3 as item_subtype_id,
tp.objid as objid,
tp.cc_type as name,
tp.last_four as id,
tp.pay_means2bus_org as bus_org_objid,
tp.dev as dev
from table_pay_means tp
where tp.means_type = 0)
union
(select
5440 as item_type_id,
4 as item_subtype_id,
tp.objid as objid,
tp.bank_name as name,
tp.last_four as id,
tp.pay_means2bus_org as bus_org_objid,
tp.dev as dev
from table_pay_means tp
where tp.means_type = 2)
union
(select
5758 as item_type_id,
5 as item_subtype_id,
tp.objid as objid,
tp.req_type as name,
tp.description as id,
tp.req_to_extern2bus_org as bus_org_objid,
tp.dev as dev
from table_req_to_extern tp))
My Recent Objects
bus_org_blg_rel_items