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

TABLE: JA.JAI_RCV_CENVAT_CLAIMS

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


Holds Information about the cenvat percentage claimed for a receipt for Manufacturing Organization.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_RCV_CENVAT_CLAIMS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
JAI_RCV_CENVAT_CLAIMS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_LINE_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Yes Indicates RCV Transaction Identifier.
SHIPMENT_LINE_ID NUMBER (15)
Indicates Shipment Line Identifier.
CENVAT_AMOUNT NUMBER

Indicates the Amount of cenvat to be availed.
CENVAT_CLAIMED_AMT NUMBER

Indicates the Amount of cenvat already claimed.
CENVAT_CLAIMED_PTG NUMBER

Indicates the Percentage of cenvat claimed.
CENVAT_SEQUENCE NUMBER

Indicates the No of Times the cenvat is claimed against the receipt.
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
VENDOR_CHANGED_FLAG VARCHAR2 (1)
Indicates whether the supplier is a third party supplier or not
VENDOR_ID NUMBER

Supplier Identifier. This can be overridden in case of Third Party Excise Vendor from the Claim Modvat On receipts form.
VENDOR_SITE_ID NUMBER

Supplier Site Identifier. This can be overridden in case of Third Party Excise Vendor from the Claim Modvat On receipts form.
UNCLAIM_CENVAT_FLAG VARCHAR2 (1)
Indicates whether the Line is Unclaimed. Possible Values are Y and N. Null Value is also Interpreted as N.
UNCLAIM_CENVAT_DATE DATE

Indicates the Date on which Unclaim is done
UNCLAIMED_CENVAT_AMOUNT NUMBER

Indicates the Unclaimed Cenvat Amount
PARTIAL_CENVAT_CLAIM VARCHAR2 (2)
Indicates that Partial Cenvat Claim is done and RTV is done for this Receipt
NON_BONDED_DELIVERY_FLAG VARCHAR2 (1)
Non Bonded Delivery Flag
QUANTITY_FOR_2ND_CLAIM NUMBER

Quantity for second claim. It may differ from the original claim quantity because of correct, rtv or deliver / rtr (non-bonded) type of transactions.
OTHER_CENVAT_AMT NUMBER

Cenvat amount for CESS on excise taxes.
OTHER_CENVAT_CLAIMED_AMT NUMBER

Cenvat amount claimed for CESS on excise taxes.
ONLINE_CLAIM_FLAG VARCHAR2 (1)
Flag to indicate if the cenvat claim for the transaction has to be done on-line. Possible values are Y and N.
CENVAT_AMT_FOR_2ND_CLAIM NUMBER

Indicates the Amount of cenvat for 2nd claim
OTHER_CENVAT_AMT_FOR_2ND_CLAIM NUMBER

Cenvat amount on 2nd claim for CESS on excise taxes.
OBJECT_VERSION_NUMBER NUMBER

Object version number
Query Text

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


SELECT TRANSACTION_ID
,      SHIPMENT_LINE_ID
,      CENVAT_AMOUNT
,      CENVAT_CLAIMED_AMT
,      CENVAT_CLAIMED_PTG
,      CENVAT_SEQUENCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      VENDOR_CHANGED_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      UNCLAIM_CENVAT_FLAG
,      UNCLAIM_CENVAT_DATE
,      UNCLAIMED_CENVAT_AMOUNT
,      PARTIAL_CENVAT_CLAIM
,      NON_BONDED_DELIVERY_FLAG
,      QUANTITY_FOR_2ND_CLAIM
,      OTHER_CENVAT_AMT
,      OTHER_CENVAT_CLAIMED_AMT
,      ONLINE_CLAIM_FLAG
,      CENVAT_AMT_FOR_2ND_CLAIM
,      OTHER_CENVAT_AMT_FOR_2ND_CLAIM
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RCV_CENVAT_CLAIMS;

Dependencies

[top of page]

JA.JAI_RCV_CENVAT_CLAIMS does not reference any database object

JA.JAI_RCV_CENVAT_CLAIMS is referenced by following:

SchemaJA
ViewJAI_RCV_CENVAT_CLAIMS#