Decimal (18,9) value in SQL from Appian

Question

Hello, 
 Client wants to have Decimal(18,9) in SQL db as this DB is being used by others as well. But when we try to insert it using Appian either it converts to exponential or gives error as CDT field we have created decimal type. 
 
 If I am doing todecimal then also it gives error. 
 Please let me know what shud we do so that atleast 18 digits we can save , I know Appian dosnt support 9 percision after decimal so it would be hard but if someone could suggest workaround so that we can save in DB decinal (18,9). 
 Not all the values are comming from Appian interface , few values we are fething from third party system also. 
 
 Thanks, 
 Pooja

Hrishikesh Dixit · Answer

You can keep the CDT field type in Appian as string and map it to a DECIMAL (18, 9) column in the back end database. For instance the xsd element in your cdt can be as follows -

<xsd:element name="decValue" nillable="true" type="xsd:string">
    <xsd:annotation>
        <xsd:appinfo source="appian.jpa">@Column(name="decValue", columnDefinition="DECIMAL")</xsd:appinfo>
    </xsd:annotation>
</xsd:element>

On the Appian interface, use a text field to capture this value from user but make sure it is validated for decimal (18, 9) or else database write will fail.