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_I_TRXS

Object Details

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

Stores Information required for RG 1 Register. It is a Quantity Register.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_RG_I_TRXS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REGISTER_ID
JAI_CMN_RG_I_TRXS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SLNO
JAI_CMN_RG_I_TRXS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LOCATION_ID INVENTORY_ITEM_ID FIN_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
REGISTER_ID	NUMBER	(15)	Yes	Indicates the register identifier that was generated.
REGISTER_ID_PART_II	NUMBER	(15)		Indicates the Register identifier of the RG23 Part II register.
FIN_YEAR	NUMBER	(9)	Yes	Indicates the Financial year of the transaction.
SLNO	NUMBER	(15)	Yes	Indicates the serial number of the transaction. This is generated based on the organization identifier, location identifier, inventory item identifier and fin year combination.
ORGANIZATION_ID	NUMBER	(15)	Yes	Indicates the Organization identifier of the transaction.
LOCATION_ID	NUMBER	(15)	Yes	Indicates the Location identifier of the transaction.
TRANSACTION_DATE	DATE		Yes	Indicates the Transaction date of the transaction.
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Indicates the inventory item identifier of the transaction transacted.
TRANSACTION_TYPE	VARCHAR2	(10)	Yes	Indicates the Transaction type; Possible values are I , R , IOR , IOI.
MANUFACTURED_QTY	NUMBER			Indicates Manufactured Quantity.
MANUFACTURED_PACKED_QTY	NUMBER			Indicates Manufactured Packed Quantity.
MANUFACTURED_LOOSE_QTY	NUMBER			Indicates Manufactured Loose Quantity.
FOR_HOME_USE_PAY_ED_QTY	NUMBER			Indicates Quantity transacted for Home Use.
FOR_HOME_USE_PAY_ED_VAL	NUMBER			Indicates Equivalent Excise Amount for Home Use.
FOR_EXPORT_PAY_ED_QTY	NUMBER			Indicates Quantity transacted for Domestic_with_Excise.
FOR_EXPORT_PAY_ED_VAL	NUMBER			Indicated Equivalent Excise amount for Domestic_with_Excise.
FOR_EXPORT_N_PAY_ED_QTY	NUMBER			Indicates Quantity Exported without Paying Excise Duty.
FOR_EXPORT_N_PAY_ED_VAL	NUMBER			Indicates Equivalent Excise Amount of goods Exported without Paying Excise Duty.
OTHER_PURPOSE	VARCHAR2	(30)		Indicates Quantity transacted for Other Purpose.
TO_OTHER_FACTORY_N_PAY_ED_QTY	NUMBER			Indicates Quantity transacted with other factory.
TO_OTHER_FACTORY_N_PAY_ED_VAL	NUMBER			Indicates Equivalent Excise Amount transacted with other factory.
OTHER_PURPOSE_N_PAY_ED_QTY	NUMBER			Indicates Quantity transacted for Other Purpose without paying Excise Duty.
OTHER_PURPOSE_N_PAY_ED_VAL	NUMBER			Indicates Equivalent Excise Amount transacted for Other Purpose without paying Excise duty.
OTHER_PURPOSE_PAY_ED_QTY	NUMBER			Indicates Quantity transacted for Other Purpose after paying Excise Duty.
OTHER_PURPOSE_PAY_ED_VAL	NUMBER			Indicates Equivalent Excise Amount transacted for Other Purpose paying Excise duty.
PRIMARY_UOM_CODE	VARCHAR2	(3)		Indicates Primary Unit of Measurement Code.
TRANSACTION_UOM_CODE	VARCHAR2	(3)		Indicates Transaction Unit of Measurement Code.
BALANCE_PACKED	NUMBER			Indicates Balance Quantity Packed.
BALANCE_LOOSE	NUMBER			Indicates Balance Quantity loose.
ISSUE_TYPE	VARCHAR2	(10)		Indicates Issue Type; possible values are HU, OPNE, EWE etc.
EXCISE_DUTY_AMOUNT	NUMBER			Indicates the amount of excise duty transacted.
EXCISE_INVOICE_NUMBER	VARCHAR2	(200)		Indicates the excise invoice number generated.
EXCISE_INVOICE_DATE	DATE			Indicates Excise Invoice Date.
PAYMENT_REGISTER	VARCHAR2	(10)		Indicates the Payment Register.
CHARGE_ACCOUNT_ID	NUMBER	(15)		Indicates the Account code to which the accounting entry is passed.
RANGE_NO	VARCHAR2	(50)		Indicates Excise Range Number.
DIVISION_NO	VARCHAR2	(50)		Indicates Excise Division Number.
REMARKS	VARCHAR2	(100)		Indicates Remarks.
BASIC_ED	NUMBER			Indicates Basic Excise Duty Amount.
ADDITIONAL_ED	NUMBER			Indicates Additional Excise Duty Amount.
OTHER_ED	NUMBER			Indicates Additional Excise Duty Amount.
EXCISE_DUTY_RATE	NUMBER			Indicates Excise Duty Rate.
VENDOR_ID	NUMBER	(15)		Indicates the supplier Identifier for the Purchase transaction.
VENDOR_SITE_ID	NUMBER	(15)		Indicates the supplier site identifier for the transaction.
CUSTOMER_ID	NUMBER	(15)		Indicates the Customer Identifier for the sale transaction.
CUSTOMER_SITE_ID	NUMBER	(15)		Indicates the Customer Site identifier for the Sale Transaction.
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
POSTED_FLAG	VARCHAR2	(1)		Indicates whether this record has been posted for RG Consolidation.
MASTER_FLAG	VARCHAR2	(1)		Indicates whether this record is for Master Org or not.
BOL_ID	NUMBER	(10)		Indicates bill of lading identifier in case of order fulfillment in OPM. This is no longer used
BOLLINE_NO	NUMBER	(5)		Indicates bill of lading line number in case of order fulfillment in OPM. This is no longer used
TRANSACTION_SOURCE_NUM	NUMBER	(15)		Indicates transaction identifier the transaction.
REF_DOC_NO	VARCHAR2	(30)		Indicates the Delivery Detail identifier of the shipment transaction.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
CESS_AMT	NUMBER			Stores the cess amount.
SOURCE	VARCHAR2	(30)		Stores the source from which the RG1 register has been populated.
SH_CESS_AMT	NUMBER			Indicates the amount of SHE Cess in RG1 register

