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_CUS_ADDRESSES

Object Details

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

Holds the Additional Customer information such as excise and sales tax registration numbers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_CUS_ADDRESSES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_ADDRESS_ID
JAI_CMN_CUS_ADDRESSES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID ADDRESS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_ID	NUMBER		Yes	Indicates the customer identifier.
ADDRESS_ID	NUMBER		Yes	Indicates the address identifier of the customer.
PAN_NO	VARCHAR2	(30)		Indicates the PAN number of the customer.
TAN_NO	VARCHAR2	(30)		Indicates the TAN number of the customer.
EXCISE_DUTY_REGION	VARCHAR2	(50)		Indicates the excise duty region of the customer.
EXCISE_DUTY_ZONE	VARCHAR2	(50)		Indicates the excise duty zone of the customer.
EXCISE_DUTY_REG_NO	VARCHAR2	(50)		Indicates the excise duty registration number of the customer.
EXCISE_DUTY_RANGE	VARCHAR2	(50)		Indicates the excise duty range of the customer.
EXCISE_DUTY_DIVISION	VARCHAR2	(50)		Indicates the excise duty division of the customer.
EXCISE_DUTY_CIRCLE	VARCHAR2	(50)		Indicates the excise duty circle of the customer.
EXCISE_DUTY_COMM	VARCHAR2	(50)		Indicates the excise duty commissioner of the customer.
TAX_CATEGORY_LIST	VARCHAR2	(50)		Indicates the tax category list of the customer.
PRICE_LIST_ID	NUMBER			Indicates the Excise assessable pricelist of the customer.
ST_REG_NO	VARCHAR2	(50)		Indicates the Sales Tax registration number of the customer.
CST_REG_NO	VARCHAR2	(50)		Indicates the Central Sales Tax registration number of the customer.
EC_CODE	VARCHAR2	(50)		Indicates the Excise Control code of the customer.
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
EXEMPT	VARCHAR2	(2)		Indicates whether the customer / Customer Site is exempted or not.
VAT_REG_NO	VARCHAR2	(50)		Indicates the VAT registration number of the Customer.
SERVICE_TAX_REGNO	VARCHAR2	(50)		Indicates the service tax registration number for customer and site
VAT_PRICE_LIST_ID	NUMBER			Indicates the VAT Price list for the Customer and site
CUSTOMER_ADDRESS_ID	NUMBER	(15)	Yes	Customer address identifier
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
CONFIRM_PAN	VARCHAR2	(2)		Indicates whether the customer has confirmed the pan number
SERVICE_TYPE_CODE	VARCHAR2	(30)		Indicates the service type for the customer
TCS_CUSTOMER_TYPE	VARCHAR2	(30)		Indicates the customer type as per the TCS regime.
STATE_CODE	VARCHAR2	(30)		The code of India State
GST_ASSESSABLE_PRICE	NUMBER			GST Assessable Price
GST_REGISTRATION_NO	NUMBER			GST Registration Number
CUSTOMER_TYPE	VARCHAR2	(30)		Customer Type
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

Query Text

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


SELECT CUSTOMER_ID
,      ADDRESS_ID
,      PAN_NO
,      TAN_NO
,      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
,      PRICE_LIST_ID
,      ST_REG_NO
,      CST_REG_NO
,      EC_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EXEMPT
,      VAT_REG_NO
,      SERVICE_TAX_REGNO
,      VAT_PRICE_LIST_ID
,      CUSTOMER_ADDRESS_ID
,      OBJECT_VERSION_NUMBER
,      CONFIRM_PAN
,      SERVICE_TYPE_CODE
,      TCS_CUSTOMER_TYPE
,      STATE_CODE
,      GST_ASSESSABLE_PRICE
,      GST_REGISTRATION_NO
,      CUSTOMER_TYPE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
FROM JA.JAI_CMN_CUS_ADDRESSES;

Dependencies

[top of page]

JA.JAI_CMN_CUS_ADDRESSES does not reference any database object

JA.JAI_CMN_CUS_ADDRESSES is referenced by following:

JA: JAI_CMN_CUS_ADDRESSES#