Export (0) Print
Expand All
Expand Minimize

EmplTable Table

The EmplTable table contains records for employees that are used with HRM and Payroll tables. The fields in this table are dedicated to employee details.

ID: 103

Security Key: BasicTables

Method

Description

address

Age

Calculates age from birth date and current date.

alias

aosValidateDelete

(Inherited from xRecord.)

aosValidateInsert

(Inherited from xRecord.)

aosValidateRead

(Inherited from xRecord.)

aosValidateUpdate

(Inherited from xRecord.)

axEmplTable

Create new AxEmplTable from current record.

cancelTimeOut

Cancels a previous method call to the Object::setTimeOut Method. (Inherited from Object.)

caption

(Inherited from xRecord.)

cellularPhone

checkRecord

(Inherited from xRecord.)

checkRestrictedDeleteActions

(Inherited from xRecord.)

clear

(Inherited from xRecord.)

clearOutlookFolders

Clear outlook folder values (calendar folder, contact folder and task folder).

communicationValue

company

(Inherited from xRecord.)

concurrencyModel

(Inherited from xRecord.)

context

(Inherited from xRecord.)

data

(Inherited from xRecord.)

dataSource

(Inherited from xRecord.)

dbOpInTransaction

(Inherited from xRecord.)

delete

Delete record. Corresponding record in HRMVirtualNetworkTable is also deleted. Additionally several delete actions exists.

DirPartyTable

disableCache

(Inherited from xRecord.)

doClear

(Inherited from xRecord.)

doDelete

(Inherited from xRecord.)

doInsert

(Inherited from xRecord.)

doUpdate

(Inherited from xRecord.)

doValidateDelete

(Inherited from xRecord.)

email

employmentStatus

Returns employment status using HRMVirtualNetworkTable.

equal

(Inherited from xRecord.)

executeCachedDisplayMethods

(Inherited from xRecord.)

getPartyAddress

getPresenceFieldData

(Inherited from xRecord.)

getTimeOutTimerHandle

Returns the timer handle for the object. (Inherited from Object.)

handle

Retrieves the handle of the class of the object. (Inherited from Object.)

helpField

(Inherited from xRecord.)

HRMPartyEmployeeRelationship

image

Returns reference to employee image. Macro resAppl is used.

initFromDirParty

initValue

Sets initial values and validates that employee category and project employee are set to Yes.

insert

Insert new record in table. HRMVirtualNetworkTable is also updated.

isFormDataSource

(Inherited from xRecord.)

isTmp

(Inherited from xRecord.)

joinChild

(Inherited from xRecord.)

joinParent

(Inherited from xRecord.)

merge

(Inherited from xRecord.)

modifiedField

name

new

Initializes a new instance of the Object class.. (Inherited from Object.)

notify

Releases the hold on an object that has called a wait method on this object. (Inherited from Object.)

notifyAll

Releases a lock on the object that was issued by a wait method on this object. (Inherited from Object.)

numberOfWorkDays

Find number of days were the employee works. This is done by finding days in field WorkingHours (an array), where hours larger than zero.

objectOnServer

Determines whether the object is on a server. (Inherited from Object.)

orig

(Inherited from xRecord.)

overwriteSystemfields

(Inherited from xRecord.)

owner

Returns the instance that owns the object. (Inherited from Object.)

pager

Phone

phoneLocal

phoneOther

postLoad

(Inherited from xRecord.)

primaryAddress

queryTimedOut

(Inherited from xRecord.)

queryTimeout

(Inherited from xRecord.)

readPast

(Inherited from xRecord.)

recordLevelSecurity

(Inherited from xRecord.)

renamePrimaryKey

Called when primary key is renamed. It also updates primary key for Shop Floor Control table JMGEmployee.

reread

(Inherited from xRecord.)

RowCount

(Inherited from xRecord.)

selectForUpdate

(Inherited from xRecord.)

selectLocked

(Inherited from xRecord.)

