| Previous: cost_plus_invc_sect_fmt | Unanet Data Model | Next: cost_pool |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | cost_plus_post_detail_key | decimal(15) | |||
| 2. | project_key | decimal(15) | project | fk_cost_plus_post_detail1 | ||
| 3. | time_data_key | decimal(15) | person_time_data | fk_cost_plus_post_detail3 | ||
| 4. | expense_data_allocation_key | decimal(15) | expense_data_allocation | fk_cost_plus_post_detail4 | ||
| 5. | fin_document_det_expense_key | decimal(15) | fin_document_detail_expense | fk_cost_plus_post_detail6 | ||
| 6. | cost_element_key | decimal(15) | cost_element | fk_cost_plus_post_detail8 | ||
| 7. | fee_method_key | decimal(15) | fee_method | fk_cost_plus_post_detail9 | ||
| 8. | post_history_key | decimal(15) | post_history | fk_cost_plus_post_detail10 | ||
| 9. | invoice_key | decimal(15) | invoice | fk_cost_plus_post_detail11 | ||
| 10. | bill_amount | decimal(18,2) | ||||
| 11. | recognize_amount | decimal(18,2) | ||||
| 12. | task_key | decimal(15) | task | fk_cost_plus_post_detail2 | ||
| 13. | fin_document_det_item_key | decimal(15) | fin_document_detail_item | fk_cost_plus_post_detail7 | ||
| 14. | fin_document_det_labor_key | decimal(15) | fin_document_detail_labor | fk_cost_plus_post_detail5 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_element_key | cost_element | cost_element_key | fk_cost_plus_post_detail8 |
| expense_data_allocation_key | expense_data_allocation | expense_data_allocation_key | fk_cost_plus_post_detail4 |
| fee_method_key | fee_method | fee_method_key | fk_cost_plus_post_detail9 |
| fin_document_det_expense_key | fin_document_detail_expense | fin_document_detail_key | fk_cost_plus_post_detail6 |
| fin_document_det_item_key | fin_document_detail_item | fin_document_detail_key | fk_cost_plus_post_detail7 |
| fin_document_det_labor_key | fin_document_detail_labor | fin_document_detail_key | fk_cost_plus_post_detail5 |
| invoice_key | invoice | invoice_key | fk_cost_plus_post_detail11 |
| time_data_key | person_time_data | time_data_key | fk_cost_plus_post_detail3 |
| post_history_key | post_history | post_history_key | fk_cost_plus_post_detail10 |
| project_key | project | project_key | fk_cost_plus_post_detail1 |
| task_key | task | task_key | fk_cost_plus_post_detail2 |
| Table | Column | Foreign Key Name |
| invcd_cost_plus_post_detail | cost_plus_post_detail_key | fk_invcd_cpp_detail2 |
| journal_cost_plus_detail | cost_plus_post_detail_key | fk_journal_cost_plus_detail1 |
| Name | Definition |
| cc_cost_plus_post_direct | ([time_data_key] IS NOT NULL AND [expense_data_allocation_key] IS NULL AND [fin_document_det_labor_key] IS NULL AND [fin_document_det_expense_key] IS NULL AND [fin_document_det_item_key] IS NULL OR [time_data_key] IS NULL AND [expense_data_allocation_key] IS NOT NULL AND [fin_document_det_labor_key] IS NULL AND [fin_document_det_expense_key] IS NULL AND [fin_document_det_item_key] IS NULL OR [time_data_key] IS NULL AND [expense_data_allocation_key] IS NULL AND [fin_document_det_labor_key] IS NOT NULL AND [fin_document_det_expense_key] IS NULL AND [fin_document_det_item_key] IS NULL OR [time_data_key] IS NULL AND [expense_data_allocation_key] IS NULL AND [fin_document_det_labor_key] IS NULL AND [fin_document_det_expense_key] IS NOT NULL AND [fin_document_det_item_key] IS NULL OR [time_data_key] IS NULL AND [expense_data_allocation_key] IS NULL AND [fin_document_det_labor_key] IS NULL AND [fin_document_det_expense_key] IS NULL AND [fin_document_det_item_key] IS NOT NULL) |
| cc_cost_plus_post_item | ([cost_element_key] IS NOT NULL AND [fee_method_key] IS NULL OR [cost_element_key] IS NULL AND [fee_method_key] IS NOT NULL) |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_cost_plus_post_detail | true | cost_plus_post_detail_key | Asc |
| idx_cost_plus_post_detail1 | false | project_key | Asc |
| idx_cost_plus_post_detail10 | false | post_history_key | Asc |
| idx_cost_plus_post_detail2 | false | time_data_key | Asc |
| idx_cost_plus_post_detail3 | false | expense_data_allocation_key | Asc |
| idx_cost_plus_post_detail4 | false | fin_document_det_labor_key | Asc |
| idx_cost_plus_post_detail5 | false | fin_document_det_expense_key | Asc |
| idx_cost_plus_post_detail6 | false | fin_document_det_item_key | Asc |
| idx_cost_plus_post_detail7 | false | cost_element_key | Asc |
| idx_cost_plus_post_detail8 | false | fee_method_key | Asc |
| idx_cost_plus_post_detail9 | false | invoice_key | Asc |
| View Name |
| journal_view |