Report Column Temporary (AF50300)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Report Column Temporary
Physical Name: AF50300
Technical Name: AF_Report_Column_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Report Column Temporary'].USERID AS 'Report Column Temporary-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       AF50300 AS ['Report Column Temporary']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Report Column Temporary'].USERID = ['Users Master'].USERID
2REPORTID SearchReport IDINT_STORAGEInteger0
3RPTGRIND SearchReport Group IndexINTInteger0
4RTPACHIN SearchReport Palette Choice IndexINTInteger0
5RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
6COLNUM SearchCOL NUMINT_STORAGEInteger0
7CLTKNCNT SearchCALC Token CNTINT_STORAGEInteger0
8COLTYPE SearchCOL TypeINT_STORAGEInteger0
9COLSIZE SearchCOL SizeINT_STORAGEInteger0
10COLOFMRK_1 SearchCOL Offset Marks[1]INTInteger0
11COLOFMRK_2 SearchCOL Offset Marks[2]INTInteger0
12COLOFMRK_3 SearchCOL Offset Marks[3]INTInteger0
13COLOFMRK_4 SearchCOL Offset Marks[4]INTInteger0
14COLOMCNT SearchCOL Offset Mark CNTINTInteger0
15HIDEFLAG SearchHide FlagINT_STORAGEInteger0
16TEXTVALU SearchText ValueSTR50String50
17STPERIOD SearchStart PeriodINT_STORAGEInteger0
18ENDPEROD SearchEnd PeriodINT_STORAGEInteger0
19SEGFROM_1 SearchSEG From:Account_Segment_Pool1Account_Segment_Pool1String6
20SEGFROM_2 SearchSEG From:Account_Segment_Pool2Account_Segment_Pool2String6
21SEGFROM_3 SearchSEG From:Account_Segment_Pool3Account_Segment_Pool3String6
22SEGFROM_4 SearchSEG From:Account_Segment_Pool4Account_Segment_Pool4String6
23SEGFROM_5 SearchSEG From:Account_Segment_Pool5Account_Segment_Pool5String6
24SEGFROM_6 SearchSEG From:Account_Segment_Pool6Account_Segment_Pool6String6
25SEGFROM_7 SearchSEG From:Account_Segment_Pool7Account_Segment_Pool7String6
26SEGFROM_8 SearchSEG From:Account_Segment_Pool8Account_Segment_Pool8String6
27SEGFROM_9 SearchSEG From:Account_Segment_Pool9Account_Segment_Pool9String6
28SEGFROM_10 SearchSEG From:Account_Segment_Pool10Account_Segment_Pool10String6
29SEGTO_1 SearchSEG To:Account_Segment_Pool1Account_Segment_Pool1String6
30SEGTO_2 SearchSEG To:Account_Segment_Pool2Account_Segment_Pool2String6
31SEGTO_3 SearchSEG To:Account_Segment_Pool3Account_Segment_Pool3String6
32SEGTO_4 SearchSEG To:Account_Segment_Pool4Account_Segment_Pool4String6
33SEGTO_5 SearchSEG To:Account_Segment_Pool5Account_Segment_Pool5String6
34SEGTO_6 SearchSEG To:Account_Segment_Pool6Account_Segment_Pool6String6
35SEGTO_7 SearchSEG To:Account_Segment_Pool7Account_Segment_Pool7String6
36SEGTO_8 SearchSEG To:Account_Segment_Pool8Account_Segment_Pool8String6
37SEGTO_9 SearchSEG To:Account_Segment_Pool9Account_Segment_Pool9String6
38SEGTO_10 SearchSEG To:Account_Segment_Pool10Account_Segment_Pool10String6
39AMNTFROM SearchAmount FromINT_STORAGEInteger0
40HISTYEAR SearchHIST YearINT_STORAGEInteger0
41BUDID SearchBUD IDSTR15_LBAUString15
42PRTSIGN SearchPRT SignINTInteger0
43PRTCOMMA SearchPRT CommaINT_STORAGEInteger0
44PRTPCENT SearchPRT PercentINT_STORAGEInteger0
45PRTTEXT SearchPRT TextINT_STORAGEInteger0
46ROUNDOPT SearchRound OPTINT_STORAGEInteger0
47HEADALIN SearchHead AlignINT_STORAGEInteger0
48HDFTFMLY SearchHead Font FamilyINTInteger0
49HDFTSIZE SearchHead Font SizeINTInteger0
50HEDSTYLE_1 SearchHead Style[1]INT_STORAGEInteger0
51HEDSTYLE_2 SearchHead Style[2]INT_STORAGEInteger0
52HEDSTYLE_3 SearchHead Style[3]INT_STORAGEInteger0
53HEDSTYLE_4 SearchHead Style[4]INT_STORAGEInteger0
54HEDSTYLE_5 SearchHead Style[5]INT_STORAGEInteger0
55HEDSTYLE_6 SearchHead Style[6]INT_STORAGEInteger0
56HEADTYPE_1 SearchHead Type[1]INT_STORAGEInteger0
57HEADTYPE_2 SearchHead Type[2]INT_STORAGEInteger0
58HEADTYPE_3 SearchHead Type[3]INT_STORAGEInteger0
59HEADTYPE_4 SearchHead Type[4]INT_STORAGEInteger0
60HEADTYPE_5 SearchHead Type[5]INT_STORAGEInteger0
61HEADTYPE_6 SearchHead Type[6]INT_STORAGEInteger0
62HEDFRMAT_1 SearchHead Format[1]INT_STORAGEInteger0
63HEDFRMAT_2 SearchHead Format[2]INT_STORAGEInteger0
64HEDFRMAT_3 SearchHead Format[3]INT_STORAGEInteger0
65HEDFRMAT_4 SearchHead Format[4]INT_STORAGEInteger0
66HEDFRMAT_5 SearchHead Format[5]INT_STORAGEInteger0
67HEDFRMAT_6 SearchHead Format[6]INT_STORAGEInteger0
68HEADOPT_1 SearchHead OPT[1]INT_STORAGEInteger0
69HEADOPT_2 SearchHead OPT[2]INT_STORAGEInteger0
70HEADOPT_3 SearchHead OPT[3]INT_STORAGEInteger0
71HEADOPT_4 SearchHead OPT[4]INT_STORAGEInteger0
72HEADOPT_5 SearchHead OPT[5]INT_STORAGEInteger0
73HEADOPT_6 SearchHead OPT[6]INT_STORAGEInteger0
74HEADOPT2_1 SearchHead OPT2[1]INT_STORAGEInteger0
75HEADOPT2_2 SearchHead OPT2[2]INT_STORAGEInteger0
76HEADOPT2_3 SearchHead OPT2[3]INT_STORAGEInteger0
77HEADOPT2_4 SearchHead OPT2[4]INT_STORAGEInteger0
78HEADOPT2_5 SearchHead OPT2[5]INT_STORAGEInteger0
79HEADOPT2_6 SearchHead OPT2[6]INT_STORAGEInteger0
80COLHDNG_1 SearchCOL Heading[1]STR50String50
81COLHDNG_2 SearchCOL Heading[2]STR50String50
82COLHDNG_3 SearchCOL Heading[3]STR50String50
83COLHDNG_4 SearchCOL Heading[4]STR50String50
84COLHDNG_5 SearchCOL Heading[5]STR50String50
85COLHDNG_6 SearchCOL Heading[6]STR50String50
86COLHDNG2_1 SearchCOL Heading2[1]STR50String50
87COLHDNG2_2 SearchCOL Heading2[2]STR50String50
88COLHDNG2_3 SearchCOL Heading2[3]STR50String50
89COLHDNG2_4 SearchCOL Heading2[4]STR50String50
90COLHDNG2_5 SearchCOL Heading2[5]STR50String50
91COLHDNG2_6 SearchCOL Heading2[6]STR50String50
92ALGNOFST SearchAlignment OffsetINTInteger0
93COLEXPER SearchCOL Expression ErrorBooleanBoolean0
94NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Report Column Temporary'].NOTEINDX AS 'Report Column Temporary-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       AF50300 AS ['Report Column Temporary']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Report Column Temporary'].NOTEINDX = ['Record Notes Master'].NOTEINDX
95DEX_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.

Leave a Reply

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