Table Name:	pay_channel
Table Number:	5696
Group:	Billing Manager
Description:	Channel through which a customer requests a financial system to initiate payment collection on a regular basis
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_pay_channel

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
last_update	CLK_TIME	datetime				CHANGE_DATE	Date time of last update
name	CHAR	varchar		80			Name given to the pay channel, e.g. Personal, Business, Voice, Data etc	Search (5)
objid	LONG	int	3			DIRECT	Internal record number	Search (6)
status	CHAR	varchar		20			Status of pay channel, e.g. Active, Close	Search (2)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
pay_channel2ba_pc_role	OTM	ba_pc_role	ba_pc_role2pay_channel	Billing arrangement roles for the pay channel e.g. pre-paid, post-paid
pc_child2bus_org	MTO	bus_org	child2pay_channel	Organization this pay channel is managed			Search (1)
pc_parent2bus_org	MTO	bus_org	parent2pay_channel	Parent organization this pay channel is managed			Search (1)
pay_channel2case	OTM	case	case2pay_channel	Case related to the pay channel
pay_channel2con_pc_role	OTM	con_pc_role	con_pc_role2pay_channel	contact roles for the pay channel
pay_channel2fa_pc_role	OTM	fa_pc_role	fa_pc_role2pay_channel	Financial account roles for the pay channel
pay_channel2interact	OTM	interact	interact2pay_channel	Interaction related to the pay channel
pay_channel2pay_chnl_extern	OTM	pay_chnl_extern	pay_chnl_extern2pay_channel	External system key related to the Pay Channel

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
pcc2bo5696	pc_child2bus_org	nonclustered located on PRIMARY
pcp2bo5696	pc_parent2bus_org	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5718	vw_con_pay_chnl	con_pc_role, contact, pay_channel, pay_chnl_extern
5721	vw_fin_accnt_pay_chnl	fa_pc_role, fin_accnt, fin_accnt_extern, pay_channel, pay_chnl_extern
5722	vw_blg_argmnt_pay_chnl	ba_pc_role, blg_argmnt, blg_argmnt_extern, pay_channel, pay_chnl_extern
5730	vw_bus_org_pay_chnl	bus_org, pay_channel, pay_chnl_extern
5731	vw_case_billing	blg_argmnt, case, condition, contact, fin_accnt, gbst_elm, pay_channel, site
5736	vw_pbus_org_pay_chnl	bus_org, pay_channel, pay_chnl_extern

My Recent Objects

pay_channel

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user