Name in AssignmentPro: Account Taxability with Override (view)
Name in Database: VWEQ_ACCOUNT_TAXABILITY_WITH_OVERRIDE
Description inc. recommended uses and limitations: This Company level view can be used to easily report on the Account Taxability By Country positions, including Federal, Social and State taxability, as well as potential company taxability overrides that might be applied. This view is recommended to be used when there are override taxabilities on certain companies regarding to what is configured at a system level. When creating a user report that uses this view, a company ID filter is required to return the data for a specific company.
Tables used in the view:
COMPANY
ACCOUNT
COUNTRY
STATE_PROVINCE
ACCOUNT_TAXABILITY
ACCOUNT_TAXABILITY_OVERRIDE
ACCOUNT_STATE_TAXABILITY
ACCOUNT_STATE_TAXABILITY_OVERRIDE
Fields contained in the view:
Company ID
Account ID
Account Number
Sub Account Number
Sub Account Long Description
Federal Taxability
Social Taxability
State Taxability
Country Code
Country Name
State Code
State Name
Click here for details on how to create a user report to return all fields for a given name in the database.