Previous: fee_cap_adjustment | Unanet Data Model | Next: fin_document |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | fee_method_key | decimal(15) | |||
2. | fee_method | varchar(128) | ||||
3. | actuals_formula | varchar(3500) | ||||
4. | budget_formula | varchar(3500) | ||||
5. | active | char(1) | ('Y') |
Table | Column | Foreign Key Name |
cost_plus_post_detail | fee_method_key | fk_cost_plus_post_detail6 |
fee_cap_adjustment | fee_method_key | fk_fee_cap_adjustment2 |
project_fee | fee_method_key | fk_project_fee2 |
Name | Definition |
cc_fee_method_active | ([active]='N' OR [active]='Y') |
Index Name | Unique | Column Name | Asc Or Desc |
pk_fee_method | true | fee_method_key | Asc |
idx_fee_method1 | true | fee_method | Asc |