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 TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2EMPLNAME SearchEmployee NameSTR40String4240
3PRINTED SearchPrintedCBBoolean20

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
4VOIDED SearchVoidedCBBoolean20
5CHEKDATE SearchCheck DateDATEDate46
6CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
7PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer48
8SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
9NTWPYRN SearchNet Wages/Pay RunDLR11_$S2Currency1014
10GRWGPRN SearchGross Wages/Pay RunDLR11_$S2Currency1014
11STTPYPRD SearchStart Pay PeriodDTDate48
12ENPAYPRD SearchEnd Pay PeriodDTDate48
13INACTIVE SearchInactiveCB_InactiveBoolean20
14DDVOIDED SearchDD VoidedCBBoolean20
15DDMASKDLR SearchDD Mask DollarCBBoolean20
16DDSUPCHK SearchDD Suppress CheckINT5Integer24
17DDNBRACCTS SearchDD Number of AccountsINT5Integer24
18DDATRXCODE SearchDD Array12 Transaction CodeSTR2String42
19DDATRXCODE_1 SearchDD Array12 Transaction Code[1]STR2String42
20DDATRXCODE_2 SearchDD Array12 Transaction Code[2]STR2String42
21DDATRXCODE_3 SearchDD Array12 Transaction Code[3]STR2String42
22DDATRXCODE_4 SearchDD Array12 Transaction Code[4]STR2String42
23DDATRXCODE_5 SearchDD Array12 Transaction Code[5]STR2String42
24DDATRXCODE_6 SearchDD Array12 Transaction Code[6]STR2String42
25DDATRXCODE_7 SearchDD Array12 Transaction Code[7]STR2String42
26DDATRXCODE_8 SearchDD Array12 Transaction Code[8]STR2String42
27DDATRXCODE_9 SearchDD Array12 Transaction Code[9]STR2String42
28DDATRXCODE_10 SearchDD Array12 Transaction Code[10]STR2String42
29DDATRXCODE_11 SearchDD Array12 Transaction Code[11]STR2String42
30DDATRXCODE_12 SearchDD Array12 Transaction Code[12]STR2String42
31DDATRANSIT SearchDD Array12 Transit NumberDD_STR09String109
32DDATRANSIT_1 SearchDD Array12 Transit Number[1]DD_STR09String109
33DDATRANSIT_2 SearchDD Array12 Transit Number[2]DD_STR09String109
34DDATRANSIT_3 SearchDD Array12 Transit Number[3]DD_STR09String109
35DDATRANSIT_4 SearchDD Array12 Transit Number[4]DD_STR09String109
36DDATRANSIT_5 SearchDD Array12 Transit Number[5]DD_STR09String109
37DDATRANSIT_6 SearchDD Array12 Transit Number[6]DD_STR09String109
38DDATRANSIT_7 SearchDD Array12 Transit Number[7]DD_STR09String109
39DDATRANSIT_8 SearchDD Array12 Transit Number[8]DD_STR09String109
40DDATRANSIT_9 SearchDD Array12 Transit Number[9]DD_STR09String109
41DDATRANSIT_10 SearchDD Array12 Transit Number[10]DD_STR09String109
42DDATRANSIT_11 SearchDD Array12 Transit Number[11]DD_STR09String109
43DDATRANSIT_12 SearchDD Array12 Transit Number[12]DD_STR09String109
44DDAACCOUNT SearchDD Array12 Account NumberDD_STR16String1816
45DDAACCOUNT_1 SearchDD Array12 Account Number[1]DD_STR16String1816
46DDAACCOUNT_2 SearchDD Array12 Account Number[2]DD_STR16String1816
47DDAACCOUNT_3 SearchDD Array12 Account Number[3]DD_STR16String1816
48DDAACCOUNT_4 SearchDD Array12 Account Number[4]DD_STR16String1816
49DDAACCOUNT_5 SearchDD Array12 Account Number[5]DD_STR16String1816
50DDAACCOUNT_6 SearchDD Array12 Account Number[6]DD_STR16String1816
51DDAACCOUNT_7 SearchDD Array12 Account Number[7]DD_STR16String1816
52DDAACCOUNT_8 SearchDD Array12 Account Number[8]DD_STR16String1816
53DDAACCOUNT_9 SearchDD Array12 Account Number[9]DD_STR16String1816
54DDAACCOUNT_10 SearchDD Array12 Account Number[10]DD_STR16String1816
55DDAACCOUNT_11 SearchDD Array12 Account Number[11]DD_STR16String1816
56DDAACCOUNT_12 SearchDD Array12 Account Number[12]DD_STR16String1816
57DDAAMOUNT SearchDD Array12 AmountDLR11_$S2Currency1014
58DDAAMOUNT_1 SearchDD Array12 Amount[1]DLR11_$S2Currency1014
59DDAAMOUNT_2 SearchDD Array12 Amount[2]DLR11_$S2Currency1014
60DDAAMOUNT_3 SearchDD Array12 Amount[3]DLR11_$S2Currency1014
61DDAAMOUNT_4 SearchDD Array12 Amount[4]DLR11_$S2Currency1014
62DDAAMOUNT_5 SearchDD Array12 Amount[5]DLR11_$S2Currency1014
63DDAAMOUNT_6 SearchDD Array12 Amount[6]DLR11_$S2Currency1014
64DDAAMOUNT_7 SearchDD Array12 Amount[7]DLR11_$S2Currency1014
65DDAAMOUNT_8 SearchDD Array12 Amount[8]DLR11_$S2Currency1014
66DDAAMOUNT_9 SearchDD Array12 Amount[9]DLR11_$S2Currency1014
67DDAAMOUNT_10 SearchDD Array12 Amount[10]DLR11_$S2Currency1014
68DDAAMOUNT_11 SearchDD Array12 Amount[11]DLR11_$S2Currency1014
69DDAAMOUNT_12 SearchDD Array12 Amount[12]DLR11_$S2Currency1014
70ERRDESCR SearchError DescriptionSTR130String132130
71USERID SearchUser IDSTR15_User_IDString1615
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 Searchintint1010

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 *