Table Name:pp_bucket
Table Number:5752
Group:Billing Manager
Description:Pre Paid Bucket, the customer's pre-paid balance and is the focal entity on which financial transactions (recharges, voucher load) are applied
Flags: 
Baseline/Custom:Baseline
select * from table_pp_bucket
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
blg_evt_gen_stsLONGint  0 DIRECT, ALLOW_NULL Billing event status;0=No event necessary or event already sent, 1=create event pending, 2=update event pending;Default=0  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
hier_name_indLONGtinyint  1 DIRECT Indicates whether pre-paid bucket's name is derived from organization's name or not, i.e., 0=No, 1=Yes, default=1  
last_updateCLK_TIMEdatetime46   Date time of last update  
nameCHARvarchar 80  A name for the pre paid bucket Search (3)
objidLONGint3  DIRECT Internal record number Search (3)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in ViewsSet NameType ID Stored inObjid Stored In
 Exclusive Set Relations
pp_bucket2billable_itmOTMbillable_itmbillable_itm2pp_bucketBillable item charging a pre-paid bucket       
pp_bucket2blg_argmntMTOblg_argmntblg_argmnt2pp_bucketBilling arrangements done for the pre-paid bucket       
pp_bucket2bus_orgMTObus_orgbus_org2pp_bucketAn organization owns pre-paid bucket        
primary_ppb2bus_orgOTOFbus_orgprimary2pp_bucketOrganization's primary pre-paid bucket       
pp_bucket2con_ppb_roleOTMcon_ppb_rolecon_ppb_role2pp_bucketContact roles for the pre-paid bucket       
pp_bucket2extern_idOTMextern_idextern_id2pp_bucketSeveral different entities in the external systems can be mapped to a pre-paid bucket     extern_for clarify_type clarify_objid 
pp_bucket2order_actionOTMorder_actionorder_action2pp_bucketService to cover pre-paid       
pp_bucket2rechrg_instrnOTMrechrg_instrnrechrg_instrn2pp_bucketRecharge instructions for the pre paid bucket balances. The money collected augments the balance of the connected pre-paid bucket       
pp_bucket2req_to_externOTMreq_to_externreq_to_extern2pp_bucketRequest can be related to a Pre-paid bucket       
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
objindexobjidclustered, unique located on PRIMARY
My Recent Objects
pp_bucket      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user