Currency Setup (MC40200)

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
Physical Name: MC40200
Technical Name: MC_Currency_SETP

Group Display Name: Multicurrency System Setup
Group Technical Name: Multicurrency System Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
2CURRNIDX SearchCurrency IndexIntegerINT33
3NOTEINDX SearchNote IndexCurrencyDLR1414
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
4CRNCYDSC SearchCurrency DescriptionStringSTR3030
5CRNCYSYM SearchCurrency SymbolStringCurrency_Symbol3
6CNYSYMAR_1 SearchCurrency Symbol Array[1]IntegerINT0
7CNYSYMAR SearchCurrency Symbol ArrayINTInteger0
8CNYSYMAR_2 SearchCurrency Symbol Array[2]IntegerINT0
9CNYSYMAR_3 SearchCurrency Symbol Array[3]IntegerINT0
10CYSYMPLC SearchCurrency Symbol PlacementIntegerGB0
11INCLSPAC SearchInclude SpaceBooleanCB_Include_Space0
12NEGSYMBL SearchNegative SymbolIntegerDDL_Negative_Symbol0
13NGSMAMPC SearchNegative Symbol Amount PlacementIntegerGB0
14NEGSMPLC SearchNegative Symbol PlacementIntegerGB0
15DECSYMBL SearchDecimal SymbolIntegerDDL_Decimal_Symbol0
16DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
17THOUSSYM SearchThousands SymbolIntegerDDL_Thousands_Symbol0
18CURTEXT_1 SearchCurrency Text[1]StringSTR2525
19CURTEXT_2 SearchCurrency Text[2]StringSTR2525
20CURTEXT SearchCurrency TextSTR25String25
21CURTEXT_3 SearchCurrency Text[3]StringSTR2525
22ISOCURRC SearchISO Currency CodeStringSTR3_ISO_Currency_Code3
23CURLNGID SearchCurrency Language IDIntegerINT54

Leave a Reply

Your email address will not be published. Required fields are marked *