Import/export template > Module Common Data > Import/export template EVSIMPLIF (Import CUN complet articl)
Import CUN complet articl
"Simplified" EV file format.
Simplified individual event file format with the employee ID as identifier.
This format is compatible with Sage's current Payroll versions.It is used to import absence events.
Mandatory fields in the template
The mandatory fields are the employee ID, the event code, the start and end dates and time.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Event nature does not exist
Code not defined in the event nature table. There also could be an error in the transcoding table, or the event may need to be created.
Incorrect date
The date is not formatted correctly.
Time already entered for this period
The template does not authorize the update or the event creation date is not specified and the import contains an event already existing in the database for the employee ID and the line date of the file being imported.
Employee not present on this day
The date of the event to import is not valid because the employee is not declared for this date according to the arrival/departure tab of the employee's record.
Tables used
This template can be used in import and export modes. The data is updated in the following tables :
Table | Table description |
|---|---|
ACCES [ACC] | Access by user |
ATEXTRA [AXX] | Texts to translate |
BOM [BOH] | Header BOMS |
BOMD [BOD] | Detail BOMs |
FACILITY [FCY] | |
ITMBOM [ITB] | Products - BOMs |
ITMCATEG [ITG] | |
ITMFACILIT [ITF] | |
ITMMASTER [ITM] | |
TABBOMALT [TBO] |