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_RG_EXC_INV_NOS

Object Details

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

Stores setup information to generate excise invoice numbers

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_RG_EXC_INV_NOS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXC_INV_NUM_ID
JAI_CMN_RG_EXC_INV_NOS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LOCATION_ID FIN_YEAR TRANSACTION_TYPE ORDER_INVOICE_TYPE REGISTER_CODE
JAI_CMN_RG_EXC_INV_NOS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER	(15)		Inventory Organization Identifier.
LOCATION_ID	NUMBER	(15)		Location identifier.
FIN_YEAR	NUMBER	(9)		Financial year identifier.
GP1	NUMBER			This column stores the value that needs to be used when a domestic shipment (within the country) is done.
GP2	NUMBER			This column stores the value that needs to be used when an export shipment (outside the country) is done.
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
ORDER_INVOICE_TYPE	VARCHAR2	(50)		This column holds the Order or Invoice type associated . Used for setting the prefix , start number , and jump by.
REGISTER_CODE	VARCHAR2	(80)		This column holds the register code . Possible values are Trading Domestic With Excise , Trading Domestic Without Excise , Trading Export Without Excise , Trading Export Without Excise (Bond) ,Bond Register, Domestic With Excise, Domestic Without Excise, Export With Excise , Domestic and Export.
START_NUMBER	NUMBER			Start number for generation of excise invoice number.
END_NUMBER	NUMBER			End number for generation of excise invoice number.
JUMP_BY	NUMBER			Difference between subsequent excise invoice numbers.
PREFIX	VARCHAR2	(50)		Prefix for excise inv no generation.
TRANSACTION_TYPE	VARCHAR2	(3)		This column indicates the transaction type. Possible values are : I Indicating Invoice , O Indicating Order and RTV Indicating Return to Vendor.
EXC_INV_NUM_ID	NUMBER	(15)	Yes	Excise invoice number unique identifier
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT ORGANIZATION_ID
,      LOCATION_ID
,      FIN_YEAR
,      GP1
,      GP2
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORDER_INVOICE_TYPE
,      REGISTER_CODE
,      START_NUMBER
,      END_NUMBER
,      JUMP_BY
,      PREFIX
,      TRANSACTION_TYPE
,      EXC_INV_NUM_ID
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_RG_EXC_INV_NOS;

Dependencies

[top of page]

JA.JAI_CMN_RG_EXC_INV_NOS does not reference any database object

JA.JAI_CMN_RG_EXC_INV_NOS is referenced by following:

JA: JAI_CMN_RG_EXC_INV_NOS#