| Previous: item_uom_rate | Unanet Data Model | Next: journal_document_expense |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | journal_key | decimal(15) | |||
| 2. | journal_trans_date | datetime | ||||
| 3. | cost_plus_post_detail_key | decimal(15) | cost_plus_post_detail | fk_journal_cost_plus_detail1 | ||
| 4. | organization_key | decimal(15) | customer | fk_journal_cost_plus_detail6 | ||
| 5. | general_ledger_key | decimal(15) | general_ledger | fk_journal_cost_plus_detail7 | ||
| 6. | account_key | decimal(15) | account | fk_journal_cost_plus_detail2 | ||
| 7. | post_history_key | decimal(15) | post_history | fk_journal_cost_plus_detail4 | ||
| 8. | invoice_key | decimal(15) | invoice | fk_journal_cost_plus_detail5 | ||
| 9. | project_key | decimal(15) | project | fk_journal_cost_plus_detail3 | ||
| 10. | category | tinyint | ||||
| 11. | amount | decimal(18,2) | ||||
| 12. | extract_date | datetime | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_journal_cost_plus_detail2 |
| cost_plus_post_detail_key | cost_plus_post_detail | cost_plus_post_detail_key | fk_journal_cost_plus_detail1 |
| organization_key | customer | customer_key | fk_journal_cost_plus_detail6 |
| general_ledger_key | general_ledger | general_ledger_key | fk_journal_cost_plus_detail7 |
| invoice_key | invoice | invoice_key | fk_journal_cost_plus_detail5 |
| post_history_key | post_history | post_history_key | fk_journal_cost_plus_detail4 |
| project_key | project | project_key | fk_journal_cost_plus_detail3 |
| Name | Definition |
| cc_jcpd_category | ([category]>=(1) AND [category]<=(99)) |
| cc_jcpd_journal_trans_date | ([journal_trans_date]>='1900-01-01' AND [journal_trans_date]<='2099-12-31') |
| cc_jcpd_source | ([post_history_key] IS NOT NULL AND [invoice_key] IS NULL OR [post_history_key] IS NULL AND [invoice_key] IS NOT NULL) |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_journal_cost_plus_detail | true | journal_key | Asc |
| idx_journal_cost_plus_detail1 | false | project_key | Asc |
| idx_journal_cost_plus_detail2 | false | invoice_key | Asc |
| idx_journal_cost_plus_detail3 | false | cost_plus_post_detail_key | Asc |
| idx_journal_cost_plus_detail4 | false | organization_key | Asc |
| idx_journal_cost_plus_detail5 | false | general_ledger_key | Asc |
| idx_journal_cost_plus_detail6 | false | account_key | Asc |
| idx_journal_cost_plus_detail7 | false | post_history_key | Asc |
| idx_journal_cost_plus_detail8 | false | project_key | Asc |
| journal_trans_date | |||
| category |
| View Name |
| journal_view |