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.
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
TAX_TYPE_ID NUMBER (15)
Tax Type ID
REVERSE_CHARGE_FLAG VARCHAR2 (1)
Reverse Charge Flag
AUTO_CREATE_CATEGORY VARCHAR2 (1)
Auto create TDS tax category flag
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
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      TAX_TYPE_ID
,      REVERSE_CHARGE_FLAG
,      AUTO_CREATE_CATEGORY
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:

SchemaJA
ViewJAI_CMN_TAXES_ALL#