Table: dbo.Positive_Pay_File_Detail
This table associates a given positive pay file with all the bank transactions that exported in the file.
Columns
NameTypeConstraintsDescription
positive_pay_file_detail_KEYint (4)NOT NULLThe primary key for this table.
positive_pay_file_KEYint (4)NOT NULLWhich Positive Pay File does this bank transaction relate to?
bank_transaction_KEYint (4)NOT NULLThe bank transaction for this record
transaction_status_KEYint (4)NOT NULLThe bank transaction status at the time the Postive Pay file was created. The value can only be Live or Voided cuz those are the only two status values that export.
Primary key
NameColumnsDescription
PK_Positive_Pay_File_Detailpositive_pay_file_detail_KEY
Unique constraints
NameColumnsDescription
UK_Positive_Pay_File_Detail$positive_pay_file_KEY$bank_transaction_KEY$transaction_status_KEYpositive_pay_file_KEY, bank_transaction_KEY, transaction_status_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Positive_Pay_File_Detail__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Positive_Pay_File_Detail__Positive_Pay_File__positive_pay_file_KEYpositive_pay_file_KEYPositive_Pay_File (positive_pay_file_KEY)
FK_Positive_Pay_File_Detail__Transaction_Status__transaction_status_KEYtransaction_status_KEYTransaction_Status (transaction_status_KEY)

Schema diagram