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
Name | Type | Constraints | Description
export_text_file_format_row_definition_KEY | int (4) | NOT NULL | The primary key for this table.
export_text_file_format_KEY | int (4) | NOT NULL | Foreign key to the text file format that this row definition belongs to.
sequence_number | int (4) | NOT NULL | The order these rows appear in the text file.
code | nvarchar (20) | NOT NULL | The 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.
description | nvarchar (100) | NOT NULL | Description of this row definition. For example, 'Detail' or 'Header'.

Primary key
Name | Columns | Description
PK_Export_Text_File_Format_Row_Definition | export_text_file_format_row_definition_KEY |
Unique constraints
Name | Columns | Description
UK_Export_Text_File_Format_Row_Definition$export_text_file_format_KEY$description | export_text_file_format_KEY, description |

Foreign keys
Name | Columns | Referenced 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 (export_text_file_format_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
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_Column_Definition |