Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our HRM scripts. All of our scripts for Dynamics GP can be found here
HRM Scripts
 
No records to display.
Module List > Module COMPANY..HRM tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change
Module Remarks:
Hrm Module
ClearPixel
Freq
Used
 Display Name
 APR_APR00610APR Employee Benefit Dependents
 APR_BSS00100 
 APR_BSS00101 
 APR_BSS00102 
 APR_BSS00103 
 APR_BSS00200 
 APR_GL00100APR Account Master COMP
 APR_ORM00400APR_ORM_Options
 APR_ORM00500APR_EmpBatch_Temp
 APR_PIP00100 
 APR_PIP00400APR PIP Key MSTR
 APR_PPR00100APR PPR Options
 APR_PTO00100APR_PTO_Options
 APR_UPR00111APR Payroll Master Dependent Companion
 APR_UPR00500APR Payroll Employee Deduction Master
 APR00100APR Payroll Master Companion
 APR00400APR Payroll Pay Code Master Companion
 APR00401APR Employee Pay Policy Master
 APR00402APR Employee Pay Policy
 APR00403APR Employee Pay Policy Detail
 APR00501APR Add-On Master
 ORM_UPR00400ORM Payroll Pay Code COMP
 PTO00100PTO Payroll Master
 PTO00101PTO Pending Master
 PTO00102PTO Anniversary Carry Over
Freq
Used
 Display Name
 APR_BLM10300Future Effective Activity Tracking
 APR_BSS10100 
 APR_BSS10101 
 APR_BSS10102 
 APR_BSS10103 
 APR_BSS10104 
 APR_DIA10100Deduction In Arrears WORK
 APR_DIA10200DIA Payroll Temp Posting 2
 APR_DIA10300DIA Payroll Work Deduction TEMP
 APR_ORM10000APR_Differential_Build
 APR10100APR Transaction Import WORK
 APR10101APR Transaction Import Errors
 APR10302APR TRX Batch Detail Companion
 APR10302_Archive 
 ORM_UPR10203ORM OT Rates WORK
 PTO10200PTO Year End Processing
Freq
Used
 Display Name
 APR_BE020230APR HR_Benefit_SETP
 APR_DIA20100Deductions in Arrears OPEN
 APR_DIA20101Deductions in Arrears OPEN Activity
Work Tables
Freq
Used
 Display Name
 APR_APR30000APR_Accrual_History
 APR_APR30300APR Pay Run History
 APR_BLM31100BLM HR Benefit Setup History
 APR_BLM31200Future Effective CoPays History
 APR_BLM31300Future Effective Benefit Tiers History
 APR_BLM31400Future Effective Life Premiums History
 APR_BLM31500Future Effective Entrance Dates History
 APR_BLM31600Future Effective Benefit Funds History
 APR_BLM32100Future Effective Payroll Benefit Setup History
 APR_BLM32200Future Effective Payroll Benefit Based On Setup Hi
 APR_BLM33100Future Effective Payroll Deduction Setup History
 APR_BLM33200Future Effective Payroll Deduction Based On Setup
 APR_BSS30100 
 APR_BSS30101 
 APR_BSS30102 
 APR_BSS30103 
 APR_DIA30100Deductions in Arrears History
 PTO30100 
