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
NameTypeConstraintsDescription
insurepay_n_payroll_bank_transaction_KEYint (4)NOT NULLPrimary key for this table.
bank_transaction_KEYint (4)NOT NULLForeign key for this table.The associated Payroll_Bank_Transaction primary key.
insurepay_payroll_transmission_KEYint (4)NOT NULLForeign key for this table. The associated Insurepay_Payroll_Transmission primary key.
bank_transaction_event_type_KEYint (4)NOT NULLForeign 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
NameColumnsDescription
PK_Insurepay_N_Payroll_Bank_Transactioninsurepay_n_payroll_bank_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Insurepay_N_Payroll_Bank_Transaction$bank_transaction_KEY$bank_transaction_event_type_KEYbank_transaction_KEY, bank_transaction_event_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_N_Payroll_Bank_Transaction__Bank_Transaction_Event_Type__bank_transaction_event_type_KEYbank_transaction_event_type_KEYBank_Transaction_Event_Type (bank_transaction_event_type_KEY)
FK_Insurepay_N_Payroll_Bank_Transaction__Insurepay_Payroll_Transmission__insurepay_payroll_transmission_KEYinsurepay_payroll_transmission_KEYInsurepay_Payroll_Transmission (insurepay_payroll_transmission_KEY)
FK_Insurepay_N_Payroll_Bank_Transaction__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction (bank_transaction_KEY)

Schema diagram