Table Name:	billable_itm
Table Number:	5756
Group:	Billing Manager
Description:
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_billable_itm

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
billable_itm	CHAR	varchar		40			Item which can be billed. Valid values should be taken from the product catalogue e.g. service/EGI/subscriber	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
expiry_date	CLK_TIME	datetime					Expiration date to be used only for limited time agreements	Search (1)
last_update	CLK_TIME	datetime				CHANGE_DATE	Date time of last update
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
pre_post_type	LONG	tinyint			0	DIRECT	Pre and Post paid payments; 0=Post Paid, 1=Pre paid; default=0	Search (1)
start_date	CLK_TIME	datetime					The beginning of the item's effective date	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
billable_itm2ba_bi_role	OTM	ba_bi_role	ba_bi_role2billable_itm	Billiang arrangement roles for billable items
billable_itm2pp_bucket	MTO	pp_bucket	pp_bucket2billable_itm	Pre-paid bucket billed for items
billable_itm2site_part	MTO	site_part	site_part2billable_itm	Service/subscription the billable item is related			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5819	ba_bi_role_view	ba_bi_role, billable_itm, blg_argmnt, bus_org, site_part

My Recent Objects

billable_itm

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user