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_THHOLD_TRXS

Object Details

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

This table stores the details of all transactions where TDS invoices have been generated by the system.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_THHOLD_TRXS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID
JAI_AP_TDS_THHOLD_TRXS_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THRESHOLD_TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
THRESHOLD_TRX_ID	NUMBER	(15)	Yes	Threshold transaction identifier
INVOICE_ID	NUMBER	(15)	Yes	Invoice Identifier
THRESHOLD_GRP_ID	NUMBER	(15)		Threshold Group identifier
THRESHOLD_HDR_ID	NUMBER	(15)		Threshold Group idenitifier
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice Distribution identifier
TDS_EVENT	VARCHAR2	(100)		TDS event at which the processing has happened. Possible values are , INVOICE VALIDATE, PREPAYMENT APPLICATION, PREPAYMENT UNAPPLICATION, THRESHOLD TRANSITION, INVOICE CANCEL
TAX_ID	NUMBER	(15)		Tax identifier
TAX_RATE	NUMBER			Tax rate
TAXABLE_AMOUNT	NUMBER			Taxable basis, amount on which tax is calculated
TAX_AMOUNT	NUMBER			Tax amount
TDS_AUTHORITY_VENDOR_ID	NUMBER	(15)		Supplier identifier for the TDS authority
TDS_AUTHORITY_VENDOR_SITE_ID	NUMBER	(15)		Supplier site identifier for the TDS authority
INVOICE_TO_TDS_AUTHORITY_NUM	VARCHAR2	(50)		Number of the invoice raised to TDS authority for TDS.
INVOICE_TO_TDS_AUTHORITY_TYPE	VARCHAR2	(25)		Type of the Invoice that is raised to the TDS authority. Possible values are STANDARD and CREDIT
INVOICE_TO_TDS_AUTHORITY_CURR	VARCHAR2	(15)		Currency of the invoice for TDS authority. Currently this will always be the functional currency INR.
INVOICE_TO_TDS_AUTHORITY_AMT	NUMBER			Amount of the invoice to TDS authority.
INVOICE_TO_TDS_AUTHORITY_ID	NUMBER	(15)		Invoice identifier of the invoice to TDS authority. This value is populated after the Invoice is imported by payables open interface.
VENDOR_ID	NUMBER	(15)		Supplier Idenitifier
VENDOR_SITE_ID	NUMBER	(15)		Supplier Site Identifier
INVOICE_TO_VENDOR_NUM	VARCHAR2	(50)		Invoice number that is raised to the supplier for TDS.
INVOICE_TO_VENDOR_TYPE	VARCHAR2	(25)		Type of the invoice raised to the supplier for TDS
INVOICE_TO_VENDOR_CURR	VARCHAR2	(15)		Currency of the invoice raised to the supplier for TDS. This will always be in the currency of the invoice on which the tds is being deducted.
INVOICE_TO_VENDOR_AMT	NUMBER			Amount of the invoice raised to the supplier for TDS
INVOICE_TO_VENDOR_ID	NUMBER	(15)		Invoice identifier of invoice raised to the supplier for TDS
PARENT_INV_PAYMENT_PRIORITY	NUMBER	(9)		Payment priority of the parent invoice.
PARENT_INV_EXCHANGE_RATE	NUMBER			Exchange rate for the parent invoice
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.
INVOICE_LINE_NUMBER	NUMBER	(15)		Invoice Line Number
CALC_TAX_AMOUNT	NUMBER			Indicates the non-rounded TDS amount.
TDS_ROUNDING_FACTOR	NUMBER			Indicates the rounding factor that has been used for calculating TDS Amount
TDS_ROLLBACKED	VARCHAR2	(1)		Indicates 'Y' if the TDS Transactions are roll-backed. When Rollback happens all TDS Invoices created prior to Rollback except the TDS Invoice created on SINGLE slab will be reversed via Rollback Invoice
ROLLBACK_REVERSED	VARCHAR2	(1)		Flag is marked 'Y' if Threshold Transition happens again after Rollback.
TDS_SECTION_CODE	VARCHAR2	(30)		Indicates the Section Code for which TDS is generated.
TAX_CATEGORY_ID	NUMBER			Tax Category ID

Query Text

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


SELECT THRESHOLD_TRX_ID
,      INVOICE_ID
,      THRESHOLD_GRP_ID
,      THRESHOLD_HDR_ID
,      INVOICE_DISTRIBUTION_ID
,      TDS_EVENT
,      TAX_ID
,      TAX_RATE
,      TAXABLE_AMOUNT
,      TAX_AMOUNT
,      TDS_AUTHORITY_VENDOR_ID
,      TDS_AUTHORITY_VENDOR_SITE_ID
,      INVOICE_TO_TDS_AUTHORITY_NUM
,      INVOICE_TO_TDS_AUTHORITY_TYPE
,      INVOICE_TO_TDS_AUTHORITY_CURR
,      INVOICE_TO_TDS_AUTHORITY_AMT
,      INVOICE_TO_TDS_AUTHORITY_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      INVOICE_TO_VENDOR_NUM
,      INVOICE_TO_VENDOR_TYPE
,      INVOICE_TO_VENDOR_CURR
,      INVOICE_TO_VENDOR_AMT
,      INVOICE_TO_VENDOR_ID
,      PARENT_INV_PAYMENT_PRIORITY
,      PARENT_INV_EXCHANGE_RATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
,      CALC_TAX_AMOUNT
,      TDS_ROUNDING_FACTOR
,      TDS_ROLLBACKED
,      ROLLBACK_REVERSED
,      TDS_SECTION_CODE
,      TAX_CATEGORY_ID
FROM JA.JAI_AP_TDS_THHOLD_TRXS;

Dependencies

[top of page]

JA.JAI_AP_TDS_THHOLD_TRXS does not reference any database object

JA.JAI_AP_TDS_THHOLD_TRXS is referenced by following:

JA: JAI_AP_TDS_THHOLD_TRXS#