Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_CacheField
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-pivotTable.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottable_xsd Drilldown into mpMap in schema sml-pivottable_xsd Drilldown into fieldGroup in schema sml-pivottable_xsd Drilldown into sharedItems in schema sml-pivottable_xsd Drilldown into memberPropertyField in schema sml-pivottable_xsd Drilldown into mappingCount in schema sml-pivottable_xsd Drilldown into databaseField in schema sml-pivottable_xsd Drilldown into level in schema sml-pivottable_xsd Drilldown into hierarchy in schema sml-pivottable_xsd Drilldown into sqlType in schema sml-pivottable_xsd Drilldown into formula in schema sml-pivottable_xsd Drilldown into numFmtId in schema sml-pivottable_xsd Drilldown into uniqueList in schema sml-pivottable_xsd Drilldown into serverField in schema sml-pivottable_xsd Drilldown into propertyName in schema sml-pivottable_xsd Drilldown into caption in schema sml-pivottable_xsd Drilldown into name in schema sml-pivottable_xsdXSD Diagram of CT_CacheField in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_CacheField">
    <xsd:sequence>
        <xsd:element name="sharedItems" type="CT_SharedItems" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Shared Items</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="fieldGroup" minOccurs="0" type="CT_FieldGroup">
            <xsd:annotation>
                <xsd:documentation>Field Group Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="mpMap" minOccurs="0" maxOccurs="unbounded" type="CT_X">
            <xsd:annotation>
                <xsd:documentation>Member Properties Map</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="name" type="ST_Xstring" use="required">
        <xsd:annotation>
            <xsd:documentation>PivotCache Field Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>PivotCache Field Caption</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="propertyName" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Property Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="serverField" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Server-based Field</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="uniqueList" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Unique List Retrieved</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional">
        <xsd:annotation>
            <xsd:documentation>Number Format Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="formula" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Calculated Field Formula</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sqlType" type="xsd:int" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>SQL Data Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hierarchy" type="xsd:int" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Hierarchy</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="level" type="xsd:unsignedInt" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Hierarchy Level</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="databaseField" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Database Field</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mappingCount" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Member Property Count</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="memberPropertyField" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Member Property Field</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
sharedItems nsM:sharedItems 0 1
fieldGroup nsM:fieldGroup 0 (1)
mpMap nsM:mpMap 0 unbounded
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
name nsM:name Required
caption nsM:caption Optional
propertyName nsM:propertyName Optional
serverField nsM:serverField false Optional
uniqueList nsM:uniqueList true Optional
numFmtId nsM:numFmtId Optional
formula nsM:formula Optional
sqlType nsM:sqlType 0 Optional
hierarchy nsM:hierarchy 0 Optional
level nsM:level 0 Optional
databaseField nsM:databaseField true (Optional)
mappingCount nsM:mappingCount Optional
memberPropertyField nsM:memberPropertyField false Optional
Collapse Derivation Tree:
Collapse References:
nsM:cacheField
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0