Table: dbo.Export_Text_File_Format
This table contains file formats for text files. These text files are used to export data out of the database. For example, Positive Pay type text file formats are used to export bank transaction information to financial institutions that support it.
Columns
NameTypeConstraintsDescription
export_text_file_format_KEYint (4)NOT NULLThe primary key for this table.
descriptionnvarchar (100)NOT NULLA description of what this text file format is used for.
record_lengthint (4)NOT NULLRecord length if a fixed length. If variable length then equals zero.
field_delimiternvarchar (10)NOT NULLIf variable length record then the field delimiter must be entered; otherwise it is set to the empty string for fixed length records.
record_delimiternvarchar (10)NOT NULLIf variable length record the record delimiter must be entered; otherwise it is set to the empty string for fixed length records.
export_text_file_format_type_KEYint (4)NOT NULLType of format this is: Positive Pay, 401K, etc.
Primary key
NameColumnsDescription
PK_Export_Text_File_Formatexport_text_file_format_KEY
Unique constraints
NameColumnsDescription
UK_Export_Text_File_Format$description$export_text_file_format_type_KEYdescription, export_text_file_format_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Export_Text_File_Format__Export_Text_File_Format_Type__export_text_file_format_type_KEYexport_text_file_format_type_KEYExport_Text_File_Format_Type (export_text_file_format_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Export_Text_File_Format_Row_Definition__Export_Text_File_Format__export_text_file_format_KEYexport_text_file_format_KEYExport_Text_File_Format_Row_Definition
FK_Checkbook__Export_Text_File_Format__positive_pay__export_text_file_format_KEYpositive_pay__export_text_file_format_KEYCheckbook

Schema diagram