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.

[Home] [Help]

Table: JAI_CMN_RG_EXC_INV_NOS

Product:	JA - Asia/Pacific Localizations
Description:	Stores setup information to generate excise invoice numbers
Implementation/DBA Data:	JA.JAI_CMN_RG_EXC_INV_NOS

Primary Key: JAI_CMN_RG_EXC_INV_NOS_PK

EXC_INV_NUM_ID

Primary Key: JAI_CMN_RG_EXC_INV_NOS_UK1

ORGANIZATION_ID
LOCATION_ID
FIN_YEAR
TRANSACTION_TYPE
ORDER_INVOICE_TYPE
REGISTER_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
JAI_CMN_RG_EXC_INV_NOS		JAI_CMN_FIN_YEARS	JAI_CMN_RG_EXC_INV_NOS.ORGANIZATION_ID JAI_CMN_RG_EXC_INV_NOS.FIN_YEAR
JAI_CMN_RG_EXC_INV_NOS		HR_LOCATIONS_ALL	JAI_CMN_RG_EXC_INV_NOS.LOCATION_ID