Table: dbo.XactPay_N_Payroll_Bank_Transaction
A dictionary table to map XactPay_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
xactpay_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.
xactpay_payroll_transmission_KEY | int (4) | NOT NULL | Foreign key for this table. The associated XactPay_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_XactPay_N_Payroll_Bank_Transaction | xactpay_n_payroll_bank_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_XactPay_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_XactPay_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_XactPay_N_Payroll_Bank_Transaction__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) |
FK_XactPay_N_Payroll_Bank_Transaction__XactPay_Payroll_Transmission__xactpay_payroll_transmission_KEY | xactpay_payroll_transmission_KEY | XactPay_Payroll_Transmission (xactpay_payroll_transmission_KEY) |