[Home] [Help] [Dependency Information]
Object Name: | AR_VAT_TAX_ALL_TL |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_VAT_TAX_ALL_TL |
Subobject Name: | |
Status: | VALID |
The AR_VAT_TAX_ALL_TL table provides multilingual support (MLS) for each tax code that you define in the Tax Codes and Rates window. MLS lets you store and print data that you define in multiple languages. For example, if you define a tax code in Spanish, the LANGUAGE column stores the code for Spanish.
.
The primary keys for this table are VAT_TAX_ID and LANGUAGE.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_VAT_TAX_ALL_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
VAT_TAX_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VAT_TAX_ID | NUMBER | (15) | Yes | Unique identifier |
ORG_ID | NUMBER | (15) | Organization identifier | |
PRINTED_TAX_NAME | VARCHAR2 | (60) | The name of this tax code as it appears on the printed invoice | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code of the tax code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of record that this record was copied from during upgrade |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
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). |
Cut, paste (and edit) the following text to query this object:
SELECT VAT_TAX_ID
, ORG_ID
, PRINTED_TAX_NAME
, LANGUAGE
, SOURCE_LANG
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM AR.AR_VAT_TAX_ALL_TL;
AR.AR_VAT_TAX_ALL_TL does not reference any database object
AR.AR_VAT_TAX_ALL_TL is referenced by following:
|
|
|