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: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_VAT_TAX_ALL_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVAT_TAX_ID
AR_VAT_TAX_ALL_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnTAX_CODE
ColumnSTART_DATE
AR_VAT_TAX_ALL_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnTAX_TYPE
ColumnSTART_DATE
AR_VAT_TAX_ALL_B_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_ACCOUNT_ID
AR_VAT_TAX_ALL_B_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_CODE
ColumnSTART_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:

SchemaAPPS
SynonymAR_VAT_TAX
SynonymAR_VAT_TAX_ALL_B
SynonymAR_VAT_TAX_B