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
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