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_AR_CASH_RECEIPTS_ALL

Object Details

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

This table stores the payment information about payment made to TCS authority.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_CASH_RECEIPTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOC_CASH_RECEIPT_ID
JAI_AR_CASH_RECEIPTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CASH_RECEIPT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOC_CASH_RECEIPT_ID	NUMBER	(15)	Yes	Indicates cash receipt amount.
CASH_RECEIPT_ID	NUMBER	(15)		Indicates Cash Receipt Identifier.
ORGANIZATION_ID	NUMBER	(15)	Yes	Indicates Inventory organization identifier for which the cash receipt is created.
CUSTOMER_ID	NUMBER	(15)	Yes	Indicates Customer Identifier from whom the Cash was received.
TAX_CATEGORY_ID	NUMBER	(15)		Indicates India Localization Tax Category attached to the receipt
ITEM_CLASSIFICATION	VARCHAR2	(100)		Indicates TCS Item classification of the receipt item
RECEIPT_AMOUNT	NUMBER			Indicates cash receipt amount.
CURRENCY_CODE	VARCHAR2	(15)	Yes	Indicates Currency code for the cash receipt
EXCHANGE_RATE	NUMBER			Indicates Exchange rate for the cash receipt
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Indicates Exchange rate type for the cash receipt
EXCHANGE_DATE	DATE			Indicates Exchange date for the cash receipt
GL_DATE	DATE		Yes	Indicates General Ledger Date of the Cash receipt
ORG_ID	NUMBER	(15)	Yes	Indicates Identifier for Operating unit for which cash receipt is created
TAX_DEFAULTED_FLAG	VARCHAR2	(1)		Indicates flag to check, if the taxes are defaulted. This can have values as 'N' and 'Y'
CONFIRM_FLAG	VARCHAR2	(1)		Indicates whether the receipt has taxes as confirmed. This can have 'N' and 'Y' as values
CONFIRM_DATE	DATE			Indicates date on which JAI TCS Taxes are confirmed for the receipt
TEMP_SEQUENCE_ID	NUMBER	(15)		Indicates temporary sequence identifier, which is used internally.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER			Standard WHO column
LOCATION_ID	NUMBER	(15)		Location ID used for Service tax.
SERVICE_TYPE_CODE	VARCHAR2	(30)		Service type used for Service tax.
DOCUMENT_TYPE	VARCHAR2	(80)		Service Tax or TCS
ATTRIBUTE1	VARCHAR2	(150)		Description flex field column
ATTRIBUTE2	VARCHAR2	(150)		Description flex field column
ATTRIBUTE3	VARCHAR2	(150)		Description flex field column
ATTRIBUTE4	VARCHAR2	(150)		Description flex field column
ATTRIBUTE5	VARCHAR2	(150)		Description flex field column
ATTRIBUTE6	VARCHAR2	(150)		Description flex field column
ATTRIBUTE7	VARCHAR2	(150)		Description flex field column
ATTRIBUTE8	VARCHAR2	(150)		Description flex field column
ATTRIBUTE9	VARCHAR2	(150)		Description flex field column
ATTRIBUTE10	VARCHAR2	(150)		Description flex field column
ATTRIBUTE11	VARCHAR2	(150)		Description flex field column
ATTRIBUTE12	VARCHAR2	(150)		Description flex field column
ATTRIBUTE13	VARCHAR2	(150)		Description flex field column
ATTRIBUTE14	VARCHAR2	(150)		Description flex field column
ATTRIBUTE15	VARCHAR2	(150)		Description flex field column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category

Query Text

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


SELECT LOC_CASH_RECEIPT_ID
,      CASH_RECEIPT_ID
,      ORGANIZATION_ID
,      CUSTOMER_ID
,      TAX_CATEGORY_ID
,      ITEM_CLASSIFICATION
,      RECEIPT_AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      GL_DATE
,      ORG_ID
,      TAX_DEFAULTED_FLAG
,      CONFIRM_FLAG
,      CONFIRM_DATE
,      TEMP_SEQUENCE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      LOCATION_ID
,      SERVICE_TYPE_CODE
,      DOCUMENT_TYPE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
FROM JA.JAI_AR_CASH_RECEIPTS_ALL;

Dependencies

[top of page]

JA.JAI_AR_CASH_RECEIPTS_ALL does not reference any database object

JA.JAI_AR_CASH_RECEIPTS_ALL is referenced by following:

JA: JAI_AR_CASH_RECEIPTS_ALL#