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 IDStringSTR15_Employee_ID15
2EMPLNAME SearchEmployee NameStringSTR4040
3PRINTED SearchPrintedBooleanCB0

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
4VOIDED SearchVoidedBooleanCB0
5CHEKDATE SearchCheck DateDateDATE6
6CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
7PYADNMBR SearchPayment/Adjustment NumberLong IntegerLI8_U08
8SOCSCNUM SearchSocial Security NumberStringSTR15_Social_Security_Number15
9NTWPYRN SearchNet Wages/Pay RunCurrencyDLR11_$S214
10GRWGPRN SearchGross Wages/Pay RunCurrencyDLR11_$S214
11STTPYPRD SearchStart Pay PeriodDateDT8
12ENPAYPRD SearchEnd Pay PeriodDateDT8
13INACTIVE SearchInactiveBooleanCB_Inactive0
14DDVOIDED SearchDD VoidedBooleanCB0
15DDMASKDLR SearchDD Mask DollarBooleanCB0
16DDSUPCHK SearchDD Suppress CheckIntegerINT54
17DDNBRACCTS SearchDD Number of AccountsIntegerINT54
18DDATRXCODE SearchDD Array12 Transaction CodeSTR2String2
19DDATRXCODE_1 SearchDD Array12 Transaction Code[1]StringSTR22
20DDATRXCODE_2 SearchDD Array12 Transaction Code[2]StringSTR22
21DDATRXCODE_3 SearchDD Array12 Transaction Code[3]StringSTR22
22DDATRXCODE_4 SearchDD Array12 Transaction Code[4]StringSTR22
23DDATRXCODE_5 SearchDD Array12 Transaction Code[5]StringSTR22
24DDATRXCODE_6 SearchDD Array12 Transaction Code[6]StringSTR22
25DDATRXCODE_7 SearchDD Array12 Transaction Code[7]StringSTR22
26DDATRXCODE_8 SearchDD Array12 Transaction Code[8]StringSTR22
27DDATRXCODE_9 SearchDD Array12 Transaction Code[9]StringSTR22
28DDATRXCODE_10 SearchDD Array12 Transaction Code[10]StringSTR22
29DDATRXCODE_11 SearchDD Array12 Transaction Code[11]StringSTR22
30DDATRXCODE_12 SearchDD Array12 Transaction Code[12]StringSTR22
31DDATRANSIT_1 SearchDD Array12 Transit Number[1]StringDD_STR099
32DDATRANSIT SearchDD Array12 Transit NumberDD_STR09String9
33DDATRANSIT_2 SearchDD Array12 Transit Number[2]StringDD_STR099
34DDATRANSIT_3 SearchDD Array12 Transit Number[3]StringDD_STR099
35DDATRANSIT_4 SearchDD Array12 Transit Number[4]StringDD_STR099
36DDATRANSIT_5 SearchDD Array12 Transit Number[5]StringDD_STR099
37DDATRANSIT_6 SearchDD Array12 Transit Number[6]StringDD_STR099
38DDATRANSIT_7 SearchDD Array12 Transit Number[7]StringDD_STR099
39DDATRANSIT_8 SearchDD Array12 Transit Number[8]StringDD_STR099
40DDATRANSIT_9 SearchDD Array12 Transit Number[9]StringDD_STR099
41DDATRANSIT_10 SearchDD Array12 Transit Number[10]StringDD_STR099
42DDATRANSIT_11 SearchDD Array12 Transit Number[11]StringDD_STR099
43DDATRANSIT_12 SearchDD Array12 Transit Number[12]StringDD_STR099
44DDAACCOUNT_1 SearchDD Array12 Account Number[1]StringDD_STR1616
45DDAACCOUNT_2 SearchDD Array12 Account Number[2]StringDD_STR1616
46DDAACCOUNT SearchDD Array12 Account NumberDD_STR16String16
47DDAACCOUNT_3 SearchDD Array12 Account Number[3]StringDD_STR1616
48DDAACCOUNT_4 SearchDD Array12 Account Number[4]StringDD_STR1616
49DDAACCOUNT_5 SearchDD Array12 Account Number[5]StringDD_STR1616
50DDAACCOUNT_6 SearchDD Array12 Account Number[6]StringDD_STR1616
51DDAACCOUNT_7 SearchDD Array12 Account Number[7]StringDD_STR1616
52DDAACCOUNT_8 SearchDD Array12 Account Number[8]StringDD_STR1616
53DDAACCOUNT_9 SearchDD Array12 Account Number[9]StringDD_STR1616
54DDAACCOUNT_10 SearchDD Array12 Account Number[10]StringDD_STR1616
55DDAACCOUNT_11 SearchDD Array12 Account Number[11]StringDD_STR1616
56DDAACCOUNT_12 SearchDD Array12 Account Number[12]StringDD_STR1616
57DDAAMOUNT_1 SearchDD Array12 Amount[1]CurrencyDLR11_$S214
58DDAAMOUNT_2 SearchDD Array12 Amount[2]CurrencyDLR11_$S214
59DDAAMOUNT_3 SearchDD Array12 Amount[3]CurrencyDLR11_$S214
60DDAAMOUNT SearchDD Array12 AmountDLR11_$S2Currency14
61DDAAMOUNT_4 SearchDD Array12 Amount[4]CurrencyDLR11_$S214
62DDAAMOUNT_5 SearchDD Array12 Amount[5]CurrencyDLR11_$S214
63DDAAMOUNT_6 SearchDD Array12 Amount[6]CurrencyDLR11_$S214
64DDAAMOUNT_7 SearchDD Array12 Amount[7]CurrencyDLR11_$S214
65DDAAMOUNT_8 SearchDD Array12 Amount[8]CurrencyDLR11_$S214
66DDAAMOUNT_9 SearchDD Array12 Amount[9]CurrencyDLR11_$S214
67DDAAMOUNT_10 SearchDD Array12 Amount[10]CurrencyDLR11_$S214
68DDAAMOUNT_11 SearchDD Array12 Amount[11]CurrencyDLR11_$S214
69DDAAMOUNT_12 SearchDD Array12 Amount[12]CurrencyDLR11_$S214
70ERRDESCR SearchError DescriptionStringSTR130130
71USERID SearchUser IDStringSTR15_User_ID15
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
azurecurveProductsMicrosoft Dynamics GP (0)PayrollDirect Deposit Employee Deposits Work (DD10100)

Leave a Reply

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