selectRefRecord

(Inherited from xRecord.)

selectWithRepeatableRead

(Inherited from xRecord.)

setConnection

(Inherited from xRecord.)

setTimeOut

Sets up the scheduled execution of a specified method. (Inherited from Object.)

setTmp

(Inherited from xRecord.)

setTmpData

(Inherited from xRecord.)

showPartyMatchIcon

skipAosValidation

(Inherited from xRecord.)

skipDatabaseLog

(Inherited from xRecord.)

skipDataMethods

(Inherited from xRecord.)

skipDeleteActions

(Inherited from xRecord.)

skipDeleteMethod

(Inherited from xRecord.)

skipEvents

Provides an option to turn off calling the Application.event* methods for the life time of the xRecord instance. (Inherited from xRecord.)

skipTTSCheck

(Inherited from xRecord.)

SMS

suppressWarnings

(Inherited from xRecord.)

telefax

telex

toolTipField

(Inherited from xRecord.)

toolTipRecord

(Inherited from xRecord.)

toString

Returns a string that represents the current object. (Inherited from Object.)

ttsabort

(Inherited from xRecord.)

ttsbegin

(Inherited from xRecord.)

ttscommit

(Inherited from xRecord.)

update

updateBySyncService

url

usageCount

(Inherited from xRecord.)

validateDelete

Validate that delete is possible.

validateDirPartyName

Validates the Name that is related to the PartyId associated with the employee.

ValidateField

Determines whether the p1 field is valid.

validateIfTerminatedAllowed

validateProjServerProperties

validateUniquePartyId

Validates that the PartyId related to an employee is unique.

validateWrite

Validates whether a write to the table is possible.

virtualNetworkId

Get the virtual network id. Returns value of HRMVirtualNetworkTable::findTypeReference Method.

wait

Pauses a process. (Inherited from Object.)

wasCached

(Inherited from xRecord.)

write

Called when write to table is performed. Clears the email cache.

xml

(Inherited from xRecord.)

::capacity

Find capacity for an employee within a specified period. The capacity is returned by summing up hours in WorkCalendarDateLine in the period.

If period dates not specified, the default period is current date and 50 days forward.

::checkExist

Check if employee exists.

::createCategoryConnection

::createProjConnection

::emplId2Name

::exist

Check if employee exists.

::find

Find EmplTable record from employee ID.

::findByPartyId

::lookupEmplId

::lookupEmployee

::periodHourRegistration

Returns sum of registered hours in ProjEmplTrans Table for the specified employee, within the specified period.

::txtNotExist

Returns label ID for error message, to use when employee does not exist.

::userId2EmplId

Get employee ID from user ID.

::userId2PBAUserProfile

Gets a product builder user profile from a user ID.

Field

ID

Type

Configuration key

Description

EmplId

1

Extended Data Type: EmplId

Type: str

None

Employee number.

DEL_Name

2

Extended Data Type: EmplName

Type: str

SysDeletedObjects41

Name of employee.

Dimension

3

Extended Data Type: Dimension

Type: str

None

Department number.

Training

4

Extended Data Type: Training

Type: str

None

Employee's education.

DEL_Address

5

Extended Data Type: Addressing

Type: str

SysDeletedObjects41

Home address.

DEL_Phone

6

Extended Data Type: Phone

Type: str

SysDeletedObjects41

Home phone number.

DEL_PhoneLocal

7

Extended Data Type: PhoneLocal

Type: str

SysDeletedObjects41

Employee's extension at work.

DEL_SyncOutlookAtStartup

8

Extended Data Type: DEL_smmSyncAtStartup

Type: NoYes

SysDeletedObjects40

Start synchronization automatically with Microsoft Dynamics startup.

OutlookCalendarOutlookStoreID

9

Extended Data Type: smmCalendarOutlookStoreID

Type: str

SmmCRM

Store ID for the Microsoft Office Outlook calendar folder used for synchronization

