Triva isn't available right now.
Check out the support page for our phone number and hours
Build report XLS file worksheet descriptions
Go to file downloads to download the Return XML file sets.
Go to file downloads to download the Return XML file sets.
Worksheet | Description |
|---|---|
Org_XML_DataDict_Xref | This is the data dictionary. The data dictionary lists all form and field names enabled for Return XML. Use this worksheet to determine if an Organizer data field is enabled. |
Txf_XML_DataDict_Xref | This worksheet is empty as tax forms aren't enabled for Return XML. |
Wkp_XML_DataDict_Xref | This worksheet is empty as workpapers aren't enabled for Return XML. |
XML_Required_Fields | This worksheet lists DocumentID and DataTag combintations required to be in an import file if the activity member or group member is to be created. If a required field is missing from the import file but other items in the associated group exist, the import won't work. The import file is validated before the import process begins. |
XML_Master_Group_Forms | This worksheet lists master group activities, which are different types of income or assets that use common fields. The DocumentID determines which master group to associate the common field data. |
XML_Child_Forms | This worksheets lists activities with common fields that can be associated underneath different tax forms. For example, the DocumentID for Form 2106 is a child form and appears within the Schedule C in an XML file. |
Field_Collections | This worksheet lists groups of fields where, if 1 field contains data, the others in that group must also contain data. |
Field_Collection_Field_Rules | This worksheet lists instances where having data in 1 field will conflict with having data in another field. |
Field_Collection_Group_Rules | This worksheet lists instances where having data in 1 group of fields conflicts with having data in another group of fields. For example, if some parts of a US address are populated, then no part of the corresponding foreign address should be populated. |
XML_Discontinued_Fields | This worksheet lists field values included in the prior file sets. They've been removed from the mapping for the current period file sets. |
XML_Changed_Fields | This worksheet lists current and prior field values for DocumentID, sections, and DataTag. |
XML_New_Fields | This lists new fields added with values for DocumentID, sections, and DataTag. These fields weren't in prior file sets. |
XML_Data_Changes | This lists field values for current and prior data type, length, and precision. These changes are tied to DocumentID, sections, and DataTag. |
XML_String_Values | This lists all string values used in the current file sets by DocumentID, section, and DataTag. |
Discontinued_XML_String_Values | This worksheet lists string values that weren't in prior file sets and are no longer in the current file set. |
New_XML_String_Values | This lists new string values for DocumentIDs that have been added to the file sets that weren't of the prior file sets. |
Changed_XML_String_Values | This lists previous string values from a prior file set to the current string values. |
Org_Navigation | This worksheets lists the navigation in the return for enabled Organizer fields. |
Txf_Navigation | This worksheet is empty as tax forms aren't enabled for Return XML. |
Wkp_Navigation | This worksheet is empty as workpapers aren't enabled for Return XML. |
Related Content
-
About Return XML
Format:
Article,
1 min read
-
File format for use with Return XML
Format:
Article,
2 min read
Related Content
-
About Return XML
Format:
Article,
1 min read
-
File format for use with Return XML
Format:
Article,
2 min read