| 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) | |