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_CMN_VENDOR_SITES

Object Details

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

Stores excise account related information about vendors.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_VENDOR_SITES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VENDOR_ID	NUMBER		Yes	Indicates Supplier Identifier.
VENDOR_SITE_ID	NUMBER		Yes	Indicates Supplier site Identifier.
EXCISE_DUTY_REGION	VARCHAR2	(50)		Indicates Excise Duty Region.
EXCISE_DUTY_ZONE	VARCHAR2	(50)		Indicates Excise Duty Zone.
EXCISE_DUTY_REG_NO	VARCHAR2	(50)		Indicates Excise Duty Registration No.
EXCISE_DUTY_RANGE	VARCHAR2	(50)		Indicates Excise Duty Range.
EXCISE_DUTY_DIVISION	VARCHAR2	(50)		Indicates Excise Duty Division.
EXCISE_DUTY_CIRCLE	VARCHAR2	(50)		Indicates Excise Duty Circle.
EXCISE_DUTY_COMM	VARCHAR2	(50)		Indicates Excise Duty Commissionerate.
TAX_CATEGORY_LIST	VARCHAR2	(50)		Indicates Tax Category List.
ST_REG_NO	VARCHAR2	(50)		Indicates Sales Tax Registration No.
CST_REG_NO	VARCHAR2	(50)		Indicates Central Sales Tax Registration No.
EC_CODE	VARCHAR2	(50)		Indicates the Excise registration code.z
INACTIVE_FLAG	VARCHAR2	(1)		Indicates whether the Information is Active or Inactive(possible values are Y or N).
PRICE_LIST_ID	NUMBER			Indicates the Price List identifier.
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
APPROVED_INVOICE_FLAG	VARCHAR2	(1)		Indicates the Approved Invoice Flag.
VENDOR_TYPE	VARCHAR2	(30)		Indicates Supplier Type.
DOCUMENT_TYPE	VARCHAR2	(30)		Indicates Excise Document Type.
OVERRIDE_FLAG	VARCHAR2	(1)		Indicates Over Ride Flag.
VAT_REG_NO	VARCHAR2	(50)		Indicates VAT Registration No.
SERVICE_TAX_REGNO	VARCHAR2	(50)		Service Tax Registration Number of Vendor and Site
VAT_PRICE_LIST_ID	NUMBER			VAT Price list application to Vendor and Site
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
SERVICE_TYPE_CODE	VARCHAR2	(30)		Indicates the service type for the Vendor Site
TAX_CATEGORY_ID	NUMBER	(15)		Tax Category Identifier
STATE_CODE	VARCHAR2	(30)		The code of India State
GST_ASSESSABLE_PRICE	NUMBER			GST Assessable Price
GST_REGISTRATION_NO	NUMBER			GST Registration Number
ATTRIBUTE1	VARCHAR2	(240)		Other Attribute1
ATTRIBUTE2	VARCHAR2	(240)		Other Attribute2
ATTRIBUTE3	VARCHAR2	(240)		Other Attribute3
ATTRIBUTE4	VARCHAR2	(240)		Other Attribute4
ATTRIBUTE5	VARCHAR2	(240)		Other Attribute5
ATTRIBUTE6	VARCHAR2	(240)		Other Attribute6
ATTRIBUTE7	VARCHAR2	(240)		Other Attribute7
ATTRIBUTE8	VARCHAR2	(240)		Other Attribute8
ATTRIBUTE9	VARCHAR2	(240)		Other Attribute9
ATTRIBUTE10	VARCHAR2	(240)		Other Attribute10
APPROVED_TDS_FLAG	VARCHAR2	(1)		Approved TDS flag

Query Text

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


SELECT VENDOR_ID
,      VENDOR_SITE_ID
,      EXCISE_DUTY_REGION
,      EXCISE_DUTY_ZONE
,      EXCISE_DUTY_REG_NO
,      EXCISE_DUTY_RANGE
,      EXCISE_DUTY_DIVISION
,      EXCISE_DUTY_CIRCLE
,      EXCISE_DUTY_COMM
,      TAX_CATEGORY_LIST
,      ST_REG_NO
,      CST_REG_NO
,      EC_CODE
,      INACTIVE_FLAG
,      PRICE_LIST_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      APPROVED_INVOICE_FLAG
,      VENDOR_TYPE
,      DOCUMENT_TYPE
,      OVERRIDE_FLAG
,      VAT_REG_NO
,      SERVICE_TAX_REGNO
,      VAT_PRICE_LIST_ID
,      OBJECT_VERSION_NUMBER
,      SERVICE_TYPE_CODE
,      TAX_CATEGORY_ID
,      STATE_CODE
,      GST_ASSESSABLE_PRICE
,      GST_REGISTRATION_NO
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      APPROVED_TDS_FLAG
FROM JA.JAI_CMN_VENDOR_SITES;

Dependencies

[top of page]

JA.JAI_CMN_VENDOR_SITES does not reference any database object

JA.JAI_CMN_VENDOR_SITES is referenced by following:

JA: JAI_CMN_VENDOR_SITES#