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_AP_RGM_PAYMENTS

Object Details

Object Name:	JAI_AP_RGM_PAYMENTS
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_AP_RGM_PAYMENTS
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_AP_RGM_PAYMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_ID
JAI_AP_RGM_PAYMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_AUTHORITY_ID TAX_AUTHORITY_SITE_ID
JAI_AP_RGM_PAYMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SETTLEMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_ID	NUMBER	(15)	Yes	Indicates the unique identifier for every record
SETTLEMENT_ID	NUMBER	(15)	Yes	Indicates the settlement Identifier.
CHECK_ID	NUMBER	(15)	Yes	Indicated the Check Identifier of the cheque through which payment was made.
CHECK_DATE	DATE		Yes	Indicates the date check was issued to TCS authority.
CHECK_NUMBER	NUMBER	(15)	Yes	Indicates the check number through which payment was made.
ORG_TAN_NO	VARCHAR2	(240)	Yes	Indicates the TAN Number of the organization.
BANK_BRANCH_ID	NUMBER	(15)	Yes	Indicates the bank branch Identifier.
TCS_AMOUNT	NUMBER			Indicates the TCS amount to be paid.
SURCHARGE_AMOUNT	NUMBER			Indicates the Surcharge Amount to be Paid
CESS_AMOUNT	NUMBER			Indicates the Cess Amount to be paid.
CHECK_DEPOSIT_DATE	DATE		Yes	Indicates the date when check was deposited.
CHALLAN_NO	NUMBER	(5)	Yes	Indicates the challan no issued by the authority.
TAX_AUTHORITY_ID	NUMBER	(15)	Yes	Indicates the Tax Authority Identifier to whom payment is made
TAX_AUTHORITY_SITE_ID	NUMBER	(15)	Yes	Indicates the Tax Authority Side identifier.
VOUCHER_NUMBER	VARCHAR2	(150)		Indicates the Voucher Number / challan number.
BOOK_ENTRY_DEPOSITED	VARCHAR2	(1)		Indicates whether the book entry is deposited or not
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
BSR_CODE	VARCHAR2	(7)		Indicates the BSR Code
OBJECT_VERSION_NUMBER	NUMBER			Standard WHO column
SH_CESS_AMOUNT	NUMBER			Indicates the amount of Secondary and Higher Education Cess

Query Text

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


SELECT PAYMENT_ID
,      SETTLEMENT_ID
,      CHECK_ID
,      CHECK_DATE
,      CHECK_NUMBER
,      ORG_TAN_NO
,      BANK_BRANCH_ID
,      TCS_AMOUNT
,      SURCHARGE_AMOUNT
,      CESS_AMOUNT
,      CHECK_DEPOSIT_DATE
,      CHALLAN_NO
,      TAX_AUTHORITY_ID
,      TAX_AUTHORITY_SITE_ID
,      VOUCHER_NUMBER
,      BOOK_ENTRY_DEPOSITED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BSR_CODE
,      OBJECT_VERSION_NUMBER
,      SH_CESS_AMOUNT
FROM JA.JAI_AP_RGM_PAYMENTS;

Dependencies

[top of page]

JA.JAI_AP_RGM_PAYMENTS does not reference any database object

JA.JAI_AP_RGM_PAYMENTS is referenced by following:

JA: JAI_AP_RGM_PAYMENTS#