| Previous: fee_method | Unanet Data Model | Next: fin_document_attachment |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_key | decimal(15) | |||
| 2. | legal_entity_key | decimal(15) | customer | fk_fin_document1 | ||
| 3. | document_type | tinyint | ||||
| 4. | document_number | varchar(15) | ||||
| 5. | document_date | datetime | ||||
| 6. | post_date | datetime | ||||
| 7. | last_updated_by | decimal(15) | person | fk_fin_document2 | ||
| 8. | created_by | decimal(15) | person | fk_fin_document3 | ||
| 9. | submitted_by | decimal(15) | person | fk_fin_document4 | ||
| 10. | posted_by | decimal(15) | person | fk_fin_document5 | ||
| 11. | last_updated_timestamp | datetime | ||||
| 12. | created_timestamp | datetime | ||||
| 13. | submitted_timestamp | datetime | ||||
| 14. | posted_timestamp | datetime | ||||
| 15. | reference | varchar(25) | ||||
| 16. | description | varchar(128) | ||||
| 17. | comments | varchar(2000) | ||||
| 18. | voiding_fin_document_key | decimal(15) | fin_document | fk_fin_document6 | ||
| 19. | voided_fin_document_key | decimal(15) | fin_document | fk_fin_document7 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| legal_entity_key | customer | customer_key | fk_fin_document1 |
| voiding_fin_document_key | fin_document | fin_document_key | fk_fin_document6 |
| voided_fin_document_key | fin_document | fin_document_key | fk_fin_document7 |
| last_updated_by | person | person_key | fk_fin_document2 |
| created_by | person | person_key | fk_fin_document3 |
| submitted_by | person | person_key | fk_fin_document4 |
| posted_by | person | person_key | fk_fin_document5 |
| Table | Column | Foreign Key Name |
| customer_payment | fin_document_key | fk_customer_payment1 |
| deposit | fin_document_key | fk_deposit1 |
| deposit_included | included_fin_document_key | fk_deposit_included2 |
| fin_document | voided_fin_document_key | fk_fin_document7 |
| fin_document | voiding_fin_document_key | fk_fin_document6 |
| fin_document_attachment | fin_document_key | fk_fin_document_attachment1 |
| fin_document_detail | fin_document_key | fk_fin_document_detail1 |
| fin_document_recurring | created_by_fin_document_key | fk_fin_document_recurring2 |
| fin_document_recurring | fin_document_key | fk_fin_document_recurring1 |
| journal_entry | fin_document_key | fk_journal_entry1 |
| vendor_invoice | fin_document_key | fk_vendor_invoice1 |
| vendor_payment | fin_document_key | fk_vendor_payment9 |
| vendor_payment_included | included_fin_document_key | fk_vendor_payment_included2 |
| Name | Definition |
| cc_fd_created_timestamp | ([created_timestamp]>='1900-01-01' AND [created_timestamp]<='2099-12-31') |
| cc_fd_document_date | ([document_date]>='1900-01-01' AND [document_date]<='2099-12-31') |
| cc_fd_document_type | ([document_type]>=(0) AND [document_type]<=(99)) |
| cc_fd_last_updated_timestamp | ([last_updated_timestamp]>='1900-01-01' AND [last_updated_timestamp]<='2099-12-31') |
| cc_fd_post_date | ([post_date]>='1900-01-01' AND [post_date]<='2099-12-31') |
| cc_fd_posted_timestamp | ([posted_timestamp]>='1900-01-01' AND [posted_timestamp]<='2099-12-31') |
| cc_fd_submitted_timestamp | ([submitted_timestamp]>='1900-01-01' AND [submitted_timestamp]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_fin_document | true | fin_document_key | Asc |
| idx_fin_document1 | true | document_number | Asc |
| document_type | |||
| idx_fin_document2 | false | legal_entity_key | Asc |
| idx_fin_document3 | false | last_updated_by | Asc |
| idx_fin_document4 | false | created_by | Asc |
| idx_fin_document5 | false | submitted_by | Asc |
| idx_fin_document6 | false | posted_by | Asc |
| idx_fin_document7 | false | voiding_fin_document_key | Asc |
| idx_fin_document8 | false | voided_fin_document_key | Asc |
| View Name |
| customer_invoice_activity |
| customer_payment_activity |
| vendor_invoice_activity |
| vendor_payment_1099_view |
| vendor_payment_activity |