| Previous: fin_document_detail | Unanet Data Model | Next: fin_document_detail_project |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_detail_key | decimal(15) | fin_document_detail_project | fk_fin_doc_detail_expense1 | |
| 2. | amount | decimal(18,2) | ||||
| 3. | bill_amount | decimal(18,2) | ||||
| 4. | markup | decimal(5,2) | ((0)) | |||
| 5. | cost_struct_odc_key | decimal(15) | cost_struct_odc | fk_fin_doc_detail_expense2 | ||
| 6. | post_history_key | decimal(15) | post_history | fk_fin_doc_detail_expense3 | ||
| 7. | invoice_key | decimal(15) | invoice | fk_fin_doc_detail_expense4 | ||
| 8. | gl_customer_key | decimal(15) | customer | fk_fin_doc_detail_expense5 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_struct_odc_key | cost_struct_odc | cost_struct_odc_key | fk_fin_doc_detail_expense2 |
| gl_customer_key | customer | customer_key | fk_fin_doc_detail_expense5 |
| fin_document_detail_key | fin_document_detail_project | fin_document_detail_key | fk_fin_doc_detail_expense1 |
| invoice_key | invoice | invoice_key | fk_fin_doc_detail_expense4 |
| post_history_key | post_history | post_history_key | fk_fin_doc_detail_expense3 |
| Table | Column | Foreign Key Name |
| cost_plus_post_detail | fin_document_detail_key | fk_cost_plus_post_detail4 |
| invcd_document_expense | fin_document_detail_key | fk_invcd_document_expense2 |
| journal_document_expense | fin_document_detail_key | fk_journal_document_expense1 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_fin_doc_detail_expense | true | fin_document_detail_key | Asc |
| idx_fin_doc_detail_expense1 | false | post_history_key | Asc |
| idx_fin_doc_detail_expense2 | false | invoice_key | Asc |
| idx_fin_doc_detail_expense3 | false | cost_struct_odc_key | Asc |
| idx_fin_doc_detail_expense4 | false | gl_customer_key | Asc |