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_ETCS_T

Object Details

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

This is a temporary table used for e-tcs filing

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Batch Identifier
CHALLAN_LINE_NUM	NUMBER	(15)		Line number of the challan record
DEDUCTEE_LINE_NUM	NUMBER	(15)		Line number of the deductee record
SOURCE_DOCUMENT_ID	NUMBER	(15)	Yes	Document Identifier of the Invoice, Receipt, CM
SOURCE_DOCUMENT_DATE	DATE			Transaction Date of the Document
SOURCE_DOCUMENT_TYPE	VARCHAR2	(50)		Type of the Document
LINE_AMT	NUMBER			Line Amount of the Document
EXEMPTED_FLAG	VARCHAR2	(2)		TCS Exempted Flag
TCS_TAX_RATE	NUMBER			TCS Tax Rate
TCS_AMT	NUMBER			Amount of TCS type tax applicable
SURCHARGE_AMT	NUMBER			Amount of Surcharge applicable
CESS_AMT	NUMBER			Amount of Cess applicable
TCS_CHECK_ID	NUMBER	(15)		Indicates the TCS Check Identifier
CHALLAN_NO	VARCHAR2	(25)		Challan Number
CHALLAN_DATE	DATE			Challan Date
BANK_BRANCH_CODE	VARCHAR2	(25)		Bank Branch Code
PARTY_ID	NUMBER			Party Identifier
PARTY_SITE_ID	NUMBER		Yes	Party Site Code
PARTY_CODE	VARCHAR2	(2)		Buyer Code
PARTY_PAN	VARCHAR2	(10)		Party PAN
CHECK_NUMBER	NUMBER	(15)		Check Number
CERTIFICATE_ISSUE_DATE	DATE			Certificate Issue Date
TCS_CHECK_DATE	DATE			TCS Check Date
COLLECTION_FLAG	VARCHAR2	(1)		Collection Flag of TCS Item
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
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT BATCH_ID
,      CHALLAN_LINE_NUM
,      DEDUCTEE_LINE_NUM
,      SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_DATE
,      SOURCE_DOCUMENT_TYPE
,      LINE_AMT
,      EXEMPTED_FLAG
,      TCS_TAX_RATE
,      TCS_AMT
,      SURCHARGE_AMT
,      CESS_AMT
,      TCS_CHECK_ID
,      CHALLAN_NO
,      CHALLAN_DATE
,      BANK_BRANCH_CODE
,      PARTY_ID
,      PARTY_SITE_ID
,      PARTY_CODE
,      PARTY_PAN
,      CHECK_NUMBER
,      CERTIFICATE_ISSUE_DATE
,      TCS_CHECK_DATE
,      COLLECTION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_ETCS_T;

Dependencies

[top of page]

JA.JAI_AR_ETCS_T does not reference any database object

JA.JAI_AR_ETCS_T is referenced by following:

APPS: JAI_AR_ETCS_T