Table: dbo.Reprintable_Bank_Transaction
This table is the master list of all bank transactions that may be reprinted because they were stored for reprinting during their initial printing.
Columns
Name | Type | Constraints | Description
bank_transaction_KEY | int (4) | NOT NULL | Key that uniquely identifies each row of the table and links to a record in table Bank_Transaction.
reprintable_print_job_KEY | int (4) | NOT NULL | Foreign key to table Reprintable_Print_Job that allows us to tie back to the staff who originally printed checks and also to the date of printing.
report_definition_KEY | int (4) | NOT NULL | Foreign key to table Report_Definition to identify the layout paired with the bank transaction during its initial printing.
original_report_definition_checksum | decimal (9) | NOT NULL | Use this to compare later to column checksum in table Report_Definition to see if the user changed the layout since the original print job.

Primary key
Name | Columns | Description
PK_Reprintable_Bank_Transaction$bank_transaction_KEY | bank_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_Reprintable_Bank_Transaction$bank_transaction_KEY | bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Reprintable_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Reprintable_Bank_Transaction__Report_Definition__report_definition_KEY | report_definition_KEY | Report_Definition (report_definition_KEY) |
FK_Reprintable_Bank_Transaction__Reprintable_Print_Job__reprintable_print_job_KEY | reprintable_print_job_KEY | Reprintable_Print_Job (print_job_KEY) |