Direct Deposit Transaction History Detail (DD30101)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollDirect Deposit Transaction History Detail (DD30101)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Direct Deposit Transaction History Detail
Physical Name: DD30101
Technical Name: ddTrxHistDetail

Group Display Name: Payroll Direct Deposit Transaction History
Group Technical Name: Payroll Direct Deposit Transaction History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1INDXLONG SearchIndexLongLong IntLong Integer48
2DDITEM SearchDD ItemINT5Integer24
3CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
4EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
5DDTRANS SearchDD Transaction CodeSTR2String42
6DDTRANUM SearchDD Transit NumberDD_STR09String109
7DDACTNUM SearchDD Account NumberDD_STR17String1817
8DDAMTDLR SearchDD AmountDlrDLR11_$S2Currency1014
9DDTRACE SearchDD Trace NumberSTR15String1615
10DEX_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 Transaction History Detail (DD30101)

Leave a Reply

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