GP Tables

AF40101 - Financials Layout Setup

Dynamics GP table AF40101 (Financials Layout Setup) contains 59 columns including REPORTID, MNHDRCNT, MNFTRCNT....

SQL Query Builder

59 Columns

Column Description Type Length
REPORTID Report ID Integer 2
MNHDRCNT Main Header CNT Integer 2
MNFTRCNT Main Footer CNT Integer 2
SHDRCNT Subheader CNT Integer 2
SFTRCNT Subfooter CNT Integer 2
ROWCNT1 Row CNT Integer 2
COLCNT COL CNT Integer 2
SHDRPCNT Subheader Proper CNT Integer 2
SFTRPCNT Subfooter Proper CNT Integer 2
MNHDRFLG Main Header Flag Integer 2
MNFTRFLG Main Footer Flag Integer 2
SHDRFLAG Subheader Flag Integer 2
SFTRFLAG Subfooter Flag Integer 2
MNHDRSIZ Main Header Size Integer 2
MNFTRSIZ Main Footer Size Integer 2
SHDRSIZE_1 Subheader Size[1] Integer 2
SHDRSIZE_2 Subheader Size[2] Integer 2
SHDRSIZE_3 Subheader Size[3] Integer 2
SHDRSIZE_4 Subheader Size[4] Integer 2
SHDRSIZE_5 Subheader Size[5] Integer 2
SFTRSIZE_1 Subfooter Size[1] Integer 2
SFTRSIZE_2 Subfooter Size[2] Integer 2
SFTRSIZE_3 Subfooter Size[3] Integer 2
SFTRSIZE_4 Subfooter Size[4] Integer 2
SFTRSIZE_5 Subfooter Size[5] Integer 2
SHDROPT_1 Subheader OPT[1] Integer 2
SHDROPT_2 Subheader OPT[2] Integer 2
SHDROPT_3 Subheader OPT[3] Integer 2
SHDROPT_4 Subheader OPT[4] Integer 2
SHDROPT_5 Subheader OPT[5] Integer 2
SHDRPRT_1 Subheader PRT[1] Integer 2
SHDRPRT_2 Subheader PRT[2] Integer 2
SHDRPRT_3 Subheader PRT[3] Integer 2
SHDRPRT_4 Subheader PRT[4] Integer 2
SHDRPRT_5 Subheader PRT[5] Integer 2
SFTROPT_1 Subfooter OPT[1] Integer 2
SFTROPT_2 Subfooter OPT[2] Integer 2
SFTROPT_3 Subfooter OPT[3] Integer 2
SFTROPT_4 Subfooter OPT[4] Integer 2
SFTROPT_5 Subfooter OPT[5] Integer 2
SFTRPRT_1 Subfooter PRT[1] Integer 2
SFTRPRT_2 Subfooter PRT[2] Integer 2
SFTRPRT_3 Subfooter PRT[3] Integer 2
SFTRPRT_4 Subfooter PRT[4] Integer 2
SFTRPRT_5 Subfooter PRT[5] Integer 2
COLHDCNT COL Heading CNT Integer 2
COLDHSIZ_1 COL Heading Size[1] Integer 2
COLDHSIZ_2 COL Heading Size[2] Integer 2
COLDHSIZ_3 COL Heading Size[3] Integer 2
COLDHSIZ_4 COL Heading Size[4] Integer 2
COLDHSIZ_5 COL Heading Size[5] Integer 2
COLDHSIZ_6 COL Heading Size[6] Integer 2
RTOTLSIZ Row Total Size Integer 2
COLTOSIZ COL Total Size Integer 2
COLOFSIZ COL Offset Size Integer 2
LFTMARGN Left Margin Integer 2
RTMARGIN Right Margin Integer 2
TOPMARGN Top Margin Integer 2
BOTMARGN Bottom Margin Integer 2

Related Tables

Tables that share columns with AF40101. Click "Join" to add to your query.

REPORTID

AF40100 AF40102 AF40103 AF40104 AF40105 AF40106 AF40107 AF40108