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_F16_HDRS_ALL

Object Details

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

Header information for TDS certificates.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_F16_HDRS_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORM16_HDR_ID
JAI_AP_TDS_F16_HDRS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CERTIFICATE_NUM
JAI_AP_TDS_F16_HDRS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID
JAI_AP_TDS_F16_HDRS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TDS_TAX_ID
JAI_AP_TDS_F16_HDRS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
JAI_AP_TDS_F16_HDRS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_TAN_NUM TDS_TAX_SECTION VENDOR_ID FIN_YR CERTIFICATE_NUM
JAI_AP_TDS_F16_HDRS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TDS_TAX_SECTION VENDOR_ID FIN_YR CERTIFICATE_NUM
JAI_AP_TDS_F16_HDRS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CERTIFICATE_NUM ORG_TAN_NUM FIN_YR

Columns

Name	Datatype	Length	Mandatory	Comments
CERTIFICATE_DATE	DATE			Date of creation of TDS certificate.
VENDOR_ID	NUMBER	(15)		Supplier identifier
VENDOR_SITE_ID	NUMBER	(15)		Supplier site identifier
TDS_TAX_ID	NUMBER	(15)		Tax identifier.
TDS_TAX_SECTION	VARCHAR2	(50)		TDS section for the Tax.
TAX_AUTHORITY_ID	NUMBER	(15)		Tax authority identifier.
FROM_DATE	DATE			Starting date of TDS report.
TO_DATE	DATE			End date of TDS report.
PRINT_FLAG	VARCHAR2	(1)		To identify Original / duplicate printing.
ORG_ID	NUMBER	(15)		Organization identifier.
ISSUE_DATE	DATE			Certificate Issue 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
FIN_YR	NUMBER	(9)		Financial Year for which the TDS certificate is generated.
ORG_TAN_NUM	VARCHAR2	(50)		Organization TAN number.
FORM16_HDR_ID	NUMBER	(15)	Yes	Form 16 header identifier
CERTIFICATE_NUM	NUMBER	(15)		Certificate number
PROGRAM_ID	NUMBER	(15)		Program identifier
PROGRAM_LOGIN_ID	NUMBER	(15)		Program login identifier
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program application identifier
REQUEST_ID	NUMBER	(15)		Request identifier
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT CERTIFICATE_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      TDS_TAX_ID
,      TDS_TAX_SECTION
,      TAX_AUTHORITY_ID
,      FROM_DATE
,      TO_DATE
,      PRINT_FLAG
,      ORG_ID
,      ISSUE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FIN_YR
,      ORG_TAN_NUM
,      FORM16_HDR_ID
,      CERTIFICATE_NUM
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AP_TDS_F16_HDRS_ALL;

Dependencies

[top of page]

JA.JAI_AP_TDS_F16_HDRS_ALL does not reference any database object

JA.JAI_AP_TDS_F16_HDRS_ALL is referenced by following:

JA: JAI_AP_TDS_F16_HDRS_ALL#