OutlookCalendarOutlookEntryID

10

Extended Data Type: smmCalendarOutlookEntryID

Type: str

SmmCRM

Entry ID for the Microsoft Office Outlook calendar folder used for synchronization

OutlookTaskOutlookStoreID

11

Extended Data Type: smmTaskOutlookStoreID

Type: str

None

Store ID for the Microsoft Office Outlook task folder used for synchronization

DEL_UserId

12

System Data Type: userId

Type: str

SysDeletedObjects40

Specification of employee's user name.

AltNum

13

Extended Data Type: EmplAltNum

Type: str

None

Alternative number to be used for searches, etc.

DEL_ZipCodeId

14

Extended Data Type: AddressZipCodeId

Type: str

SysDeletedObjects41

Identify ZIP/postal Code district.

DEL_CountryRegionId

15

Extended Data Type: AddressCountryRegionId

Type: str

SysDeletedObjects41

Specifies default native country/region in connection with addresses.

DEL_StateId

16

Extended Data Type: AddressStateId

Type: str

SysDeletedObjects41

Identification of state.

DEL_CountyId

17

Extended Data Type: AddressCountyId

Type: str

SysDeletedObjects41

Specifies a county within a state in the current country/region.

DEL_URL

18

Extended Data Type: URL

Type: str

SysDeletedObjects41

Employee WWW address.

DEL_Email

19

Extended Data Type: Email

Type: str

SysDeletedObjects41

Employee e-mail address.

DEL_Telex

20

Extended Data Type: Telex

Type: str

SysDeletedObjects41

Employee telex number.

DEL_CellularPhone

21

Extended Data Type: PhoneMobile

Type: str

SysDeletedObjects41

Employee mobile phone number.

DEL_TeleFax

22

Extended Data Type: TeleFax

Type: str

SysDeletedObjects41

Employee fax number

CalendarId

23

Extended Data Type: CalendarId

Type: str

None

Identification of calendar.

BirthDate

24

Extended Data Type: BirthDate

Type: date

None

Employee's birth date.

DEL_Alias

25

Extended Data Type: EmplAlias

Type: str

SysDeletedObjects41

Employee alias.

ProjPeriodId

26

Extended Data Type: ProjPeriodId

Type: str

ProjBasicHour

Period code that is used as a reference.

ItemBuyerGroupId

27

Extended Data Type: ItemBuyerGroupId

Type: str

LogisticsBasic

Identification of the buyer group.

OutlookTaskOutlookEntryID

28

Extended Data Type: smmTaskOutlookEntryID

Type: str

None

Entry ID for the Microsoft Office Outlook task folder used for synchronization

OutlookTaskFolderName

29

Extended Data Type: smmOutlookTaskFolderName

Type: str

None

Name of the Microsoft Office Outlook task folder used for synchronization

DEL_City

30

Extended Data Type: AddressCity

Type: str

SysDeletedObjects41

City for ZIP/postal Code.

DEL_Street

31

Extended Data Type: AddressStreet

Type: str

SysDeletedObjects41

Enter the street name of the address.

DEL_Pager

32

Extended Data Type: Pager

Type: str

SysDeletedObjects41

Number of pager.

DEL_SMS

33

Extended Data Type: SMS

Type: str

SysDeletedObjects41

E-mail address for sending SMS to a mobile phone.

Title

34

Extended Data Type: PersonTitle

Type: str

None

Job title

OutlookCalendarFolderName

35

Extended Data Type: smmOutlookCalendarFolderName

Type: str

None

Name of the Microsoft Office Outlook calendar folder used for synchronization

DEL_RefZipCode

36

Extended Data Type: RefRecId

Type: int64

SysDeletedObjects40

Reference field in a different table.

ValidateProjEmpl

37

Extended Data Type: ProjValidateOption

Type: NoYes

ProjBasic

Validate on this option.

ValidateEmplCategory

38

Extended Data Type: ProjValidateOption

