AF40103 - Financials Column Setup | Prospr - Dynamics GP Table Reference

AF40103 - Financials Column Setup

Query Builder

Select * from AF40103

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
REPORTID	Report ID	Integer	2	View
COLNUM	COL NUM	Integer	2	View
CLTKNCNT	CALC Token CNT	Integer	2	View
COLTYPE	COL Type	Integer	2	View
COLSIZE	COL Size	Integer	2	View
COLOMCNT	COL Offset Mark CNT	Integer	2	View
COLOFMRK_1	COL Offset Marks[1]	Integer	2	View
COLOFMRK_2	COL Offset Marks[2]	Integer	2	View
COLOFMRK_3	COL Offset Marks[3]	Integer	2	View
COLOFMRK_4	COL Offset Marks[4]	Integer	2	View
HIDEFLAG	Hide Flag	Integer	2	View
TEXTVALU	Text Value	String	52	View
STPERIOD	Start Period	Integer	2	View
ENDPEROD	End Period	Integer	2	View
AMNTFROM	Amount From	Integer	2	View
HISTYEAR	HIST Year	Integer	2	View
BUDID	BUD ID	String	16	View
PRTSIGN	PRT Sign	Integer	2	View
PRTCOMMA	PRT Comma	Integer	2	View
PRTPCENT	PRT Percent	Integer	2	View
PRTTEXT	PRT Text	Integer	2	View
ROUNDOPT	Round OPT	Integer	2	View
HEADALIN	Head Align	Integer	2	View
HDFTFMLY	Head Font Family	Integer	2	View
HDFTSIZE	Head Font Size	Integer	2	View
HEDSTYLE_1	Head Style[1]	Integer	2	View
HEDSTYLE_2	Head Style[2]	Integer	2	View
HEDSTYLE_3	Head Style[3]	Integer	2	View
HEDSTYLE_4	Head Style[4]	Integer	2	View
HEDSTYLE_5	Head Style[5]	Integer	2	View
HEDSTYLE_6	Head Style[6]	Integer	2	View
HEADTYPE_1	Head Type[1]	Integer	2	View
HEADTYPE_2	Head Type[2]	Integer	2	View
HEADTYPE_3	Head Type[3]	Integer	2	View
HEADTYPE_4	Head Type[4]	Integer	2	View
HEADTYPE_5	Head Type[5]	Integer	2	View
HEADTYPE_6	Head Type[6]	Integer	2	View
HEDFRMAT_1	Head Format[1]	Integer	2	View
HEDFRMAT_2	Head Format[2]	Integer	2	View
HEDFRMAT_3	Head Format[3]	Integer	2	View
HEDFRMAT_4	Head Format[4]	Integer	2	View
HEDFRMAT_5	Head Format[5]	Integer	2	View
HEDFRMAT_6	Head Format[6]	Integer	2	View
HEADOPT_1	Head OPT[1]	Integer	2	View
HEADOPT_2	Head OPT[2]	Integer	2	View
HEADOPT_3	Head OPT[3]	Integer	2	View
HEADOPT_4	Head OPT[4]	Integer	2	View
HEADOPT_5	Head OPT[5]	Integer	2	View
HEADOPT_6	Head OPT[6]	Integer	2	View
HEADOPT2_1	Head OPT2[1]	Integer	2	View
HEADOPT2_2	Head OPT2[2]	Integer	2	View
HEADOPT2_3	Head OPT2[3]	Integer	2	View
HEADOPT2_4	Head OPT2[4]	Integer	2	View
HEADOPT2_5	Head OPT2[5]	Integer	2	View
HEADOPT2_6	Head OPT2[6]	Integer	2	View
COLHDNG_1	COL Heading[1]	String	52	View
COLHDNG_2	COL Heading[2]	String	52	View
COLHDNG_3	COL Heading[3]	String	52	View
COLHDNG_4	COL Heading[4]	String	52	View
COLHDNG_5	COL Heading[5]	String	52	View
COLHDNG_6	COL Heading[6]	String	52	View
COLHDNG2_1	COL Heading2[1]	String	52	View
COLHDNG2_2	COL Heading2[2]	String	52	View
COLHDNG2_3	COL Heading2[3]	String	52	View
COLHDNG2_4	COL Heading2[4]	String	52	View
COLHDNG2_5	COL Heading2[5]	String	52	View
COLHDNG2_6	COL Heading2[6]	String	52	View
ALGNOFST	Alignment Offset	Integer	2	View
COLEXPER	COL Expression Error	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
SEGFROM_1	SEG From:Account_Segment_Pool1	String	10	View
SEGFROM_2	SEG From:Account_Segment_Pool2	String	10	View
SEGFROM_3	SEG From:Account_Segment_Pool3	String	10	View
SEGFROM_4	SEG From:Account_Segment_Pool4	String	10	View
SEGFROM_5	SEG From:Account_Segment_Pool5	String	10	View
SEGTO_1	SEG To:Account_Segment_Pool1	String	10	View
SEGTO_2	SEG To:Account_Segment_Pool2	String	10	View
SEGTO_3	SEG To:Account_Segment_Pool3	String	10	View
SEGTO_4	SEG To:Account_Segment_Pool4	String	10	View
SEGTO_5	SEG To:Account_Segment_Pool5	String	10	View

AF40103 - Financials Column Setup

Query Builder

Customer Service

Information

My Account

Contact Us