Entity IntercorpTMSExport

Description of Entity IntercorpTMSExport

The Intercorp Solutions export requires additional set up, however it is usually a one-time configuration and depending on your point of view, may be more convenient. Set the export to run at a specific time using the Windows Task Scheduler. Part of Sage EasyPay will extract the required data and put these into 2 special table within Sage EasyPay. From there, use the import function from within Intercorp AMS.


List of all Dependencies of the Entity IntercorpTMSExport

Name

Code

Class Name

Relation_1535746

Relation_1535746

Reference


List of Attributes of the Entity IntercorpTMSExport

Name

Code

Inter TMS Export ID

InterTMSExportId

Description

InterTMSExportDesc

Inter Staff No Mapping

InterStaffNoMapping

Inter SocNo Mapping

InterSocNoMapping

Inter Soc Exp Date Mapping

InterSocExpDateMapping

InterNationalityMapping

InterNationalityMapping

InterDeptMapping

InterDeptMapping

InterCompanyCode

InterCompanyCode

Purge Leave Details Dated __ Days Behind

InterNoOfDaysToPurge

Exclude selected employees

InterExcludeSelEmp


Entity Attribute Inter TMS Export ID of the Entity IntercorpTMSExport

Card of Attribute Inter TMS Export ID of the Entity IntercorpTMSExport

Name

Inter TMS Export ID

Code

InterTMSExportId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Inter TMS Export ID of the Entity IntercorpTMSExport

Shows the identity for the TMS Export. It is the primary key for the IntercorpTMSExport table.


Entity Attribute Description of the Entity IntercorpTMSExport

Card of Attribute Description of the Entity IntercorpTMSExport

Name

Description

Code

InterTMSExportDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity IntercorpTMSExport

Stores a description about the TMS export.


Entity Attribute Inter Staff No Mapping of the Entity IntercorpTMSExport

Card of Attribute Inter Staff No Mapping of the Entity IntercorpTMSExport

Name

Inter Staff No Mapping

Code

InterStaffNoMapping

Data Type

char(20)

Mandatory

No


Description of Attribute Inter Staff No Mapping of the Entity IntercorpTMSExport

Shows the mapping for the staff number.


Entity Attribute Inter SocNo Mapping of the Entity IntercorpTMSExport

Card of Attribute Inter SocNo Mapping of the Entity IntercorpTMSExport

Name

Inter SocNo Mapping

Code

InterSocNoMapping

Data Type

char(20)

Mandatory

No


Description of Attribute Inter SocNo Mapping of the Entity IntercorpTMSExport

Shows the mapping for the social number.


Entity Attribute Inter Soc Exp Date Mapping of the Entity IntercorpTMSExport

Card of Attribute Inter Soc Exp Date Mapping of the Entity IntercorpTMSExport

Name

Inter Soc Exp Date Mapping

Code

InterSocExpDateMapping

Data Type

char(20)

Mandatory

No


Description of Attribute Inter Soc Exp Date Mapping of the Entity IntercorpTMSExport

Shows the mapping for the social expiry date.
It is usually in the format: DD-MM-YYYY.


Entity Attribute InterNationalityMapping of the Entity IntercorpTMSExport

Card of Attribute InterNationalityMapping of the Entity IntercorpTMSExport

Name

InterNationalityMapping

Code

InterNationalityMapping

Data Type

char(20)

Mandatory

No


Description of Attribute InterNationalityMapping of the Entity IntercorpTMSExport

Shows the mapping for the nationality.


Entity Attribute InterDeptMapping of the Entity IntercorpTMSExport

Card of Attribute InterDeptMapping of the Entity IntercorpTMSExport

Name

InterDeptMapping

Code

InterDeptMapping

Data Type

char(20)

Mandatory

No


Description of Attribute InterDeptMapping of the Entity IntercorpTMSExport

Shows the mapping for the department.


Entity Attribute InterCompanyCode of the Entity IntercorpTMSExport

Card of Attribute InterCompanyCode of the Entity IntercorpTMSExport

Name

InterCompanyCode

Code

InterCompanyCode

Data Type

char(50)

Mandatory

No


Description of Attribute InterCompanyCode of the Entity IntercorpTMSExport

Shows the company code for the TMS export.


Entity Attribute Purge Leave Details Dated __ Days Behind of the Entity IntercorpTMSExport

Card of Attribute Purge Leave Details Dated __ Days Behind of the Entity IntercorpTMSExport

Name

Purge Leave Details Dated __ Days Behind

Code

InterNoOfDaysToPurge

Data Type

integer

Mandatory

No


Description of Attribute Purge Leave Details Dated __ Days Behind of the Entity IntercorpTMSExport

Shows the number of days the purge leave is behind.


Entity Attribute Exclude selected employees of the Entity IntercorpTMSExport

Card of Attribute Exclude selected employees of the Entity IntercorpTMSExport

Name

Exclude selected employees

Code

InterExcludeSelEmp

Data Type

smallint

Mandatory

No


Description of Attribute Exclude selected employees of the Entity IntercorpTMSExport

Indicates if the user wants to exclude the existing employees, in a form of a checkbox.