Unanet Data Model

EXP_CUST_APPROVAL_STATUS

Column Name Data Type Nulls References
Table
Foreign Key
Name
expense_report_key decimal (15,0)   EXPENSE_REPORT fk_exp_cust_approval_status1
project_key decimal (15,0)   PROJECT fk_exp_cust_approval_status2
approved varchar (1)      

Check Constraints for EXP_CUST_APPROVAL_STATUS

Check Constraint Name Definition
cc_ecas_approved (approved = 'N' or (approved = 'Y'))

Indexes on EXP_CUST_APPROVAL_STATUS

Index Name Column(s)
pk_exp_cust_approval_status expense_report_key, project_key


No References made to EXP_CUST_APPROVAL_STATUS

No Views Reference EXP_CUST_APPROVAL_STATUS


Copyright 1998, 1999 Computer Strategies, Inc., All Rights Reserved.
Last revised: May 25, 2000 11:27:39 AM EDT