DD00200 - Direct Deposit Employee Account Master
Dynamics GP table DD00200 (Direct Deposit Employee Account Master) contains 12 columns including EMPLOYID, INDEX1, INACTIVE....
SQL Query Builder
12 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| EMPLOYID | Employee ID | String | 16 | ||
| INDEX1 | Index | Integer | 2 | ||
| INACTIVE | Inactive | Boolean | 2 | ||
Active Status values (2) 0 = Active1 = Inactive | |||||
| DEDNMTHD | Deduction Method | Integer | 2 | ||
| DEDUCTON | Deduction | String | 8 | ||
| DDPRE | DD Prenote | Boolean | 2 | ||
| DDPRECNT | DD Prenote Count | Integer | 2 | ||
| DDPCT | DD Percent | Integer | 2 | ||
| DDAMTDLR | DD AmountDlr | Currency | 10 | ||
| DDACTNUM | DD Account Number | String | 18 | ||
| DDTRANUM | DD Transit Number | String | 10 | ||
| DDTRANS | DD Transaction Code | String | 4 | ||
Related Tables
Tables that share columns with DD00200. Click "Join" to add to your query.
DDPRECNT