Table: payment_term

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	payment_term_key	decimal(15)
2.		payment_term_code	varchar(25)
3.		description	varchar(128)
4.		days	decimal(3)
5.		default_selected	char(1)
6.		active	char(1)
7.		discount_days	decimal(3)
8.		discount_percent	decimal(5,2)

Referenced from
Table	Column	Foreign Key Name
customer_org	payment_term_key	fk_customer_org3
invoice	payment_term_key	fk_invoice4
project_invoice	payment_term_key	fk_project_invoice3
purchase_order	payment_term_key	fk_purchase_order6
vendor_invoice	payment_term_key	fk_vendor_invoice3
vendor_org	payment_term_key	fk_vendor_org3

Check Constraints
Name	Definition
cc_discount_percent	([discount_percent]>(0) AND [discount_percent]<=(100))
cc_payment_term_active	([active]='N' OR [active]='Y')
cc_pt_default_selected	([default_selected]='N' OR [default_selected]='Y')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_payment_term	true	payment_term_key	Asc
idx_payment_term1	true	payment_term_code	Asc