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_INVOICES

Object Details

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

This table holds the history of all the TDS related invoice generated against invoices. It has the link of both the TDS invoice and the credit memo.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_INVOICES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TDS_INVOICE_ID
JAI_AP_TDS_INVOICES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID
JAI_AP_TDS_INVOICES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CERTIFICATE_NUMBER
JAI_AP_TDS_INVOICES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TDS_TAX_ID
JAI_AP_TDS_INVOICES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TDS_SECTION

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER	(15)		Invoice identifier.
INVOICE_AMOUNT	NUMBER			Invoice amount subjected to TDS.
DM_INVOICE_NUM	VARCHAR2	(50)		Supplier Debit memo invoice number that has been generated against the invoice.
TDS_INVOICE_NUM	VARCHAR2	(50)		TDS invoice number that has been generated against the invoice.
TDS_TAX_ID	NUMBER	(15)		Tax identifier.
TDS_SECTION	VARCHAR2	(50)		TDS section corresponding to the tax.
TDS_TAX_RATE	NUMBER			Tax rate.
TDS_AMOUNT	NUMBER			Amount deducted for TDS.
AMT_REVERSED	NUMBER			Amount reversed.
AMT_APPLIED	NUMBER			Prepayment Amount applied.
ORGANIZATION_ID	NUMBER	(15)		Organization identifier.
CERTIFICATE_NUMBER	VARCHAR2	(100)		Confessional tax Form.
SOURCE_ATTRIBUTE	VARCHAR2	(25)		Source Attribute used for tax type identification TDS/WCT.
TDS_INVOICE_ID	NUMBER	(15)	Yes	TDS invoice identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
AMT_OF_TDS	NUMBER			Amount of TDS deducted
AMT_OF_SURCHARGE	NUMBER			Amount of surcharge
AMT_OF_CESS	NUMBER			Amount of CESS applicable
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
AMT_OF_SH_CESS	NUMBER			Indicates the SHE Cess amount in the AP Invoice
TAX_CATEGORY_ID	NUMBER			Tax Category ID

Query Text

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


SELECT INVOICE_ID
,      INVOICE_AMOUNT
,      DM_INVOICE_NUM
,      TDS_INVOICE_NUM
,      TDS_TAX_ID
,      TDS_SECTION
,      TDS_TAX_RATE
,      TDS_AMOUNT
,      AMT_REVERSED
,      AMT_APPLIED
,      ORGANIZATION_ID
,      CERTIFICATE_NUMBER
,      SOURCE_ATTRIBUTE
,      TDS_INVOICE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      AMT_OF_TDS
,      AMT_OF_SURCHARGE
,      AMT_OF_CESS
,      OBJECT_VERSION_NUMBER
,      AMT_OF_SH_CESS
,      TAX_CATEGORY_ID
FROM JA.JAI_AP_TDS_INVOICES;

Dependencies

[top of page]

JA.JAI_AP_TDS_INVOICES does not reference any database object

JA.JAI_AP_TDS_INVOICES is referenced by following:

JA: JAI_AP_TDS_INVOICES#