| Previous: export_template_data | Unanet Data Model | Next: fee_method |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fee_cap_adjustment_key | decimal(15) | |||
| 2. | project_key | decimal(15) | project | fk_fee_cap_adjustment1 | ||
| 3. | fee_method_key | decimal(15) | fee_method | fk_fee_cap_adjustment2 | ||
| 4. | post_history_key | decimal(15) | post_history | fk_fee_cap_adjustment3 | ||
| 5. | invoice_key | decimal(15) | invoice | fk_fee_cap_adjustment4 | ||
| 6. | bill_amount | decimal(18,2) | ||||
| 7. | recognize_amount | decimal(18,2) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| fee_method_key | fee_method | fee_method_key | fk_fee_cap_adjustment2 |
| invoice_key | invoice | invoice_key | fk_fee_cap_adjustment4 |
| post_history_key | post_history | post_history_key | fk_fee_cap_adjustment3 |
| project_key | project | project_key | fk_fee_cap_adjustment1 |
| Table | Column | Foreign Key Name |
| invcd_fee_cap_adjustment | fee_cap_adjustment_key | fk_invcd_fee_cap_adjustment2 |
| journal_fee_cap_adjustment | fee_cap_adjustment_key | fk_journal_fee_cap_adjust1 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_fee_cap_adjustment | true | fee_cap_adjustment_key | Asc |
| idx_fee_cap_adjustment1 | false | project_key | Asc |
| fee_method_key | |||
| idx_fee_cap_adjustment2 | false | invoice_key | Asc |
| idx_fee_cap_adjustment3 | false | fee_method_key | Asc |
| idx_fee_cap_adjustment4 | false | post_history_key | Asc |