Type: NoYes

ProjBasic

Validate on this option.

ActivityStartTime

39

Extended Data Type: smmActivityStartTime

Type: int

SmmCRM

Activity start time.

ActivityEndTime

40

Extended Data Type: smmActivityEndTime

Type: int

SmmCRM

End time for activity.

OutlookContactFolderEntryID

41

Extended Data Type: smmContactPersonOutlookEntryID

Type: str

None

Entry ID for the Microsoft Office Outlook contact folder used for synchronization.

OutlookContactFolderStoreID

42

Extended Data Type: smmContactPersonOutlookStoreID

Type: str

None

Store ID for the Microsoft Office Outlook contact folder used for synchronization

OutlookContactFolderName

43

Extended Data Type: smmOutlookContactFolderName

Type: str

None

Name of the Microsoft Office Outlook contact folder used for synchronization.

InclRecurringAppointments

44

Extended Data Type: smmInclRecurringAppointments

Type: NoYes

None

Include recurring appointments while doing synchronization with Microsoft Office Outlook.

OutlookUserEntryID

45

Extended Data Type: smmOutlookUserEntryID

Type: str

None

Entry ID for the Microsoft Office Outlook user ID used for synchronization.

InclPrivateAppointments

46

Extended Data Type: smmInclPrivateAppointments

Type: NoYes

None

Include private appointments while doing synchronization with Microsoft Office Outlook.

InclPrivateTasks

47

Extended Data Type: smmInclPrivateTasks

Type: NoYes

None

Include private tasks while doing synchronization with Microsoft Office Outlook.

PartyId

48

Extended Data Type: DirPartyId

Type: str

None

Address book identification

SyncTransIdCreate

50

Extended Data Type: SyncTransId

Type: guid

None

Unique identifier of an entity transaction

SyncEntityId

51

Extended Data Type: SyncEntityId

Type: guid

None

Unique identifier of an entity instance

SyncVersion

53

Extended Data Type: SyncVersion

Type: int64

None

Version of an entity. This is a sequential number

DEL_M1_Gender

56

Enumeration: Gender

SysDeletedObjects41

Actual employee

DEL_M1_DependentsNum

57

Extended Data Type: EmplDependentsNum

Type: int

SysDeletedObjects41

Employee's number of dependents

ReqSiteId

59

Extended Data Type: PurchReqSiteId

Type: str

PurchReq

Select a default site

DEL_M1_MaritalStatus

60

Enumeration: EmplMaritalStatus

SysDeletedObjects41

Actual employee

ReqLocationId

61

Extended Data Type: PurchReqLocationId

Type: str

PurchReq

Select a default warehouse

DEL_M1_AdjustedStartDate

62

Extended Data Type: EmplAdjustedStartDate

Type: date

SysDeletedObjects41

Actual employee

DEL_M1_StartDate

63

Extended Data Type: EmplStartDate

Type: date

SysDeletedObjects41

Actual employee

DEL_M1_LastDateWorked

64

Extended Data Type: EmplLastDateWorked

Type: date

SysDeletedObjects41

Actual employee

DEL_M1_TerminationDate

65

Extended Data Type: EmplTerminationDate

Type: date

SysDeletedObjects41

Actual employee

DEL_M1_Citizenship

66

Extended Data Type: AddressCountryRegionId

Type: str

SysDeletedObjects41

Actual employee

DEL_M1_EEOMultiRace

67

Extended Data Type: EmplEEOMultiRace

Type: EmplBoolean

SysDeletedObjects41

Actual employee

DEL_M1_EEORaceIntlCode

68

Extended Data Type: EmplEEORaceIntlCode

Type: EmplEEORaceIntlCodeValues

SysDeletedObjects41

Actual employee

DEL_M1_ActiveDate

69

Extended Data Type: EmplActiveDate

Type: date

SysDeletedObjects41

Actual employee

DEL_M1_ExpiryDate

70

