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_MTL_MATCH_RECEIPTS

Object Details

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

This table stores information related to receipts matched for claiming excise and VAT for capital goods during inter organization transfer

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_MTL_MATCH_RECEIPTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MATCH_RECEIPT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MATCH_RECEIPT_ID	NUMBER		Yes	Unique identifier of the transaction
TRANSACTION_TEMP_ID	NUMBER		Yes	Unique identifier for every item line in inter organization transfer
ORGANIZATION_ID	NUMBER	(15)	Yes	Indicates Organization Identifier
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Inventory item Identifier
RECEIPT_NUMBER	VARCHAR2	(30)	Yes	Indicates the receipt number
QUANTITY	NUMBER			Indicates the receipt quantity
CENVAT_QTY_AVAILABLE	NUMBER			Indicates the quantity available for cenvat claim.
CENVAT_CLAIMED_PTG	NUMBER			Indicates the Percentage of cenvat claimed.
CENVAT_CLAIMED_AMT	NUMBER			Indicates the Amount of cenvat already claimed.
OTHER_CENVAT_CLAIMED_AMT	NUMBER			Cenvat amount claimed for CESS on excise taxes.
CENVAT_AMT_FOR_2ND_CLAIM	NUMBER			Indicates the Amount of cenvat for 2nd claim
CENVAT_AMOUNT	NUMBER			Indicates the Amount of cenvat to be availed
VAT_QTY	NUMBER			Indicates vat Quantity
VAT_CLAIMED_PTG	NUMBER			Indicates the percentage of vat claimed
VAT_INVOICE_NO	VARCHAR2	(200)		Indicates the vat invoice number generated
QTY_APPLY	NUMBER			Indicates quantity applied for claim
SHIPMENT_LINE_ID	NUMBER		Yes	Unique Shipment Line Identifier
OTHER_CENVAT_AMT_FOR_2ND_CLAIM	NUMBER			Cenvat amount on 2nd claim for CESS on excise taxes.
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column

Query Text

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


SELECT MATCH_RECEIPT_ID
,      TRANSACTION_TEMP_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RECEIPT_NUMBER
,      QUANTITY
,      CENVAT_QTY_AVAILABLE
,      CENVAT_CLAIMED_PTG
,      CENVAT_CLAIMED_AMT
,      OTHER_CENVAT_CLAIMED_AMT
,      CENVAT_AMT_FOR_2ND_CLAIM
,      CENVAT_AMOUNT
,      VAT_QTY
,      VAT_CLAIMED_PTG
,      VAT_INVOICE_NO
,      QTY_APPLY
,      SHIPMENT_LINE_ID
,      OTHER_CENVAT_AMT_FOR_2ND_CLAIM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM JA.JAI_MTL_MATCH_RECEIPTS;

Dependencies

[top of page]

JA.JAI_MTL_MATCH_RECEIPTS does not reference any database object

JA.JAI_MTL_MATCH_RECEIPTS is referenced by following:

JA: JAI_MTL_MATCH_RECEIPTS#