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_23AC_II_TRXS

Object Details

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

Stores Information of RG23A/C Part II Details. This is commonly referred to as the Amount Register.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_RG_23AC_II_TRXS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REGISTER_ID
JAI_CMN_RG_23AC_II_TRXS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SLNO
JAI_CMN_RG_23AC_II_TRXS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LOCATION_ID REGISTER_TYPE FIN_YEAR
JAI_CMN_RG_23AC_II_TRXS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_REF

Columns

Name	Datatype	Length	Mandatory	Comments
REGISTER_ID	NUMBER	(15)	Yes	Indicates the Register Identifier - Unique Key.
FIN_YEAR	NUMBER	(9)	Yes	Indicates the Financial Year in which the Transaction is carried out.
SLNO	NUMBER	(15)	Yes	Indicates the Serial No of the Transaction.
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Indicates the Inventory Item Identifier.
ORGANIZATION_ID	NUMBER	(15)	Yes	Indicates the Organization Identifier.
RECEIPT_DATE	DATE			Indicates the Date of Receipt.
RANGE_NO	VARCHAR2	(50)		Indicates the Range No of the Customer/Supplier.
DIVISION_NO	VARCHAR2	(50)		Indicates the Division No of the Customer/Supplier.
CR_BASIC_ED	NUMBER			Indicates the Credit Basic Excise Duty.
CR_ADDITIONAL_ED	NUMBER			Indicates the Credit Additional Excise Duty.
CR_OTHER_ED	NUMBER			Indicates the Credit Other Excise Duty.
DR_BASIC_ED	NUMBER			Indicates the Debit Basic Excise Duty.
DR_ADDITIONAL_ED	NUMBER			Indicates the Debit Additional Excise Duty.
DR_OTHER_ED	NUMBER			Indicates the Debit Other Excise Duty.
EXCISE_INVOICE_NO	VARCHAR2	(200)		Indicates the Excise Invoice No.
EXCISE_INVOICE_DATE	DATE			Indicates the Excise Invoice Date.
REGISTER_TYPE	VARCHAR2	(2)		Indicates the Register Type (Possible Values are A or C).
REMARKS	VARCHAR2	(100)		Indicates the Remarks if any.
VENDOR_ID	NUMBER	(15)		Indicates the Supplier Identifier.
VENDOR_SITE_ID	NUMBER	(15)		Indicates the Supplier Site Identifier.
CUSTOMER_ID	NUMBER	(15)		Indicates the Customer Identifier.
CUSTOMER_SITE_ID	NUMBER	(15)		Indicates the Customer Site Identifier.
LOCATION_ID	NUMBER	(15)		Indicates the Location Identifier.
TRANSACTION_DATE	DATE			Indicates the Transaction Date.
OPENING_BALANCE	NUMBER			Indicates the Opening Balance.
CLOSING_BALANCE	NUMBER			Indicates the Closing Balance of the Record.
CHARGE_ACCOUNT_ID	NUMBER	(15)		Indicates the Charge Account Either RM Account or CG Account.
REGISTER_ID_PART_I	NUMBER	(15)		Indicates Register Identifier of the Quantity Register (Either RG23 Part I or RG I).
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 that the Record is Posted for Master Org Consolidation.
MASTER_FLAG	VARCHAR2	(1)		Indicates whether this Record is for a Master Organization.
REFERENCE_NUM	VARCHAR2	(30)		Indicates the Reference Number.
BOL_ID	NUMBER	(10)		Indicates bill of lading identifier in case of order fulfillment in OPM. This is obsolete in R12
BOLLINE_NO	NUMBER	(5)		Indicates bill of lading line number in case of order fulfillment in OPM. This is obsolete in R12
PERIOD_BALANCE_ID	NUMBER	(15)		Period Balance Identifier
ROUNDING_ID	NUMBER	(15)		Rounding Identifier
OTHER_TAX_CREDIT	NUMBER			Tax Credit that is taken against tax types other than Excise, Addl. Excise, Other Excise and CVD
OTHER_TAX_DEBIT	NUMBER			Tax Debit that is taken against tax types other than Excise, Addl. Excise, Other Excise and CVD
TRANSACTION_SOURCE_NUM	NUMBER	(15)		Indicates the Transaction Identifier for each Transaction.
RECEIPT_REF	VARCHAR2	(50)		Indicates the Receipt Identifier (References Transaction Identifier of the parent Transaction).
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
ADDITIONAL_CVD_AMT	NUMBER	(38)		This column stores Additional cvd amount.
CR_ADDITIONAL_CVD	NUMBER	(38)		This column stores the Credit Additional CVD Amount
DR_ADDITIONAL_CVD	NUMBER	(38)		This column stores the Debit Additional CVD Amount

Query Text

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


SELECT REGISTER_ID
,      FIN_YEAR
,      SLNO
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      RECEIPT_DATE
,      RANGE_NO
,      DIVISION_NO
,      CR_BASIC_ED
,      CR_ADDITIONAL_ED
,      CR_OTHER_ED
,      DR_BASIC_ED
,      DR_ADDITIONAL_ED
,      DR_OTHER_ED
,      EXCISE_INVOICE_NO
,      EXCISE_INVOICE_DATE
,      REGISTER_TYPE
,      REMARKS
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      LOCATION_ID
,      TRANSACTION_DATE
,      OPENING_BALANCE
,      CLOSING_BALANCE
,      CHARGE_ACCOUNT_ID
,      REGISTER_ID_PART_I
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      POSTED_FLAG
,      MASTER_FLAG
,      REFERENCE_NUM
,      BOL_ID
,      BOLLINE_NO
,      PERIOD_BALANCE_ID
,      ROUNDING_ID
,      OTHER_TAX_CREDIT
,      OTHER_TAX_DEBIT
,      TRANSACTION_SOURCE_NUM
,      RECEIPT_REF
,      OBJECT_VERSION_NUMBER
,      ADDITIONAL_CVD_AMT
,      CR_ADDITIONAL_CVD
,      DR_ADDITIONAL_CVD
FROM JA.JAI_CMN_RG_23AC_II_TRXS;

Dependencies

[top of page]

JA.JAI_CMN_RG_23AC_II_TRXS does not reference any database object

JA.JAI_CMN_RG_23AC_II_TRXS is referenced by following:

APPS: JAI_CMN_RG_23AC_II_TRXS; JAI_JRG_23AC2_BRIUD_T1