Extended Data Type: EmplExpiryDate

Type: date

SysDeletedObjects41

Actual employee

DEL_M1_AccountType

71

Enumeration: LedgerJournalACType

SysDeletedObjects41

Actual employee

DEL_M1_AccountNumber

72

Extended Data Type: LedgerJournalAC

Type: str

SysDeletedObjects41

Actual employee

EmplIdentNumber

73

Extended Data Type: EmplNationalIDCode

Type: str

None

National ID for employee.

ReqAttention

74

Extended Data Type: PurchReqAttention

Type: str

PurchReq

Attention information for the purchase requisition

DispatchTeamId

77

Extended Data Type: SMADispatchTeamId

Type: str

None

Identification of the dispatch team.

DeceasedDate

78

Extended Data Type: DeceasedDate

Type: date

None

Employee's deceased date.

EmplGender

79

Enumeration: EmplGender

None

Employee's gender.

DEL_resignReasonCodeId

8001

Extended Data Type: HRMResignReasonCodeId

Type: str

SysDeletedObjects41

Reason for termination

DEL_seniorityDate

8003

Extended Data Type: TransDate

Type: date

SysDeletedObjects41

Employee's seniority date

OutlookUserID

8006

Extended Data Type: smmOutlookUserId

Type: str

None

The Microsoft Office Outlook User ID for this employee

DEL_DateLastSyncWithOutlook

8007

Extended Data Type: DEL_smmDateofLastSyncWithPIM

Type: date

SysDeletedObjects40

Date of last synchronization. Initially set date for oldest appointment/task to synchronize

DEL_SyncInterval

8008

Extended Data Type: DEL_smmInterval4Sync2PIM

Type: int

SysDeletedObjects40

Normally no batch synchronization is recommended. Then set time interval to 0.

DEL_TimeLastSyncWithOutlook

8009

Extended Data Type: DEL_smmTimeofLastSyncWithPIM

Type: int

SysDeletedObjects40

Date of last synchronization

DEL_SyncWithOutlook

8012

Extended Data Type: DEL_smmSyncWithOutlook

Type: NoYes

SysDeletedObjects40

Determines whether Microsoft Office Outlook synchronization is performed.

ActivateAnswer

8014

Extended Data Type: smmActivateAnswer

Type: NoYes

smmPhone

Activates inbound call detection for the selected user.

DEL_hrmAbsenceSetupId

8015

Extended Data Type: HRMAbsenceSetupId

Type: str

SysDeletedObjects41

Set up absence.

DEL_absenceFromDate

8016

Extended Data Type: HRMAbsenceEmplFromDate

Type: date

SysDeletedObjects41

Date from which you want to record an absence for the employee.

DEL_workingHours

8017

Extended Data Type: HRMWorkingHours

Type: real

SysDeletedObjects41

Number of work hours.

DEL_probationDate

8018

Extended Data Type: BaseDate

Type: date

SysDeletedObjects41

Date of expiration for the trial period

DEL_employeeTerminationNoticeUnit

8019

Enumeration: HRMNoticeUnit

SysDeletedObjects41

Unit for employee's termination notice.

DEL_employerTerminationNoticeUnit

8020

Enumeration: HRMNoticeUnit

SysDeletedObjects41

Unit for employer's termination notice.

DEL_employerTerminationNotice

8021

Extended Data Type: HRMTerminationNotice

Type: int

SysDeletedObjects41

Employer's termination notice.

DEL_employeeTerminationNotice

8022

Extended Data Type: HRMTerminationNotice

Type: int

SysDeletedObjects41

Employee's termination notice.

DEL_pensionStartDateEmplContract

8024

Extended Data Type: StartDate

Type: date

SysDeletedObjects41

Date on which employee employed on a contract basis enters into an earnings-related pension scheme.

DEL_pensionStartDateEmpl

8025

Extended Data Type: StartDate

Type: date

SysDeletedObjects41

