Table Name:	blg_argmnt
Table Number:	5695
Group:	Billing Manager
Description:	Arrangements made for billing
Flags:
Baseline/Custom:	Baseline

select * from table_blg_argmnt

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
blg_evt_gen_sts	LONG	int			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
description	CHAR	varchar		80		ALLOW_NULL	Billing arrangements description. The name is used for the sending of the bill, the description is the BAR description	Search (4)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
hier_name_ind	LONG	tinyint			0	DIRECT	Indicates whether billing arrangement name is derived from organization's name or not, i.e., 0=No, 1=Yes, default=0	Search (1)
last_update	CLK_TIME	datetime	46				Date time of last update
name	CHAR	varchar		80			Name of billing arrangement	Search (13)
objid	LONG	int	3			DIRECT	Internal record number	Search (16)
status	CHAR	varchar		20			Status of billing arrangement, e.g. Active, Close	Search (6)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	Used in Views	Set Name	Type ID Stored in	Objid Stored In
							Exclusive Set Relations
blg_argmnt2addr_ba_role	OTM	addr_ba_role	blg_argmnt_role2blg_argmnt	Address for the billing arrangement
blg_argmnt2ba_bi_role	OTM	ba_bi_role	ba_bi_role2blg_argmnt	Billable item roles for billing arrangement
blg_argmnt2ba_pc_role	OTM	ba_pc_role	ba_pc_role2blg_argmnt	Pay channel for the billing arrangement
blg_argmnt2blg_argmnt_extern	OTM	blg_argmnt_extern	blg_argmnt_extern2blg_argmnt	External system key related to the blg_argmnt
ba_parent2bus_org	MTO	bus_org	parent2blg_argmnt	Parent organization this billing arrangements belongs to		Search (1)
ba_child2bus_org	MTO	bus_org	child2blg_argmnt	Organization this billing arrangements belongs to		Search (6)
primary_ba2bus_org	OTOF	bus_org	primary2blg_argmnt	Customer's Primary billing arrangement
blg_argmnt2case	OTM	case	case2blg_argmnt	Case using a billing arrangement
ba2con_blg_argmnt_role	OTM	con_blg_argmnt_role	ba_role2blg_argmnt	Contact roles for the billing arrangements
primary_blg_argmnt2e_addr	MTO	e_addr	primary_e_addr2blg_argmnt	Primary email address of the billing arrangement		Search (2)
blg_argmnt2e_addr_ba_role	OTM	e_addr_ba_role	e_addr_ba_role2blg_argmnt	E-addr roles for billing arrangement
blg_argmnt2extern_id	OTM	extern_id	extern_id2blg_argmnt	Several different entities in the external systems can be mapped to a billing arrangement			extern_for	clarify_type	clarify_objid
blg_argmnt2fin_accnt	MTO	fin_accnt	fin_accnt2blg_argmnt	Financial account having billing arrangements		Search (3)
blg_argmnt2interact	OTM	interact	interact2blg_argmnt	Interaction related to billing arrangement
blg_argmnt2order_action	OTM	order_action	order_action2blg_argmnt	The billing arrangement to cover this service
blg_argmnt2pay_means	MTO	pay_means	pay_means2blg_argmnt	The pay means for automatic post paid payment due to the invoice		Search (2)
blg_argmnt2pp_bucket	OTM	pp_bucket	pp_bucket2blg_argmnt	Pre-paid bucket for a billing arragnement
blg_argmnt2rechrg_instrn	OTM	rechrg_instrn	rechrg_instrn2blg_argmnt	Recharge instrcutions for a billing arrangement			payment_for	source_type	source_lowid
blg_argmnt2req_to_extern	OTM	req_to_extern	req_to_extern2blg_argmnt	Request can be related to a Billing arrangement
primary_blg_argmnt2site	MTO	site	primary_site2blg_argmnt	Primary site of the billing arrangement	REQUIRED	Search (1)
blg_argmnt2site_ba_role	OTM	site_ba_role	site_ba_role2blg_argmnt	Site roles for a billing arrangement

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ba2fa5695	blg_argmnt2fin_accnt	nonclustered located on PRIMARY
ba2pm5695	blg_argmnt2pay_means	nonclustered located on PRIMARY
bc2bo5695	ba_child2bus_org	nonclustered located on PRIMARY
bp2bo5695	ba_parent2bus_org	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
pba2ea5695	primary_blg_argmnt2e_addr	nonclustered located on PRIMARY
pba2s5695	primary_blg_argmnt2site	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5714	blg_argmnt_addr_vw	addr_ba_role, address, blg_argmnt, bus_org, bus_org_extern, country, state_prov
5717	vw_con_blg_argmnt	blg_argmnt, blg_argmnt_extern, con_blg_argmnt_role, contact
5719	vw_addr_blg_argmnt	addr_ba_role, address, blg_argmnt, blg_argmnt_extern, country, state_prov
5720	vw_fin_accnt_blg_argmnt	blg_argmnt, blg_argmnt_extern, fin_accnt, fin_accnt_extern
5722	vw_blg_argmnt_pay_chnl	ba_pc_role, blg_argmnt, blg_argmnt_extern, pay_channel, pay_chnl_extern
5725	vw_pbus_org_blg_argmnt	blg_argmnt, blg_argmnt_extern, bus_org
5726	vw_bus_org_blg_argmnt	blg_argmnt, blg_argmnt_extern, bus_org
5731	vw_case_billing	blg_argmnt, case, condition, contact, fin_accnt, gbst_elm, pay_channel, site
5818	con_ba_role_view	blg_argmnt, bus_org, con_blg_argmnt_role, contact
5819	ba_bi_role_view	ba_bi_role, billable_itm, blg_argmnt, bus_org, site_part
5827	bar_busorg_fa_pm_eaddr_v	blg_argmnt, bus_org, e_addr, fin_accnt, pay_means
5828	bar_rel_prim_addr_v	address, blg_argmnt, bus_org, country, e_addr, fin_accnt, site, state_prov, time_zone
5835	sr_blg_argmnt_view	blg_argmnt, site, site_ba_role
5837	pm_bar_view	blg_argmnt, pay_means
5838	req_to_extern_view	blg_argmnt, bus_org, fin_accnt, pay_means, pp_bucket, rechrg_instrn, req_to_extern
6072	st_blg_rel_itm_vw	blg_argmnt

My Recent Objects

blg_argmnt

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog