DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_CMN_RG_COMP_DTLS

Object Details
Object Name: JAI_CMN_RG_COMP_DTLS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_CMN_RG_COMP_DTLS
Subobject Name:
Status: VALID


Stores the Information of Detailed Balance of Each Excise Component for Every line for RG23A and RG23C Registers. This Information is specific to a Textile Industry.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_RG_COMP_DTLS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXCISE_COMP_DTL_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15)
Organization Identifier.
LOCATION_ID NUMBER (15)
Location Identifier.
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item Identifier.
FIN_YEAR NUMBER (9)
Financial Year.
REGISTER_ID NUMBER (15)
Register Identifier.
SLNO NUMBER (15)
Serial Number.
REGISTER_TYPE VARCHAR2 (2)
Register Type (A or C).
BASIC_OPENING_BALANCE NUMBER

Opening Balance of Basic Excise Component.
ADDITIONAL_OPENING_BALANCE NUMBER

Opening Balance of Additional Excise Component.
OTHER_OPENING_BALANCE NUMBER

Opening Balance of Other Excise Component.
CR_BASIC_ED NUMBER

Credit Basic Excise Duty.
CR_ADDITIONAL_ED NUMBER

Credit Additional Excise Duty.
CR_OTHER_ED NUMBER

Credit Other Excise Duty.
DR_BASIC_ED NUMBER

Debit Basic Excise Duty.
DR_ADDITIONAL_ED NUMBER

Debit Additional Excise Duty.
DR_OTHER_ED NUMBER

Debit Other Excise Duty.
BASIC_CLOSING_BALANCE NUMBER

Closing Balance of Basic Excise Component.
ADDITIONAL_CLOSING_BALANCE NUMBER

Closing Balance of Additional Excise Component.
OTHER_CLOSING_BALANCE NUMBER

Closing Balance of Other Excise Component.
TRANSACTION_DATE DATE

Transaction Date.
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
EXCISE_COMP_DTL_ID NUMBER (15) Yes Table Pk.
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
Query Text

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


SELECT ORGANIZATION_ID
,      LOCATION_ID
,      INVENTORY_ITEM_ID
,      FIN_YEAR
,      REGISTER_ID
,      SLNO
,      REGISTER_TYPE
,      BASIC_OPENING_BALANCE
,      ADDITIONAL_OPENING_BALANCE
,      OTHER_OPENING_BALANCE
,      CR_BASIC_ED
,      CR_ADDITIONAL_ED
,      CR_OTHER_ED
,      DR_BASIC_ED
,      DR_ADDITIONAL_ED
,      DR_OTHER_ED
,      BASIC_CLOSING_BALANCE
,      ADDITIONAL_CLOSING_BALANCE
,      OTHER_CLOSING_BALANCE
,      TRANSACTION_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EXCISE_COMP_DTL_ID
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_RG_COMP_DTLS;

Dependencies

[top of page]

JA.JAI_CMN_RG_COMP_DTLS does not reference any database object

JA.JAI_CMN_RG_COMP_DTLS is referenced by following:

SchemaAPPS
SynonymJAI_CMN_RG_COMP_DTLS