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. |
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. |