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