Table: dbo.Insurepay_N_Payroll_Bank_Transaction
A dictionary table to map Insurepay_Payroll_Transmission and Payroll_Bank_Transaction, so that each check item in the payroll file will have an entry here.
Columns
Name | Type | Constraints | Description
insurepay_n_payroll_bank_transaction_KEY | int (4) | NOT NULL | Primary key for this table.
bank_transaction_KEY | int (4) | NOT NULL | Foreign key for this table.The associated Payroll_Bank_Transaction primary key.
insurepay_payroll_transmission_KEY | int (4) | NOT NULL | Foreign key for this table. The associated Insurepay_Payroll_Transmission primary key.
bank_transaction_event_type_KEY | int (4) | NOT NULL | Foreign key for this table.The associated bank transaction event type in Payroll_Bank_Transaction. It will have two possible values: 2(Finalize) means 2(Finalize) in Payroll_Bank_Transaction, 4(delete) means 3(Void) or 4(Delete) in Payroll_Bank_Transaction.

Primary key
Name | Columns | Description
PK_Insurepay_N_Payroll_Bank_Transaction | insurepay_n_payroll_bank_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_Insurepay_N_Payroll_Bank_Transaction$bank_transaction_KEY$bank_transaction_event_type_KEY | bank_transaction_KEY, bank_transaction_event_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_N_Payroll_Bank_Transaction__Bank_Transaction_Event_Type__bank_transaction_event_type_KEY | bank_transaction_event_type_KEY | Bank_Transaction_Event_Type (bank_transaction_event_type_KEY) |
FK_Insurepay_N_Payroll_Bank_Transaction__Insurepay_Payroll_Transmission__insurepay_payroll_transmission_KEY | insurepay_payroll_transmission_KEY | Insurepay_Payroll_Transmission (insurepay_payroll_transmission_KEY) |
FK_Insurepay_N_Payroll_Bank_Transaction__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) |