[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_STANDALONE_TAXES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOC_TAX_ID | NUMBER | Document tax identifier | ||
TAX_LINE_NO | NUMBER | (15) | Yes | Indicates the tax line number |
TAX_ID | NUMBER | (15) | Yes | Indicates the tax line number |
TAX_TYPE | VARCHAR2 | (30) | Yes | Indicates the tax type |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Indicates the currency of the tax |
TAX_RATE | NUMBER | Indicates the tax rate of the tax | ||
QTY_RATE | NUMBER | Indicates the rate per unit of the tax | ||
UOM | VARCHAR2 | (15) | Indicates the unit of measurement of the tax | |
TAX_AMT | NUMBER | Indicates the tax amount | ||
FUNC_TAX_AMT | NUMBER | Indicates the tax amount in ledger currency | ||
MODVAT_FLAG | VARCHAR2 | (1) | Indicates whether the tax is recoverable | |
TAX_CATEGORY_ID | NUMBER | (15) | Indicates the tax category identifier | |
SOURCE_DOC_TYPE | VARCHAR2 | (40) | Indicates the type of document for which the tax is attached | |
SOURCE_DOC_ID | NUMBER | (15) | Indicates the document identifier | |
SOURCE_DOC_LINE_ID | NUMBER | Indicates the document line identifier | ||
SOURCE_TABLE_NAME | VARCHAR2 | (40) | Indicates the table name | |
TAX_MODIFIED_BY | VARCHAR2 | (10) | Indicates whether the tax was modified in the front end | |
ADHOC_FLAG | VARCHAR2 | (1) | Indicates whether there is adhoc amount entered for the tax | |
PRECEDENCE_1 | NUMBER | (15) | Indicates precedence 1 | |
PRECEDENCE_2 | NUMBER | (15) | Indicates precedence 2 | |
PRECEDENCE_3 | NUMBER | (15) | Indicates precedence 3 | |
PRECEDENCE_4 | NUMBER | (15) | Indicates precedence 4 | |
PRECEDENCE_5 | NUMBER | (15) | Indicates precedence 5 | |
PRECEDENCE_6 | NUMBER | (15) | Indicates precedence 6 | |
PRECEDENCE_7 | NUMBER | (15) | Indicates precedence 7 | |
PRECEDENCE_8 | NUMBER | (15) | Indicates precedence 8 | |
PRECEDENCE_9 | NUMBER | (15) | Indicates precedence 9 | |
PRECEDENCE_10 | NUMBER | (15) | Indicates precedence 10 | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SOURCE_DOC_PARENT_LINE_NO | NUMBER | (15) | Indicates the item line number of the AP invoice line for which this tax is created |
Cut, paste (and edit) the following text to query this object:
SELECT DOC_TAX_ID
, TAX_LINE_NO
, TAX_ID
, TAX_TYPE
, CURRENCY_CODE
, TAX_RATE
, QTY_RATE
, UOM
, TAX_AMT
, FUNC_TAX_AMT
, MODVAT_FLAG
, TAX_CATEGORY_ID
, SOURCE_DOC_TYPE
, SOURCE_DOC_ID
, SOURCE_DOC_LINE_ID
, SOURCE_TABLE_NAME
, TAX_MODIFIED_BY
, ADHOC_FLAG
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_DOC_PARENT_LINE_NO
FROM APPS.JAI_AP_STANDALONE_TAXES_V;
APPS.JAI_AP_STANDALONE_TAXES_V is not referenced by any database object
|
|
|