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
Name | Type | Constraints | Description
export_text_file_format_KEY | int (4) | NOT NULL | The primary key for this table.
description | nvarchar (100) | NOT NULL | A description of what this text file format is used for.
record_length | int (4) | NOT NULL | Record length if a fixed length. If variable length then equals zero.
field_delimiter | nvarchar (10) | NOT NULL | If variable length record then the field delimiter must be entered; otherwise it is set to the empty string for fixed length records.
record_delimiter | nvarchar (10) | NOT NULL | If 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_KEY | int (4) | NOT NULL | Type of format this is: Positive Pay, 401K, etc.

Primary key
Name | Columns | Description
PK_Export_Text_File_Format | export_text_file_format_KEY |
Unique constraints
Name | Columns | Description
UK_Export_Text_File_Format$description$export_text_file_format_type_KEY | description, export_text_file_format_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Export_Text_File_Format__Export_Text_File_Format_Type__export_text_file_format_type_KEY | export_text_file_format_type_KEY | Export_Text_File_Format_Type (export_text_file_format_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Export_Text_File_Format_Row_Definition__Export_Text_File_Format__export_text_file_format_KEY | export_text_file_format_KEY | Export_Text_File_Format_Row_Definition |
FK_Checkbook__Export_Text_File_Format__positive_pay__export_text_file_format_KEY | positive_pay__export_text_file_format_KEY | Checkbook |