Table: dbo.Data_Origin
This table enumerates possible origins of certain data (for example, bank transactions or journal entries) in the database. For data integrity reasons, entries MUST NEVER BE REMOVED FROM THIS TABLE and can be instead documented as obsolete. Value 16 is reserved. It was OnBalance; it was removed from this table leading to the need to triage customer data by altering the audit trail to reflect such entries were manual data entry.
Columns
Name | Type | Constraints | Description
data_origin_KEY | int (4) | NOT NULL | Primary key.
description | nvarchar (50) | NOT NULL | Description of a data origin.

Primary key
Name | Columns | Description
PK_Data_Origin | data_origin_KEY |
Unique constraints
Name | Columns | Description
UK_Data_Origin$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client__Data_Origin__data_origin_KEY | data_origin_KEY | Client |
FK_Journal_Entry__Data_Origin__data_origin_KEY | data_origin_KEY | Journal_Entry |
FK_Bank_Transaction__Data_Origin__data_origin_KEY | data_origin_KEY | Bank_Transaction |
FK_Bank_Transaction_Template__Data_Origin__data_origin_KEY | data_origin_KEY | Bank_Transaction_Template |
FK_Payable_Payment_Application$data_origin_KEY | data_origin_KEY | Payable_Payment_Application |