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

TABLE: JA.JAI_CMN_TAXES_ALL

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


Stores the tax lines that are attached to tax categories defined in JA_IN_TAX_CATEOGORIES table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_TAXES_ALL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_ID
JAI_CMN_TAXES_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_TYPE
JAI_CMN_TAXES_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_NAME
Columns
Name Datatype Length Mandatory Comments
TAX_ID NUMBER (15) Yes Unique identifier generated by system.
TAX_NAME VARCHAR2 (50) Yes Tax name.
TAX_DESCR VARCHAR2 (100)
Tax description.
TAX_TYPE VARCHAR2 (30) Yes Tax type, this is user defined.
TAX_RATE NUMBER

Tax rate.
TAX_AMOUNT NUMBER

Tax amount.
UOM_CODE VARCHAR2 (3)
Unit of Measure code.
ADHOC_FLAG VARCHAR2 (1)
Value of Y, Indicated if the tax is Adhoc. For adhoc taxes user enters the amount.
VENDOR_ID NUMBER

Supplier identifier
VENDOR_FLAG VARCHAR2 (1)
Indicates if supplier for this tax can be changed in a transaction. Y-> can be changed.
VENDOR_SITE_ID NUMBER

Supplier site identifier
MODIFIABLE_FLAG VARCHAR2 (1)
Transaction modifiable flag.
TAX_ACCOUNT_ID NUMBER (15)
Tax charge account.
MOD_CR_PERCENTAGE NUMBER

Modvat credit percentage.
STFORM_TYPE VARCHAR2 (20)
Sales Tax form for discounted tax rate, if any. Lookup Code
ORIG_TAX_PERCENTAGE NUMBER

Original tax percentage.
TDS_SECTION VARCHAR2 (30)
TDS section. Lookup Code
CURRENCY_FLAG VARCHAR2 (1)
Indicates if Currency can be changed for this tax in transactions. Y -> can be changed.
START_DATE DATE
Yes Start date.
END_DATE DATE

End date.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ORG_ID NUMBER (15)
Organization identifier.
SURCHARGE_RATE NUMBER

Surcharge Rate.
SURCHARGE_FLAG VARCHAR2 (1)
Surcharge Flag.
ROUNDING_FACTOR NUMBER

Rounding factor.
DUTY_DRAWBACK_FLAG VARCHAR2 (1)
Duty Drawback Flag.
DUTY_DRAWBACK_PERCENTAGE NUMBER (15)
Duty Drawback Percentage.
VAT_FLAG VARCHAR2 (1)
Indicates if this is a VAT type of Tax. A VAT type of tax is internally set as a Sales type of tax.
SECTION_TYPE VARCHAR2 (30)
TDS Section Type. eg. TDS
SECTION_CODE VARCHAR2 (30)
Section Code relevant to Section Type. eg. Sec. 194(C) in of TDS Section Type
CESS_RATE NUMBER

Cess rate
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
SH_CESS_RATE NUMBER

Indicates the SHE CESS component of the TDS tax rate
INCLUSIVE_TAX_FLAG VARCHAR2 (1)
Indicates whether an tax is inclusive or not.
Query Text

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


SELECT TAX_ID
,      TAX_NAME
,      TAX_DESCR
,      TAX_TYPE
,      TAX_RATE
,      TAX_AMOUNT
,      UOM_CODE
,      ADHOC_FLAG
,      VENDOR_ID
,      VENDOR_FLAG
,      VENDOR_SITE_ID
,      MODIFIABLE_FLAG
,      TAX_ACCOUNT_ID
,      MOD_CR_PERCENTAGE
,      STFORM_TYPE
,      ORIG_TAX_PERCENTAGE
,      TDS_SECTION
,      CURRENCY_FLAG
,      START_DATE
,      END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      SURCHARGE_RATE
,      SURCHARGE_FLAG
,      ROUNDING_FACTOR
,      DUTY_DRAWBACK_FLAG
,      DUTY_DRAWBACK_PERCENTAGE
,      VAT_FLAG
,      SECTION_TYPE
,      SECTION_CODE
,      CESS_RATE
,      OBJECT_VERSION_NUMBER
,      SH_CESS_RATE
,      INCLUSIVE_TAX_FLAG
FROM JA.JAI_CMN_TAXES_ALL;

Dependencies

[top of page]

JA.JAI_CMN_TAXES_ALL does not reference any database object

JA.JAI_CMN_TAXES_ALL is referenced by following:

SchemaAPPS
SynonymJAI_CMN_TAXES_ALL