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 TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
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_STORAGEInteger20
3RPTGRIND SearchReport Group IndexINTInteger20
4RTPACHIN SearchReport Palette Choice IndexINTInteger20
5RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
6COLNUM SearchCOL NUMINT_STORAGEInteger20
7CLTKNCNT SearchCALC Token CNTINT_STORAGEInteger20
8COLTYPE SearchCOL TypeINT_STORAGEInteger20
9COLSIZE SearchCOL SizeINT_STORAGEInteger20
10COLOFMRK_1 SearchCOL Offset Marks[1]INTInteger20
11COLOFMRK_2 SearchCOL Offset Marks[2]INTInteger20
12COLOFMRK_3 SearchCOL Offset Marks[3]INTInteger20
13COLOFMRK_4 SearchCOL Offset Marks[4]INTInteger20
14COLOMCNT SearchCOL Offset Mark CNTINTInteger20
15HIDEFLAG SearchHide FlagINT_STORAGEInteger20
16TEXTVALU SearchText ValueSTR50String5250
17STPERIOD SearchStart PeriodINT_STORAGEInteger20
18ENDPEROD SearchEnd PeriodINT_STORAGEInteger20
19SEGFROM_1 SearchSEG From:Account_Segment_Pool1Account_Segment_Pool1String86
20SEGFROM_2 SearchSEG From:Account_Segment_Pool2Account_Segment_Pool2String86
21SEGFROM_3 SearchSEG From:Account_Segment_Pool3Account_Segment_Pool3String86
22SEGFROM_4 SearchSEG From:Account_Segment_Pool4Account_Segment_Pool4String86
23SEGFROM_5 SearchSEG From:Account_Segment_Pool5Account_Segment_Pool5String86
24SEGFROM_6 SearchSEG From:Account_Segment_Pool6Account_Segment_Pool6String86
25SEGFROM_7 SearchSEG From:Account_Segment_Pool7Account_Segment_Pool7String86
26SEGFROM_8 SearchSEG From:Account_Segment_Pool8Account_Segment_Pool8String86
27SEGFROM_9 SearchSEG From:Account_Segment_Pool9Account_Segment_Pool9String86
28SEGFROM_10 SearchSEG From:Account_Segment_Pool10Account_Segment_Pool10String86
29SEGTO_1 SearchSEG To:Account_Segment_Pool1Account_Segment_Pool1String86
30SEGTO_2 SearchSEG To:Account_Segment_Pool2Account_Segment_Pool2String86
31SEGTO_3 SearchSEG To:Account_Segment_Pool3Account_Segment_Pool3String86
32SEGTO_4 SearchSEG To:Account_Segment_Pool4Account_Segment_Pool4String86
33SEGTO_5 SearchSEG To:Account_Segment_Pool5Account_Segment_Pool5String86
34SEGTO_6 SearchSEG To:Account_Segment_Pool6Account_Segment_Pool6String86
35SEGTO_7 SearchSEG To:Account_Segment_Pool7Account_Segment_Pool7String86
36SEGTO_8 SearchSEG To:Account_Segment_Pool8Account_Segment_Pool8String86
37SEGTO_9 SearchSEG To:Account_Segment_Pool9Account_Segment_Pool9String86
38SEGTO_10 SearchSEG To:Account_Segment_Pool10Account_Segment_Pool10String86
39AMNTFROM SearchAmount FromINT_STORAGEInteger20
40HISTYEAR SearchHIST YearINT_STORAGEInteger20
41BUDID SearchBUD IDSTR15_LBAUString1615
42PRTSIGN SearchPRT SignINTInteger20
43PRTCOMMA SearchPRT CommaINT_STORAGEInteger20
44PRTPCENT SearchPRT PercentINT_STORAGEInteger20
45PRTTEXT SearchPRT TextINT_STORAGEInteger20
46ROUNDOPT SearchRound OPTINT_STORAGEInteger20
47HEADALIN SearchHead AlignINT_STORAGEInteger20
48HDFTFMLY SearchHead Font FamilyINTInteger20
49HDFTSIZE SearchHead Font SizeINTInteger20
50HEDSTYLE_1 SearchHead Style[1]INT_STORAGEInteger20
51HEDSTYLE_2 SearchHead Style[2]INT_STORAGEInteger20
52HEDSTYLE_3 SearchHead Style[3]INT_STORAGEInteger20
53HEDSTYLE_4 SearchHead Style[4]INT_STORAGEInteger20
54HEDSTYLE_5 SearchHead Style[5]INT_STORAGEInteger20
55HEDSTYLE_6 SearchHead Style[6]INT_STORAGEInteger20
56HEADTYPE_1 SearchHead Type[1]INT_STORAGEInteger20
57HEADTYPE_2 SearchHead Type[2]INT_STORAGEInteger20
58HEADTYPE_3 SearchHead Type[3]INT_STORAGEInteger20
59HEADTYPE_4 SearchHead Type[4]INT_STORAGEInteger20
60HEADTYPE_5 SearchHead Type[5]INT_STORAGEInteger20
61HEADTYPE_6 SearchHead Type[6]INT_STORAGEInteger20
62HEDFRMAT_1 SearchHead Format[1]INT_STORAGEInteger20
63HEDFRMAT_2 SearchHead Format[2]INT_STORAGEInteger20
64HEDFRMAT_3 SearchHead Format[3]INT_STORAGEInteger20
65HEDFRMAT_4 SearchHead Format[4]INT_STORAGEInteger20
66HEDFRMAT_5 SearchHead Format[5]INT_STORAGEInteger20
67HEDFRMAT_6 SearchHead Format[6]INT_STORAGEInteger20
68HEADOPT_1 SearchHead OPT[1]INT_STORAGEInteger20
69HEADOPT_2 SearchHead OPT[2]INT_STORAGEInteger20
70HEADOPT_3 SearchHead OPT[3]INT_STORAGEInteger20
71HEADOPT_4 SearchHead OPT[4]INT_STORAGEInteger20
72HEADOPT_5 SearchHead OPT[5]INT_STORAGEInteger20
73HEADOPT_6 SearchHead OPT[6]INT_STORAGEInteger20
74HEADOPT2_1 SearchHead OPT2[1]INT_STORAGEInteger20
75HEADOPT2_2 SearchHead OPT2[2]INT_STORAGEInteger20
76HEADOPT2_3 SearchHead OPT2[3]INT_STORAGEInteger20
77HEADOPT2_4 SearchHead OPT2[4]INT_STORAGEInteger20
78HEADOPT2_5 SearchHead OPT2[5]INT_STORAGEInteger20
79HEADOPT2_6 SearchHead OPT2[6]INT_STORAGEInteger20
80COLHDNG_1 SearchCOL Heading[1]STR50String5250
81COLHDNG_2 SearchCOL Heading[2]STR50String5250
82COLHDNG_3 SearchCOL Heading[3]STR50String5250
83COLHDNG_4 SearchCOL Heading[4]STR50String5250
84COLHDNG_5 SearchCOL Heading[5]STR50String5250
85COLHDNG_6 SearchCOL Heading[6]STR50String5250
86COLHDNG2_1 SearchCOL Heading2[1]STR50String5250
87COLHDNG2_2 SearchCOL Heading2[2]STR50String5250
88COLHDNG2_3 SearchCOL Heading2[3]STR50String5250
89COLHDNG2_4 SearchCOL Heading2[4]STR50String5250
90COLHDNG2_5 SearchCOL Heading2[5]STR50String5250
91COLHDNG2_6 SearchCOL Heading2[6]STR50String5250
92ALGNOFST SearchAlignment OffsetINTInteger20
93COLEXPER SearchCOL Expression ErrorBooleanBoolean20
94NOTEINDX SearchNote IndexDLR14Currency1014
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 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.

Leave a Reply

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