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]

TABLE: AR.AR_VAT_TAX_ALL_B

Object Details

Object Name:	AR_VAT_TAX_ALL_B
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_VAT_TAX_ALL_B
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

This is the AR_VAT_TAX_ALL_B view
with PRINTED_TAX_NAME column removed.
May be used by all products

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_VAT_TAX_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VAT_TAX_ID
AR_VAT_TAX_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID TAX_CODE START_DATE
AR_VAT_TAX_ALL_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID TAX_TYPE START_DATE
AR_VAT_TAX_ALL_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_ACCOUNT_ID
AR_VAT_TAX_ALL_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_CODE START_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
VAT_TAX_ID	NUMBER	(15)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
TAX_CODE	VARCHAR2	(50)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
TAX_RATE	NUMBER
TAX_TYPE	VARCHAR2	(30)	Yes
VALIDATE_FLAG	VARCHAR2	(1)
TAX_ACCOUNT_ID	NUMBER	(15)
START_DATE	DATE		Yes
END_DATE	DATE
UNAPPROVED_EXEMPTION_FLAG	VARCHAR2	(1)		Flag that indicates whether an unapproved exemption can be created
DESCRIPTION	VARCHAR2	(60)		Tax code description
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ORG_ID	NUMBER	(15)		Organization identifier
VAT_TRANSACTION_TYPE	VARCHAR2	(30)		Transaction type for tax code
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved For Globalization Functionality
AMOUNT_INCLUDES_TAX_FLAG	VARCHAR2	(1)		When this flag is set to 'Y', then the tax code is inclusive by default.Otherwise, it is exclusive.
AMOUNT_INCLUDES_TAX_OVERRIDE	VARCHAR2	(1)		When this flag is set to 'Y', the value of AMOUNT_INCLUDES_TAX_FLAG can be overridden at time of usage. Otherwise, the AMOUNT_INCLUDES_TAX_FLAG at the tax code level must be used.
TAXABLE_BASIS	VARCHAR2	(30)		Lookup type, AR_TAXABLE_BASIS, for determining the taxable amount.
TAX_CALCULATION_PLSQL_BLOCK	VARCHAR2	(2000)		PL/SQL Block to calculate the tax amount.
INTERIM_TAX_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the deferred tax account.
ADJ_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the expense/revenue account for adjustments.
EDISC_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the expense account for earned discounts.
UNEDISC_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the expense account for unearned discounts.
FINCHRG_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the revenue account for finance charge.
ADJ_NON_REC_TAX_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the non-recoverable tax account for adjustments.
EDISC_NON_REC_TAX_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the non-recoverable tax account for earned discounts.
UNEDISC_NON_REC_TAX_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the non-recoverable tax account for unearned discounts.
FINCHRG_NON_REC_TAX_CCID	NUMBER	(15)		Code combination ID of the accounting flexfield for the non-recoverable.
TAX_CLASS	VARCHAR2	(1)		Input vs. Output Tax
DISPLAYED_FLAG	VARCHAR2	(1)		Displayed Flag
ENABLED_FLAG	VARCHAR2	(1)		Enabled Flag
TAX_CONSTRAINT_ID	NUMBER	(15)
TAX_REGIME_CODE	VARCHAR2	(30)		Tax Regime Code
TAX	VARCHAR2	(50)		Tax
TAX_STATUS_CODE	VARCHAR2	(30)		Tax Status Code
ADJUSTMENT_TAX_CODE	VARCHAR2	(50)		Tax code used for adjustment
LEASING_FLAG	VARCHAR2	(1)		Leasing Flag

Query Text

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


SELECT VAT_TAX_ID
,      SET_OF_BOOKS_ID
,      TAX_CODE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TAX_RATE
,      TAX_TYPE
,      VALIDATE_FLAG
,      TAX_ACCOUNT_ID
,      START_DATE
,      END_DATE
,      UNAPPROVED_EXEMPTION_FLAG
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      VAT_TRANSACTION_TYPE
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      AMOUNT_INCLUDES_TAX_FLAG
,      AMOUNT_INCLUDES_TAX_OVERRIDE
,      TAXABLE_BASIS
,      TAX_CALCULATION_PLSQL_BLOCK
,      INTERIM_TAX_CCID
,      ADJ_CCID
,      EDISC_CCID
,      UNEDISC_CCID
,      FINCHRG_CCID
,      ADJ_NON_REC_TAX_CCID
,      EDISC_NON_REC_TAX_CCID
,      UNEDISC_NON_REC_TAX_CCID
,      FINCHRG_NON_REC_TAX_CCID
,      TAX_CLASS
,      DISPLAYED_FLAG
,      ENABLED_FLAG
,      TAX_CONSTRAINT_ID
,      TAX_REGIME_CODE
,      TAX
,      TAX_STATUS_CODE
,      ADJUSTMENT_TAX_CODE
,      LEASING_FLAG
FROM AR.AR_VAT_TAX_ALL_B;

Dependencies

[top of page]

AR.AR_VAT_TAX_ALL_B does not reference any database object

AR.AR_VAT_TAX_ALL_B is referenced by following:

APPS: AR_VAT_TAX; AR_VAT_TAX_ALL_B; AR_VAT_TAX_B