This table contains file formats for text files. These text files are used to export data out of the database. For example, Positive Pay type text file formats are used to export bank transaction information to financial institutions that support it. |
export_text_file_format_KEY | int (4) | NOT NULL | The primary key for this table. |
description | nvarchar (100) | NOT NULL | A description of what this text file format is used for. |
record_length | int (4) | NOT NULL | Record length if a fixed length. If variable length then equals zero. |
field_delimiter | nvarchar (10) | NOT NULL | If variable length record then the field delimiter must be entered; otherwise it is set to the empty string for fixed length records. |
record_delimiter | nvarchar (10) | NOT NULL | If variable length record the record delimiter must be entered; otherwise it is set to the empty string for fixed length records. |
export_text_file_format_type_KEY | int (4) | NOT NULL | Type of format this is: Positive Pay, 401K, etc. |