UPR10307 - Payroll Manual Check
Dynamics GP table UPR10307 (Payroll Manual Check) contains 15 columns including MLCHKTYP, PYADNMBR, BACHNUMB....
SQL Query Builder
15 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| MLCHKTYP | Manual Check Type | Integer | 2 | |
| PYADNMBR | Payment/Adjustment Number | Long Integer | 4 | |
| BACHNUMB | Batch Number | String | 16 | |
| CHEKBKID | Checkbook ID | String | 16 | |
| CHEKNMBR | Check Number | String | 22 | |
| CHEKDATE | Check Date | Date | 4 | |
| POSTEDDT | Posted Date | Date | 4 | |
| EMPLOYID | Employee ID | String | 16 | |
| ATACRVAC | Auto Accrue Vacation | Boolean | 2 | |
| ATACRSCK | Auto Accrue Sick | Boolean | 2 | |
| GROSAMNT | Gross Amount | Currency | 10 | |
| NETAMNT | Net Amount | Currency | 10 | |
| MCHKPRTD | Manual Check Printed | Boolean | 2 | |
| MCHKPSTD | Manual Check Posted | Boolean | 2 | |
| NOTEINDX | Note Index | Currency | 10 |
Related Tables
Tables that share columns with UPR10307. Click "Join" to add to your query.