Table: dbo.Eftps_Transaction
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLPrimary key - points to related vendor check.
is_processedbit (1)NOT NULLFlag indicating transaction has been processed to EFPTS file.
processed_datesmalldatetime (4)Date transaction was processed to EFPTS file
physical_file_namenvarchar (510)NOT NULLName of physical file containing transaction information.
record_status_KEYint (4)NOT NULLThe status of the EFTPS transaction record.
settlement_datesmalldatetime (4)Settlement date for the eftps transaction.
Primary key
NameColumnsDescription
PK_Eftps_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Eftps_Transaction__Record_Status__record_status_KEYrecord_status_KEYRecord_Status (record_status_KEY)
FK_Eftps_Transaction__Vendor_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYVendor_Bank_Transaction (bank_transaction_KEY)

Schema diagram