Query Text

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


SELECT REGISTER_ID
,      REGISTER_ID_PART_II
,      FIN_YEAR
,      SLNO
,      ORGANIZATION_ID
,      LOCATION_ID
,      TRANSACTION_DATE
,      INVENTORY_ITEM_ID
,      TRANSACTION_TYPE
,      MANUFACTURED_QTY
,      MANUFACTURED_PACKED_QTY
,      MANUFACTURED_LOOSE_QTY
,      FOR_HOME_USE_PAY_ED_QTY
,      FOR_HOME_USE_PAY_ED_VAL
,      FOR_EXPORT_PAY_ED_QTY
,      FOR_EXPORT_PAY_ED_VAL
,      FOR_EXPORT_N_PAY_ED_QTY
,      FOR_EXPORT_N_PAY_ED_VAL
,      OTHER_PURPOSE
,      TO_OTHER_FACTORY_N_PAY_ED_QTY
,      TO_OTHER_FACTORY_N_PAY_ED_VAL
,      OTHER_PURPOSE_N_PAY_ED_QTY
,      OTHER_PURPOSE_N_PAY_ED_VAL
,      OTHER_PURPOSE_PAY_ED_QTY
,      OTHER_PURPOSE_PAY_ED_VAL
,      PRIMARY_UOM_CODE
,      TRANSACTION_UOM_CODE
,      BALANCE_PACKED
,      BALANCE_LOOSE
,      ISSUE_TYPE
,      EXCISE_DUTY_AMOUNT
,      EXCISE_INVOICE_NUMBER
,      EXCISE_INVOICE_DATE
,      PAYMENT_REGISTER
,      CHARGE_ACCOUNT_ID
,      RANGE_NO
,      DIVISION_NO
,      REMARKS
,      BASIC_ED
,      ADDITIONAL_ED
,      OTHER_ED
,      EXCISE_DUTY_RATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      POSTED_FLAG
,      MASTER_FLAG
,      BOL_ID
,      BOLLINE_NO
,      TRANSACTION_SOURCE_NUM
,      REF_DOC_NO
,      OBJECT_VERSION_NUMBER
,      CESS_AMT
,      SOURCE
,      SH_CESS_AMT
FROM JA.JAI_CMN_RG_I_TRXS;

Dependencies

[top of page]

JA.JAI_CMN_RG_I_TRXS does not reference any database object

JA.JAI_CMN_RG_I_TRXS is referenced by following:

APPS: JAI_CMN_RG_I_TRXS