We are trying to integrate our Appian instance with an existing MS SQL database.

bryant.st39 over 10 years ago

We are trying to integrate our Appian instance with an existing MS SQL database. One of the tables we are trying to map a CDT to has a column of data type Money. What is the appropriate Appian data type to map the CDT field to?

I've tried several versions of the following:

<xsd:element name="Material_Cost" type="xsd:float">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(name="Material_Cost", columnDefinition="decimal(19,4)")
</xsd:appinfo>
</xsd:annotation>
</xsd:element>

Discussion posts and replies are publicly visible

0 bryant.st39 over 10 years ago

If failed to try the obvious...

<xsd:element name="Material_Cost" type="xsd:double">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(name="Material_Cost", columnDefinition="money")</xsd:appinfo>
</xsd:annotation>
</xsd:element>

This is what worked for me.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel