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_AR_TDS_CERTIFICATES

Object Details

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

This Table is used to store details of TDS credit memo generated such as customer name , customer site , form number , form amount for creation of a AR credit memo.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_TDS_CERTIFICATES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TDS_CERTIFICATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_ID	NUMBER	(15)	Yes	Indicates Customer identifier from whom the TDS Credit memo is received.
SITE_USE_ID	NUMBER	(15)	Yes	Indicates the customer Site.
FORM_NAME	VARCHAR2	(30)	Yes	Indicates Form Name of the TDS Credit memo provided by the customer.
FORM_NUMBER	VARCHAR2	(30)	Yes	Indicates Form Number of the TDS Credit Memo provided by the customer.
CERTIFICATE_DATE	DATE		Yes	Indicates Certificate_date of the TDS credit memo as provided by the customer.
RECEIVED_DATE	DATE		Yes	Indicates the date when the TDS Credit memo was received from customer.
AMOUNT	NUMBER	(15)	Yes	Indicates form amount of the TDS Credit memo.
DESCRIPTION	VARCHAR2	(240)	Yes	Free text description for the TDS Certificate.
INTERFACE_LINE_ATTRIBUTE1	VARCHAR2	(30)	Yes	Holds the hard coded value CR.
INTERFACE_LINE_ATTRIBUTE2	VARCHAR2	(30)	Yes	Holds the next value from the sequence ja_in_tds_cert_info_s.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
TDS_CERTIFICATE_ID	NUMBER	(15)	Yes	TDS Certificate identifier
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT CUSTOMER_ID
,      SITE_USE_ID
,      FORM_NAME
,      FORM_NUMBER
,      CERTIFICATE_DATE
,      RECEIVED_DATE
,      AMOUNT
,      DESCRIPTION
,      INTERFACE_LINE_ATTRIBUTE1
,      INTERFACE_LINE_ATTRIBUTE2
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TDS_CERTIFICATE_ID
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_TDS_CERTIFICATES;

Dependencies

[top of page]

JA.JAI_AR_TDS_CERTIFICATES does not reference any database object

JA.JAI_AR_TDS_CERTIFICATES is referenced by following:

APPS: JAI_AR_TDS_CERTIFICATES