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


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_CUS_ADDRESSES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ADDRESS_ID
JAI_CMN_CUS_ADDRESSES_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ID
ColumnADDRESS_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.
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
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:

SchemaAPPS
SynonymJAI_CMN_CUS_ADDRESSES