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
Name | Type | Constraints | Description
positive_pay_file_detail_KEY | int (4) | NOT NULL | The primary key for this table.
positive_pay_file_KEY | int (4) | NOT NULL | Which Positive Pay File does this bank transaction relate to?
bank_transaction_KEY | int (4) | NOT NULL | The bank transaction for this record
transaction_status_KEY | int (4) | NOT NULL | The 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
Name | Columns | Description
PK_Positive_Pay_File_Detail | positive_pay_file_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Positive_Pay_File_Detail$positive_pay_file_KEY$bank_transaction_KEY$transaction_status_KEY | positive_pay_file_KEY, bank_transaction_KEY, transaction_status_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Positive_Pay_File_Detail__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Positive_Pay_File_Detail__Positive_Pay_File__positive_pay_file_KEY | positive_pay_file_KEY | Positive_Pay_File (positive_pay_file_KEY) |
FK_Positive_Pay_File_Detail__Transaction_Status__transaction_status_KEY | transaction_status_KEY | Transaction_Status (transaction_status_KEY) |