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_TDS_PREPAYMENTS

Object Details

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

This table stores the details of TDS processing for prepayment application and unapplication. This also includes allocation of a prepayment line to non-prepay distributions of the invoice.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_PREPAYMENTS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_DISTRIBUTION_ID_PREPAY INVOICE_DISTRIBUTION_ID
JAI_AP_TDS_PREPAYMENTS_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TDS_PREPAYMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TDS_PREPAYMENT_ID	NUMBER	(15)	Yes	TDS prepayment identifier
INVOICE_ID	NUMBER	(15)	Yes	Invoice Identifier
INVOICE_DISTRIBUTION_ID_PREPAY	NUMBER	(15)	Yes	Invoice Distribution idenifier for the prepay distribution
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Invoice Distribution idenitifier of the distributions against which the prepayment distribution has been considered.
APPLICATION_AMOUNT	NUMBER			Application Amount
APPLICATION_BASIS	VARCHAR2	(30)		Application Basis. Possible values are STANDARD INVOICE and PREPAYMENT. Value STANDARD INVOICE, means that tds was already processed for the STANDARD INVOICE on which the prepayment is being applied at the time of application. In such cases, tds reversed will be as deducted on the STANDARD INVOICE.
UNAPPLY_FLAG	VARCHAR2	(1)		Unapply Flag. A value of Y indicates that the Corresponding prepayment has been already unapplied.
TDS_SECTION_CODE_PREPAY	VARCHAR2	(30)		TDS section as applicable on the prepayment distribution.
TDS_SECTION_CODE_OTHER	VARCHAR2	(30)		TDS section as applicable on the standard invoice distribution.
TDS_TAX_ID_PREPAY	NUMBER	(15)		Tax idenitifier as applicable to prepay distribution.
TDS_TAX_ID_OTHER	NUMBER	(15)		Tax idenitifier as applicable to standard invoice distribution.
TDS_APPLICABLE_FLAG	VARCHAR2	(1)		Flag to indicate if TDS is applicable for the prepay distribution and standard invoice distribution combination
TDS_APPLICATION_AMOUNT	NUMBER			Effective amount for this prepay distribution and standard invoice distribution combination
TDS_THRESHOLD_TRX_ID_APPLY	NUMBER	(15)		Threshold transaction identifier for the prepayment application.
TDS_THRESHOLD_TRX_ID_UNAPPLY	NUMBER	(15)		TDS Threshold transaction identifier for the prepayment unapplication.
TDS_THRESHOLD_GRP_ID	NUMBER	(15)		Threshold group identifier.
WCT_TAX_ID_PREPAY	NUMBER	(15)		WCT tax identifier as applicable to prepay distribution
WCT_TAX_ID_OTHER	NUMBER	(15)		WCT tax identifier as applicable to standard invoice distribution
WCT_APPLICABLE_FLAG	VARCHAR2	(1)		Flag to indicate if WCT is applicable for this prepay distribution and standard invoice distribution combination.
WCT_APPLICATION_AMOUNT	NUMBER			Effective WCT amount for this prepay distribution and standard invoice distribution combination
WCT_THRESHOLD_TRX_ID_APPLY	NUMBER	(15)		WCT Threshold transaction identifier for the prepayment application.
WCT_THRESHOLD_TRX_ID_UNAPPLY	NUMBER	(15)		WCT Threshold transaction identifier for the prepayment unapplication.
ESSI_TAX_ID_PREPAY	NUMBER	(15)		ESSI tax identifier as applicable on the prepayment distribution.
ESSI_TAX_ID_OTHER	NUMBER	(15)		ESSI tax identifier as applicable on the standard invoice distribution.
ESSI_APPLICABLE_FLAG	VARCHAR2	(1)		Flag to indicate if ESSI is applicable for this prepay distribution and standard invoice distribution combination
ESSI_APPLICATION_AMOUNT	NUMBER			Effective ESSI amountfor this prepay distribution and standard invoice distribution combination
ESSI_THRESHOLD_TRX_ID_APPLY	NUMBER	(15)		ESSI Threshold transaction identifier for the prepayment application.
ESSI_THRESHOLD_TRX_ID_UNAPPLY	NUMBER	(15)		ESSI Threshold transaction identifier for the prepayment unapplication.
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.
CALC_ESSI_APPLN_AMT	NUMBER			Indicates non-rounded TDS amount for this prepay distribution and standard invoice distribution combination.
CALC_TDS_APPLN_AMT	NUMBER			Indicates non-rounded ESSI amount for this prepay distribution and standard invoice distribution combination.
CALC_WCT_APPLN_AMT	NUMBER			Indicates non-rounded WCT amount for this prepay distribution and standard invoice distribution combination.

Query Text

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


SELECT TDS_PREPAYMENT_ID
,      INVOICE_ID
,      INVOICE_DISTRIBUTION_ID_PREPAY
,      INVOICE_DISTRIBUTION_ID
,      APPLICATION_AMOUNT
,      APPLICATION_BASIS
,      UNAPPLY_FLAG
,      TDS_SECTION_CODE_PREPAY
,      TDS_SECTION_CODE_OTHER
,      TDS_TAX_ID_PREPAY
,      TDS_TAX_ID_OTHER
,      TDS_APPLICABLE_FLAG
,      TDS_APPLICATION_AMOUNT
,      TDS_THRESHOLD_TRX_ID_APPLY
,      TDS_THRESHOLD_TRX_ID_UNAPPLY
,      TDS_THRESHOLD_GRP_ID
,      WCT_TAX_ID_PREPAY
,      WCT_TAX_ID_OTHER
,      WCT_APPLICABLE_FLAG
,      WCT_APPLICATION_AMOUNT
,      WCT_THRESHOLD_TRX_ID_APPLY
,      WCT_THRESHOLD_TRX_ID_UNAPPLY
,      ESSI_TAX_ID_PREPAY
,      ESSI_TAX_ID_OTHER
,      ESSI_APPLICABLE_FLAG
,      ESSI_APPLICATION_AMOUNT
,      ESSI_THRESHOLD_TRX_ID_APPLY
,      ESSI_THRESHOLD_TRX_ID_UNAPPLY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      CALC_ESSI_APPLN_AMT
,      CALC_TDS_APPLN_AMT
,      CALC_WCT_APPLN_AMT
FROM JA.JAI_AP_TDS_PREPAYMENTS;

Dependencies

[top of page]

JA.JAI_AP_TDS_PREPAYMENTS does not reference any database object

JA.JAI_AP_TDS_PREPAYMENTS is referenced by following:

APPS: JAI_AP_TDS_PREPAYMENTS