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
NameTypeConstraintsDescription
export_text_file_format_column_definition_KEYint (4)NOT NULLPrimary key for this table.
export_text_file_format_row_definition_KEYint (4)NOT NULLWhat kind of row definition does this column belong to - header, detail, total, etc?
sequence_numberint (4)NOT NULLThe order these columns appear in a row in the text file.
field_lengthint (4)NOT NULLFor fixed length formats, this is the size of the column. For variable length formats, this is zero.
field_descriptionnvarchar (100)NOT NULLDescription from the receiving institution's specs. Example: "Issue Dater" for the check date
date_formatnvarchar (24)NOT NULLFor date fields what should the format of the date be. Example: "mmDDYY"
standard_type_codenchar (20)NOT NULLThe code to send in a 'record type' column for a normal transaction.
voided_type_codenchar (20)NOT NULLThe code to send in a 'record type' column for a voided transaction. For example, 'V'.
export_text_file_format_export_data_KEYint (4)NOT NULLThe particular piece of data being exported from our database.
Primary key
NameColumnsDescription
PK_Export_Text_File_Format_Column_Definitionexport_text_file_format_column_definition_KEY
Unique constraints
NameColumnsDescription
UK_Export_Text_File_Format_Column_Definition$export_text_file_format_row_definition_KEY$field_descriptionexport_text_file_format_row_definition_KEY, field_description
Foreign keys
NameColumnsReferenced tableDescription
FK_Export_Text_File_Format_Column_Definition__Export_Text_File_Format_Export_Data__export_text_file_format_export_data_KEYexport_text_file_format_export_data_KEYExport_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_KEYexport_text_file_format_row_definition_KEYExport_Text_File_Format_Row_Definition (export_text_file_format_row_definition_KEY)

Schema diagram