AF40102 - Financials Header and Footer Setup

Dynamics GP table AF40102 (Financials Header and Footer Setup) contains 24 columns including REPORTID, HDRFTRTY, FLDNUM....

SQL Query Builder

SELECT * FROM AF40102

Select all

Column	Description	Type	Length	Shared With
REPORTID	Report ID	Integer	2	12 tables
HDRFTRTY	Header Footer Type	Integer	2	-
FLDNUM	FLD NUM	Integer	2	-
FLDPOSX1	FLD POS X1	Integer	2	-
FLDPOSY1	FLD POS Y1	Integer	2	-
FLDPOSX2	FLD POS X2	Integer	2	-
FLDPOSY2	FLD POS Y2	Integer	2	-
FLDTYPE	FLD Type	Integer	2	-
FLDFRMAT	FLD Format	Integer	2	-
SBHSBFIN	Subheader Subfooter Index	Integer	2	-
FLDOPT	FLD OPT	Integer	2	-
FLDOPT2	FLD OPT2	Integer	2	-
FLDALIGN	FLD Align	Integer	2	-
FLDFTFML	FLD Font Family	Integer	2	-
FLDFTSIZ	FLD Font Size	Integer	2	-
FLDSTYLE_1	FLD Style[1]	Integer	2	-
FLDSTYLE_2	FLD Style[2]	Integer	2	-
FLDSTYLE_3	FLD Style[3]	Integer	2	-
FLDSTYLE_4	FLD Style[4]	Integer	2	-
FLDSTYLE_5	FLD Style[5]	Integer	2	-
FLDSTYLE_6	FLD Style[6]	Integer	2	-
FLDVALUE	FLD Value	String	82	-
FLDVALU2	FLD Value2	String	82	-
FLDPRNAM	FLD Picture Name	String	82	1 tables

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

REPORTID

FLDPRNAM