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_VENDOR_HDRS

Object Details

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

This table stores information about all the TDS sections defined against a vendor and limit of each of the TDS sections. It also stores the information about deduction of TDS against all invoices or against each invoice for a particular vendor.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_VENDOR_HDRS_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_ID	NUMBER	(15)		Tax identifier.
VENDOR_ID	NUMBER		Yes	Supplier identifier
VENDOR_SITE_ID	NUMBER		Yes	Supplier site identifier
PAN_NO	VARCHAR2	(30)		PAN number of the supplier
TAN_NO	VARCHAR2	(30)		TAN number of the supplier
WARD_NO	VARCHAR2	(30)		WARD number.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
SECTION_TYPE	VARCHAR2	(30)		Indicates the section type. Possible values are TDS_SECTION, WCT_SECTION and ESSI_SECTION. Currently only TDS_SECTION is supported.
SECTION_CODE	VARCHAR2	(30)		Stores the section code that is the default section for TDS for the supplier. If the default tax is not specified, system finds out the applicable tax from threshold position.
CONFIRM_PAN_FLAG	VARCHAR2	(1)		Flag to indicate if the PAN number for the supplier has been confirmed. No change is allowed after this confirmation. TDS threshold calculation is based on this PAN number. Possible values are Y and N. Null is treated as N.
TDS_VENDOR_TYPE_LOOKUP_CODE	VARCHAR2	(30)		Stores the supplier classification used for finidng out the TDS threshold that is applicable for the supplier.
OBJECT_VERSION_NUMBER	NUMBER			Object version Number

Query Text

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


SELECT TAX_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PAN_NO
,      TAN_NO
,      WARD_NO
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECTION_TYPE
,      SECTION_CODE
,      CONFIRM_PAN_FLAG
,      TDS_VENDOR_TYPE_LOOKUP_CODE
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AP_TDS_VENDOR_HDRS;

Dependencies

[top of page]

JA.JAI_AP_TDS_VENDOR_HDRS does not reference any database object

JA.JAI_AP_TDS_VENDOR_HDRS is referenced by following:

APPS: JAI_AP_TDS_VENDOR_HDRS