Table: payment_method

Previous: pay_code_rate

Unanet Data Model

Next: payment_method_account

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	payment_method_key	decimal(15)
2.		payment_method_code	varchar(25)
3.		description	varchar(2000)
4.		pr_allowed	char(1)	('N')
5.		reimbursable	char(1)	('N')
6.		ap_payment_type	char(1)
7.		ar_payment_type	char(1)
8.		active	char(1)	('Y')
9.		allow_for_non_employee	char(1)	('N')
10.		include_in_1099	char(1)	('N')

Referenced from

Table	Column	Foreign Key Name
customer_payment	payment_method_key	fk_customer_payment3
expense_data	payment_method_key	fk_expense_data4
imported_expense_data	payment_method_key	fk_imported_expense_data1
payment_method_account	payment_method_key	fk_payment_method_account1
person	payment_method_key	fk_person14
vendor_payment	payment_method_key	fk_vendor_payment2

Check Constraints

Name	Definition
cc_allow_for_non_employee	([allow_for_non_employee]='N' OR [allow_for_non_employee]='Y')
cc_ap_payment_type	([ap_payment_type]='O' OR [ap_payment_type]='M' OR [ap_payment_type]='S')
cc_ar_payment_type	([ar_payment_type]='O' OR [ar_payment_type]='K')
cc_payment_method_incl_in_1099	([include_in_1099]='N' OR [include_in_1099]='Y')
cc_pm_active	([active]='N' OR [active]='Y')
cc_pr_allowed	([pr_allowed]='N' OR [pr_allowed]='Y')
cc_reimbursable	([reimbursable]='N' OR [reimbursable]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_payment_method	true	payment_method_key	Asc

Dependent Views

View Name
vendor_payment_1099_view