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.

[Home] [Help]

Table: JAI_AP_TDS_PREPAYMENTS

Product:	JA - Asia/Pacific Localizations
Description:	Stores details of TDS processing for prepayment application and unapplication
Implementation/DBA Data:	JA.JAI_AP_TDS_PREPAYMENTS

Primary Key: JAI_AP_TDS_PREPAYMENTS_PK

TDS_PREPAYMENT_ID

Primary Key: JAI_AP_TDS_PREPAYMENTS_UK1

INVOICE_ID
INVOICE_DISTRIBUTION_ID_PREPAY
INVOICE_DISTRIBUTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
JAI_AP_TDS_PREPAYMENTS	JAI_AP_TDS_THHOLD_TRXS	JAI_AP_TDS_PREPAYMENTS.WCT_THRESHOLD_TRX_ID_APPLY
JAI_AP_TDS_PREPAYMENTS	JAI_AP_TDS_THHOLD_TRXS	JAI_AP_TDS_PREPAYMENTS.WCT_THRESHOLD_TRX_ID_UNAPPLY
JAI_AP_TDS_PREPAYMENTS	JAI_CMN_TAXES_ALL	JAI_AP_TDS_PREPAYMENTS.ESSI_TAX_ID_PREPAY
JAI_AP_TDS_PREPAYMENTS	JAI_CMN_TAXES_ALL	JAI_AP_TDS_PREPAYMENTS.ESSI_TAX_ID_OTHER
JAI_AP_TDS_PREPAYMENTS	JAI_AP_TDS_THHOLD_TRXS	JAI_AP_TDS_PREPAYMENTS.ESSI_THRESHOLD_TRX_ID_APPLY
JAI_AP_TDS_PREPAYMENTS	JAI_AP_TDS_THHOLD_TRXS	JAI_AP_TDS_PREPAYMENTS.ESSI_THRESHOLD_TRX_ID_UNAPPLY
JAI_AP_TDS_PREPAYMENTS	AP_INVOICES_ALL	JAI_AP_TDS_PREPAYMENTS.INVOICE_ID
JAI_AP_TDS_PREPAYMENTS	JAI_CMN_TAXES_ALL	JAI_AP_TDS_PREPAYMENTS.TDS_TAX_ID_OTHER
JAI_AP_TDS_PREPAYMENTS	JAI_CMN_TAXES_ALL	JAI_AP_TDS_PREPAYMENTS.TDS_TAX_ID_PREPAY
JAI_AP_TDS_PREPAYMENTS	JAI_AP_TDS_THHOLD_TRXS	JAI_AP_TDS_PREPAYMENTS.TDS_THRESHOLD_TRX_ID_APPLY
JAI_AP_TDS_PREPAYMENTS	JAI_AP_TDS_THHOLD_TRXS	JAI_AP_TDS_PREPAYMENTS.TDS_THRESHOLD_TRX_ID_UNAPPLY
JAI_AP_TDS_PREPAYMENTS	JAI_AP_TDS_THHOLD_GRPS	JAI_AP_TDS_PREPAYMENTS.TDS_TAX_ID_PREPAY
JAI_AP_TDS_PREPAYMENTS	JAI_CMN_TAXES_ALL	JAI_AP_TDS_PREPAYMENTS.WCT_TAX_ID_PREPAY
JAI_AP_TDS_PREPAYMENTS	JAI_CMN_TAXES_ALL	JAI_AP_TDS_PREPAYMENTS.WCT_TAX_ID_OTHER