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: TableJA.JAI_CMN_VENDOR_SITES
Subobject Name:
Status: VALID


Stores excise account related information about vendors.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_VENDOR_SITES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
ColumnVENDOR_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:

SchemaJA
ViewJAI_CMN_VENDOR_SITES#