Table: dbo.Export_Text_File_Format_Row_Definition
This table contains row definitions for a given text file format. Each text file format can have one or more row definitions. For example, a definition that defines the format of rows in the header section of the file and a definition that defines the format of rows in the detail section of the file.
Columns
NameTypeConstraintsDescription
export_text_file_format_row_definition_KEYint (4)NOT NULLThe primary key for this table.
export_text_file_format_KEYint (4)NOT NULLForeign key to the text file format that this row definition belongs to.
sequence_numberint (4)NOT NULLThe order these rows appear in the text file.
codenvarchar (20)NOT NULLThe code to identify rows of this type in the actual export text file. For example, 'T' for transaction or 'H' for header row. If set to the empty string, then no code is needed in the file.
descriptionnvarchar (100)NOT NULLDescription of this row definition. For example, 'Detail' or 'Header'.
Primary key
NameColumnsDescription
PK_Export_Text_File_Format_Row_Definitionexport_text_file_format_row_definition_KEY
Unique constraints
NameColumnsDescription
UK_Export_Text_File_Format_Row_Definition$export_text_file_format_KEY$descriptionexport_text_file_format_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Export_Text_File_Format_Row_Definition__Export_Text_File_Format__export_text_file_format_KEYexport_text_file_format_KEYExport_Text_File_Format (export_text_file_format_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
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_Column_Definition

Schema diagram