Table: dbo.Export_Text_File_Format_Column_Definition
This table contains column definitions for a given row in a text file format. Each text file format row definition can have one or more columns defined.
Columns
Name | Type | Constraints | Description
export_text_file_format_column_definition_KEY | int (4) | NOT NULL | Primary key for this table.
export_text_file_format_row_definition_KEY | int (4) | NOT NULL | What kind of row definition does this column belong to - header, detail, total, etc?
sequence_number | int (4) | NOT NULL | The order these columns appear in a row in the text file.
field_length | int (4) | NOT NULL | For fixed length formats, this is the size of the column. For variable length formats, this is zero.
field_description | nvarchar (100) | NOT NULL | Description from the receiving institution's specs. Example: "Issue Dater" for the check date
date_format | nvarchar (24) | NOT NULL | For date fields what should the format of the date be. Example: "mmDDYY"
standard_type_code | nchar (20) | NOT NULL | The code to send in a 'record type' column for a normal transaction.
voided_type_code | nchar (20) | NOT NULL | The code to send in a 'record type' column for a voided transaction. For example, 'V'.
export_text_file_format_export_data_KEY | int (4) | NOT NULL | The particular piece of data being exported from our database.

Primary key
Name | Columns | Description
PK_Export_Text_File_Format_Column_Definition | export_text_file_format_column_definition_KEY |
Unique constraints
Name | Columns | Description
UK_Export_Text_File_Format_Column_Definition$export_text_file_format_row_definition_KEY$field_description | export_text_file_format_row_definition_KEY, field_description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Export_Text_File_Format_Column_Definition__Export_Text_File_Format_Export_Data__export_text_file_format_export_data_KEY | export_text_file_format_export_data_KEY | Export_Text_File_Format_Export_Data (export_text_file_format_export_data_KEY) |
FK_Export_Text_File_Format_Column_Definition__Export_Text_File_Format_Row_Definition__export_text_file_format_row_definition_KEY | export_text_file_format_row_definition_KEY | Export_Text_File_Format_Row_Definition (export_text_file_format_row_definition_KEY) |