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 TypeSQL DB LengthKeyable Length
1REPORTID SearchReport IDINT_STORAGEInteger20
2ROWNUMBR SearchRow NUMINT_STORAGEInteger20
3TOTKNCNT SearchTotal Token CNTINT_STORAGEInteger20
4ROWTYPE SearchRow TypeINT_STORAGEInteger20
5ROWSIZE SearchRow SizeINT_STORAGEInteger20
6ROLUPFLG SearchRoll Up FlagINT_STORAGEInteger20
7ROWDESC SearchRow DESCSTR50String5250
8SUBSUDID SearchSubsidiary IDSTR15String1615
9TYPCLBAL SearchTypical BALINT_STORAGEInteger20
10CATNUMBR SearchCategory NUMINT_STORAGEInteger20
11PRTSIGN SearchPRT SignINTInteger20
12PRTHEDER SearchPRT HeaderINT_STORAGEInteger20
13CENTHEDR SearchCenter HeaderINT_STORAGEInteger20
14ROWFTFAM SearchRow Font FamilyINTInteger20
15ROWFTSIZ SearchRow Font SizeINTInteger20
16ROWSTYLE_1 SearchRow Style[1]INT_STORAGEInteger20
17ROWSTYLE_2 SearchRow Style[2]INT_STORAGEInteger20
18ROWSTYLE_3 SearchRow Style[3]INT_STORAGEInteger20
19ROWSTYLE_4 SearchRow Style[4]INT_STORAGEInteger20
20ROWSTYLE_5 SearchRow Style[5]INT_STORAGEInteger20
21ROWSTYLE_6 SearchRow Style[6]INT_STORAGEInteger20
22ROFMRKIN_1 SearchRow Offset Mark Indexes[1]INT_STORAGEInteger20
23ROFMRKIN_2 SearchRow Offset Mark Indexes[2]INT_STORAGEInteger20
24ROFMRKIN_3 SearchRow Offset Mark Indexes[3]INT_STORAGEInteger20
25ROFMRKIN_4 SearchRow Offset Mark Indexes[4]INT_STORAGEInteger20
26ROFMRKIN_5 SearchRow Offset Mark Indexes[5]INT_STORAGEInteger20
27ROFMRKIN_6 SearchRow Offset Mark Indexes[6]INT_STORAGEInteger20
28ROFMRKIN_7 SearchRow Offset Mark Indexes[7]INT_STORAGEInteger20
29ROFMRKIN_8 SearchRow Offset Mark Indexes[8]INT_STORAGEInteger20
30ROFMRKIN_9 SearchRow Offset Mark Indexes[9]INT_STORAGEInteger20
31ROFMRKIN_10 SearchRow Offset Mark Indexes[10]INT_STORAGEInteger20
32ROFMRKIN_11 SearchRow Offset Mark Indexes[11]INT_STORAGEInteger20
33ROFMRKIN_12 SearchRow Offset Mark Indexes[12]INT_STORAGEInteger20
34ROFMRKIN_13 SearchRow Offset Mark Indexes[13]INT_STORAGEInteger20
35ROFMRKIN_14 SearchRow Offset Mark Indexes[14]INT_STORAGEInteger20
36ROFMRKIN_15 SearchRow Offset Mark Indexes[15]INT_STORAGEInteger20
37ROFMRKIN_16 SearchRow Offset Mark Indexes[16]INT_STORAGEInteger20
38ROFMRKIN_17 SearchRow Offset Mark Indexes[17]INT_STORAGEInteger20
39ROFMRKIN_18 SearchRow Offset Mark Indexes[18]INT_STORAGEInteger20
40ROFMRKIN_19 SearchRow Offset Mark Indexes[19]INT_STORAGEInteger20
41ROFMRKIN_20 SearchRow Offset Mark Indexes[20]INT_STORAGEInteger20
42ROFMRKIN_21 SearchRow Offset Mark Indexes[21]INT_STORAGEInteger20
43ROFMRKIN_22 SearchRow Offset Mark Indexes[22]INT_STORAGEInteger20
44ROFMRKIN_23 SearchRow Offset Mark Indexes[23]INT_STORAGEInteger20
45ROFMRKIN_24 SearchRow Offset Mark Indexes[24]INT_STORAGEInteger20
46ROFMRKIN_25 SearchRow Offset Mark Indexes[25]INT_STORAGEInteger20
47ROFMRKIN_26 SearchRow Offset Mark Indexes[26]INT_STORAGEInteger20
48ROFMRKIN_27 SearchRow Offset Mark Indexes[27]INT_STORAGEInteger20
49ROFMRKIN_28 SearchRow Offset Mark Indexes[28]INT_STORAGEInteger20
50ROFMRKIN_29 SearchRow Offset Mark Indexes[29]INT_STORAGEInteger20
51ROFMRKIN_30 SearchRow Offset Mark Indexes[30]INT_STORAGEInteger20
52ROFMRKIN_31 SearchRow Offset Mark Indexes[31]INT_STORAGEInteger20
53ROFMRKIN_32 SearchRow Offset Mark Indexes[32]INT_STORAGEInteger20
54ROFMRKIN_33 SearchRow Offset Mark Indexes[33]INT_STORAGEInteger20
55ROFMRKIN_34 SearchRow Offset Mark Indexes[34]INT_STORAGEInteger20
56ROFMRKIN_35 SearchRow Offset Mark Indexes[35]INT_STORAGEInteger20
57ROFMRKIN_36 SearchRow Offset Mark Indexes[36]INT_STORAGEInteger20
58ROFMRKIN_37 SearchRow Offset Mark Indexes[37]INT_STORAGEInteger20
59ROFMRKIN_38 SearchRow Offset Mark Indexes[38]INT_STORAGEInteger20
60ROFMRKIN_39 SearchRow Offset Mark Indexes[39]INT_STORAGEInteger20
61ROFMRKIN_40 SearchRow Offset Mark Indexes[40]INT_STORAGEInteger20
62CFLOSCTN SearchCash Flow SectionDDL_Cash_FlowInteger20
63RWEXPERR SearchRow Expression ErrorBooleanBoolean20
64NOTEINDX SearchNote IndexDLR14Currency1014
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_Pool1String86
66STTACCT_2 SearchStart ACCT:Account_Mask_Pool2Account_Mask_Pool2String86
67STTACCT_3 SearchStart ACCT:Account_Mask_Pool3Account_Mask_Pool3String86
68STTACCT_4 SearchStart ACCT:Account_Mask_Pool4Account_Mask_Pool4String86
69STTACCT_5 SearchStart ACCT:Account_Mask_Pool5Account_Mask_Pool5String86
70STTACCT_6 SearchStart ACCT:Account_Mask_Pool6Account_Mask_Pool6String86
71STTACCT_7 SearchStart ACCT:Account_Mask_Pool7Account_Mask_Pool7String86
72STTACCT_8 SearchStart ACCT:Account_Mask_Pool8Account_Mask_Pool8String86
73STTACCT_9 SearchStart ACCT:Account_Mask_Pool9Account_Mask_Pool9String86
74STTACCT_10 SearchStart ACCT:Account_Mask_Pool10Account_Mask_Pool10String86
75ENDACCT_1 SearchEnd ACCT:Account_Mask_Pool1Account_Mask_Pool1String86
76ENDACCT_2 SearchEnd ACCT:Account_Mask_Pool2Account_Mask_Pool2String86
77ENDACCT_3 SearchEnd ACCT:Account_Mask_Pool3Account_Mask_Pool3String86
78ENDACCT_4 SearchEnd ACCT:Account_Mask_Pool4Account_Mask_Pool4String86
79ENDACCT_5 SearchEnd ACCT:Account_Mask_Pool5Account_Mask_Pool5String86
80ENDACCT_6 SearchEnd ACCT:Account_Mask_Pool6Account_Mask_Pool6String86
81ENDACCT_7 SearchEnd ACCT:Account_Mask_Pool7Account_Mask_Pool7String86
82ENDACCT_8 SearchEnd ACCT:Account_Mask_Pool8Account_Mask_Pool8String86
83ENDACCT_9 SearchEnd ACCT:Account_Mask_Pool9Account_Mask_Pool9String86
84ENDACCT_10 SearchEnd ACCT:Account_Mask_Pool10Account_Mask_Pool10String86
85DEX_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 *