FND Design Data [Home] [Help]

Table: JAI_AP_TDS_THHOLD_GRPS

Product: JA - Asia/Pacific Localizations
Description: Stores the details current threshold position for a threshold group.
Implementation/DBA Data: TableJA.JAI_AP_TDS_THHOLD_GRPS
Primary Key: JAI_AP_TDS_THHOLD_GRPS_PK
  1. ColumnTHRESHOLD_GRP_ID
Primary Key: JAI_AP_TDS_THHOLD_GRPS_UK1
  1. ColumnVENDOR_ID
  2. ColumnORG_TAN_NUM
  3. ColumnVENDOR_PAN_NUM
  4. ColumnSECTION_TYPE
  5. ColumnSECTION_CODE
  6. ColumnFIN_YEAR
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_AP_TDS_THHOLD_GRPS FK Joins to TableHZ_PARTIES JAI_AP_TDS_THHOLD_GRPS.VENDOR_ID
JAI_AP_TDS_THHOLD_GRPS FK Joins to TableJAI_AP_TDS_THHOLD_SLABS JAI_AP_TDS_THHOLD_GRPS.CURRENT_THRESHOLD_SLAB_ID
TableJAI_AP_TDS_INV_CANCELS FK Joins to JAI_AP_TDS_THHOLD_GRPS JAI_AP_TDS_INV_CANCELS.THRESHOLD_GRP_ID
TableJAI_AP_TDS_INV_TAXES FK Joins to JAI_AP_TDS_THHOLD_GRPS JAI_AP_TDS_INV_TAXES.DEFAULT_THRESHOLD_GRP_ID
TableJAI_AP_TDS_INV_TAXES FK Joins to JAI_AP_TDS_THHOLD_GRPS JAI_AP_TDS_INV_TAXES.THRESHOLD_GRP_ID
TableJAI_AP_TDS_PREPAYMENTS FK Joins to JAI_AP_TDS_THHOLD_GRPS JAI_AP_TDS_PREPAYMENTS.TDS_TAX_ID_PREPAY
TableJAI_AP_TDS_THGRP_AUDITS FK Joins to JAI_AP_TDS_THHOLD_GRPS JAI_AP_TDS_THGRP_AUDITS.THRESHOLD_GRP_ID
TableJAI_AP_TDS_THHOLD_TRXS FK Joins to JAI_AP_TDS_THHOLD_GRPS JAI_AP_TDS_THHOLD_TRXS.THRESHOLD_GRP_ID