| Previous: fin_document_det_proj_labor | Unanet Data Model | Next: fin_document_detail_expense |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_detail_key | decimal(15) | |||
| 2. | fin_document_key | decimal(15) | fin_document | fk_fin_document_detail1 | ||
| 3. | account_key | decimal(15) | account | fk_fin_document_detail2 | ||
| 4. | organization_key | decimal(15) | customer | fk_fin_document_detail3 | ||
| 5. | reference | varchar(25) | ||||
| 6. | description | varchar(128) | ||||
| 7. | transaction_date | datetime | ||||
| 8. | person_key | decimal(15) | person | fk_fin_document_detail4 | ||
| 9. | general_ledger_key | decimal(15) | general_ledger | fk_fin_document_detail5 | ||
| 10. | debit_amount | decimal(18,2) | ((0)) | |||
| 11. | credit_amount | decimal(18,2) | ((0)) | |||
| 12. | customer_key | decimal(15) | customer | fk_fin_document_detail6 | ||
| 13. | detail_type | char(1) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_fin_document_detail2 |
| organization_key | customer | customer_key | fk_fin_document_detail3 |
| customer_key | customer | customer_key | fk_fin_document_detail6 |
| fin_document_key | fin_document | fin_document_key | fk_fin_document_detail1 |
| general_ledger_key | general_ledger | general_ledger_key | fk_fin_document_detail5 |
| person_key | person | person_key | fk_fin_document_detail4 |
| Table | Column | Foreign Key Name |
| fin_document_det_proj_expense | fin_document_detail_key | fk_fin_doc_det_proj_expense5 |
| fin_document_det_proj_item | fin_document_detail_key | fk_fin_doc_det_proj_item1 |
| fin_document_det_proj_labor | fin_document_detail_key | fk_fin_doc_det_proj_labor1 |
| fin_document_detail_po | fin_document_detail_key | fk_fin_doc_detail_po1 |
| Name | Definition |
| cc_fdd_amount | (NOT ([debit_amount]<>(0) AND [credit_amount]<>(0))) |
| cc_fdd_detail_type | ([detail_type]='L' OR [detail_type]='I' OR [detail_type]='E') |
| cc_fdd_transaction_date | ([transaction_date]>='1900-01-01' AND [transaction_date]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_fin_document_detail | true | fin_document_detail_key | Asc |
| idx_fin_document_detail1 | false | fin_document_key | Asc |
| idx_fin_document_detail2 | false | account_key | Asc |
| idx_fin_document_detail3 | false | organization_key | Asc |
| idx_fin_document_detail4 | false | person_key | Asc |
| idx_fin_document_detail5 | false | general_ledger_key | Asc |
| idx_fin_document_detail6 | false | customer_key | Asc |
| View Name |
| customer_payment_activity |
| customer_payment_export_view |
| journal_view |
| vendor_payment_1099_view |
| vendor_payment_activity |
| vendor_payment_export_view |