Dataset Parameters

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

Deactivates the auto payable posting.

AdvLiabPosting

 

Alphanumeric

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 section of Temporary Difference pages for all users.

 

1 displays the Rollforward section of Temporary Difference pages for Read/Write and Read-Only users, and the Detail section for Administrators.

 

2 displays the Rollforward section 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:


 

 

 

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 sections of Temporary Difference pages.

 

1 limits the ability to enter data in the Details section of Temporary Difference  pages to Administrators only. All users, however, can view data in the Details section.

RTPTAG

 

Alphanumeric

Tag letter

Configures the tag that designates RTP Deferred Only adjustments. Overrides the default RTP posting tag.

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. (Applicable for v9.2 and earlier)

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_AMTESTIMATOR_Default. 1 uses the Local Currency methodology.

USETBPTBI

 

Alphanumeric

0

Deactivates the PTBI bridge posting

USETBPTBI

 

Alphanumeric

1

Activates the PTBI bridge posting for all income statement accounts

USETBPTBI

 

Alphanumeric

2

Activates the PTBI bridge posting for all accounts with codes beginning with PTBI

USE_WWPTBI_INTPROVETR

 

Alphanumeric

0 or 1

Affects interim provision and interim effective tax rate reports:

0 uses pre-tax book income excluding Exclude Foreign Loss and Exclude Unit units.

1 uses pre-tax book income including Exclude Foreign Loss and Exclude Unit units.

USE_WWPTBI_STATEFCRATE

 

Alphanumeric

0 or 1

Affects forecast state rate:

0 uses pre-tax book income of units with active state records only.

1 uses pre-tax book income of all units with active or inactive state records.

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.