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 IDINT_STORAGEInteger0
2ROWNUMBR SearchRow NUMINT_STORAGEInteger0
3TOTKNCNT SearchTotal Token CNTINT_STORAGEInteger0
4ROWTYPE SearchRow TypeINT_STORAGEInteger0
5ROWSIZE SearchRow SizeINT_STORAGEInteger0
6ROLUPFLG SearchRoll Up FlagINT_STORAGEInteger0
7ROWDESC SearchRow DESCSTR50String50
8SUBSUDID SearchSubsidiary IDSTR15String15
9TYPCLBAL SearchTypical BALINT_STORAGEInteger0
10CATNUMBR SearchCategory NUMINT_STORAGEInteger0
11PRTSIGN SearchPRT SignINTInteger0
12PRTHEDER SearchPRT HeaderINT_STORAGEInteger0
13CENTHEDR SearchCenter HeaderINT_STORAGEInteger0
14ROWFTFAM SearchRow Font FamilyINTInteger0
15ROWFTSIZ SearchRow Font SizeINTInteger0
16ROWSTYLE_1 SearchRow Style[1]INT_STORAGEInteger0
17ROWSTYLE_2 SearchRow Style[2]INT_STORAGEInteger0
18ROWSTYLE_3 SearchRow Style[3]INT_STORAGEInteger0
19ROWSTYLE_4 SearchRow Style[4]INT_STORAGEInteger0
20ROWSTYLE_5 SearchRow Style[5]INT_STORAGEInteger0
21ROWSTYLE_6 SearchRow Style[6]INT_STORAGEInteger0
22ROFMRKIN_1 SearchRow Offset Mark Indexes[1]INT_STORAGEInteger0
23ROFMRKIN_2 SearchRow Offset Mark Indexes[2]INT_STORAGEInteger0
24ROFMRKIN_3 SearchRow Offset Mark Indexes[3]INT_STORAGEInteger0
25ROFMRKIN_4 SearchRow Offset Mark Indexes[4]INT_STORAGEInteger0
26ROFMRKIN_5 SearchRow Offset Mark Indexes[5]INT_STORAGEInteger0
27ROFMRKIN_6 SearchRow Offset Mark Indexes[6]INT_STORAGEInteger0
28ROFMRKIN_7 SearchRow Offset Mark Indexes[7]INT_STORAGEInteger0
29ROFMRKIN_8 SearchRow Offset Mark Indexes[8]INT_STORAGEInteger0
30ROFMRKIN_9 SearchRow Offset Mark Indexes[9]INT_STORAGEInteger0
31ROFMRKIN_10 SearchRow Offset Mark Indexes[10]INT_STORAGEInteger0
32ROFMRKIN_11 SearchRow Offset Mark Indexes[11]INT_STORAGEInteger0
33ROFMRKIN_12 SearchRow Offset Mark Indexes[12]INT_STORAGEInteger0
34ROFMRKIN_13 SearchRow Offset Mark Indexes[13]INT_STORAGEInteger0
35ROFMRKIN_14 SearchRow Offset Mark Indexes[14]INT_STORAGEInteger0
36ROFMRKIN_15 SearchRow Offset Mark Indexes[15]INT_STORAGEInteger0
37ROFMRKIN_16 SearchRow Offset Mark Indexes[16]INT_STORAGEInteger0
38ROFMRKIN_17 SearchRow Offset Mark Indexes[17]INT_STORAGEInteger0
39ROFMRKIN_18 SearchRow Offset Mark Indexes[18]INT_STORAGEInteger0
40ROFMRKIN_19 SearchRow Offset Mark Indexes[19]INT_STORAGEInteger0
41ROFMRKIN_20 SearchRow Offset Mark Indexes[20]INT_STORAGEInteger0
42ROFMRKIN_21 SearchRow Offset Mark Indexes[21]INT_STORAGEInteger0
43ROFMRKIN_22 SearchRow Offset Mark Indexes[22]INT_STORAGEInteger0
44ROFMRKIN_23 SearchRow Offset Mark Indexes[23]INT_STORAGEInteger0
45ROFMRKIN_24 SearchRow Offset Mark Indexes[24]INT_STORAGEInteger0
46ROFMRKIN_25 SearchRow Offset Mark Indexes[25]INT_STORAGEInteger0
47ROFMRKIN_26 SearchRow Offset Mark Indexes[26]INT_STORAGEInteger0
48ROFMRKIN_27 SearchRow Offset Mark Indexes[27]INT_STORAGEInteger0
49ROFMRKIN_28 SearchRow Offset Mark Indexes[28]INT_STORAGEInteger0
50ROFMRKIN_29 SearchRow Offset Mark Indexes[29]INT_STORAGEInteger0
51ROFMRKIN_30 SearchRow Offset Mark Indexes[30]INT_STORAGEInteger0
52ROFMRKIN_31 SearchRow Offset Mark Indexes[31]INT_STORAGEInteger0
53ROFMRKIN_32 SearchRow Offset Mark Indexes[32]INT_STORAGEInteger0
54ROFMRKIN_33 SearchRow Offset Mark Indexes[33]INT_STORAGEInteger0
55ROFMRKIN_34 SearchRow Offset Mark Indexes[34]INT_STORAGEInteger0
56ROFMRKIN_35 SearchRow Offset Mark Indexes[35]INT_STORAGEInteger0
57ROFMRKIN_36 SearchRow Offset Mark Indexes[36]INT_STORAGEInteger0
58ROFMRKIN_37 SearchRow Offset Mark Indexes[37]INT_STORAGEInteger0
59ROFMRKIN_38 SearchRow Offset Mark Indexes[38]INT_STORAGEInteger0
60ROFMRKIN_39 SearchRow Offset Mark Indexes[39]INT_STORAGEInteger0
61ROFMRKIN_40 SearchRow Offset Mark Indexes[40]INT_STORAGEInteger0
62CFLOSCTN SearchCash Flow SectionDDL_Cash_FlowInteger0
63RWEXPERR SearchRow Expression ErrorBooleanBoolean0
64NOTEINDX SearchNote IndexDLR14Currency14
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_Pool1Account_Mask_Pool1String6
66STTACCT_2 SearchStart ACCT:Account_Mask_Pool2Account_Mask_Pool2String6
67STTACCT_3 SearchStart ACCT:Account_Mask_Pool3Account_Mask_Pool3String6
68STTACCT_4 SearchStart ACCT:Account_Mask_Pool4Account_Mask_Pool4String6
69STTACCT_5 SearchStart ACCT:Account_Mask_Pool5Account_Mask_Pool5String6
70STTACCT_6 SearchStart ACCT:Account_Mask_Pool6Account_Mask_Pool6String6
71STTACCT_7 SearchStart ACCT:Account_Mask_Pool7Account_Mask_Pool7String6
72STTACCT_8 SearchStart ACCT:Account_Mask_Pool8Account_Mask_Pool8String6
73STTACCT_9 SearchStart ACCT:Account_Mask_Pool9Account_Mask_Pool9String6
74STTACCT_10 SearchStart ACCT:Account_Mask_Pool10Account_Mask_Pool10String6
75ENDACCT_1 SearchEnd ACCT:Account_Mask_Pool1Account_Mask_Pool1String6
76ENDACCT_2 SearchEnd ACCT:Account_Mask_Pool2Account_Mask_Pool2String6
77ENDACCT_3 SearchEnd ACCT:Account_Mask_Pool3Account_Mask_Pool3String6
78ENDACCT_4 SearchEnd ACCT:Account_Mask_Pool4Account_Mask_Pool4String6
79ENDACCT_5 SearchEnd ACCT:Account_Mask_Pool5Account_Mask_Pool5String6
80ENDACCT_6 SearchEnd ACCT:Account_Mask_Pool6Account_Mask_Pool6String6
81ENDACCT_7 SearchEnd ACCT:Account_Mask_Pool7Account_Mask_Pool7String6
82ENDACCT_8 SearchEnd ACCT:Account_Mask_Pool8Account_Mask_Pool8String6
83ENDACCT_9 SearchEnd ACCT:Account_Mask_Pool9Account_Mask_Pool9String6
84ENDACCT_10 SearchEnd ACCT:Account_Mask_Pool10Account_Mask_Pool10String6
85DEX_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 *