eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_AP_TDS_THHOLD_GRPS

Object Details

Object Name:	JAI_AP_TDS_THHOLD_GRPS
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_AP_TDS_THHOLD_GRPS
Subobject Name:
Status:	VALID

This table stores the details of Threshold position for a unique combination of vendor, vendor pan and supplier tan for a fin year, section type and section code.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_THHOLD_GRPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	THRESHOLD_GRP_ID
JAI_AP_TDS_THHOLD_GRPS_UK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID ORG_TAN_NUM VENDOR_PAN_NUM SECTION_TYPE SECTION_CODE FIN_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
THRESHOLD_GRP_ID	NUMBER	(15)	Yes	Unique Identifier
VENDOR_ID	NUMBER	(15)	Yes	Supplier identifier
ORG_TAN_NUM	VARCHAR2	(30)	Yes	Organization TAN number
VENDOR_PAN_NUM	VARCHAR2	(30)	Yes	Vendor PAN number
SECTION_TYPE	VARCHAR2	(30)	Yes	Section Type. Currently the only value possible is "TDS_SECTION"
SECTION_CODE	VARCHAR2	(30)	Yes	Section Code
FIN_YEAR	NUMBER	(9)	Yes	Financial Year
TOTAL_INVOICE_AMOUNT	NUMBER			Total amount that has been invoiced having tds applicability against the section
TOTAL_INVOICE_CANCEL_AMOUNT	NUMBER			Total tds applicable invoice amount that has been cancelled.
TOTAL_INVOICE_APPLY_AMOUNT	NUMBER			Total tds applicable invoice amount that has been paid via tds applicable prepayments
TOTAL_INVOICE_UNAPPLY_AMOUNT	NUMBER			Total tds applicable prepayment amount that has been unapplied.
TOTAL_TAX_PAID	NUMBER			Total amount of TDS that has been paid.
TOTAL_THHOLD_CHANGE_TAX_PAID	NUMBER			Total tds amount that has been pais at TDS threshold transition. Total tax paid amount is inclusive of this amount.
CURRENT_THRESHOLD_SLAB_ID	NUMBER	(15)		Current tds threshold slab identifier.
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.
CUSTOMER_TYPE_LOOKUP_CODE	VARCHAR2	(30)
REGIME_ID	NUMBER	(22)

Query Text

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


SELECT THRESHOLD_GRP_ID
,      VENDOR_ID
,      ORG_TAN_NUM
,      VENDOR_PAN_NUM
,      SECTION_TYPE
,      SECTION_CODE
,      FIN_YEAR
,      TOTAL_INVOICE_AMOUNT
,      TOTAL_INVOICE_CANCEL_AMOUNT
,      TOTAL_INVOICE_APPLY_AMOUNT
,      TOTAL_INVOICE_UNAPPLY_AMOUNT
,      TOTAL_TAX_PAID
,      TOTAL_THHOLD_CHANGE_TAX_PAID
,      CURRENT_THRESHOLD_SLAB_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      CUSTOMER_TYPE_LOOKUP_CODE
,      REGIME_ID
FROM JA.JAI_AP_TDS_THHOLD_GRPS;

Dependencies

[top of page]

JA.JAI_AP_TDS_THHOLD_GRPS does not reference any database object

JA.JAI_AP_TDS_THHOLD_GRPS is referenced by following:

APPS: JAI_AP_TDS_THHOLD_GRPS