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

bryant.st39 over 9 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 9 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