| Previous: expense_data | Unanet Data Model | Next: expense_history |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | expense_data_allocation_key | decimal(15) | |||
| 2. | expense_data_key | decimal(15) | expense_data | fk_expense_data_allocation1 | ||
| 3. | project_key | decimal(15) | project | fk_expense_data_allocation2 | ||
| 4. | task_key | decimal(15) | task | fk_expense_data_allocation3 | ||
| 5. | allocation | decimal(6,3) | ||||
| 6. | amount | decimal(18,3) | ||||
| 7. | bill_amount | decimal(18,3) | ||||
| 8. | expense_currency | varchar(25) | ||||
| 9. | sequence | int | ||||
| 10. | vat_amount | decimal(18,3) | ((0.000)) | |||
| 11. | vat_location_key | decimal(15) | vat_location | fk_expense_data_allocation4 | ||
| 12. | cost_struct_odc_key | decimal(15) | cost_struct_odc | fk_expense_data_allocation5 | ||
| 13. | project_type_key | decimal(15) | project_type | fk_expense_data_allocation6 | ||
| 14. | billable | char(1) | ||||
| 15. | post_history_key | decimal(15) | post_history | fk_expense_data_allocation7 | ||
| 16. | invoice_key | decimal(15) | invoice | fk_expense_data_allocation8 | ||
| 17. | markup | decimal(5,2) | ((0)) | |||
| 18. | cost_account_key | decimal(15) | account | fk_expense_data_allocation9 | ||
| 19. | cost_post_history_key | decimal(15) | post_history | fk_expense_data_allocation10 | ||
| 20. | vendor_invoice_key | decimal(15) | vendor_invoice | fk_expense_data_allocation11 | ||
| 21. | po_key | decimal(15) | purchase_order | fk_expense_data_allocation12 | ||
| 22. | po_expense_line_descriptor_key | decimal(15) | po_expense_line_descriptor | fk_expense_data_allocation13 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_account_key | account | account_key | fk_expense_data_allocation9 |
| cost_struct_odc_key | cost_struct_odc | cost_struct_odc_key | fk_expense_data_allocation5 |
| expense_data_key | expense_data | expense_data_key | fk_expense_data_allocation1 |
| invoice_key | invoice | invoice_key | fk_expense_data_allocation8 |
| po_expense_line_descriptor_key | po_expense_line_descriptor | po_expense_line_descriptor_key | fk_expense_data_allocation13 |
| cost_post_history_key | post_history | post_history_key | fk_expense_data_allocation10 |
| post_history_key | post_history | post_history_key | fk_expense_data_allocation7 |
| project_key | project | project_key | fk_expense_data_allocation2 |
| project_type_key | project_type | project_type_key | fk_expense_data_allocation6 |
| po_key | purchase_order | po_key | fk_expense_data_allocation12 |
| task_key | task | task_key | fk_expense_data_allocation3 |
| vat_location_key | vat_location | location_key | fk_expense_data_allocation4 |
| vendor_invoice_key | vendor_invoice | fin_document_key | fk_expense_data_allocation11 |
| Table | Column | Foreign Key Name |
| cost_plus_post_detail | expense_data_allocation_key | fk_cost_plus_post_detail4 |
| invcd_expense | expense_data_allocation_key | fk_invcd_expense2 |
| journal_expense | expense_data_allocation_key | fk_journal_expense1 |
| vi_included_expense | expense_data_allocation_key | fk_vi_included_expense2 |
| Name | Definition |
| cc_eda_billable | (([billable]='N' OR [billable]='Y') AND [billable] IS NOT NULL) |
| cc_eda_project_type_key | ([project_type_key] IS NOT NULL) |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_expense_data_allocation | true | expense_data_allocation_key | Asc |
| idx_expense_data_alloc1 | false | expense_data_key | Asc |
| idx_expense_data_alloc2 | false | project_key | Asc |
| idx_expense_data_alloc3 | false | invoice_key | Asc |
| idx_expense_data_alloc4 | false | po_key | Asc |
| idx_expense_data_alloc5 | false | po_expense_line_descriptor_key | Asc |
| idx_expense_data_alloc6 | false | vendor_invoice_key | Asc |
| View Name |
| journal_view |
| vendor_payment_1099_view |