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_I_TRXS

Object Details

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

Stores Information of RG23A/C records and known as Quantity Register.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_RG_23AC_I_TRXS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SLNO
JAI_CMN_RG_23AC_I_TRXS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_REF
JAI_CMN_RG_23AC_I_TRXS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OTH_RECEIPT_ID_REF
JAI_CMN_RG_23AC_I_TRXS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LOCATION_ID REGISTER_TYPE INVENTORY_ITEM_ID FIN_YEAR
JAI_CMN_RG_23AC_I_TRXS_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGISTER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REGISTER_ID	NUMBER	(15)	Yes	Indicates the Register Identifier.
FIN_YEAR	NUMBER	(9)	Yes	Indicates the Financial Year.
SLNO	NUMBER	(15)	Yes	Indicates the Serial No.
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Indicates the Inventory Item Identifier.
ORGANIZATION_ID	NUMBER	(15)	Yes	Indicates the Organization Identifier.
QUANTITY_RECEIVED	NUMBER			Indicates the Receipt Quantity.
TRANSACTION_TYPE	VARCHAR2	(10)		Indicates the Transaction Type (Possible Values are CR,I,IA,IOI,IOR,PI,PR,R,RA,RTV).
RECEIPT_DATE	DATE			Indicates the Receipt Date.
RANGE_NO	VARCHAR2	(50)		Indicates the Range No.
DIVISION_NO	VARCHAR2	(50)		Indicates the Division No.
PO_HEADER_ID	NUMBER	(15)		Indicates the PO Header Identifier.
PO_HEADER_DATE	DATE			Indicates the PO Header Date.
PO_LINE_ID	NUMBER	(15)		Indicates the PO Line Identifier.
PO_LINE_LOCATION_ID	NUMBER	(15)		Indicates the PO Line Location Identifier.
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.
GOODS_ISSUE_DATE	DATE			Indicates the Goods Issue Date.
GOODS_ISSUE_QUANTITY	NUMBER			Indicates the Goods Issue Quantity.
SALES_INVOICE_DATE	DATE			Indicates the Sales Invoice Date.
SALES_INVOICE_QUANTITY	NUMBER			Indicates the Sales Invoice Quantity.
EXCISE_INVOICE_DATE	DATE			Indicates the Excise Invoice Date.
OTH_RECEIPT_QUANTITY	NUMBER			Indicates Other Receipt Quantity.
OTH_RECEIPT_DATE	DATE			Indicates Other Receipt Date.
REGISTER_TYPE	VARCHAR2	(2)		Indicates the Register Type ( Possible Values are A or C).
IDENTIFICATION_NO	VARCHAR2	(50)		Indicates the Identification No.
IDENTIFICATION_MARK	VARCHAR2	(100)		Indicates the Identification Mark.
BRAND_NAME	VARCHAR2	(50)		Indicates the Brand Name.
DATE_OF_VERIFICATION	DATE			Indicates the Date of Verification.
DATE_OF_INSTALLATION	DATE			Indicates the Date of Installation.
DATE_OF_COMMISSION	DATE			Indicates the Date of Commissioning of the Asset.
PLACE_OF_INSTALL	VARCHAR2	(50)		Indicates the Place of Installation of the Asset.
REMARKS	VARCHAR2	(120)		Indicates Remarks, If any.
LOCATION_ID	NUMBER	(15)	Yes	Indicates the Location Identifier.
PRIMARY_UOM_CODE	VARCHAR2	(3)		Indicates the Primary Unit of Measure.
TRANSACTION_UOM_CODE	VARCHAR2	(3)		Indicates the Transaction Unit of Measure.
TRANSACTION_DATE	DATE			Indicates the Transaction Date.
BASIC_ED	NUMBER			Indicates the Excise Duty of the Basic Excise Component.
ADDITIONAL_ED	NUMBER			Indicates the Excise Duty of the Additional Excise Component.
OTHER_ED	NUMBER			Indicates the Excise Duty of the Other Excise Component.
OPENING_BALANCE_QTY	NUMBER			Indicates the Opening Balance.
CLOSING_BALANCE_QTY	NUMBER			Indicates the Closing Balance.
CHARGE_ACCOUNT_ID	NUMBER	(15)		Indicates the Charge Account identifier.
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 the record is considered for Master Org consolidation(Possible values are Y,N and Null).
MASTER_FLAG	VARCHAR2	(1)		Indicates whether the record is a Master Org record(Possible values are Y,N and Null).
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
TRANSACTION_SOURCE_NUM	NUMBER	(15)		Indicates the Transaction Identifier.
RECEIPT_REF	VARCHAR2	(50)		Indicates the Receipt Identifier (Refers to Transaction Identifier of RCV_TRANSACTIONS Table).
GOODS_ISSUE_ID_REF	VARCHAR2	(30)		Indicates the Goods Issue Identifier.
SALES_INVOICE_NO	VARCHAR2	(240)		Indicates the Sales Invoice Identifier.
EXCISE_INVOICE_NO	VARCHAR2	(30)		Indicates the Excise Invoice Identifier.
OTH_RECEIPT_ID_REF	VARCHAR2	(30)		Indicates Other Receipt Identifier Reference.
REGISTER_ID_PART_II	NUMBER	(15)		Indicates the Register Identifier of the Corresponding Amount Register record.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
ADDITIONAL_CVD	NUMBER	(38)		This column stores the 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
,      QUANTITY_RECEIVED
,      TRANSACTION_TYPE
,      RECEIPT_DATE
,      RANGE_NO
,      DIVISION_NO
,      PO_HEADER_ID
,      PO_HEADER_DATE
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      GOODS_ISSUE_DATE
,      GOODS_ISSUE_QUANTITY
,      SALES_INVOICE_DATE
,      SALES_INVOICE_QUANTITY
,      EXCISE_INVOICE_DATE
,      OTH_RECEIPT_QUANTITY
,      OTH_RECEIPT_DATE
,      REGISTER_TYPE
,      IDENTIFICATION_NO
,      IDENTIFICATION_MARK
,      BRAND_NAME
,      DATE_OF_VERIFICATION
,      DATE_OF_INSTALLATION
,      DATE_OF_COMMISSION
,      PLACE_OF_INSTALL
,      REMARKS
,      LOCATION_ID
,      PRIMARY_UOM_CODE
,      TRANSACTION_UOM_CODE
,      TRANSACTION_DATE
,      BASIC_ED
,      ADDITIONAL_ED
,      OTHER_ED
,      OPENING_BALANCE_QTY
,      CLOSING_BALANCE_QTY
,      CHARGE_ACCOUNT_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
,      RECEIPT_REF
,      GOODS_ISSUE_ID_REF
,      SALES_INVOICE_NO
,      EXCISE_INVOICE_NO
,      OTH_RECEIPT_ID_REF
,      REGISTER_ID_PART_II
,      OBJECT_VERSION_NUMBER
,      ADDITIONAL_CVD
FROM JA.JAI_CMN_RG_23AC_I_TRXS;

Dependencies

[top of page]

JA.JAI_CMN_RG_23AC_I_TRXS does not reference any database object

JA.JAI_CMN_RG_23AC_I_TRXS is referenced by following:

APPS: JAI_CMN_RG_23AC_I_TRXS; JAI_JRG_23AC1_BRIUD_T1