Financials Column Setup (AF40103)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Financials Column Setup
Physical Name: AF40103
Technical Name: AF_Report_Column_SETP

Group Display Name: Financials Setup
Group Technical Name: Financials Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1REPORTID SearchReport IDINT_STORAGEInteger0
2COLNUM SearchCOL NUMINT_STORAGEInteger0
3CLTKNCNT SearchCALC Token CNTINT_STORAGEInteger0
4COLTYPE SearchCOL TypeINT_STORAGEInteger0
5COLSIZE SearchCOL SizeINT_STORAGEInteger0
6COLOMCNT SearchCOL Offset Mark CNTINTInteger0
7COLOFMRK_1 SearchCOL Offset Marks[1]INTInteger0
8COLOFMRK_2 SearchCOL Offset Marks[2]INTInteger0
9COLOFMRK_3 SearchCOL Offset Marks[3]INTInteger0
10COLOFMRK_4 SearchCOL Offset Marks[4]INTInteger0
11HIDEFLAG SearchHide FlagINT_STORAGEInteger0
12TEXTVALU SearchText ValueSTR50String50
13STPERIOD SearchStart PeriodINT_STORAGEInteger0
14ENDPEROD SearchEnd PeriodINT_STORAGEInteger0
15AMNTFROM SearchAmount FromINT_STORAGEInteger0
16HISTYEAR SearchHIST YearINT_STORAGEInteger0
17BUDID SearchBUD IDSTR15_LBAUString15
18PRTSIGN SearchPRT SignINTInteger0
19PRTCOMMA SearchPRT CommaINT_STORAGEInteger0
20PRTPCENT SearchPRT PercentINT_STORAGEInteger0
21PRTTEXT SearchPRT TextINT_STORAGEInteger0
22ROUNDOPT SearchRound OPTINT_STORAGEInteger0
23HEADALIN SearchHead AlignINT_STORAGEInteger0
24HDFTFMLY SearchHead Font FamilyINTInteger0
25HDFTSIZE SearchHead Font SizeINTInteger0
26HEDSTYLE_1 SearchHead Style[1]INT_STORAGEInteger0
27HEDSTYLE_2 SearchHead Style[2]INT_STORAGEInteger0
28HEDSTYLE_3 SearchHead Style[3]INT_STORAGEInteger0
29HEDSTYLE_4 SearchHead Style[4]INT_STORAGEInteger0
30HEDSTYLE_5 SearchHead Style[5]INT_STORAGEInteger0
31HEDSTYLE_6 SearchHead Style[6]INT_STORAGEInteger0
32HEADTYPE_1 SearchHead Type[1]INT_STORAGEInteger0
33HEADTYPE_2 SearchHead Type[2]INT_STORAGEInteger0
34HEADTYPE_3 SearchHead Type[3]INT_STORAGEInteger0
35HEADTYPE_4 SearchHead Type[4]INT_STORAGEInteger0
36HEADTYPE_5 SearchHead Type[5]INT_STORAGEInteger0
37HEADTYPE_6 SearchHead Type[6]INT_STORAGEInteger0
38HEDFRMAT_1 SearchHead Format[1]INT_STORAGEInteger0
39HEDFRMAT_2 SearchHead Format[2]INT_STORAGEInteger0
40HEDFRMAT_3 SearchHead Format[3]INT_STORAGEInteger0
41HEDFRMAT_4 SearchHead Format[4]INT_STORAGEInteger0
42HEDFRMAT_5 SearchHead Format[5]INT_STORAGEInteger0
43HEDFRMAT_6 SearchHead Format[6]INT_STORAGEInteger0
44HEADOPT_1 SearchHead OPT[1]INT_STORAGEInteger0
45HEADOPT_2 SearchHead OPT[2]INT_STORAGEInteger0
46HEADOPT_3 SearchHead OPT[3]INT_STORAGEInteger0
47HEADOPT_4 SearchHead OPT[4]INT_STORAGEInteger0
48HEADOPT_5 SearchHead OPT[5]INT_STORAGEInteger0
49HEADOPT_6 SearchHead OPT[6]INT_STORAGEInteger0
50HEADOPT2_1 SearchHead OPT2[1]INT_STORAGEInteger0
51HEADOPT2_2 SearchHead OPT2[2]INT_STORAGEInteger0
52HEADOPT2_3 SearchHead OPT2[3]INT_STORAGEInteger0
53HEADOPT2_4 SearchHead OPT2[4]INT_STORAGEInteger0
54HEADOPT2_5 SearchHead OPT2[5]INT_STORAGEInteger0
55HEADOPT2_6 SearchHead OPT2[6]INT_STORAGEInteger0
56COLHDNG_1 SearchCOL Heading[1]STR50String50
57COLHDNG_2 SearchCOL Heading[2]STR50String50
58COLHDNG_3 SearchCOL Heading[3]STR50String50
59COLHDNG_4 SearchCOL Heading[4]STR50String50
60COLHDNG_5 SearchCOL Heading[5]STR50String50
61COLHDNG_6 SearchCOL Heading[6]STR50String50
62COLHDNG2_1 SearchCOL Heading2[1]STR50String50
63COLHDNG2_2 SearchCOL Heading2[2]STR50String50
64COLHDNG2_3 SearchCOL Heading2[3]STR50String50
65COLHDNG2_4 SearchCOL Heading2[4]STR50String50
66COLHDNG2_5 SearchCOL Heading2[5]STR50String50
67COLHDNG2_6 SearchCOL Heading2[6]STR50String50
68ALGNOFST SearchAlignment OffsetINTInteger0
69COLEXPER SearchCOL Expression ErrorBooleanBoolean0
70NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Financials Column Setup'].NOTEINDX AS 'Financials Column Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       AF40103 AS ['Financials Column Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Financials Column Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
71SEGFROM_1 SearchSEG From:Account_Segment_Pool1Account_Segment_Pool1String6
72SEGFROM_2 SearchSEG From:Account_Segment_Pool2Account_Segment_Pool2String6
73SEGFROM_3 SearchSEG From:Account_Segment_Pool3Account_Segment_Pool3String6
74SEGFROM_4 SearchSEG From:Account_Segment_Pool4Account_Segment_Pool4String6
75SEGFROM_5 SearchSEG From:Account_Segment_Pool5Account_Segment_Pool5String6
76SEGFROM_6 SearchSEG From:Account_Segment_Pool6Account_Segment_Pool6String6
77SEGFROM_7 SearchSEG From:Account_Segment_Pool7Account_Segment_Pool7String6
78SEGFROM_8 SearchSEG From:Account_Segment_Pool8Account_Segment_Pool8String6
79SEGFROM_9 SearchSEG From:Account_Segment_Pool9Account_Segment_Pool9String6
80SEGFROM_10 SearchSEG From:Account_Segment_Pool10Account_Segment_Pool10String6
81SEGTO_1 SearchSEG To:Account_Segment_Pool1Account_Segment_Pool1String6
82SEGTO_2 SearchSEG To:Account_Segment_Pool2Account_Segment_Pool2String6
83SEGTO_3 SearchSEG To:Account_Segment_Pool3Account_Segment_Pool3String6
84SEGTO_4 SearchSEG To:Account_Segment_Pool4Account_Segment_Pool4String6
85SEGTO_5 SearchSEG To:Account_Segment_Pool5Account_Segment_Pool5String6
86SEGTO_6 SearchSEG To:Account_Segment_Pool6Account_Segment_Pool6String6
87SEGTO_7 SearchSEG To:Account_Segment_Pool7Account_Segment_Pool7String6
88SEGTO_8 SearchSEG To:Account_Segment_Pool8Account_Segment_Pool8String6
89SEGTO_9 SearchSEG To:Account_Segment_Pool9Account_Segment_Pool9String6
90SEGTO_10 SearchSEG To:Account_Segment_Pool10Account_Segment_Pool10String6
91DEX_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 *