Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Reference items

Dataset Parameters Reference

You can activate the following "Dataset Parameters" in the application for additional functionality. The "Parameter Function" column describes the functionality.
Parameter
Parameter
Parameter Value
Parameter Function
AdvLiabPosting
Alphanumeric
N, Y
N Deactivates the auto payable posting
Y Activates the auto payable posting.
AWP_WRITE
Alphanumeric
0 or 1
1 makes Active Workpapers read/write for Read/Write users.
BSORTPTAG
Alphanumeric
Tag letter
Configures the tag that designates RTP Deferred Only adjustments. Overrides the default Balance Sheet Only posting tag.
CASENUMBER
Alphanumeric
User Defined Code
Case number that identifies the unit when exporting data to compliance systems.
CTA_ALT_CALC
Alphanumeric
1
Enables automatic calculation of Currency Translation Adjustment (CTA) for all temporary differences via the Alternative calculation (through P/L). This calculation computes the current Tax Expense, which is offset in a Taxes Payable account. The Deferred Tax Expense is offset in the Ending Deferred Tax Asset/Liability accounts.
CUSTOM_HEADERS
Alphanumeric
1
You can add information to the header of each "component" page.
DEFAULT_TD_TAB
Alphanumeric
0, 1, or 2
0 displays the
Detail
tab for the Temporary Difference pages for all users.
1 displays the
Rollforward
 tab for the Temporary Difference pages for Read/Write and Read-Only users, and the
Detail
 tab for Administrators.
2 displays the
Rollforward
 tab of Temporary Difference pages for all users.
DefEndBalDefault
Alphanumeric
Tag letter and type of event
Designates at the dataset level where the difference is posted when Ending Balances are entered vs Activity for Book/Tax Basis Temporary Differences.
Examples: O,A uses tag O and posts as Activity X,D uses tag X and posts as Deferred Only Note: This parameter overrides the DefEndBalDefault system parameter.
DEF_RF_SUMMATION_COLUMN
Alphanumeric
1 thru 26
Selects the column in the Deferred Balances Report to display a sub-total balance for the Adjusted Beginning Balance or any other purpose for a specific dataset. Note: This parameter overrides the DEF_RF_SUMMATION_COLUMN system parameter.
DEF_RF_SUMMATION_NAME
Alphanumeric
Text
Column Heading for the column created with DEF_RF_SUMMATION_COLUMN parameter. Note: This parameter overrides the DEF_RF_SUMMATION_NAME system parameter.
DORTPTAG
Alphanumeric
Tag letter
Configures the tag that designates RTP Deferred Only adjustments. Overrides the default Deferred Only posting tag.
EstPymtFranchiseType
Alphanumeric
Tag Letter
Dictates the tag letter used in the payment summary report for income payments.
EstPymtPctCushion
Decimal Number
1.XX
Cushion amount that should be added to Estimated Tax Payments.
EstPymtRoundFactor
Whole Number
X00, X000
Rounding factors applied to Estimated Tax Payments.
EstPymtType
Alphanumeric
Tag Letter
Dictates the tag letter used in the payment summary report for income payments.
FATTD_Prefix
Alphanumeric
AT Temp Diff Code
Identifies which of the After Tax Temporary Differences (ATTD) should be considered as Foreign Tax Credit Carryover amounts for the Alternative Minimum Tax Calculation. If no value is entered, no ATTD is included in the calculation.
FEDBENEFITOFSTATE
Alphanumeric
FED/STATE
"FED" Federal Benefit of State impact in the Federal Rate or "State" Federal Benefit of State impact in the State Rate.
*Mass Update Rates:
N/A
N/A
N/A
CountryRates
Alphanumeric
Y
Y will show a table that stores rates that will automatically update country rates for a dataset.
CurrencyRates
Alphanumeric
Y
Y will show a table that stores rates that will automatically update currency rates for a dataset.
StateRates
Alphanumeric
Y
Y will show a table that stores rates that will automatically update state rates for a dataset.
NOLAUTO_BSO_EXCLUSIONYYY
Alphanumeric
Tag letter
Used to exclude Balance Sheet Only amounts from the Federal NOLs Automation balance. (YYY are numbers and Tag Letter is the tag that should be excluded.) Multiple tags can be excluded by setting up multiple parameters.
NOLAUTO_DEFONLY_EXCLUSIONXXX
Alphanumeric
Tag letter
Used to exclude Deferred Only amounts from the Federal NOLAutomation balance. (XXX are numbers and Tag Letter is the tag that should be excluded.) Multiple tags can be excluded by setting up multiple parameters.
PAYABLE_CPROV_DOM_BUCKET
Alphanumeric
Payable Bucket Code
Determines which payable bucket the Domestic Unit's Federal Current Return Basis Tax Charge posts to.
PAYABLE_CPROV_FOR_BUCKET
Alphanumeric
Payable Bucket Code
Determines which payable bucket the Foreign Unit's Federal National Return Basis Tax Charge posts to.
PAYABLE_CPROV_DOM_STATE_BUCKET
Alphanumeric
Payable Bucket Code
Determines which payable bucket the Domestic Unit's State Current Return Basis Tax Charge posts to.
PAYABLE_CPROV_FOR_STATE_BUCKET
Alphanumeric
Payable Bucket Code
Determines which payable bucket the Foreign Unit's Current State Return Basis Tax Charge posts to.
PAYABLE_FXRATE_CALC
Alphanumeric
1
1 allows you to specify for a particular dataset not to default to the filing unit's FX rate, but to calculate by summing all Cash Federal Provisions in Local Currency and dividing by all Cash Federal Provisions in Reporting Currency when payable items are being calculated for a filing group.
PAYABLE_RTP_DOM_BUCKET
Alphanumeric
Payable Bucket Code
Determines which payable bucket the Domestic Unit's Federal Tax Adj with codes NC_RTP or NC_ATR posts to.
PAYABLE_RTP_FOR_BUCKET
Alphanumeric
Payable Bucket Code
Determines which payable bucket the Foreign Unit's Federal Tax Adj with codes NC_RTP or NC_ATR posts to.
PAYABLE_RTP_DOM_STATE_BUCKET
Alphanumeric
Payable Bucket Code
Determines which payable bucket the Domestic Unit's State Tax Adj with codes NC_RTP or NC_ATR posts to.
PAYABLE_RTP_FOR_STATE_BUCKET
Alphanumeric
Payable Bucket Code
Determines which payable bucket the Foreign Unit's State Tax Adj with codes NC_RTP or NC_ATR posts to.
PAYRECTYPE
Alphanumeric
0, 1 or 2
Determines how the PAYRECUNIT parameter functions: 0 indicates there is no payable reclass. 1 indicates that the Payable Reclass on the Federal and State levels is based on the unit determined for PAYRECUNIT at the Unit Dataset parameter level. 2 indicates that the Payable Reclass on the Federal level is based on the unit determined for PAYRECUNIT at the Unit Dataset parameter level. In addition, the Payable Reclass on the State level is based on the unit determined for PAYRECUNIT at the Unit State Dataset parameter level.
Prior_Year_Tag#
Alphanumeric
Tag Letter
Determines which NC_ and Deferred amounts are considered in the Prior Year Breakout view of the Foreign/Domestic Summary report, based on their tag letters. For example: To include NC_ and Deferred amounts tagged with R and X, add the dataset parameters: Prior_Year_Tag1, Alphanumeric, R Prior_Year_Tag2, Alphanumeric, X
PULL_PAY_FROM_DATASET
Alphanumeric
Dataset Name
Entering the name of the Provision Dataset in the Estimated Tax Payments dataset posts payable transaction codes 1ES, 1ES-F, 2ES, 2ES-F, 3ES, 3ES-F, 4ES, 4ESF,ADJ and ADJ-F total display on the Federal Est Pymt and State Est Pymt reports after Reset Report Data.
RestrictTA
Alphanumeric
Beginning of code which should not be modifiable
Restricts Read/Write users on data entry/modification of tax adjustment codes.
RestrictTag_X
Alphanumeric
Beginning of tag which should not be modifiable
Restricts Read/Write users on data entry/modification of tags. X represents the specified tag with a paramvalue of the specified tag.
RESTRICT_TD_TABS
Alphanumeric
0 or 1
0 allows Administrators and Read/Write users to enter data either on both the
Rollforward
 and
