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 Group Display Name: Transaction Analysis Table Group
Physical Name: DTA00700
Technical Name: DTA_Analysis_ROPT
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. |