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. |
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. |