Table: dbo.Positive_Pay_File
This table tracks each positive pay export file created by our program.
Columns
NameTypeConstraintsDescription
positive_pay_file_KEYint (4)NOT NULLThe primary key for this table.
client_KEYint (4)NOT NULLClient this file was created for. Initially it will be the firm client since only impound checkbooks will be allowed to create positive pay files.
creation_datedatetime (8, 3)NOT NULLDate and time that the positive pay file was created.
file_namenvarchar (120)NOT NULLFile name used for this positive pay file.
Primary key
NameColumnsDescription
PK_Positive_Pay_Filepositive_pay_file_KEY
Unique constraints
NameColumnsDescription
UK_Positive_Pay_File$client_KEY$creation_date$file_nameclient_KEY, creation_date, file_name
Foreign keys
NameColumnsReferenced tableDescription
FK_Positive_Pay_File__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Positive_Pay_File_Detail__Positive_Pay_File__positive_pay_file_KEYpositive_pay_file_KEYPositive_Pay_File_Detail

Schema diagram