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_RCV_TRANSACTIONS

Object Details

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

Holds receiving transaction records information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RCV_TRANSACTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
JAI_RCV_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID SHIPMENT_LINE_ID
JAI_RCV_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THIRD_PARTY_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
SHIPMENT_HEADER_ID	NUMBER		Yes	Shipment Header Identifier
SHIPMENT_LINE_ID	NUMBER		Yes	Shipment Line Identifier
TRANSACTION_ID	NUMBER		Yes	Trasancation Identifier
TRANSACTION_TYPE	VARCHAR2	(25)	Yes	Indicates the type of Receiving Transaction type
TRANSACTION_DATE	DATE			Transaction Date
QUANTITY	NUMBER			Quantity
UOM_CODE	VARCHAR2	(3)		Unit Of Measure
PARENT_TRANSACTION_ID	NUMBER			Parent Transaction Identifier
PARENT_TRANSACTION_TYPE	VARCHAR2	(25)		Parent Transaction type
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination Type Code
RECEIPT_NUM	VARCHAR2	(30)		Receipt Number
ORGANIZATION_ID	NUMBER	(15)		Organziation Identifier
LOCATION_ID	NUMBER	(15)		Location Identifier
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory item identifier
EXCISE_INVOICE_NO	VARCHAR2	(30)		Excise Invoice Number
EXCISE_INVOICE_DATE	DATE			Excise Invoice Date
TAX_AMOUNT	NUMBER			Tax amount
ASSESSABLE_VALUE	NUMBER			Value on which excise is calclulated
CENVAT_AMOUNT	NUMBER			Cenvat Amount
CENVAT_CLAIMED_PTG	NUMBER			Cenvat Claimed percentage
CURRENCY_CONVERSION_RATE	NUMBER			Currency Conversion Rate
ITEM_CLASS	VARCHAR2	(4)		Class of item type
ITEM_CENVATABLE	VARCHAR2	(2)		Indicates whether the item is cenvatable
ITEM_EXCISABLE	VARCHAR2	(2)		Indicates whether the item can have excise type of taxes
ITEM_TRADING_FLAG	VARCHAR2	(1)		Indicates whether the item can be traded
INV_ITEM_FLAG	VARCHAR2	(1)		Inventory Item flag
INV_ASSET_FLAG	VARCHAR2	(1)		Inventory Asset Flag
LOC_SUBINV_TYPE	VARCHAR2	(2)		Subinventory Location type
ORGANIZATION_TYPE	VARCHAR2	(2)		Organization Types
EXCISE_IN_TRADING	VARCHAR2	(2)		Excise in Trading
COSTING_METHOD	NUMBER			Costing Method
BOE_APPLIED_FLAG	VARCHAR2	(1)		Bill OF Entry Applied Flag
THIRD_PARTY_FLAG	VARCHAR2	(1)		Third Party Flag
PROCESS_MESSAGE	VARCHAR2	(1000)		Process Message
CENVAT_RG_MESSAGE	VARCHAR2	(1000)		Cenvat RG messages
PROCESS_DATE	DATE			Process Date
CODEPATH	VARCHAR2	(1996)		Holds Debug information indicating the code flow path
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
TAX_TRANSACTION_ID	NUMBER	(15)		Stores the transaction identifier of the transaction against which taxes are maintained. This transaction identifier is generally the transaction identifier of the RECEIVE/MATCH transaction as that is the first transaction when tax is defaulted.
PROCESS_VAT_MESSAGE	VARCHAR2	(1000)		Prcessing message related to VAT.
VAT_INVOICE_NO	VARCHAR2	(100)		VAT invoice number.
VAT_INVOICE_DATE	DATE			VAT invoice Date
BASE_ASSET_INVENTORY	NUMBER	(9)		Base Subinventory Asset Flag
PROCESS_STATUS	VARCHAR2	(2)		Process Flag
CENVAT_RG_STATUS	VARCHAR2	(2)		Cenvat RG flag
PROCESS_VAT_STATUS	VARCHAR2	(2)		Flag to indicate VAT processing status of the transaction. Possible values are X-Not applicable, Y-Processed, E-Error, N-To be processed, O- Others, mainly setup related problems.
OBJECT_VERSION_NUMBER	NUMBER			Object version number
TAX_APPORTION_FACTOR	NUMBER			Tax apportion of the main transaction
QUANTITY_REGISTER_FLAG	VARCHAR2	(1)		Quantity Register Flag
OPM_COSTING_FLAG	VARCHAR2	(1)		Specifies if non recoverable taxes are updated to the Process Manufacturing Receipts cost
OPM_COSTING_AMOUNT	NUMBER	(22)		Non recoverable tax amount updated to the Process Manufacturing Receipts cost
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
EXCISE_INV_GEN_STATUS	VARCHAR2	(150)		Excise invoice generation status
VAT_INV_GEN_STATUS	VARCHAR2	(150)		Vat invoice generation status
EXCISE_INV_GEN_NUMBER	VARCHAR2	(150)		Excise invoice generation number
VAT_INV_GEN_NUMBER	VARCHAR2	(150)		Vat invoice generation number
CENVAT_COSTED_FLAG	VARCHAR2	(150)		Cenvat costed flag
TRX_INFORMATION	VARCHAR2	(30)		Transaction information
GST_INVOICE_NO	VARCHAR2	(150)		GST Invoice Number
GST_INVOICE_DATE	DATE			GST Invoice Date

