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