Excel Report Fields (ERB10200)

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

Display Name: Excel Report Fields
Physical Name: ERB10200
Technical Name: ERB_Fields

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Excel_Report_ID	Excel Report ID	STR15_LBAU	String	15
2	Table_Number	Table Number	INT5	Integer	4
3	Field_Number	Field Number	INT2	Integer	2
4	Excel_Field_Name	Excel Report Field Name	STR80	String	80
5	Excel_Display_Name	Excel Report Display Name	STR80	String	80
6	Display_Field	Display Field	CB	Boolean	0
7	FIELDTYPE	Field Type	Long Int	Long Integer	8
8	Excel_String_Format	Excel Report String Format	Excel Report String Format	Integer	0
9	String_Mask	String Mask	STR30	String	30
10	DECPLCUR	Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	0
11	Show_Currency_Symbol	Show Currency Symbol	Show Currency Symbol	Boolean	0
12	Show_Percentage_Symbol	Show Percentage Symbol	Show Percentage Symbol	Boolean	0
13	Show_Thousands_Separator	Show Thousands Separator	Show Thousands Separator	Boolean	0
14	Display_As_Account	Display As Account	Display As Account	Boolean	0
15	TBLPHYSNM	Table Physical Name	STR50	String	50
16	Display_As_Negative	Display As Negative	Display As Negative	Boolean	0
17	Display_As_Note	Display As Note	Display As Note	Boolean	0
18	Negative_Table	Negative Table	INT5	Integer	4
19	Negative_Field	Negative Field	INT5	Integer	4
20	Decimal_Places_Method	Decimal Places Method	Decimal Places Method	Integer	0
21	Pivot_Table_Field_Pos	Pivot Table Field Position	Pivot Table Field Position	Integer	0
22	TXTFIELD	Text Field	TX32000	Text	32000