Query Text

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


SELECT SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      TRANSACTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      QUANTITY
,      UOM_CODE
,      PARENT_TRANSACTION_ID
,      PARENT_TRANSACTION_TYPE
,      DESTINATION_TYPE_CODE
,      RECEIPT_NUM
,      ORGANIZATION_ID
,      LOCATION_ID
,      INVENTORY_ITEM_ID
,      EXCISE_INVOICE_NO
,      EXCISE_INVOICE_DATE
,      TAX_AMOUNT
,      ASSESSABLE_VALUE
,      CENVAT_AMOUNT
,      CENVAT_CLAIMED_PTG
,      CURRENCY_CONVERSION_RATE
,      ITEM_CLASS
,      ITEM_CENVATABLE
,      ITEM_EXCISABLE
,      ITEM_TRADING_FLAG
,      INV_ITEM_FLAG
,      INV_ASSET_FLAG
,      LOC_SUBINV_TYPE
,      ORGANIZATION_TYPE
,      EXCISE_IN_TRADING
,      COSTING_METHOD
,      BOE_APPLIED_FLAG
,      THIRD_PARTY_FLAG
,      PROCESS_MESSAGE
,      CENVAT_RG_MESSAGE
,      PROCESS_DATE
,      CODEPATH
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      TAX_TRANSACTION_ID
,      PROCESS_VAT_MESSAGE
,      VAT_INVOICE_NO
,      VAT_INVOICE_DATE
,      BASE_ASSET_INVENTORY
,      PROCESS_STATUS
,      CENVAT_RG_STATUS
,      PROCESS_VAT_STATUS
,      OBJECT_VERSION_NUMBER
,      TAX_APPORTION_FACTOR
,      QUANTITY_REGISTER_FLAG
,      OPM_COSTING_FLAG
,      OPM_COSTING_AMOUNT
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EXCISE_INV_GEN_STATUS
,      VAT_INV_GEN_STATUS
,      EXCISE_INV_GEN_NUMBER
,      VAT_INV_GEN_NUMBER
,      CENVAT_COSTED_FLAG
,      TRX_INFORMATION
,      GST_INVOICE_NO
,      GST_INVOICE_DATE
FROM JA.JAI_RCV_TRANSACTIONS;

Dependencies

[top of page]

JA.JAI_RCV_TRANSACTIONS does not reference any database object

JA.JAI_RCV_TRANSACTIONS is referenced by following:

JA: JAI_RCV_TRANSACTIONS#