Import/export template > Module Common Data > Import/export template SAEMP3 (SA employee) 

Use this template to extract employee accounting details. You can use it to import employee data from any third party payroll product into Sage X3 and to export from Sage X3.
Imported data is converted into the right format to populate accounting and dimension information fields on the Acct tab of the Employee record (function Employees (GESEML)).
 Multiple database tables are associated with each individual Sage X3 employee record and their associated contract of employment record. You must, therefore, run each of the following import/export templates in addition to this template to ensure the respective employee database tables are populated:
  • SAEMP1 - Republic of South Africa employee personal details
  • SAEMP2 - Republic of South Africa employee administrative details
  • SAEMP4 - Republic of South Africa employee payment methods
  • SAEMPCTR1 - Republic of South Africa employee contract details
  • SAEMPCTR3 - Republic of South Africa employee contract accounting details
  • SAEMPCTRSA - Republic of South Africa employee tax details
  • SAEMPSA - Republic of South Africa employee personal identity details
  • SAEMPCTR - Republic of South Africa employee contract details validation – you must run this template last
 You must validate your data after importing data from any third party payroll product into Sage X3. See SAEMPCTR - Republic of South Africa employee contract details validation for further information.

Prerequisites

The Employee ID must exist in data to be imported.

Mandatory fields in the template

The mandatory fields are as follows:

  • Employee ID

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

EMPLOCPT [CPT]

Accounting information