Currency Setup (MC40200)

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

Display Name: Currency Setup
Physical Name: MC40200
Technical Name: MC_Currency_SETP

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CURNCYID	Currency ID	String	STR15_Currency_ID	15
2	CURRNIDX	Currency Index	Integer	INT3	3
3	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Currency Setup'].NOTEINDX AS 'Currency Setup-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM MC40200 AS ['Currency Setup'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Currency Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4	CRNCYDSC	Currency Description	String	STR30	30
5	CRNCYSYM	Currency Symbol	String	Currency_Symbol	3
6	CNYSYMAR	Currency Symbol Array	INT	Integer	0
7	CNYSYMAR_1	Currency Symbol Array[1]	Integer	INT	0
8	CNYSYMAR_2	Currency Symbol Array[2]	Integer	INT	0
9	CNYSYMAR_3	Currency Symbol Array[3]	Integer	INT	0
10	CYSYMPLC	Currency Symbol Placement	Integer	GB	0
11	INCLSPAC	Include Space	Boolean	CB_Include_Space	0
12	NEGSYMBL	Negative Symbol	Integer	DDL_Negative_Symbol	0
13	NGSMAMPC	Negative Symbol Amount Placement	Integer	GB	0
14	NEGSMPLC	Negative Symbol Placement	Integer	GB	0
15	DECSYMBL	Decimal Symbol	Integer	DDL_Decimal_Symbol	0
16	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
17	THOUSSYM	Thousands Symbol	Integer	DDL_Thousands_Symbol	0
18	CURTEXT_1	Currency Text[1]	String	STR25	25
19	CURTEXT_2	Currency Text[2]	String	STR25	25
20	CURTEXT	Currency Text	STR25	String	25
21	CURTEXT_3	Currency Text[3]	String	STR25	25
22	ISOCURRC	ISO Currency Code	String	STR3_ISO_Currency_Code	3
23	CURLNGID	Currency Language ID	Integer	INT5	4