Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DD10700
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Direct Deposit Exceptions Group Display Name: Payroll Direct Deposit Work
Physical Name: DD10700
Technical Name: ddExceptions
Group Technical Name: Payroll Direct Deposit Work
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | INDXLONG  | IndexLong | Long Integer | Long Int | 8 | |
| 2 | EMPLOYID | Employee ID | String | STR15_Employee_ID | 15 | |
| 3 | DDTRANUM | DD Transit Number | String | DD_STR09 | 9 | |
| 4 | DDACTNUM | DD Account Number | String | DD_STR17 | 17 | |
| 5 | DDTRANS | DD Transaction Code | String | STR2 | 2 | |
| 6 | DDAMTDLR | DD AmountDlr | Currency | DLR11_$S2 | 14 | |
| 7 | AMNTOPST | Amount To Post | Currency | DLR11_$S2 | 14 | |
| 8 | DDITEM | DD Item | Integer | INT5 | 4 | |
| 9 | ERRDESCR | Error Description | String | STR130 | 130 | |
| 10 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Direct Deposit Exceptions'].USERID AS 'Direct Deposit Exceptions-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
DD10700 AS ['Direct Deposit Exceptions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Direct Deposit Exceptions'].USERID = ['Users Master'].USERID | ||||||