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]

VIEW: JA.JAI_AP_TDS_REPOSITORY#

Object Details

Object Name:	JAI_AP_TDS_REPOSITORY#
Object Type:	VIEW
Owner:	JA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TDS_REPOSITORY_ID	NUMBER		Yes
INVOICE_ID	NUMBER
INVOICE_NUMBER	VARCHAR2	(50)
TDS_AUTHORITY_ID	NUMBER
TDS_AUTHORITY_SITE_ID	NUMBER
TDS_INVOICE_TYPE	VARCHAR2	(100)
THRESHOLD_GRP_ID	NUMBER
THRESHOLD_HDR_ID	NUMBER
THRESHOLD_TYPE_ID	NUMBER
THRESHOLD_SLAB_ID	NUMBER
EVENT	VARCHAR2	(100)
SOURCE_INVOICE_ID	NUMBER		Yes
SOURCE_INVOICE_TYPE	VARCHAR2	(50)	Yes
SOURCE_INVOICE_AMT	NUMBER		Yes
SOURCE_ID	NUMBER		Yes
SOURCE_SITE_ID	NUMBER		Yes
SOURCE_INVOICE_DATE	DATE		Yes
ACCOUNTING_DATE	DATE		Yes
APPLIED_FROM_INVOICE_ID	NUMBER
APPLIED_FROM_INVOICE_TYPE	VARCHAR2	(50)
APPLIED_FROM_INVOICE_AMT	NUMBER
APPLIED_FROM_SUPPLIER_ID	NUMBER
APPLIED_FROM_SUPPLIER_SITE_ID	NUMBER
APPLIED_FROM_INVOICE_DATE	DATE
APPLIED_FROM_ACCTG_DATE	DATE
FROM_SLAB_ID	NUMBER
APPLIED_TO_INVOICE_ID	NUMBER
APPLIED_TO_INVOICE_TYPE	VARCHAR2	(50)
APPLIED_TO_INVOICE_AMT	NUMBER
APPLIED_TO_SUPPLIER_ID	NUMBER
APPLIED_TO_SUPPLIER_SITE_ID	NUMBER
APPLIED_TO_INVOICE_DATE	DATE
APPLIED_TO_ACCTG_DATE	DATE
APPLIED_AMOUNT	NUMBER
TO_SLAB_ID	NUMBER
UNAPPLIED_AMOUNT	NUMBER
TDS_ACCOUNTING_DATE	DATE
REGIME_ID	NUMBER		Yes
REGIME_CODE	VARCHAR2	(30)	Yes
ORG_ID	NUMBER		Yes
LEGAL_ENTITY_ID	NUMBER		Yes
ORG_TAN_NUMBER	VARCHAR2	(15)	Yes
SECTION_TYPE	VARCHAR2	(30)
SECTION_CODE	VARCHAR2	(30)
TAX_RATE	NUMBER
TAX_ID	NUMBER
TAX_CATEGORY_ID	NUMBER
TDS_PAID	VARCHAR2	(1)
INVOICE_DELETED	VARCHAR2	(1)
SOURCE_INVOICE_DELETED	VARCHAR2	(1)
PRIOR_THRESHOLD	VARCHAR2	(1)
CHALLAN_NUMBER	VARCHAR2	(30)
CHECK_DATE	DATE
CHECK_DEPOSIT_DATE	DATE
BSR_CODE	VARCHAR2	(30)
PAYMENT_REFERENCE_ID	VARCHAR2	(30)
TDS_INV_TAX_AMOUNT	NUMBER
SUPPLIER_CM_AMOUNT	NUMBER
BASE_TAX_AMOUNT	NUMBER
REQUIRED_FOR_ETDS	VARCHAR2	(1)	Yes
MIGRATED	VARCHAR2	(1)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
LAST_UPDATED_BY	NUMBER		Yes

Query Text

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


SELECT TDS_REPOSITORY_ID
,      INVOICE_ID
,      INVOICE_NUMBER
,      TDS_AUTHORITY_ID
,      TDS_AUTHORITY_SITE_ID
,      TDS_INVOICE_TYPE
,      THRESHOLD_GRP_ID
,      THRESHOLD_HDR_ID
,      THRESHOLD_TYPE_ID
,      THRESHOLD_SLAB_ID
,      EVENT
,      SOURCE_INVOICE_ID
,      SOURCE_INVOICE_TYPE
,      SOURCE_INVOICE_AMT
,      SOURCE_ID
,      SOURCE_SITE_ID
,      SOURCE_INVOICE_DATE
,      ACCOUNTING_DATE
,      APPLIED_FROM_INVOICE_ID
,      APPLIED_FROM_INVOICE_TYPE
,      APPLIED_FROM_INVOICE_AMT
,      APPLIED_FROM_SUPPLIER_ID
,      APPLIED_FROM_SUPPLIER_SITE_ID
,      APPLIED_FROM_INVOICE_DATE
,      APPLIED_FROM_ACCTG_DATE
,      FROM_SLAB_ID
,      APPLIED_TO_INVOICE_ID
,      APPLIED_TO_INVOICE_TYPE
,      APPLIED_TO_INVOICE_AMT
,      APPLIED_TO_SUPPLIER_ID
,      APPLIED_TO_SUPPLIER_SITE_ID
,      APPLIED_TO_INVOICE_DATE
,      APPLIED_TO_ACCTG_DATE
,      APPLIED_AMOUNT
,      TO_SLAB_ID
,      UNAPPLIED_AMOUNT
,      TDS_ACCOUNTING_DATE
,      REGIME_ID
,      REGIME_CODE
,      ORG_ID
,      LEGAL_ENTITY_ID
,      ORG_TAN_NUMBER
,      SECTION_TYPE
,      SECTION_CODE
,      TAX_RATE
,      TAX_ID
,      TAX_CATEGORY_ID
,      TDS_PAID
,      INVOICE_DELETED
,      SOURCE_INVOICE_DELETED
,      PRIOR_THRESHOLD
,      CHALLAN_NUMBER
,      CHECK_DATE
,      CHECK_DEPOSIT_DATE
,      BSR_CODE
,      PAYMENT_REFERENCE_ID
,      TDS_INV_TAX_AMOUNT
,      SUPPLIER_CM_AMOUNT
,      BASE_TAX_AMOUNT
,      REQUIRED_FOR_ETDS
,      MIGRATED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM JA.JAI_AP_TDS_REPOSITORY#;

Dependencies

[top of page]

JA.JAI_AP_TDS_REPOSITORY# references the following:

JA: JAI_AP_TDS_REPOSITORY

JA.JAI_AP_TDS_REPOSITORY# is referenced by following:

APPS: JAI_AP_TDS_REPOSITORY