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 |