Transaction Analysis Report Options (DTA00700)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialTransaction Analysis Report Options (DTA00700)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Transaction Analysis Report Options
Physical Name: DTA00700
Technical Name: DTA_Analysis_ROPT

Group Display Name: Transaction Analysis Table Group
Group Technical Name: DTA_Analysis_Table_Group

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RPTGRIND SearchReport Group IndexINTInteger0
2RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
3RTPACHIN SearchReport Palette Choice IndexINTInteger0
4STTACNUM SearchStart Account NumberAccount_NumberComposite 80
5STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
6STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
7STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
8STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
9STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
10STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
11STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
12STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
13STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
14STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
15EACCNBR SearchEnd Account NumberAccount_NumberComposite 80
16EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
17EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
18EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
19EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
20EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
21EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
22EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
23EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
24EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
25EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
26STRTDATE SearchStart DateDTDate8
27ENDDATE SearchEnd DateDTDate8
28STARTGRP SearchDTA_Start_GroupSTR15_LBAUString15
29ENDGROUP SearchDTA_End_GroupSTR15_LBAUString15
30STRTCODE SearchDTA_Start_CodeSTR15_LBAUString15
31ENDCODE SearchDTA_End_CodeSTR15_LBAUString15
32PRNTDTLD SearchPrint Detailed CBBoolean0
33UNPSTTRX SearchUnposted TrxCB_Unposted_TrxBoolean0
34OPEN1 SearchOpenCB_OpenBoolean0
35HISTORY SearchHistoryCB_HistoryBoolean0
36STTPSTDT SearchStart Post DateDATEDate6
37ENDPSTDT SearchEnd Post DateDATEDate6
38DEX_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)FinancialTransaction Analysis Report Options (DTA00700)

Leave a Reply

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