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_FORM27_AMT_REC_DEBIT

Object Details

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

Stores TCS Amount Received/Debited. This table is populated when running India - TCS Certificates.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Comments
SOURCE_DOCUMENT_ID	NUMBER	Source Document ID
SOURCE_DOCUMENT_DATE	DATE	Source Document date
SOURCE_DOCUMENT_AMT	NUMBER	Source Document Amount
SETTLEMENT_ID	NUMBER	Settlement ID
CERTIFICATE_ID	NUMBER	Certificate ID
REQUEST_ID	NUMBER	Request ID

Query Text

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


SELECT SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_DATE
,      SOURCE_DOCUMENT_AMT
,      SETTLEMENT_ID
,      CERTIFICATE_ID
,      REQUEST_ID
FROM JA.JAI_FORM27_AMT_REC_DEBIT;

Dependencies

[top of page]

JA.JAI_FORM27_AMT_REC_DEBIT does not reference any database object

JA.JAI_FORM27_AMT_REC_DEBIT is referenced by following:

JA: JAI_FORM27_AMT_REC_DEBIT#