Financials Row Setup (AF40106)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Financials Row Setup
Physical Name: AF40106
Technical Name: AF_Report_Row_SETP

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1REPORTID SearchReport IDIntegerINT_STORAGE0
2ROWNUMBR SearchRow NUMIntegerINT_STORAGE0
3TOTKNCNT SearchTotal Token CNTIntegerINT_STORAGE0
4ROWTYPE SearchRow TypeIntegerINT_STORAGE0
5ROWSIZE SearchRow SizeIntegerINT_STORAGE0
6ROLUPFLG SearchRoll Up FlagIntegerINT_STORAGE0
7ROWDESC SearchRow DESCStringSTR5050
8SUBSUDID SearchSubsidiary IDStringSTR1515
9TYPCLBAL SearchTypical BALIntegerINT_STORAGE0
10CATNUMBR SearchCategory NUMIntegerINT_STORAGE0
11PRTSIGN SearchPRT SignIntegerINT0
12PRTHEDER SearchPRT HeaderIntegerINT_STORAGE0
13CENTHEDR SearchCenter HeaderIntegerINT_STORAGE0
14ROWFTFAM SearchRow Font FamilyIntegerINT0
15ROWFTSIZ SearchRow Font SizeIntegerINT0
16ROWSTYLE_1 SearchRow Style[1]IntegerINT_STORAGE0
17ROWSTYLE_2 SearchRow Style[2]IntegerINT_STORAGE0
18ROWSTYLE_3 SearchRow Style[3]IntegerINT_STORAGE0
19ROWSTYLE_4 SearchRow Style[4]IntegerINT_STORAGE0
20ROWSTYLE_5 SearchRow Style[5]IntegerINT_STORAGE0
21ROWSTYLE_6 SearchRow Style[6]IntegerINT_STORAGE0
22ROFMRKIN_1 SearchRow Offset Mark Indexes[1]IntegerINT_STORAGE0
23ROFMRKIN_2 SearchRow Offset Mark Indexes[2]IntegerINT_STORAGE0
24ROFMRKIN_3 SearchRow Offset Mark Indexes[3]IntegerINT_STORAGE0
25ROFMRKIN_4 SearchRow Offset Mark Indexes[4]IntegerINT_STORAGE0
26ROFMRKIN_5 SearchRow Offset Mark Indexes[5]IntegerINT_STORAGE0
27ROFMRKIN_6 SearchRow Offset Mark Indexes[6]IntegerINT_STORAGE0
28ROFMRKIN_7 SearchRow Offset Mark Indexes[7]IntegerINT_STORAGE0
29ROFMRKIN_8 SearchRow Offset Mark Indexes[8]IntegerINT_STORAGE0
30ROFMRKIN_9 SearchRow Offset Mark Indexes[9]IntegerINT_STORAGE0
31ROFMRKIN_10 SearchRow Offset Mark Indexes[10]IntegerINT_STORAGE0
32ROFMRKIN_11 SearchRow Offset Mark Indexes[11]IntegerINT_STORAGE0
33ROFMRKIN_12 SearchRow Offset Mark Indexes[12]IntegerINT_STORAGE0
34ROFMRKIN_13 SearchRow Offset Mark Indexes[13]IntegerINT_STORAGE0
35ROFMRKIN_14 SearchRow Offset Mark Indexes[14]IntegerINT_STORAGE0
36ROFMRKIN_15 SearchRow Offset Mark Indexes[15]IntegerINT_STORAGE0
37ROFMRKIN_16 SearchRow Offset Mark Indexes[16]IntegerINT_STORAGE0
38ROFMRKIN_17 SearchRow Offset Mark Indexes[17]IntegerINT_STORAGE0
39ROFMRKIN_18 SearchRow Offset Mark Indexes[18]IntegerINT_STORAGE0
40ROFMRKIN_19 SearchRow Offset Mark Indexes[19]IntegerINT_STORAGE0
41ROFMRKIN_20 SearchRow Offset Mark Indexes[20]IntegerINT_STORAGE0
42ROFMRKIN_21 SearchRow Offset Mark Indexes[21]IntegerINT_STORAGE0
43ROFMRKIN_22 SearchRow Offset Mark Indexes[22]IntegerINT_STORAGE0
44ROFMRKIN_23 SearchRow Offset Mark Indexes[23]IntegerINT_STORAGE0
45ROFMRKIN_24 SearchRow Offset Mark Indexes[24]IntegerINT_STORAGE0
46ROFMRKIN_25 SearchRow Offset Mark Indexes[25]IntegerINT_STORAGE0
47ROFMRKIN_26 SearchRow Offset Mark Indexes[26]IntegerINT_STORAGE0
48ROFMRKIN_27 SearchRow Offset Mark Indexes[27]IntegerINT_STORAGE0
49ROFMRKIN_28 SearchRow Offset Mark Indexes[28]IntegerINT_STORAGE0
50ROFMRKIN_29 SearchRow Offset Mark Indexes[29]IntegerINT_STORAGE0
51ROFMRKIN_30 SearchRow Offset Mark Indexes[30]IntegerINT_STORAGE0
52ROFMRKIN_31 SearchRow Offset Mark Indexes[31]IntegerINT_STORAGE0
53ROFMRKIN_32 SearchRow Offset Mark Indexes[32]IntegerINT_STORAGE0
54ROFMRKIN_33 SearchRow Offset Mark Indexes[33]IntegerINT_STORAGE0
55ROFMRKIN_34 SearchRow Offset Mark Indexes[34]IntegerINT_STORAGE0
56ROFMRKIN_35 SearchRow Offset Mark Indexes[35]IntegerINT_STORAGE0
57ROFMRKIN_36 SearchRow Offset Mark Indexes[36]IntegerINT_STORAGE0
58ROFMRKIN_37 SearchRow Offset Mark Indexes[37]IntegerINT_STORAGE0
59ROFMRKIN_38 SearchRow Offset Mark Indexes[38]IntegerINT_STORAGE0
60ROFMRKIN_39 SearchRow Offset Mark Indexes[39]IntegerINT_STORAGE0
61ROFMRKIN_40 SearchRow Offset Mark Indexes[40]IntegerINT_STORAGE0
62CFLOSCTN SearchCash Flow SectionIntegerDDL_Cash_Flow0
63RWEXPERR SearchRow Expression ErrorBooleanBoolean0
64NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Financials Row Setup'].NOTEINDX AS 'Financials Row Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       AF40106 AS ['Financials Row Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Financials Row Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
65STTACCT_1 SearchStart ACCT:Account_Mask_Pool1StringAccount_Mask_Pool16
66STTACCT_2 SearchStart ACCT:Account_Mask_Pool2StringAccount_Mask_Pool26
67STTACCT_3 SearchStart ACCT:Account_Mask_Pool3StringAccount_Mask_Pool36
68STTACCT_4 SearchStart ACCT:Account_Mask_Pool4StringAccount_Mask_Pool46
69STTACCT_5 SearchStart ACCT:Account_Mask_Pool5StringAccount_Mask_Pool56
70STTACCT_6 SearchStart ACCT:Account_Mask_Pool6StringAccount_Mask_Pool66
71STTACCT_7 SearchStart ACCT:Account_Mask_Pool7StringAccount_Mask_Pool76
72STTACCT_8 SearchStart ACCT:Account_Mask_Pool8StringAccount_Mask_Pool86
73STTACCT_9 SearchStart ACCT:Account_Mask_Pool9StringAccount_Mask_Pool96
74STTACCT_10 SearchStart ACCT:Account_Mask_Pool10StringAccount_Mask_Pool106
75ENDACCT_1 SearchEnd ACCT:Account_Mask_Pool1StringAccount_Mask_Pool16
76ENDACCT_2 SearchEnd ACCT:Account_Mask_Pool2StringAccount_Mask_Pool26
77ENDACCT_3 SearchEnd ACCT:Account_Mask_Pool3StringAccount_Mask_Pool36
78ENDACCT_4 SearchEnd ACCT:Account_Mask_Pool4StringAccount_Mask_Pool46
79ENDACCT_5 SearchEnd ACCT:Account_Mask_Pool5StringAccount_Mask_Pool56
80ENDACCT_6 SearchEnd ACCT:Account_Mask_Pool6StringAccount_Mask_Pool66
81ENDACCT_7 SearchEnd ACCT:Account_Mask_Pool7StringAccount_Mask_Pool76
82ENDACCT_8 SearchEnd ACCT:Account_Mask_Pool8StringAccount_Mask_Pool86
83ENDACCT_9 SearchEnd ACCT:Account_Mask_Pool9StringAccount_Mask_Pool96
84ENDACCT_10 SearchEnd ACCT:Account_Mask_Pool10StringAccount_Mask_Pool106

Leave a Reply

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