Financials Column Setup (AF40103)

azurecurve Products Microsoft Dynamics GP (0)FinancialFinancials Column Setup (AF40103)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Financials Column Setup
Physical Name: AF40103
Technical Name: AF_Report_Column_SETP

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	REPORTID	Report ID	Integer	INT_STORAGE	0
2	COLNUM	COL NUM	Integer	INT_STORAGE	0
3	CLTKNCNT	CALC Token CNT	Integer	INT_STORAGE	0
4	COLTYPE	COL Type	Integer	INT_STORAGE	0
5	COLSIZE	COL Size	Integer	INT_STORAGE	0
6	COLOMCNT	COL Offset Mark CNT	Integer	INT	0
7	COLOFMRK_1	COL Offset Marks[1]	Integer	INT	0
8	COLOFMRK_2	COL Offset Marks[2]	Integer	INT	0
9	COLOFMRK_3	COL Offset Marks[3]	Integer	INT	0
10	COLOFMRK_4	COL Offset Marks[4]	Integer	INT	0
11	HIDEFLAG	Hide Flag	Integer	INT_STORAGE	0
12	TEXTVALU	Text Value	String	STR50	50
13	STPERIOD	Start Period	Integer	INT_STORAGE	0
14	ENDPEROD	End Period	Integer	INT_STORAGE	0
15	AMNTFROM	Amount From	Integer	INT_STORAGE	0
16	HISTYEAR	HIST Year	Integer	INT_STORAGE	0
17	BUDID	BUD ID	String	STR15_LBAU	15
18	PRTSIGN	PRT Sign	Integer	INT	0
19	PRTCOMMA	PRT Comma	Integer	INT_STORAGE	0
20	PRTPCENT	PRT Percent	Integer	INT_STORAGE	0
21	PRTTEXT	PRT Text	Integer	INT_STORAGE	0
22	ROUNDOPT	Round OPT	Integer	INT_STORAGE	0
23	HEADALIN	Head Align	Integer	INT_STORAGE	0
24	HDFTFMLY	Head Font Family	Integer	INT	0
25	HDFTSIZE	Head Font Size	Integer	INT	0
26	HEDSTYLE_1	Head Style[1]	Integer	INT_STORAGE	0
27	HEDSTYLE_2	Head Style[2]	Integer	INT_STORAGE	0
28	HEDSTYLE_3	Head Style[3]	Integer	INT_STORAGE	0
29	HEDSTYLE_4	Head Style[4]	Integer	INT_STORAGE	0
30	HEDSTYLE_5	Head Style[5]	Integer	INT_STORAGE	0
31	HEDSTYLE_6	Head Style[6]	Integer	INT_STORAGE	0
32	HEADTYPE_1	Head Type[1]	Integer	INT_STORAGE	0
33	HEADTYPE_2	Head Type[2]	Integer	INT_STORAGE	0
34	HEADTYPE_3	Head Type[3]	Integer	INT_STORAGE	0
35	HEADTYPE_4	Head Type[4]	Integer	INT_STORAGE	0
36	HEADTYPE_5	Head Type[5]	Integer	INT_STORAGE	0
37	HEADTYPE_6	Head Type[6]	Integer	INT_STORAGE	0
38	HEDFRMAT_1	Head Format[1]	Integer	INT_STORAGE	0
39	HEDFRMAT_2	Head Format[2]	Integer	INT_STORAGE	0
40	HEDFRMAT_3	Head Format[3]	Integer	INT_STORAGE	0
41	HEDFRMAT_4	Head Format[4]	Integer	INT_STORAGE	0
42	HEDFRMAT_5	Head Format[5]	Integer	INT_STORAGE	0
43	HEDFRMAT_6	Head Format[6]	Integer	INT_STORAGE	0
44	HEADOPT_1	Head OPT[1]	Integer	INT_STORAGE	0
45	HEADOPT_2	Head OPT[2]	Integer	INT_STORAGE	0
46	HEADOPT_3	Head OPT[3]	Integer	INT_STORAGE	0
47	HEADOPT_4	Head OPT[4]	Integer	INT_STORAGE	0
48	HEADOPT_5	Head OPT[5]	Integer	INT_STORAGE	0
49	HEADOPT_6	Head OPT[6]	Integer	INT_STORAGE	0
50	HEADOPT2_1	Head OPT2[1]	Integer	INT_STORAGE	0
51	HEADOPT2_2	Head OPT2[2]	Integer	INT_STORAGE	0
52	HEADOPT2_3	Head OPT2[3]	Integer	INT_STORAGE	0
53	HEADOPT2_4	Head OPT2[4]	Integer	INT_STORAGE	0
54	HEADOPT2_5	Head OPT2[5]	Integer	INT_STORAGE	0
55	HEADOPT2_6	Head OPT2[6]	Integer	INT_STORAGE	0
56	COLHDNG_1	COL Heading[1]	String	STR50	50
57	COLHDNG_2	COL Heading[2]	String	STR50	50
58	COLHDNG_3	COL Heading[3]	String	STR50	50
59	COLHDNG_4	COL Heading[4]	String	STR50	50
60	COLHDNG_5	COL Heading[5]	String	STR50	50
61	COLHDNG_6	COL Heading[6]	String	STR50	50
62	COLHDNG2_1	COL Heading2[1]	String	STR50	50
63	COLHDNG2_2	COL Heading2[2]	String	STR50	50
64	COLHDNG2_3	COL Heading2[3]	String	STR50	50
65	COLHDNG2_4	COL Heading2[4]	String	STR50	50
66	COLHDNG2_5	COL Heading2[5]	String	STR50	50
67	COLHDNG2_6	COL Heading2[6]	String	STR50	50
68	ALGNOFST	Alignment Offset	Integer	INT	0
69	COLEXPER	COL Expression Error	Boolean	Boolean	0
70	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Financials Column Setup'].NOTEINDX AS 'Financials Column Setup-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM AF40103 AS ['Financials Column Setup'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Financials Column Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
71	SEGFROM_1	SEG From:Account_Segment_Pool1	String	Account_Segment_Pool1	6
72	SEGFROM_2	SEG From:Account_Segment_Pool2	String	Account_Segment_Pool2	6
73	SEGFROM_3	SEG From:Account_Segment_Pool3	String	Account_Segment_Pool3	6
74	SEGFROM_4	SEG From:Account_Segment_Pool4	String	Account_Segment_Pool4	6
75	SEGFROM_5	SEG From:Account_Segment_Pool5	String	Account_Segment_Pool5	6
76	SEGFROM_6	SEG From:Account_Segment_Pool6	String	Account_Segment_Pool6	6
77	SEGFROM_7	SEG From:Account_Segment_Pool7	String	Account_Segment_Pool7	6
78	SEGFROM_8	SEG From:Account_Segment_Pool8	String	Account_Segment_Pool8	6
79	SEGFROM_9	SEG From:Account_Segment_Pool9	String	Account_Segment_Pool9	6
80	SEGFROM_10	SEG From:Account_Segment_Pool10	String	Account_Segment_Pool10	6
81	SEGTO_1	SEG To:Account_Segment_Pool1	String	Account_Segment_Pool1	6
82	SEGTO_2	SEG To:Account_Segment_Pool2	String	Account_Segment_Pool2	6
83	SEGTO_3	SEG To:Account_Segment_Pool3	String	Account_Segment_Pool3	6
84	SEGTO_4	SEG To:Account_Segment_Pool4	String	Account_Segment_Pool4	6
85	SEGTO_5	SEG To:Account_Segment_Pool5	String	Account_Segment_Pool5	6
86	SEGTO_6	SEG To:Account_Segment_Pool6	String	Account_Segment_Pool6	6
87	SEGTO_7	SEG To:Account_Segment_Pool7	String	Account_Segment_Pool7	6
88	SEGTO_8	SEG To:Account_Segment_Pool8	String	Account_Segment_Pool8	6
89	SEGTO_9	SEG To:Account_Segment_Pool9	String	Account_Segment_Pool9	6
90	SEGTO_10	SEG To:Account_Segment_Pool10	String	Account_Segment_Pool10	6

azurecurve Products Microsoft Dynamics GP (0)FinancialFinancials Column Setup (AF40103)

Click to show/hide

Leave a Reply Cancel reply