Transaction 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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RPTGRIND	Report Group Index	INT	Integer	0
2	RTGRSBIN	Report Group Sub Index	DLR14	Currency	14
3	RTPACHIN	Report Palette Choice Index	INT	Integer	0
4	STTACNUM	Start Account Number	Account_Number	Composite	80
5	STTACNUM_1	Start Account Number:Account_Segment_Pool1	Account_Segment_Pool1	String	6
6	STTACNUM_2	Start Account Number:Account_Segment_Pool2	Account_Segment_Pool2	String	6
7	STTACNUM_3	Start Account Number:Account_Segment_Pool3	Account_Segment_Pool3	String	6
8	STTACNUM_4	Start Account Number:Account_Segment_Pool4	Account_Segment_Pool4	String	6
9	STTACNUM_5	Start Account Number:Account_Segment_Pool5	Account_Segment_Pool5	String	6
10	STTACNUM_6	Start Account Number:Account_Segment_Pool6	Account_Segment_Pool6	String	6
11	STTACNUM_7	Start Account Number:Account_Segment_Pool7	Account_Segment_Pool7	String	6
12	STTACNUM_8	Start Account Number:Account_Segment_Pool8	Account_Segment_Pool8	String	6
13	STTACNUM_9	Start Account Number:Account_Segment_Pool9	Account_Segment_Pool9	String	6
14	STTACNUM_10	Start Account Number:Account_Segment_Pool10	Account_Segment_Pool10	String	6
15	EACCNBR	End Account Number	Account_Number	Composite	80
16	EACCNBR_1	End Account Number:Account_Segment_Pool1	Account_Segment_Pool1	String	6
17	EACCNBR_2	End Account Number:Account_Segment_Pool2	Account_Segment_Pool2	String	6
18	EACCNBR_3	End Account Number:Account_Segment_Pool3	Account_Segment_Pool3	String	6
19	EACCNBR_4	End Account Number:Account_Segment_Pool4	Account_Segment_Pool4	String	6
20	EACCNBR_5	End Account Number:Account_Segment_Pool5	Account_Segment_Pool5	String	6
21	EACCNBR_6	End Account Number:Account_Segment_Pool6	Account_Segment_Pool6	String	6
22	EACCNBR_7	End Account Number:Account_Segment_Pool7	Account_Segment_Pool7	String	6
23	EACCNBR_8	End Account Number:Account_Segment_Pool8	Account_Segment_Pool8	String	6
24	EACCNBR_9	End Account Number:Account_Segment_Pool9	Account_Segment_Pool9	String	6
25	EACCNBR_10	End Account Number:Account_Segment_Pool10	Account_Segment_Pool10	String	6
26	STRTDATE	Start Date	DT	Date	8
27	ENDDATE	End Date	DT	Date	8
28	STARTGRP	DTA_Start_Group	STR15_LBAU	String	15
29	ENDGROUP	DTA_End_Group	STR15_LBAU	String	15
30	STRTCODE	DTA_Start_Code	STR15_LBAU	String	15
31	ENDCODE	DTA_End_Code	STR15_LBAU	String	15
32	PRNTDTLD	Print Detailed	CB	Boolean	0
33	UNPSTTRX	Unposted Trx	CB_Unposted_Trx	Boolean	0
34	OPEN1	Open	CB_Open	Boolean	0
35	HISTORY	History	CB_History	Boolean	0
36	STTPSTDT	Start Post Date	DATE	Date	6
37	ENDPSTDT	End Post Date	DATE	Date	6
38	DEX_ROW_ID		int	int	10
	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.

azurecurve Products Microsoft Dynamics GP (0)FinancialTransaction Analysis Report Options (DTA00700)

Leave a Reply Cancel reply