Table: pay_code_rate

Previous: pay_code_mapping Unanet Data Model Next: payment_method
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK pay_code_rate_key decimal(15)      
2.   pay_code_key decimal(15)   pay_code fk_pay_code_rate1
3.   begin_date datetime      
4.   end_date datetime      
5.   rate decimal(15,5)      
Foreign Keys
Column References Foreign Key Name
Table Column
pay_code_key pay_code pay_code_key fk_pay_code_rate1
Check Constraints
Name Definition
cc_pcr_begin_date ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_pcr_end_date ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_pay_code_rate true pay_code_rate_key Asc
idx_pay_code_rate1 true pay_code_key Asc
    begin_date