Mandatory pension plan enrollment date.

DEL_currency

8026

Extended Data Type: CurrencyCode

Type: str

SysDeletedObjects41

Current currency code.

DEL_hrmIncomeTaxCategoryId

8027

Extended Data Type: HRMIncomeTaxCategoryId

Type: str

SysDeletedObjects41

Income tax category for employee.

DEL_hrmIncomeTaxCodeId

8028

Extended Data Type: HRMIncomeTaxCodeId

Type: str

SysDeletedObjects41

Employee's income tax code.

DEL_employerSavingAmount

8029

Extended Data Type: HRMPayrollEmployerSavingsAmount

Type: real

SysDeletedObjects41

Employer's contribution to savings

DEL_employeeSavingAmount

8030

Extended Data Type: HRMPayrollEmployeeSavingsAmount

Type: real

SysDeletedObjects41

Employer's contribution to savings

DEL_holidays

8031

Extended Data Type: HRMHolidays

Type: real

SysDeletedObjects41

Number of vacation days for employee

DEL_vacationPayment

8032

Extended Data Type: HRMVacationPayment

Type: real

SysDeletedObjects41

Vacation pay amount

DEL_movingAllowanceAmount

8033

Extended Data Type: HRMMovingAllowance

Type: real

SysDeletedObjects41

Employer contribution to employee's moving expenses

DEL_firstName

8035

Extended Data Type: HRMFirstName

Type: str

SysDeletedObjects41

Specify first name of the person.

DEL_middleName

8036

Extended Data Type: HRMMiddleName

Type: str

SysDeletedObjects41

Specify middle name of the person.

DEL_lastName

8037

Extended Data Type: HRMLastName

Type: str

SysDeletedObjects41

Specify last name of the person.

DEL_salutation

8038

Enumeration: HRMSalutation

SysDeletedObjects41

Form of address

DEL_nameSuffix

8039

Enumeration: HRMNameSuffix

SysDeletedObjects41

Specify name suffix of the person.

DEL_internalExternal

8040

Enumeration: DEL_HRMEmployeeInternalExternal

SysDeletedObjects40

Specify employee type.

eMailSaveCopy

8041

Extended Data Type: smmEMailSaveCopy

Type: NoYes

None

Save a copy of e-mails which are sent to contacts.

status

8042

Enumeration: HRMEmplStatus

None

Employee status

PBAUserProfile

8043

Extended Data Type: PBAUserProfile

Type: str

PBA_ProductBuilder

User profile in the Product Builder

DEL_hrmUnionIdNegotiator

8044

Extended Data Type: HRMUnionIdNegotiator

Type: str

SysDeletedObjects41

Is the organization entitled to negotiate?

DEL_hrmUnionId

8045

Extended Data Type: HRMUnionIdOrganization

Type: str

SysDeletedObjects41

Unique identification of organization.

DEL_hrmSalaryType

8046

Enumeration: HRMSalaryType

SysDeletedObjects41

Unique identification of payroll type.

DEL_hrmSalaryScaleDate

8047

Extended Data Type: TransDate

Type: date

SysDeletedObjects41

Date of advancement to the next scale level.

DEL_hrmActiveInactive

8048

Enumeration: DEL_HRMActiveInactive

SysDeletedObjects40

Employee status

DEL_hrmMunicipalId

8049

Extended Data Type: HRMMunicipalId

Type: str

SysDeletedObjects41

Unique identification of county.

DEL_hrmVacationWithSalary

8050

Extended Data Type: NoYesId

Type: NoYes

SysDeletedObjects41

Specify eligibility for paid vacation.

DEL_hrmDaysOffWithSalary

8051

Extended Data Type: NoYesId

Type: NoYes

SysDeletedObjects41

Specify eligibility for additional paid vacation days.

DEL_hrmCareWithSalary

8052

Extended Data Type: NoYesId

Type: NoYes

SysDeletedObjects41

Specify eligibility for personal days.

