Fields Transferred Between Microsoft Dynamics GP and Ascentis HR

The following table shows fields are transferred between Microsoft Dynamics GP and Ascentis HR.

Note:  * Denotes that only the field transfer from Ascentis HR to Microsoft Dynamics GP is supported.  

Great Plains UI Location

Field

Cards/Payroll/Employee: First

First Name

Cards/Payroll/Employee: Middle

Middle Name

Cards/Payroll/Employee: Last Name

Last Name

Cards/Payroll/Employee/Additional Information: Birth Date

Birth date

Cards/Payroll/Employee: Address

Address Street 1&2

Cards/Payroll/Employee: City

Address City

Cards/Payroll/Employee: State

Address State/Province

Cards/Payroll/Employee: Zip Code

Address Postal Code

Cards/Payroll/Employee: Country

Address Country

Cards/Payroll/Employee: Phone 1,2

Home/Work Phone Number

Cards/Payroll/Employee/Additional Information: Ethnic Origin

Ethnic Origin

Cards/Payroll/Tax: Federal Filing Status

Filing Status

Cards/Payroll/Tax: Number of Exemptions

Primary Exemptions

Cards/Payroll/Employee/Add. Info.: Marital Status

Marital Status

Cards/Payroll/Employee/Add. Info.: Gender

Sex

Cards/Payroll/Employee: Employee ID

Employee ID

Cards/Payroll/Employee: Soc Sec Number

Social Security Number

Setup/Company/Company:  Company ID

Company ID

Setup/Company/Company:  Company Name

Company Name

Cards/Payroll/Employee: Department

Department

Cards/Payroll/Employee: Location

Location

Cards/Payroll/Employee: Hire Date

Hire Date

Cards/Payroll/Employee: Adjusted Hire Date

Adjusted Seniority Date

Cards/Payroll/Employee: Date Inactivated

Termination Date

*Cards/Payroll/Employee: Reason

Termination Reason

Cards/Payroll/Pay Code: Amount

Compensation Amount

Cards/Payroll/Pay Code: Pay Code

Payroll Code

Cards/Payroll/Pay Code: Pay Period

Pay Period

Cards/Payroll/Pay Code: Pay Per Period

Paycheck Amount

Cards/Payroll/Pay Code: Unit of Pay

Compensation Type

Cards/Payroll/Employee: Position

Job Title

Cards/Payroll/Employee: Workers' Comp Code

Workers' Comp Code

*Transactions/Payroll/Transaction Entry

Leave Taken

*Cards/Payroll/Pay Code: Pay Code

Leave Type

*Cards/Payroll/Deduction: Deduction Tiers Amount

Deduction Employee Contribution Amount

*Cards/Payroll/Deduction: Deduction Tiers Percent

Deduction Employee Contribution Percent

*Cards/Payroll/Deduction: Start Date

Deduction Start Date

*Cards/Payroll/Deduction: Deduction Code

Deduction Type

*Cards/Payroll/Deduction: End Date

Deduction End Date

*Cards/Payroll/Benefits: Benefit Tiers Amount

Deduction Employer Contribution Amount

*Cards/Payroll/Benefits: Benefit Tiers Percent

Deduction Employer Contribution Percent

*Cards/Payroll/Benefits: Start Date

Deduction Start Date

*Cards/Payroll/Benefits: Benefit Code

Deduction Type

*Cards/Payroll/Benefits: End Date

Deduction End Date