2.2.4.6 ST_FieldType

Target namespace: http://schemas.microsoft.com/office/accessservices/2010/12/application

Referenced by: UnderlyingType, CT_Parameter, CT_ParameterDefinition

A string ([XMLSCHEMA2] section 3.2.1) that specifies a data type. MUST be one of the following values.

Value	Meaning
Text	A string value up to 4000 characters in length.
Number	A floating-point number.
Yes/No	A Boolean value.
Currency	A monetary value.
Date/Time	A date value that includes time.
LongText	A string value up to the maximum storage size specified by the nvarchar ([MSDN-TSQL-Ref]) data type.
Date	A date value.
Time	A time value.
Integer	An integer number value.
Decimal	A number value with specified scale and precision, as specified by the decimal data type ([MSDN-TSQL-Ref]).

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this simple type.

 <xsd:simpleType name="ST_FieldType">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="Text" wbld:cname="Text"/>
     <xsd:enumeration value="Number" wbld:cname="Number"/>
     <xsd:enumeration value="Yes/No" wbld:cname="YesNo"/>
     <xsd:enumeration value="Currency" wbld:cname="Currency"/>
     <xsd:enumeration value="Date/Time" wbld:cname="DateTime"/>
     <xsd:enumeration value="LongText" wbld:cname="LongText"/>
     <xsd:enumeration value="Date" wbld:cname="Date"/>
     <xsd:enumeration value="Time" wbld:cname="Time"/>
     <xsd:enumeration value="Integer" wbld:cname="Integer"/>
     <xsd:enumeration value="Decimal" wbld:cname="Decimal"/>
   </xsd:restriction>
 </xsd:simpleType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).