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_PLA_TRXS

Object Details

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

Stores the Transaction Information of PLA Register.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_RG_PLA_TRXS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REGISTER_ID
JAI_CMN_RG_PLA_TRXS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LOCATION_ID FIN_YEAR SLNO

Columns

Name	Datatype	Length	Mandatory	Comments
REGISTER_ID	NUMBER		Yes	Indicates the Register Identifier of the Transaction.
FIN_YEAR	NUMBER	(9)		Indicates the Financial Year of the Transaction.
SLNO	NUMBER	(15)	Yes	Indicates the Serial Number of the Transaction.
TR6_CHALLAN_NO	VARCHAR2	(50)		Indicates the TR6 Challan No.
TR6_CHALLAN_DATE	DATE			Indicates the TR6 Challan Date.
CR_BASIC_ED	NUMBER			Indicates the Basic Excise Duty - Credit Amount.
CR_ADDITIONAL_ED	NUMBER			Indicates the Additional Excise Duty - Credit Amount.
CR_OTHER_ED	NUMBER			Indicates the Other Excise Duty - Credit Amount.
REF_DOCUMENT_ID	NUMBER	(15)		Indicates the Reference Document Identifier.
REF_DOCUMENT_DATE	DATE			Indicates the Reference Document Date.
DR_INVOICE_DATE	DATE			Indicates the Invoice Date of the Debit Transaction.
DR_BASIC_ED	NUMBER			Indicates the Basic Excise Duty - Debit Amount.
DR_ADDITIONAL_ED	NUMBER			Indicates the Additional Excise Duty - Debit Amount.
DR_OTHER_ED	NUMBER			Indicates the Other Excise Duty - Debit Amount.
ORGANIZATION_ID	NUMBER			Indicates the Organization Identifier of the Transaction.
LOCATION_ID	NUMBER			Indicates the Location Identifier of the Transaction.
BANK_BRANCH_ID	NUMBER			Indicates the Bank Branch Identifier.
ENTRY_DATE	DATE			Indicates the Date of Entry of the Transaction.
INVENTORY_ITEM_ID	NUMBER	(15)		Indicates the Inventory Item Identifier of the Transaction.
VENDOR_CUST_FLAG	VARCHAR2	(1)		Indicates whether transaction is against a Supplier or a Customer (Possible Values are V and C).
VENDOR_ID	NUMBER	(15)		Indicates the Supplier Identifier
VENDOR_SITE_ID	NUMBER	(15)		Indicates the Supplier Site Identifier
RANGE_NO	VARCHAR2	(50)		Indicates the Range No of the Supplier/Customer
DIVISION_NO	VARCHAR2	(50)		Indicates the Division No of the Supplier/Customer
EXCISE_INVOICE_NO	VARCHAR2	(200)		Indicates the Excise Invoice No.
REMARKS	VARCHAR2	(100)		Indicates Remarks If Any.
TRANSACTION_DATE	DATE		Yes	Indicates Transaction Date.
OPENING_BALANCE	NUMBER			Indicates Opening Balance of the Transaction.
CLOSING_BALANCE	NUMBER			Indicates Closing Balance of the Transaction.
CHARGE_ACCOUNT_ID	NUMBER	(15)		Indicates 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 Master Organization Processing is done for the Record ( Possible values are Y, N and Null).
MASTER_FLAG	VARCHAR2	(1)		Indicates whether the record is a Master Organization Record (Possible Values are Y, N and Null).
BASIC_OPENING_BALANCE	NUMBER			Indicates the Opening Balance of the Basic Excise Component (Populated only if the Organization/Location is an EOU in the Additional Org Info Setup).
BASIC_CLOSING_BALANCE	NUMBER			Indicates the Closing Balance of the Basic Excise Component (Populated only if the Organization/Location is an EOU in the Additional Org Info Setup).
ADDITIONAL_OPENING_BALANCE	NUMBER			Indicates the Opening Balance of the Additional Excise Component (Populated only if the Organization/Location is an EOU in the Additional Org Info Setup).
ADDITIONAL_CLOSING_BALANCE	NUMBER			Indicates the Closing Balance of the Additional Excise Component ( Populated only if the Organization/Location is an EOU in the Additional Org Info Setup).
OTHER_OPENING_BALANCE	NUMBER			Indicates the Opening Balance of the Other Excise Component (Populated only if the Organization/Location is an EOU in the Additional Org Info Setup).
OTHER_CLOSING_BALANCE	NUMBER			Indicates the Closing Balance of the Other Excise Component (Populated only if the Organization/Location is an EOU in the Additional Org Info Setup).
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.
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
ROUNDING_ID	NUMBER	(15)		Indicates the rounding entry into which this record is considered
TRANSACTION_SOURCE_NUM	NUMBER	(15)		Indicates the Transaction Identifier.
DR_INVOICE_NO	VARCHAR2	(30)		Indicates the Invoice Identifier of the Debit Transaction.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
TR6_SOURCE	VARCHAR2	(15)		It holds the source of TR6 Challan.Possible values are 'MANUAL' and 'CONSOLIDATION'.

Query Text

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


SELECT REGISTER_ID
,      FIN_YEAR
,      SLNO
,      TR6_CHALLAN_NO
,      TR6_CHALLAN_DATE
,      CR_BASIC_ED
,      CR_ADDITIONAL_ED
,      CR_OTHER_ED
,      REF_DOCUMENT_ID
,      REF_DOCUMENT_DATE
,      DR_INVOICE_DATE
,      DR_BASIC_ED
,      DR_ADDITIONAL_ED
,      DR_OTHER_ED
,      ORGANIZATION_ID
,      LOCATION_ID
,      BANK_BRANCH_ID
,      ENTRY_DATE
,      INVENTORY_ITEM_ID
,      VENDOR_CUST_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      RANGE_NO
,      DIVISION_NO
,      EXCISE_INVOICE_NO
,      REMARKS
,      TRANSACTION_DATE
,      OPENING_BALANCE
,      CLOSING_BALANCE
,      CHARGE_ACCOUNT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      POSTED_FLAG
,      MASTER_FLAG
,      BASIC_OPENING_BALANCE
,      BASIC_CLOSING_BALANCE
,      ADDITIONAL_OPENING_BALANCE
,      ADDITIONAL_CLOSING_BALANCE
,      OTHER_OPENING_BALANCE
,      OTHER_CLOSING_BALANCE
,      BOL_ID
,      BOLLINE_NO
,      OTHER_TAX_CREDIT
,      OTHER_TAX_DEBIT
,      ROUNDING_ID
,      TRANSACTION_SOURCE_NUM
,      DR_INVOICE_NO
,      OBJECT_VERSION_NUMBER
,      TR6_SOURCE
FROM JA.JAI_CMN_RG_PLA_TRXS;

Dependencies

[top of page]

JA.JAI_CMN_RG_PLA_TRXS does not reference any database object

JA.JAI_CMN_RG_PLA_TRXS is referenced by following:

APPS: JAI_CMN_RG_PLA_TRXS; JAI_JRG_PLA_BRIUD_T1