| Previous: exp_cust_approval_status | Unanet Data Model | Next: expense_data_allocation |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | expense_data_key | decimal(15) | |||
| 2. | expense_report_key | decimal(15) | expense_report | fk_expense_data1 | ||
| 3. | expense_type_key | decimal(15) | expense_type | fk_expense_data5 | ||
| 4. | currency_key | decimal(15) | currency | fk_expense_data2 | ||
| 5. | payment_method_key | decimal(15) | payment_method | fk_expense_data4 | ||
| 6. | expense_date | datetime | ||||
| 7. | expense_project_allocation_key | decimal(15) | expense_project_allocation | fk_expense_data6 | ||
| 8. | comments | varchar(2000) | ||||
| 9. | amount | decimal(18,3) | ||||
| 10. | summary | varchar(2000) | ||||
| 11. | sequence | int | ||||
| 12. | receipt_included | char(1) | ||||
| 13. | no_receipt_reason | varchar(128) | ||||
| 14. | vendor_key | decimal(15) | vendor | fk_expense_data3 | ||
| 15. | vendor_name | varchar(255) | ||||
| 16. | project_type_key | decimal(15) | project_type | fk_expense_data7 | ||
| 17. | exchange_rate | decimal(18,6) | ||||
| 18. | expense_currency | varchar(25) | ||||
| 19. | expense_amount | decimal(18,3) | ||||
| 20. | expense_vat_amount | decimal(18,3) | ((0.000)) | |||
| 21. | vat_amount | decimal(18,3) | ((0.000)) | |||
| 22. | vat_location_key | decimal(15) | vat_location | fk_expense_data8 | ||
| 23. | imported_expense_data_key | decimal(15) | imported_expense_data | fk_expense_data9 | ||
| 24. | parent_key | decimal(15) | ||||
| 25. | last_update | datetime | (getdate()) | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| currency_key | currency | currency_key | fk_expense_data2 |
| expense_project_allocation_key | expense_project_allocation | expense_project_allocation_key | fk_expense_data6 |
| expense_report_key | expense_report | expense_report_key | fk_expense_data1 |
| expense_type_key | expense_type | expense_type_key | fk_expense_data5 |
| imported_expense_data_key | imported_expense_data | imported_expense_data_key | fk_expense_data9 |
| payment_method_key | payment_method | payment_method_key | fk_expense_data4 |
| project_type_key | project_type | project_type_key | fk_expense_data7 |
| vat_location_key | vat_location | location_key | fk_expense_data8 |
| vendor_key | vendor | vendor_key | fk_expense_data3 |
| Table | Column | Foreign Key Name |
| air_detail | expense_data_key | fk_air_detail1 |
| business_meeting_detail | expense_data_key | fk_business_meeting_detail1 |
| cash_return_detail | expense_data_key | fk_cash_return_detail1 |
| cell_phone_detail | expense_data_key | fk_cell_phone_detail1 |
| company_car_detail | expense_data_key | fk_company_car_detail1 |
| entertainment_detail | expense_data_key | fk_entertainment_detail1 |
| expense_data_allocation | expense_data_key | fk_expense_data_allocation1 |
| lodging_allowable_detail | expense_data_key | fk_lodging_allowable_detail1 |
| lodging_detail | expense_data_key | fk_lodging_detail1 |
| lodging_per_diem_detail | expense_data_key | fk_lodging_per_diem_detail1 |
| mie_allowable_detail | expense_data_key | fk_mie_allowable_detail1 |
| mie_per_diem_detail | expense_data_key | fk_mie_per_diem_detail1 |
| mileage_detail | expense_data_key | fk_mileage_detail1 |
| Name | Definition |
| cc_expense_data_expense_date | ([expense_date]>='1900-01-01' AND [expense_date]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_expense_data | true | expense_data_key | Asc |
| idx_expense_data1 | false | imported_expense_data_key | Asc |
| idx_expense_data2 | false | expense_report_key | Asc |
| View Name |
| journal_view |
| vendor_payment_1099_view |