eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AR_TRX_TAX_L_V

Object Details

Object Name:	AR_TRX_TAX_L_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_TRX_TAX_L_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
TAX_LOC_ADJ_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the expense/revenue account for adjustments
TAX_LOC_ADJ_NON_REC_TAX_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the non-recoverable tax account for adjustments
TAX_LOC_EDISC_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the expense account for earned discounts
TAX_LOC_EDISC_NON_REC_TAX_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the non-recoverable tax account for earned discounts
TAX_LOC_FCHRG_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the revenue account for finance charges
TAX_LOC_FCHRG_NON_REC_TAX_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the non-recoverable tax account for finance charges
TAX_LOC_INTERIM_TAX_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the deferred tax account
TAX_LOC_TAX_ACCOUNT_CCID	NUMBER	(15)	Code combination ID for the tax account
TAX_LOC_UNED_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the expense account for unearned discounts
TAX_LOC_UNED_NON_REC_TAX_CCID	NUMBER	(15)	Code combination ID of the accounting flexfield for the non-recoverable tax account for unearned discounts
SALES_TAX_FROM_POSTAL_CODE	VARCHAR2	(30)	Low range of a postal code that this rate is active for against this location
SALES_TAX_ID	NUMBER	(15)	Internal primary key that is populated from the AR_SALES_TAX_S sequence, used as a foreign key in the RA_CUSTOMER_TRX_LINES table
SALES_TAX_RATE	NUMBER		Compiled sales tax rate, sum of every tax rate, taking into account overrides, for each segment of your structure
SALES_TAX_TO_POSTAL_CODE	VARCHAR2	(30)	High range of a postal code that this rate is active for against this location
TAX_EXEMPTION_NUMBER	VARCHAR2	(80)	Exemption certificate number
TAX_EXEMPTION_TYPE	VARCHAR2	(30)	Exemptions can be for customers at a location, or for items at a location, but not for customers and items at a location.
TAX_EXEMPTION_PERCENT_EXEMPT	NUMBER		Percentage that is exempt from tax. 100% means that this is a full exemption from tax.
TAX_EXEMPTION_REASON_CODE	VARCHAR2	(30)	The reason for this exemption
TAX_EXEMPTION_STATUS	VARCHAR2	(30)	Approval status for this exemption
TAX_CODE_EXEMPTED	VARCHAR2	(50)	Tax code that this exemption applies to
TAX_EXEMPTION_ID	NUMBER	(15)	Internal exemption identifier
VAT_TAX_ADJ_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for expense or revenue account for adjustments
VAT_TAX_ADJ_NON_REC_TAX_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for non-recoverable tax account for adjustments
VAT_TAX_DESCRIPTION	VARCHAR2	(60)	Description of tax code, for Italian legal requirement
VAT_TAX_EDISC_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for expense account for earned discounts
VAT_TAX_EDISC_NON_REC_TAX_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for non-recoverable tax account for earned discounts
VAT_TAX_FCHRG_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for revenue account for finance charges
VAT_TAX_FCHRG_NON_REC_TAX_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for non-recoverable tax account for finance charges
VAT_TAX_INTERIM_TAX_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for deferred tax account
VAT_TAX_TAXABLE_BASIS	VARCHAR2	(30)	AR_TAXABLE_BASIS lookup type for determining taxable amount
VAT_TAX_TAX_ACCOUNT_ID	NUMBER	(15)	Code combination identifier of accounting flexfield that tax should be posted to
VAT_TAX_TAX_CLASS	VARCHAR2	(1)	Input for tax codes on purchase transactions or output for tax codes on sales transactions
VAT_TAX_TAX_CODE	VARCHAR2	(50)	The tax code associated with a rate user specified in the Tax Codes and Rates window
VAT_TAX_TAX_RATE	NUMBER		The tax rate associated with the tax code the user specified in the Tax Codes and Rates window
VAT_TAX_TAX_TYPE	VARCHAR2	(30)	Lookup column that uses the TAX_TYPE lookup type
VAT_TAX_UNED_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for expense account for unearned discounts
VAT_TAX_UNED_NON_REC_TAX_CCID	NUMBER	(15)	Code combination identifier of accounting flexfield for non-recoverable tax account for unearned discounts
VAT_TAX_VAT_TAX_ID	NUMBER	(15)	Unique identifier
VAT_CODE_DESCRIPTION	VARCHAR2	(60)	Description of tax code, for Italian legal requirement
VAT_TAXABLE_BASIS	VARCHAR2	(30)	AR_TAXABLE_BASIS lookup type for determining taxable amount
VAT_TAX_ACCOUNT_ID	NUMBER	(15)	Code combination identifier of accounting flexfield that tax should be posted to
VAT_TAX_CLASS	VARCHAR2	(1)	Input for tax codes on purchase transactions or output for tax codes on sales transactions
VAT_TAX_CODE	VARCHAR2	(50)	The tax code associated with a rate user specified in the Tax Codes and Rates window
VAT_TAX_GLOBAL_ATTR1	VARCHAR2	(150)	Reserved for country-specific functionality
VAT_TAX_GLOBAL_ATTR2	VARCHAR2	(150)	Reserved for country-specific functionality
VAT_TAX_GLOBAL_ATTR3	VARCHAR2	(150)	Reserved for country-specific functionality
VAT_TAX_GLOBAL_ATTR4	VARCHAR2	(150)	Reserved for country-specific functionality
VAT_TAX_GLOBAL_ATTR5	VARCHAR2	(150)	Reserved for country-specific functionality
VAT_TAX_GLOBAL_ATTR6	VARCHAR2	(150)	Reserved for country-specific functionality
VAT_TAX_GLOBAL_ATTR7	VARCHAR2	(150)	Reserved for country-specific functionality
VAT_TAX_GLOBAL_ATTR_CAT	VARCHAR2	(30)	Reserved for country-specific functionality
VAT_TAX_ID	NUMBER	(15)	Unique identifier
VAT_TAX_RATE	NUMBER		The tax rate associated with the tax code the user specified in the Tax Codes and Rates window
VAT_TAX_TRX_TYPE	VARCHAR2	(30)	VAT transaction type
VAT_TAX_TYPE	VARCHAR2	(30)	Lookup column that uses the TAX_TYPE lookup type
TAX_LOC_VALUE_ACCT_ID	NUMBER	(15)	Primary key of the table
EVENT_ID	NUMBER	(15)
LINE_NUMBER	NUMBER	(15)
LANGUAGE	VARCHAR2	(20)
LEDGER_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TAX_LOC_ADJ_CCID
,      TAX_LOC_ADJ_NON_REC_TAX_CCID
,      TAX_LOC_EDISC_CCID
,      TAX_LOC_EDISC_NON_REC_TAX_CCID
,      TAX_LOC_FCHRG_CCID
,      TAX_LOC_FCHRG_NON_REC_TAX_CCID
,      TAX_LOC_INTERIM_TAX_CCID
,      TAX_LOC_TAX_ACCOUNT_CCID
,      TAX_LOC_UNED_CCID
,      TAX_LOC_UNED_NON_REC_TAX_CCID
,      SALES_TAX_FROM_POSTAL_CODE
,      SALES_TAX_ID
,      SALES_TAX_RATE
,      SALES_TAX_TO_POSTAL_CODE
,      TAX_EXEMPTION_NUMBER
,      TAX_EXEMPTION_TYPE
,      TAX_EXEMPTION_PERCENT_EXEMPT
,      TAX_EXEMPTION_REASON_CODE
,      TAX_EXEMPTION_STATUS
,      TAX_CODE_EXEMPTED
,      TAX_EXEMPTION_ID
,      VAT_TAX_ADJ_CCID
,      VAT_TAX_ADJ_NON_REC_TAX_CCID
,      VAT_TAX_DESCRIPTION
,      VAT_TAX_EDISC_CCID
,      VAT_TAX_EDISC_NON_REC_TAX_CCID
,      VAT_TAX_FCHRG_CCID
,      VAT_TAX_FCHRG_NON_REC_TAX_CCID
,      VAT_TAX_INTERIM_TAX_CCID
,      VAT_TAX_TAXABLE_BASIS
,      VAT_TAX_TAX_ACCOUNT_ID
,      VAT_TAX_TAX_CLASS
,      VAT_TAX_TAX_CODE
,      VAT_TAX_TAX_RATE
,      VAT_TAX_TAX_TYPE
,      VAT_TAX_UNED_CCID
,      VAT_TAX_UNED_NON_REC_TAX_CCID
,      VAT_TAX_VAT_TAX_ID
,      VAT_CODE_DESCRIPTION
,      VAT_TAXABLE_BASIS
,      VAT_TAX_ACCOUNT_ID
,      VAT_TAX_CLASS
,      VAT_TAX_CODE
,      VAT_TAX_GLOBAL_ATTR1
,      VAT_TAX_GLOBAL_ATTR2
,      VAT_TAX_GLOBAL_ATTR3
,      VAT_TAX_GLOBAL_ATTR4
,      VAT_TAX_GLOBAL_ATTR5
,      VAT_TAX_GLOBAL_ATTR6
,      VAT_TAX_GLOBAL_ATTR7
,      VAT_TAX_GLOBAL_ATTR_CAT
,      VAT_TAX_ID
,      VAT_TAX_RATE
,      VAT_TAX_TRX_TYPE
,      VAT_TAX_TYPE
,      TAX_LOC_VALUE_ACCT_ID
,      EVENT_ID
,      LINE_NUMBER
,      LANGUAGE
,      LEDGER_ID
FROM APPS.AR_TRX_TAX_L_V;

Dependencies

[top of page]

APPS.AR_TRX_TAX_L_V references the following:

APPS: AR_LOCATION_ACCOUNTS_ALL; AR_SALES_TAX; AR_VAT_TAX_ALL_B; AR_XLA_LINES_EXTRACT; RA_TAX_EXEMPTIONS_ALL

APPS.AR_TRX_TAX_L_V is not referenced by any database object