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 IDIntegerINT_STORAGE0
2COLNUM SearchCOL NUMIntegerINT_STORAGE0
3CLTKNCNT SearchCALC Token CNTIntegerINT_STORAGE0
4COLTYPE SearchCOL TypeIntegerINT_STORAGE0
5COLSIZE SearchCOL SizeIntegerINT_STORAGE0
6COLOMCNT SearchCOL Offset Mark CNTIntegerINT0
7COLOFMRK_1 SearchCOL Offset Marks[1]IntegerINT0
8COLOFMRK_2 SearchCOL Offset Marks[2]IntegerINT0
9COLOFMRK_3 SearchCOL Offset Marks[3]IntegerINT0
10COLOFMRK_4 SearchCOL Offset Marks[4]IntegerINT0
11HIDEFLAG SearchHide FlagIntegerINT_STORAGE0
12TEXTVALU SearchText ValueStringSTR5050
13STPERIOD SearchStart PeriodIntegerINT_STORAGE0
14ENDPEROD SearchEnd PeriodIntegerINT_STORAGE0
15AMNTFROM SearchAmount FromIntegerINT_STORAGE0
16HISTYEAR SearchHIST YearIntegerINT_STORAGE0
17BUDID SearchBUD IDStringSTR15_LBAU15
18PRTSIGN SearchPRT SignIntegerINT0
19PRTCOMMA SearchPRT CommaIntegerINT_STORAGE0
20PRTPCENT SearchPRT PercentIntegerINT_STORAGE0
21PRTTEXT SearchPRT TextIntegerINT_STORAGE0
22ROUNDOPT SearchRound OPTIntegerINT_STORAGE0
23HEADALIN SearchHead AlignIntegerINT_STORAGE0
24HDFTFMLY SearchHead Font FamilyIntegerINT0
25HDFTSIZE SearchHead Font SizeIntegerINT0
26HEDSTYLE_1 SearchHead Style[1]IntegerINT_STORAGE0
27HEDSTYLE_2 SearchHead Style[2]IntegerINT_STORAGE0
28HEDSTYLE_3 SearchHead Style[3]IntegerINT_STORAGE0
29HEDSTYLE_4 SearchHead Style[4]IntegerINT_STORAGE0
30HEDSTYLE_5 SearchHead Style[5]IntegerINT_STORAGE0
31HEDSTYLE_6 SearchHead Style[6]IntegerINT_STORAGE0
32HEADTYPE_1 SearchHead Type[1]IntegerINT_STORAGE0
33HEADTYPE_2 SearchHead Type[2]IntegerINT_STORAGE0
34HEADTYPE_3 SearchHead Type[3]IntegerINT_STORAGE0
35HEADTYPE_4 SearchHead Type[4]IntegerINT_STORAGE0
36HEADTYPE_5 SearchHead Type[5]IntegerINT_STORAGE0
37HEADTYPE_6 SearchHead Type[6]IntegerINT_STORAGE0
38HEDFRMAT_1 SearchHead Format[1]IntegerINT_STORAGE0
39HEDFRMAT_2 SearchHead Format[2]IntegerINT_STORAGE0
40HEDFRMAT_3 SearchHead Format[3]IntegerINT_STORAGE0
41HEDFRMAT_4 SearchHead Format[4]IntegerINT_STORAGE0
42HEDFRMAT_5 SearchHead Format[5]IntegerINT_STORAGE0
43HEDFRMAT_6 SearchHead Format[6]IntegerINT_STORAGE0
44HEADOPT_1 SearchHead OPT[1]IntegerINT_STORAGE0
45HEADOPT_2 SearchHead OPT[2]IntegerINT_STORAGE0
46HEADOPT_3 SearchHead OPT[3]IntegerINT_STORAGE0
47HEADOPT_4 SearchHead OPT[4]IntegerINT_STORAGE0
48HEADOPT_5 SearchHead OPT[5]IntegerINT_STORAGE0
49HEADOPT_6 SearchHead OPT[6]IntegerINT_STORAGE0
50HEADOPT2_1 SearchHead OPT2[1]IntegerINT_STORAGE0
51HEADOPT2_2 SearchHead OPT2[2]IntegerINT_STORAGE0
52HEADOPT2_3 SearchHead OPT2[3]IntegerINT_STORAGE0
53HEADOPT2_4 SearchHead OPT2[4]IntegerINT_STORAGE0
54HEADOPT2_5 SearchHead OPT2[5]IntegerINT_STORAGE0
55HEADOPT2_6 SearchHead OPT2[6]IntegerINT_STORAGE0
56COLHDNG_1 SearchCOL Heading[1]StringSTR5050
57COLHDNG_2 SearchCOL Heading[2]StringSTR5050
58COLHDNG_3 SearchCOL Heading[3]StringSTR5050
59COLHDNG_4 SearchCOL Heading[4]StringSTR5050
60COLHDNG_5 SearchCOL Heading[5]StringSTR5050
61COLHDNG_6 SearchCOL Heading[6]StringSTR5050
62COLHDNG2_1 SearchCOL Heading2[1]StringSTR5050
63COLHDNG2_2 SearchCOL Heading2[2]StringSTR5050
64COLHDNG2_3 SearchCOL Heading2[3]StringSTR5050
65COLHDNG2_4 SearchCOL Heading2[4]StringSTR5050
66COLHDNG2_5 SearchCOL Heading2[5]StringSTR5050
67COLHDNG2_6 SearchCOL Heading2[6]StringSTR5050
68ALGNOFST SearchAlignment OffsetIntegerINT0
69COLEXPER SearchCOL Expression ErrorBooleanBoolean0
70NOTEINDX SearchNote IndexCurrencyDLR1414
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_Pool1StringAccount_Segment_Pool16
72SEGFROM_2 SearchSEG From:Account_Segment_Pool2StringAccount_Segment_Pool26
73SEGFROM_3 SearchSEG From:Account_Segment_Pool3StringAccount_Segment_Pool36
74SEGFROM_4 SearchSEG From:Account_Segment_Pool4StringAccount_Segment_Pool46
75SEGFROM_5 SearchSEG From:Account_Segment_Pool5StringAccount_Segment_Pool56
76SEGFROM_6 SearchSEG From:Account_Segment_Pool6StringAccount_Segment_Pool66
77SEGFROM_7 SearchSEG From:Account_Segment_Pool7StringAccount_Segment_Pool76
78SEGFROM_8 SearchSEG From:Account_Segment_Pool8StringAccount_Segment_Pool86
79SEGFROM_9 SearchSEG From:Account_Segment_Pool9StringAccount_Segment_Pool96
80SEGFROM_10 SearchSEG From:Account_Segment_Pool10StringAccount_Segment_Pool106
81SEGTO_1 SearchSEG To:Account_Segment_Pool1StringAccount_Segment_Pool16
82SEGTO_2 SearchSEG To:Account_Segment_Pool2StringAccount_Segment_Pool26
83SEGTO_3 SearchSEG To:Account_Segment_Pool3StringAccount_Segment_Pool36
84SEGTO_4 SearchSEG To:Account_Segment_Pool4StringAccount_Segment_Pool46
85SEGTO_5 SearchSEG To:Account_Segment_Pool5StringAccount_Segment_Pool56
86SEGTO_6 SearchSEG To:Account_Segment_Pool6StringAccount_Segment_Pool66
87SEGTO_7 SearchSEG To:Account_Segment_Pool7StringAccount_Segment_Pool76
88SEGTO_8 SearchSEG To:Account_Segment_Pool8StringAccount_Segment_Pool86
89SEGTO_9 SearchSEG To:Account_Segment_Pool9StringAccount_Segment_Pool96
90SEGTO_10 SearchSEG To:Account_Segment_Pool10StringAccount_Segment_Pool106

Leave a Reply

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