Exporting
Contents
Topics discussed in this section include exporting categories from Administration, as well as dataset data, and component data from the Data Entry pages. When exporting data, and the export is complete, you can save the file from the current browser page. A download message appears for saving the file. The message you see varies and depends on the browser and version of the browser in use.
Dataset Export Worksheets
The export functionality generates a file with multiple worksheets:
#U# Unit, #UQ# Unit Questions, #UPD# Unit Perm Diffs, #UNOLTD# Unit NOL TDs-Tax Basis, #UTD# Unit Temp Diffs-Tax Basis, #UATTD# U AfterTx TDs-Tax Basis, #UTA# Unit Tax Adjs, #UTBBS# Unit Tax Basis BalSheet, #ULB# Unit Liability Begin Bals, #ULC# Unit Liability Changes, #UTDAM# U Temp Diff-Bk Tx Basis, #UPDAM# Unit Perm Diff Amort, #UATTDAM# U AfterTxTD-Bk Tx Bas, #FL# Fed Liability Txns, #ICOTXNS# Inter Co Txns, #DSFX# FX Rates, #S# States, #SPM# State Perm Mods, #STD# St TD-Tax Basis, #SAATD# St AfterApp TD-Tax Bas, #SATTD# St AfterTax TD-Tax Bas, #STA# State Tax Adjs, #J# Jurisdictions, #USDSP# USDS Params, #UDSP# UDS Params, #DP# Dataset Params, #JES# Journal Entries, #JETAX# JE Tax Calcs, #JEGL# JE GL Calcs, #SL# State Liability Txns, #UQUEST# Questionnaires, #UQSTNS# Questions,#UQRESP# Responses, #COU_RATES# Country Rates (Hidden), #CUR_RATES# Currency Rates (Hidden), #S_RATES# State Rates (Hidden), #CTAA# Currency Translation Adj, #DSRF# Dataset RollFrwd, #TBM# Tax Basis Mapping, #PARTH# Flow-Through Header, #PARTD# Flow-Through Detail, #PARTTAG# Flow-Through Tags, #TCM_IS# Tax Calcs Mapping IS, #TCM_BS# Tax Calcs Mapping BS, #ALTRATE# Alt Prov Rates, #ALT1# Scenario 1 Adj, #ALT2# Scenario 2 Adj, and #UAPIC# APIC Pool Amounts.
Category Export Worksheets
The Import Categories template contains the following worksheets:
#ADS# Archive Datasets, #ARDS# Archive Reporting Datasets, #CATTD# AfterTax TempDiffs, #CD# Datasets, #CDRF# Def RollForwards, #CDSR# Dataset Relations, #CRD# Reporting Datasets, #COU# Countries, #CUR# Currencies, #CDRF# Def RollForwards, #CIFTD# Incl. for Temp Diffs, #CLRF# Liab RollForwards, #CNOLTD# NOL TempDiffs, #CNRF# NOL RollForwards, #CP# Parameters, #CPRU# ParamsReportsUser, #CPD# Permanent Differences,#CPTBI# PTBI Codes, #CPYBK# Payable Buckets, #CPYRL# Payable Rollups, #CPYTP# Payable Txn Types, #CRU# Component Rollup Sets, #CS# States, #CSAATD# St AfterApp TempDiff, #CSATTD# St AfterTax TempDiff, #CSC# SubConsolidations, #CSTA# St Tax Adjs, #CTA# Tax Adjustments, #CTBL# Trial Balance Lines, #CTBSL# Trial Balance SubLines, #CTD# Temporary Differences, #CTDP# Temp Diff Postings, #CU# Units, #CUC# User Components, #CUSR# Users, #CUSRGP# Group Permissions, Users#ICOTXNT# Inter Co Txn Types, #ICOTRTT# Inter Co Trtmnt Types, #CUNC# Unit Components, and #CUNCM# Unit Component Multiple,#JEN# Journal Entry Numbers.
Note: To review the status of your export jobs, select Jobs in the navigation bar.