Direct Deposit Employee Deposits Work (DD10100)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollDirect Deposit Employee Deposits Work (DD10100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DD10100

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Direct Deposit Employee Deposits Work
Physical Name: DD10100
Technical Name: ddDeposits

Group Display Name: Payroll Direct Deposit Work
Group Technical Name: Payroll Direct Deposit Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
2EMPLNAME SearchEmployee NameSTR40String40
3PRINTED SearchPrintedCBBoolean0

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
4VOIDED SearchVoidedCBBoolean0
5CHEKDATE SearchCheck DateDATEDate6
6CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
7PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer8
8SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
9NTWPYRN SearchNet Wages/Pay RunDLR11_$S2Currency14
10GRWGPRN SearchGross Wages/Pay RunDLR11_$S2Currency14
11STTPYPRD SearchStart Pay PeriodDTDate8
12ENPAYPRD SearchEnd Pay PeriodDTDate8
13INACTIVE SearchInactiveCB_InactiveBoolean0
14DDVOIDED SearchDD VoidedCBBoolean0
15DDMASKDLR SearchDD Mask DollarCBBoolean0
16DDSUPCHK SearchDD Suppress CheckINT5Integer4
17DDNBRACCTS SearchDD Number of AccountsINT5Integer4
18DDATRXCODE SearchDD Array12 Transaction CodeSTR2String2
19DDATRXCODE_1 SearchDD Array12 Transaction Code[1]STR2String2
20DDATRXCODE_2 SearchDD Array12 Transaction Code[2]STR2String2
21DDATRXCODE_3 SearchDD Array12 Transaction Code[3]STR2String2
22DDATRXCODE_4 SearchDD Array12 Transaction Code[4]STR2String2
23DDATRXCODE_5 SearchDD Array12 Transaction Code[5]STR2String2
24DDATRXCODE_6 SearchDD Array12 Transaction Code[6]STR2String2
25DDATRXCODE_7 SearchDD Array12 Transaction Code[7]STR2String2
26DDATRXCODE_8 SearchDD Array12 Transaction Code[8]STR2String2
27DDATRXCODE_9 SearchDD Array12 Transaction Code[9]STR2String2
28DDATRXCODE_10 SearchDD Array12 Transaction Code[10]STR2String2
29DDATRXCODE_11 SearchDD Array12 Transaction Code[11]STR2String2
30DDATRXCODE_12 SearchDD Array12 Transaction Code[12]STR2String2
31DDATRANSIT SearchDD Array12 Transit NumberDD_STR09String9
32DDATRANSIT_1 SearchDD Array12 Transit Number[1]DD_STR09String9
33DDATRANSIT_2 SearchDD Array12 Transit Number[2]DD_STR09String9
34DDATRANSIT_3 SearchDD Array12 Transit Number[3]DD_STR09String9
35DDATRANSIT_4 SearchDD Array12 Transit Number[4]DD_STR09String9
36DDATRANSIT_5 SearchDD Array12 Transit Number[5]DD_STR09String9
37DDATRANSIT_6 SearchDD Array12 Transit Number[6]DD_STR09String9
38DDATRANSIT_7 SearchDD Array12 Transit Number[7]DD_STR09String9
39DDATRANSIT_8 SearchDD Array12 Transit Number[8]DD_STR09String9
40DDATRANSIT_9 SearchDD Array12 Transit Number[9]DD_STR09String9
41DDATRANSIT_10 SearchDD Array12 Transit Number[10]DD_STR09String9
42DDATRANSIT_11 SearchDD Array12 Transit Number[11]DD_STR09String9
43DDATRANSIT_12 SearchDD Array12 Transit Number[12]DD_STR09String9
44DDAACCOUNT SearchDD Array12 Account NumberDD_STR16String16
45DDAACCOUNT_1 SearchDD Array12 Account Number[1]DD_STR16String16
46DDAACCOUNT_2 SearchDD Array12 Account Number[2]DD_STR16String16
47DDAACCOUNT_3 SearchDD Array12 Account Number[3]DD_STR16String16
48DDAACCOUNT_4 SearchDD Array12 Account Number[4]DD_STR16String16
49DDAACCOUNT_5 SearchDD Array12 Account Number[5]DD_STR16String16
50DDAACCOUNT_6 SearchDD Array12 Account Number[6]DD_STR16String16
51DDAACCOUNT_7 SearchDD Array12 Account Number[7]DD_STR16String16
52DDAACCOUNT_8 SearchDD Array12 Account Number[8]DD_STR16String16
53DDAACCOUNT_9 SearchDD Array12 Account Number[9]DD_STR16String16
54DDAACCOUNT_10 SearchDD Array12 Account Number[10]DD_STR16String16
55DDAACCOUNT_11 SearchDD Array12 Account Number[11]DD_STR16String16
56DDAACCOUNT_12 SearchDD Array12 Account Number[12]DD_STR16String16
57DDAAMOUNT SearchDD Array12 AmountDLR11_$S2Currency14
58DDAAMOUNT_1 SearchDD Array12 Amount[1]DLR11_$S2Currency14
59DDAAMOUNT_2 SearchDD Array12 Amount[2]DLR11_$S2Currency14
60DDAAMOUNT_3 SearchDD Array12 Amount[3]DLR11_$S2Currency14
61DDAAMOUNT_4 SearchDD Array12 Amount[4]DLR11_$S2Currency14
62DDAAMOUNT_5 SearchDD Array12 Amount[5]DLR11_$S2Currency14
63DDAAMOUNT_6 SearchDD Array12 Amount[6]DLR11_$S2Currency14
64DDAAMOUNT_7 SearchDD Array12 Amount[7]DLR11_$S2Currency14
65DDAAMOUNT_8 SearchDD Array12 Amount[8]DLR11_$S2Currency14
66DDAAMOUNT_9 SearchDD Array12 Amount[9]DLR11_$S2Currency14
67DDAAMOUNT_10 SearchDD Array12 Amount[10]DLR11_$S2Currency14
68DDAAMOUNT_11 SearchDD Array12 Amount[11]DLR11_$S2Currency14
69DDAAMOUNT_12 SearchDD Array12 Amount[12]DLR11_$S2Currency14
70ERRDESCR SearchError DescriptionSTR130String130
71USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Direct Deposit Employee Deposits Work'].USERID AS 'Direct Deposit Employee Deposits Work-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       DD10100 AS ['Direct Deposit Employee Deposits Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Direct Deposit Employee Deposits Work'].USERID = ['Users Master'].USERID
72DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)PayrollDirect Deposit Employee Deposits Work (DD10100)

Leave a Reply

Your email address will not be published. Required fields are marked *