Financials Layout Setup (AF40101)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Financials Layout Setup
Physical Name: AF40101
Technical Name: AF_Report_Layout_SETP

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1REPORTID SearchReport IDINT_STORAGEInteger0
2MNHDRCNT SearchMain Header CNTINT_STORAGEInteger0
3MNFTRCNT SearchMain Footer CNTINT_STORAGEInteger0
4SHDRCNT SearchSubheader CNTINT_STORAGEInteger0
5SFTRCNT SearchSubfooter CNTINT_STORAGEInteger0
6ROWCNT1 SearchRow CNTINT_STORAGEInteger0
7COLCNT SearchCOL CNTINT_STORAGEInteger0
8SHDRPCNT SearchSubheader Proper CNTINTInteger0
9SFTRPCNT SearchSubfooter Proper CNTINTInteger0
10MNHDRFLG SearchMain Header FlagINTInteger0
11MNFTRFLG SearchMain Footer FlagINTInteger0
12SHDRFLAG SearchSubheader FlagINTInteger0
13SFTRFLAG SearchSubfooter FlagINTInteger0
14MNHDRSIZ SearchMain Header SizeINT_STORAGEInteger0
15MNFTRSIZ SearchMain Footer SizeINT_STORAGEInteger0
16SHDRSIZE_1 SearchSubheader Size[1]INT_STORAGEInteger0
17SHDRSIZE_2 SearchSubheader Size[2]INT_STORAGEInteger0
18SHDRSIZE_3 SearchSubheader Size[3]INT_STORAGEInteger0
19SHDRSIZE_4 SearchSubheader Size[4]INT_STORAGEInteger0
20SHDRSIZE_5 SearchSubheader Size[5]INT_STORAGEInteger0
21SFTRSIZE_1 SearchSubfooter Size[1]INT_STORAGEInteger0
22SFTRSIZE_2 SearchSubfooter Size[2]INT_STORAGEInteger0
23SFTRSIZE_3 SearchSubfooter Size[3]INT_STORAGEInteger0
24SFTRSIZE_4 SearchSubfooter Size[4]INT_STORAGEInteger0
25SFTRSIZE_5 SearchSubfooter Size[5]INT_STORAGEInteger0
26SHDROPT_1 SearchSubheader OPT[1]INT_STORAGEInteger0
27SHDROPT_2 SearchSubheader OPT[2]INT_STORAGEInteger0
28SHDROPT_3 SearchSubheader OPT[3]INT_STORAGEInteger0
29SHDROPT_4 SearchSubheader OPT[4]INT_STORAGEInteger0
30SHDROPT_5 SearchSubheader OPT[5]INT_STORAGEInteger0
31SHDRPRT_1 SearchSubheader PRT[1]INT_STORAGEInteger0
32SHDRPRT_2 SearchSubheader PRT[2]INT_STORAGEInteger0
33SHDRPRT_3 SearchSubheader PRT[3]INT_STORAGEInteger0
34SHDRPRT_4 SearchSubheader PRT[4]INT_STORAGEInteger0
35SHDRPRT_5 SearchSubheader PRT[5]INT_STORAGEInteger0
36SFTROPT_1 SearchSubfooter OPT[1]INT_STORAGEInteger0
37SFTROPT_2 SearchSubfooter OPT[2]INT_STORAGEInteger0
38SFTROPT_3 SearchSubfooter OPT[3]INT_STORAGEInteger0
39SFTROPT_4 SearchSubfooter OPT[4]INT_STORAGEInteger0
40SFTROPT_5 SearchSubfooter OPT[5]INT_STORAGEInteger0
41SFTRPRT_1 SearchSubfooter PRT[1]INT_STORAGEInteger0
42SFTRPRT_2 SearchSubfooter PRT[2]INT_STORAGEInteger0
43SFTRPRT_3 SearchSubfooter PRT[3]INT_STORAGEInteger0
44SFTRPRT_4 SearchSubfooter PRT[4]INT_STORAGEInteger0
45SFTRPRT_5 SearchSubfooter PRT[5]INT_STORAGEInteger0
46COLHDCNT SearchCOL Heading CNTINT_STORAGEInteger0
47COLDHSIZ_1 SearchCOL Heading Size[1]INT_STORAGEInteger0
48COLDHSIZ_2 SearchCOL Heading Size[2]INT_STORAGEInteger0
49COLDHSIZ_3 SearchCOL Heading Size[3]INT_STORAGEInteger0
50COLDHSIZ_4 SearchCOL Heading Size[4]INT_STORAGEInteger0
51COLDHSIZ_5 SearchCOL Heading Size[5]INT_STORAGEInteger0
52COLDHSIZ_6 SearchCOL Heading Size[6]INT_STORAGEInteger0
53RTOTLSIZ SearchRow Total SizeINT_STORAGEInteger0
54COLTOSIZ SearchCOL Total SizeINT_STORAGEInteger0
55COLOFSIZ SearchCOL Offset SizeINT_STORAGEInteger0
56LFTMARGN SearchLeft MarginINTInteger0
57RTMARGIN SearchRight MarginINTInteger0
58TOPMARGN SearchTop MarginINTInteger0
59BOTMARGN SearchBottom MarginINTInteger0
60DEX_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 *