DEL_hrmSalarySeniorityDate

8053

Extended Data Type: TransDate

Type: date

SysDeletedObjects41

Date of payroll seniority.

ActivityReminderMinutes

8054

Extended Data Type: smmActivityReminderMinutes

Type: int

None

Reminder minutes for external calendar tool.

smmSynchronizeDaysBack

8055

Extended Data Type: smmSynchronizeDayBack

Type: int

None

How many days before today's date should be synchronized to Microsoft Office Outlook.

smmSynchronizeDaysForward

8056

Extended Data Type: smmSynchronizeDaysForward

Type: int

None

How many days after today's date should be synchronized to Microsoft Office Outlook.

DEL_hrmEmployeeType

8057

Enumeration: HRMEmployeeType

SysDeletedObjects41

Specify employee type.

DEL_vendAccount

8058

Extended Data Type: VendAccount

Type: str

SysDeletedObjects41

Vendor account number.

dataAreaId

61448

System Data Type: dataAreaId

Type: str

None

recVersion

61450

System Data Type: recVersion

Type: int

None

RecId

65534

System Data Type: recId

Type: int64

None

Field Group

Fields

AbsenceRegistration

ActivityDefaultTime

ActivityStartTime

ActivityEndTime

ActivityOptions

ActivityReminderMinutes

Address

AddressDisplay

Administration

AltNum

Training

PBAUserProfile

AutoLookup

EmplId

name

AutoReport

EmplId

AltNum

Calendar

CalendarId

ContactInfo

Currency

Dimension

Dimension

Dimension

Dimension

DispatchTeam

DispatchTeamId

EPOverview

EmplId

BirthDate

Identification

EmplId

EmplIdentNumber

PartyId

status

IncomeTax

Integration

SyncVersion

SyncTransIdCreate

SyncEntityId

M1

DEL_M1_Gender

DEL_M1_DependentsNum

DEL_M1_MaritalStatus

DEL_M1_AdjustedStartDate

DEL_M1_StartDate

DEL_M1_LastDateWorked

DEL_M1_TerminationDate

DEL_M1_Citizenship

DEL_M1_EEOMultiRace

DEL_M1_EEORaceIntlCode

DEL_M1_ActiveDate

DEL_M1_ExpiryDate

DEL_M1_AccountType

DEL_M1_AccountNumber

Municipal

Name

NameDetails

OutlookFolders

OutlookContactFolderName

OutlookContactFolderEntryID

OutlookContactFolderStoreID

OutlookTaskFolderName

OutlookTaskOutlookStoreID

OutlookTaskOutlookEntryID

OutlookCalendarFolderName

OutlookCalendarOutlookStoreID

OutlookCalendarOutlookEntryID

OutlookIdentification

OutlookUserID

OutlookUserEntryID

OutlookSetup

smmSynchronizeDaysBack

smmSynchronizeDaysForward

InclPrivateAppointments

InclRecurringAppointments

InclPrivateTasks

PayrollScale

PaySavings

Personal

PersonalDetails

BirthDate

EmplGender

Title

DeceasedDate

Project

ProjPeriodId

ValidateProjEmpl

PurchReq

ReqAttention

ReqSiteId

ReqLocationId

References

ItemBuyerGroupId

RelocationContribution

Retirement

SalarySeniority

SaveOutgoingMails

eMailSaveCopy

Seniority

Telephony

ActivateAnswer

Termination

TrialPeriod

Unions

Vacation

Validation

ValidateEmplCategory

WageType

WebCategoryBrowsing

Dimension

Dimension

Dimension

Title

WorkDays

WorkingTime

Relation

Table

Lines

AddressCountryRegion

AddressCountryRegion Table

EmplTable.DEL_M1_Citizenship == AddressCountryRegion.CountryRegionId

AddressCounty

AddressCounty Table

EmplTable.DEL_CountryRegionId == AddressCounty.CountryRegionId