Detail
 tabs for the Temporary Difference pages.
1 limits the ability to enter data in the
Detail
 tab for the Temporary Difference pages to Administrators only. All users, however, can view data in the
Detail
 tab.
RTPTAG
Alphanumeric
Tag letter
Configures the tag that designates RTP Deferred Only adjustments. Overrides the default RTP posting tag.
RTPSUBCLASS
Alphanumeric
Y
Activate this dataset parameter when you want to post multiple years of GAAP and STAT Return-to-Provision true-up adjustments for Class datasets. When activated in the return dataset, this parameter will append the year to the system generated RTP Class and Subclass appropriately identifying the year and the GAAP or STAT designation.
SCRUNCH_TAG
Alphanumeric
Any letter from A through Z.
Enables similarly-coded and similarly-designated (Current/Non-Current) temporary differences (with the same or different tag letters) to be aggregated when rolling over datasets using the Scrunch functionality.
USE_OLD_AMTESTIMATOR
Alphanumeric
0 or 1
0 uses the Reporting Currency approach for the Alternative Minimum Tax (AMT) calculation for the dataset, overriding the system parameter. USE_OLD_AMTESTIMAT0OR_Default. 1 uses the Local Currency methodology.
USETBPTBI
Alphanumeric
0, 1, 2
1
2
0 - Deactivates the PTBI bridge posting
1 - Activates the PTBI bridge posting for all income statement accounts.
2 - Activates the PTBI bridge posting for all accounts with codes beginning with PTBI.
USE_WWPTBI_INTPROVETR
Alphanumeric
0 or 1
USE_WWPTBI_INTPROVETR
 determines how
Exclude Foreign Losses
 or
Exclude Unit
 affects the interim provision calculations.
0 - The interim provision and effective tax rate calculations will not include the Pre-tax book income of Exclude Foreign Loss or Exclude Unit units.
1 - The interim provision and effective tax rate calculations will include the Pre-tax book income of Exclude Foreign Loss or Exclude Unit units.
VA_CALCTYPE
Alphanumeric
0, 2, 3 or 4
2 activates the aggregated Valuation Allowance automation.
3 activates the aggregated Valuation Allowance automation.
4 activates the aggregated post-tax Valuation Allowance automation.
0 activates the separate Valuation Allowance automation.

This article applies to:

  • Product: ONESOURCE Tax Provision