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