Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MC40200
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Currency Setup Group Display Name: Multicurrency System Setup
Physical Name: MC40200
Technical Name: MC_Currency_SETP
Group Technical Name: Multicurrency System Setup
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/hideSELECT
['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_1 | Currency Symbol Array[1] | Integer | INT | 0 | |
7 | CNYSYMAR | Currency Symbol Array | INT | Integer | 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 | Currency Text | STR25 | String | 25 | |
20 | CURTEXT_2 | Currency Text[2] | String | STR25 | 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 |