EmplTable.DEL_StateId == AddressCounty.StateId

EmplTable.DEL_CountyId == AddressCounty.CountyId

AddressState

AddressState Table

EmplTable.DEL_CountryRegionId == AddressState.CountryRegionId

EmplTable.DEL_StateId == AddressState.StateId

AddressZipCode

AddressZipCode Table

EmplTable.DEL_ZipCodeId == AddressZipCode.ZipCode

CompanyImage

CompanyImage Table

EmplTable.TableId == CompanyImage.RefTableId

EmplTable.RecId == CompanyImage.RefRecId

Currency

Currency Table

EmplTable.DEL_currency == Currency.CurrencyCode

DataArea

DataArea Table

EmplTable.dataAreaId == DataArea.id

Dimensions

Dimensions Table

EmplTable.Dimension == Dimensions.Num

0 == Dimensions.DimensionCode

DirPartyTable

DirPartyTable Table

EmplTable.PartyId == DirPartyTable.PartyId

DirPartyView

DirPartyView Table

EmplTable.PartyId == DirPartyView.PartyId

EmplTable

EmplTable Table

EmplTable.AltNum == EmplTable.AltNum

HRMAbsenceSetup

HRMAbsenceSetup Table

EmplTable.DEL_hrmAbsenceSetupId == HRMAbsenceSetup.hrmAbsenceSetupId

HRMIncomeTaxCategory

HRMIncomeTaxCategory Table

EmplTable.DEL_hrmIncomeTaxCategoryId == HRMIncomeTaxCategory.hrmIncomeTaxCategoryId

HRMIncomeTaxCode

HRMIncomeTaxCode Table

EmplTable.DEL_hrmIncomeTaxCodeId == HRMIncomeTaxCode.hrmIncomeTaxCodeId

HRMMunicipal

HRMMunicipal Table

EmplTable.DEL_hrmMunicipalId == HRMMunicipal.hrmMunicipalId

HRMReasonCode

HRMReasonCode Table

EmplTable.DEL_resignReasonCodeId == HRMReasonCode.hrmReasonCodeId

0 == HRMReasonCode.type

HRMUnions

HRMUnions Table

EmplTable.DEL_hrmUnionIdNegotiator == HRMUnions.hrmUnionId

1 == HRMUnions.negotiator

InventBuyerGroup

InventBuyerGroup Table

EmplTable.ItemBuyerGroupId == InventBuyerGroup.Group

InventLocation

InventLocation Table

EmplTable.ReqLocationId == InventLocation.InventLocationId

InventSite

InventSite Table

EmplTable.ReqSiteId == InventSite.SiteId

PBAUserProfiles

PBAUserProfiles Table

EmplTable.PBAUserProfile == PBAUserProfiles.ProfileId

PersonTitleTable

PersonTitleTable Table

EmplTable.Title == PersonTitleTable.Title

ProjPeriodTable

ProjPeriodTable Table

EmplTable.ProjPeriodId == ProjPeriodTable.PeriodId

SMADispatchTeamTable

SMADispatchTeamTable Table

EmplTable.DispatchTeamId == SMADispatchTeamTable.DispatchTeamId

UserInfo

UserInfo Table

EmplTable.DEL_UserId == UserInfo.id

VendTable

VendTable Table

EmplTable.DEL_vendAccount == VendTable.AccountNum

WorkCalendarTable

WorkCalendarTable Table

EmplTable.CalendarId == WorkCalendarTable.CalendarId

Index

AllowDuplicates

Enabled

Fields

Alias

Yes

Yes

DEL_Alias

AltNumIdx

Yes

Yes

AltNum

EmplIdx

No

Yes

EmplId

PartyIdIdx

Yes

Yes

PartyId

RecId

No

Yes

RecId

Use of this table might lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to CreateReadUpdateDelete. The Application Object Server authorizes each create, read, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception is thrown.

Community Additions

ADD
Show:
© 2015 Microsoft