Table: dbo.Eftps_Transaction
Columns
Name | Type | Constraints | Description
bank_transaction_KEY | int (4) | NOT NULL | Primary key - points to related vendor check.
is_processed | bit (1) | NOT NULL | Flag indicating transaction has been processed to EFPTS file.
processed_date | smalldatetime (4) |  | Date transaction was processed to EFPTS file
physical_file_name | nvarchar (510) | NOT NULL | Name of physical file containing transaction information.
record_status_KEY | int (4) | NOT NULL | The status of the EFTPS transaction record.
settlement_date | smalldatetime (4) |  | Settlement date for the eftps transaction.

Primary key
Name | Columns | Description
PK_Eftps_Transaction$bank_transaction_KEY | bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Eftps_Transaction__Record_Status__record_status_KEY | record_status_KEY | Record_Status (record_status_KEY) |
FK_Eftps_Transaction__Vendor_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Vendor_Bank_Transaction (bank_transaction_KEY) |