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
NameTypeConstraintsDescription
xactpay_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.
xactpay_payroll_transmission_KEYint (4)NOT NULLForeign key for this table. The associated XactPay_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_XactPay_N_Payroll_Bank_Transactionxactpay_n_payroll_bank_transaction_KEY
Unique constraints
NameColumnsDescription
UK_XactPay_N_Payroll_Bank_Transaction$bank_transaction_KEY$bank_transaction_event_type_KEYbank_transaction_KEY, bank_transaction_event_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_XactPay_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_XactPay_N_Payroll_Bank_Transaction__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction (bank_transaction_KEY)
FK_XactPay_N_Payroll_Bank_Transaction__XactPay_Payroll_Transmission__xactpay_payroll_transmission_KEYxactpay_payroll_transmission_KEYXactPay_Payroll_Transmission (xactpay_payroll_transmission_KEY)

Schema diagram