Table Name:	fin_accnt
Table Number:	5694
Group:	Billing Manager
Description:	Financial account, BAN for billing product
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_fin_accnt

Keyboard shortcuts available

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
delinquent_status	LONG	tinyint			0	DIRECT	Indicates whether the customer is delinquent or not, i.e., 0=No, 1=Yes, default=0
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
hier_name_ind	LONG	tinyint			0	DIRECT	Indicates whether financial account name is derived from organization's name or not, i.e., 0=No, 1=Yes, default=0
last_update	CLK_TIME	datetime	46				Date time of last update
name	CHAR	varchar		80			A name for the financial account, e.g., Monthly charges of sales division	Search (7)
objid	LONG	int	3			DIRECT	Internal record number	Search (10)
status	CHAR	varchar		20			Status of financial account, e.g. Active, Close	Search (2)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
								Exclusive Set Relations
fin_accnt2blg_argmnt	OTM	blg_argmnt	blg_argmnt2fin_accnt	Billing arrangements done for the financial account
fa_parent2bus_org	MTO	bus_org	parent2fin_accnt	Parent organization this financial account belongs to			Search (1)
fa_child2bus_org	MTO	bus_org	child2fin_accnt	Organization this financial account belongs to			Search (1)
fin_accnt2case	OTM	case	case2fin_accnt	Cases created for this financial account
accnt2con_fin_accnt_role	OTM	con_fin_accnt_role	fin_accnt_role2fin_accnt	Contact roles for the financial account
fin_accnt2extern_id	OTM	extern_id	extern_id2fin_accnt	Several different entities in the external systems can be mapped to a financial account				extern_for	clarify_type	clarify_objid
fin_accnt2fa_pc_role	OTM	fa_pc_role	fa_pc_role2fin_accnt	Pay channel roles for the financial account
fin_accnt2fin_accnt_extern	OTM	fin_accnt_extern	fin_accnt_extern2fin_accnt	External system key related to the fin_accnt
fin_accnt2interact	OTM	interact	interact2fin_accnt	Interaction related to financial account
fin_accnt2req_to_extern	OTM	req_to_extern	req_to_extern2fin_accnt	Request can be related to a financial account

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
fc2bo5694	fa_child2bus_org	nonclustered located on PRIMARY
fp2bo5694	fa_parent2bus_org	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5716	vw_con_fin_accnt	con_fin_accnt_role, contact, fin_accnt, fin_accnt_extern
5720	vw_fin_accnt_blg_argmnt	blg_argmnt, blg_argmnt_extern, fin_accnt, fin_accnt_extern
5721	vw_fin_accnt_pay_chnl	fa_pc_role, fin_accnt, fin_accnt_extern, pay_channel, pay_chnl_extern
5723	vw_pbus_org_fin_accnt	bus_org, fin_accnt, fin_accnt_extern
5724	vw_bus_org_fin_accnt	bus_org, fin_accnt, fin_accnt_extern
5731	vw_case_billing	blg_argmnt, case, condition, contact, fin_accnt, gbst_elm, pay_channel, site
5815	fin_contact_view	con_fin_accnt_role, contact, fin_accnt
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
5838	req_to_extern_view	blg_argmnt, bus_org, fin_accnt, pay_means, pp_bucket, rechrg_instrn, req_to_extern

My Recent Objects

fin_accnt

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user