| dicmd_id | int(11) | NO | | PRI | auto_increment | Primary key |
| dicmd_cus_id | int(11) | NO | | MUL | | Customer ID for the import file |
| dicmd_cli_id | int(11) | NO | | MUL | | Client ID for the import file |
| dicmd_upload_usr_id | int(11) | NO | | MUL | | User that uploaded the file |
| dicmd_upload_date | timestamp | YES | CURRENT_TIMESTAMP | | | Date/time the file was uploaded and db record created |
| dicmd_dirt_id | int(11) | NO | | MUL | | Foreign key |
| dicmd_status | int(11) | NO | | | | The current status of the uploaded file |
| dicmd_file_name | text | YES | | | | Name of the uploaded file |
| dicmd_path | text | YES | | | | Absolute path of the uploaded file |
| dicmd_val_missing_fields | text | YES | | | | Report of fields in template but not in data file |
| dicmd_val_not_supported_fields | text | YES | | | | Report of fields in data file not supported by the template |
| dicmd_import_usr_id | int(11) | YES | | MUL | | User that executed the import |
| dicmd_import_start | timestamp | YES | | | | Date/time the import was initiated |
| dicmd_import_end | timestamp | YES | | | | Date/time the import completed |
| dicmd_comments | text | YES | | | | Generic field used for any additional information |
| dicmd_records_csv | int(11) | YES | | | | The number of records in the uploaded file available for import |
| dicmd_records_imported | int(11) | YES | | | | The number of records actually imported |
| dicmd_csv_line_last_processed | int(11) | YES | | | | The last line of the CSV file that was processed. Used in case import process stops before completion |