Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FileID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each EDI response file |
|
| FileName | varchar | 500 | √ | null |
|
|
File name - Name of the EDI response file as stored in the system |
|
| OriginalFileName | varchar | 500 | √ | null |
|
|
Original file name - Original name of the file when uploaded |
|
| Description | varchar | 2147483647 | √ | null |
|
|
File description - Description of the EDI response file contents and purpose |
|
| Status | varchar | 20 | √ | null |
|
|
Processing status - Current processing status of the EDI file (Pending, Processed, Error, etc.) |
|
| FileType | varchar | 50 | √ | null |
|
|
File type - Type of EDI file (835, 837, 999, etc.) |
|
| UploadedDate | datetime | 16,3 | √ | null |
|
|
Upload date - Date when the EDI file was uploaded to the system |
|
| UploadedBy | int | 4 | √ | null |
|
|
Uploaded by user - UserID of the person who uploaded the file |
|
| IsTemp | bit | 1 | √ | null |
|
|
Temporary flag - Boolean indicating if this is a temporary file |
|
| ResponseStatus | varchar | 100 | √ | null |
|
|
Response status - Status of the EDI response processing |
|
| ResponseError | varchar | 2147483647 | √ | null |
|
|
Response error - Error messages or details if processing failed |
Relationships
Close relationships within degrees of separation