Freq
Used
 Display Name
 APR_40300APR Accrual Date Default
 APR_APR40100APR_Payroll_Acct_Map_HDR
 APR_APR40101APR_Payroll_Acct_Map_DTL
 APR_APR40200APR UPR Master Split Setup
 APR_APR40500APR Beneficiary and Dependent Status Codes
 APR_APR50000APR Payroll Accruals TEMP
 APR_APR50001APR Accrual Distributions
 APR_APR50100APR Unit Account TEMP
 APR_APR70250APR Distribution Report Detail
 APR_APR70300APR Report Option Names
 APR_APR70500APR Department Report Options
 APR_APR70501APR Department Report Options Detail
 APR_APR70510APR Department Reports TEMP
 APR_APR70511APR Department Reports Budget TEMP
 APR_APR70512APR_Valid_Dept_FTE_Temp
 APR_APR70513APR_FTE_YTD_Report_Temp
 APR_APR70530APR Department Ben Accrual TEMP
 APR_APR70540APR Department Summ Report Temp
 APR_APR70900APR Area of Responsibility HDR
 APR_APR70901APR Area of Responsibility DTL
 APR_BLM41100Future Effective HR Benefits
 APR_BLM41101BLM Future Effective Benefits (backup)
 APR_BLM41200Future Effective CoPays
 APR_BLM41201Future Effective CoPays (Backup)
 APR_BLM41300Future Effective Benefit Tiers
 APR_BLM41301Future Effective Benefit Tiers Backup
 APR_BLM41400Future Effective Life Premiums
 APR_BLM41401Future Effective Life Premiums Backup
 APR_BLM41500Future Effective Entrance Dates
 APR_BLM41501Future Effective Entrance Dates Backup
 APR_BLM41600Future Effective Benefit Funds
 APR_BLM41601Future Effective Benefit Funds Backup
 APR_BLM42100Future Effective Payroll Benefit Setup
 APR_BLM42101Future Effective Payroll Benefit Setup (Backup)
 APR_BLM42200Future Effective Payroll Benefit Based On Setup
 APR_BLM42201Future Effective Payroll Benefit Based On Setup (B
 APR_BLM43100Future Effective Payroll Deduction Setup
 APR_BLM43101Future Effective Payroll Deduction Setup (Backup)
 APR_BLM43200Future Effective Payroll Deduction Based On Setup
 APR_BLM43201Future Effective Payroll Deduction Based On Setup
 APR_BLM43300Future Effective Ded In Arrears Setup
 APR_BLM43301Future Effective Ded In Arrears Setup (Backup)
 APR_BSS40100 
 APR_BSS40101 
 APR_BSS40200 
 APR_BSS40201 
 APR_BSS40202 
 APR_BSS40203 
 APR_BSS40300 
 APR_BSS40301 
 APR_BSS40302 
 APR_BSS40400 
 APR_BSS40401 
 APR_BSS40500 
 APR_BSS40501 
 APR_BSS40502 
 APR_BSS40503 
 APR_BSS40600 
 APR_BSS40700 
 APR_BSS40701 
 APR_BSSBEN02 
 APR_DIA40100Deduction in Arrears Setup
 APR_DIA40200Deduction In Arrears Activity Source Setup
 APR_DIA40300 
 APR_DIA50000APR DIA Missed Check TEMP
 APR_DIA50001Deductions in Arrears Uncollected Temp
 APR_DIA50002APR DIA Build Deduction Report TMP
 APR_DIA50101Deductions in Arrears VOID Activity TEMP
 APR_HRPBEN02APR HRP Benefit Beneficiary COMP
 APR_Import_Groups_TEMP 
 APR_PIP40100APR Payroll Vendors
 APR_PPR50100APR Fund Report Temp
 APR_PTO40400PTO Code Setup
 APR_PTO70500APR PTO Report Options
 APR_PTO70501PTO Report Options DTL
 APR_UPR40500APR Payroll Accounts Setup
 APR_UPR40900APR Payroll Deduction Setup
 APR40600APR Payroll Pay Code Setup Companion
 APR41100APR Pay Policy
 APR41101APR Pay Policy Detail
 APR41501APR Add-On Setup
 APR41601APR Priority Setup
 Hrm_ATT 
 Hrm_ATTAssignment 
 Hrm_BatchPrefix 
 Hrm_BPAssignment 
 Hrm_ETTDetail 
 Hrm_ETTTimeEntry 
 Hrm_Hierarchy 
 Hrm_HRMSetup 
 Hrm_LifeEventLink 
 Hrm_OrgLookup 
 Hrm_OrgLookupTimeStamp 
 Hrm_PayPeriod 
 Hrm_PaySchedule 
 Hrm_Proxy 
 Hrm_ProxyAssignments 
 Hrm_PSAssignment 
 Hrm_Signatures 
 Hrm_Timecard 
 Hrm_TimecardAssignments 
 Hrm_TimecardDetail 
 Hrm_TimecardTimeEntry 
 Hrm_VacationRequest 
 Hrm_W4History 
 Hrm_WorkContactDetails 
 ORM_UPR_SETP_OT_DTLOvertime Adjustment Setup Detail
 ORM_UPR_SETP_OT_HDROvertime Adjustment Setup
 ORM_UPR40600ORM Pay Type Setup COMP
 PTO40100PTO Accrual Schedule Header
 PTO40101PTO Accrual Schedule Detail
 PTO40200PTO Max Schedule Header
 PTO40201PTO Max Schedule Detail
 PTO90000PTO Pending Master Conversion
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3