UPR00402 - Payroll Post Dated Pay Code Master
Dynamics GP table UPR00402 (Payroll Post Dated Pay Code Master) contains 8 columns including EMPLOYID, PAYRCORD, Effective_Date....
SQL Query Builder
8 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| EMPLOYID | Employee ID | String | 16 | |
| PAYRCORD | Pay Record | String | 8 | |
| Effective_Date | Effective Date | Date | 4 | |
| PAYRTAMT | Pay Rate Amount | Currency | 10 | |
| CHANGEREASON_I | Change Reason | String | 32 | |
| PayStepStatus | Pay Step Status | Integer | 2 | |
| PYSTPTBLID | Pay Step Table ID | String | 16 | |
| Step | Step | Integer | 2 |