Table Name:	pay_means
Table Number:	5440
Group:	Sales Mgr
Description:	Contains the description of a device for making a payment; e.g., credit card
Flags:
Baseline/Custom:	Baseline

select * from table_pay_means

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
account_owner	CHAR	varchar		80		ALLOW_NULL	Name of account owner	Search (2)
account_type	CHAR	varchar		40		ALLOW_NULL	Account type e.g. Business, private etc. populated from a user defined pop-up
authorization_no	CHAR	varchar		24		ALLOW_NULL	the authorization number, as was given by the bank or CC company, to direct debit the account	Search (2)
authorization_sts	LONG	smallint				DIRECT, ALLOW_NULL	Status of process to approve direct debit in the bank	Search (1)
bank_code	CHAR	varchar		8		ALLOW_NULL	Bank's code	Search (1)
bank_name	CHAR	varchar		80		ALLOW_NULL	Name of the bank	Search (3)
bill_address	CHAR	varchar		80			Street address of the person whose name appears on the payment means
bill_city	CHAR	varchar		30			The city for the bill address
bill_country	CHAR	varchar		40			The country of the bill address
bill_state_prov	CHAR	varchar		80			The state/province of the bill address
bill_zipcode	CHAR	varchar		25			Zipcode or postal code of the bill address
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
branch_code	CHAR	varchar		8		ALLOW_NULL	Branch's code	Search (1)
cc_exp_mo	CHAR	varchar		2			2-digit number of the month when the card expires	Search (2)
cc_exp_yr	CHAR	varchar		4			2- or 4-digit number of the year in which the credit card expires	Search (2)
cc_name	CHAR	varchar		80			For credit cards, complete name of the credit card owner as it appears on the card	Search (2)
cc_type	CHAR	varchar		40			For credit cards, the credit card type populated from a user defined pop-up with the title 'cctype'	Search (3)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
expire_date	CLK_TIME	datetime					The last date the payment means is effective
id_number	CHAR	varchar		64			Payment means identification number; e.g., the credit card number	Search (2)
last_four	CHAR	varchar		4			Last four digits of the pay_means id_number	Search (3)
means_type	LONG	smallint				DIRECT	The payment option for this line item; e.g., 0=credit card, 1=purchase order, 2-bank account, 3-cash. This is from a user-defined popup with default name PAY_METHOD	Search (2)
modify_stmp	CLK_TIME	datetime	46				Date and time when object was last saved
objid	LONG	int	3			DIRECT	Internal record number	Search (7)
pin_no	CHAR	varchar		9		ALLOW_NULL	The number that is given to the user in order for the user to identify the credit card/bank details with out giving the credit card information or bank details	Search (1)
valid_dt	CLK_TIME	datetime				ALLOW_NULL	Date on which the card/bank becomes valid for use

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Set Name	Type ID Stored in	Objid Stored In
					Exclusive Set Relations
pay_means2blg_argmnt	OTM	blg_argmnt	blg_argmnt2pay_means	Automatic post paid payment due to the invoice for a pay means
pay_means2bus_org	MTO	bus_org	bus_org2pay_means	If owned by and account, the account
pay_means2con_pym_role	OTM	con_pym_role	cn_pm_role2pay_means	Contact roles for the payment means
pay_means2purchase_ord	OTM	purchase_ord	payment2pay_means	Payments made from the pay_means
pay_means2rechrg_instrn	OTM	rechrg_instrn	rechrg_instrn2pay_means	Recharge instructions for recurring pre paid payments using a pay means	payment_for	source_type	source_lowid
pay_means2req_to_extern	OTM	req_to_extern	req_to_extern2pay_means	Request can be related to a pay means

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
paymns_ind	id_number:means_type:cc_type:pay_means2bus_org:bank_code:branch_code	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ao5440	account_owner	nonclustered located on PRIMARY
bn5440	bank_name	nonclustered located on PRIMARY
ccn	cc_name	nonclustered located on PRIMARY
ct5440	cc_type	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
paymns_ind	id_number, means_type, cc_type, pay_means2bus_org, bank_code, branch_code	nonclustered, unique located on PRIMARY
pm2b	pay_means2bus_org	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5814	pm_contact_view	con_pym_role, contact, pay_means
5827	bar_busorg_fa_pm_eaddr_v	blg_argmnt, bus_org, e_addr, fin_accnt, pay_means
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
5841	pay_means_con_v	con_pym_role, contact, pay_means
5842	po_curr_contr_v	contract, currency, pay_means, purchase_ord
5865	ri_ppb_vw	pay_means, pp_bucket, rechrg_instrn

My Recent Objects

pay_means

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