Name: Tax Estimator Calculation Details (View)
Name in Database: vwEQ_TAX_ESTIMATOR_CALCULATION_DETAILS
Description inc. recommended uses and limitations: This view can be used to report on the Equus Tax Engine Tax Calculation details. It reports on the same information that is displayed when the Cost Estimate Calculation Detail report is run.
Tables used in the view:
COST_ESTIMATE
TAX_ESTIMATOR_CALCULATION_DETAIL
TAX_ESTIMATOR_OUTPUT
TAX_ESTIMATOR_SELECTOR
TAX_ESTIMATOR_VARIABLE
Fields contained in the view:
Cost Estimate ID
Authority
Caption
Currency
Location
Tax Details
Value fields for all the columns of the cost estimate (Columns 1-3)
Value Post Year
Value Year 1
Value Year 2
Value Year 3
Value Year 4
Tax fields for all the years of the cost estimate (Years 1-6)
Home Actual Social Tax Employee
Host Actual Social Tax Employee
Home Actual Social Tax Employer
Host Actual Social Tax Employer
Home Fringe Benefits Tax Employer
Host Fringe Benefits Tax Employer
Home Hypo Tax Fed
Host Hypo Tax Fed
Home Hypo Tax State
Host Hypo Tax State
Home Payroll Tax Employer
Host Payroll Tax Employer
Home Social Security Agreement In Force
Host Social Security Agreement In Force
Home Social Tax Calculated
Host Social Tax Calculated
Home Social Tax Employee
Host Social Tax Employee
Home Social Tax Employer
Host Social Tax Employer
Home Foreign Tax Credit
Home Social Tax Resident Indicator
Host Social Tax Required
Home Actual Tax Fed
Host Actual Tax Fed
Home Actual Marginal Rate
Home Hypo Marginal Rate
Host Actual Marginal Rate
Host Hypo Marginal Rate
Click here for details on how to create a user report to return all fields for a given name in the database.