Stores file logs for later bulk upload via asynchronous task
Data model
Fields
| Field |
Type |
Description |
| date_register* |
DATETIME |
Date on which the import file is registered in the system for further processing of information |
| error_quantity |
INT |
Number of failed processed records |
| file_name |
NVARCHAR (400) |
File name that contains the records to be imported |
| id* |
INT |
Unique Import Identifier |
| id_parent |
INT |
Unique identifier of the retried primary import |
| line_quantity |
INT |
Number of records processed per file |
| state_id |
INT |
Field for State Association Record: 1: Pending, 2: InProcess, 3: Processed, 4: Error |
| success_quantity |
INT |
Number of records successfully processed |
| type_id |
INT |
File Type Association Record Field: 1: Clients, 2: WorkOrders, 3: Movements |
Primary Key
| PK_AFLS_IMPORT_FILE_PROCESS |
| id |
References
