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

TABLE: JA.JAI_BOE_DETAIL_TAXES

Object Details
Object Name: JAI_BOE_DETAIL_TAXES
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_BOE_DETAIL_TAXES
Subobject Name:
Status: VALID


This table contains the BOE tax line info about the specific BOE line.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_BOE_DETAIL_TAXES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOE_DETAIL_TAX_ID
JAI_BOE_DETAIL_TAXES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOE_DETAIL_ID
Columns
Name Datatype Length Mandatory Comments
BOE_DETAIL_TAX_ID NUMBER (15) Yes Identifier of BOE Detail Tax.
BOE_DETAIL_ID NUMBER (15) Yes BOE Detail ID
TAX_LINE_NO VARCHAR2 (50) Yes BOE Tax Line Number
TAX_ID NUMBER (15)
Tax id
TAX_TYPE VARCHAR2 (30)
Tax type
TAX_RATE NUMBER

tax rate
ASSESSABLE_VALUE NUMBER

Assessable Value for the tax
TAX_AMOUNT NUMBER

Tax amount.
UOM NUMBER

Unit of Measure.
APPLIED_AMOUNT NUMBER

The amount which has been applied by receipt
QTY_RATE NUMBER

Quantity rate
PRECEDENCE_1 NUMBER

Precedence columns
PRECEDENCE_2 NUMBER

Precedence columns
PRECEDENCE_3 NUMBER

Precedence columns
PRECEDENCE_4 NUMBER

Precedence columns
PRECEDENCE_5 NUMBER

Precedence columns
PRECEDENCE_6 NUMBER

Precedence columns
PRECEDENCE_7 NUMBER

Precedence columns
PRECEDENCE_8 NUMBER

Precedence columns
PRECEDENCE_9 NUMBER

Precedence columns
PRECEDENCE_10 NUMBER

Precedence columns
BASE_TAX_AMOUNT NUMBER

Base tax amount
FUNC_TAX_AMOUNT NUMBER

Functional tax amount
INCLUSIVE_TAX_FLAG VARCHAR2 (1)
Inclusive tax flag
BOE_FLAG VARCHAR2 (1)
The flag of the tax which belongs to the BOE invoice
CREATION_DATE DATE
Yes Set who columns
CREATED_BY NUMBER (15) Yes Set who columns
LAST_UPDATE_DATE DATE
Yes Set who columns
LAST_UPDATED_BY NUMBER (15) Yes Set who columns
LAST_UPDATE_LOGIN NUMBER (15) Yes Set who columns
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
TAX_CATEGORY_ID NUMBER (15)
Tax category ID
Query Text

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


SELECT BOE_DETAIL_TAX_ID
,      BOE_DETAIL_ID
,      TAX_LINE_NO
,      TAX_ID
,      TAX_TYPE
,      TAX_RATE
,      ASSESSABLE_VALUE
,      TAX_AMOUNT
,      UOM
,      APPLIED_AMOUNT
,      QTY_RATE
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
,      BASE_TAX_AMOUNT
,      FUNC_TAX_AMOUNT
,      INCLUSIVE_TAX_FLAG
,      BOE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      TAX_CATEGORY_ID
FROM JA.JAI_BOE_DETAIL_TAXES;

Dependencies

[top of page]

JA.JAI_BOE_DETAIL_TAXES does not reference any database object

JA.JAI_BOE_DETAIL_TAXES is referenced by following:

SchemaJA
ViewJAI_BOE_DETAIL_TAXES#