FND Design Data [Home] [Help]

Table: JAI_AP_TDS_THHOLD_TAXES

Product: JA - Asia/Pacific Localizations
Description: Stores details of taxes applicable for a particular slabrate by operating unit.
Implementation/DBA Data: TableJA.JAI_AP_TDS_THHOLD_TAXES
Primary Key: JAI_AP_TDS_THHOLD_TAXES_PK
  1. ColumnTHRESHOLD_TAX_ID
Primary Key: JAI_AP_TDS_THHOLD_TAXES_UK1
  1. ColumnTHRESHOLD_HDR_ID
  2. ColumnTHRESHOLD_TYPE_ID
  3. ColumnTHRESHOLD_SLAB_ID
  4. ColumnOPERATING_UNIT_ID
  5. ColumnTAX_ID
  6. ColumnTAX_CATEGORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_AP_TDS_THHOLD_TAXES FK Joins to TableJAI_AP_TDS_THHOLD_HDRS JAI_AP_TDS_THHOLD_TAXES.THRESHOLD_HDR_ID
JAI_AP_TDS_THHOLD_TAXES FK Joins to TableJAI_AP_TDS_THHOLD_TYPES JAI_AP_TDS_THHOLD_TAXES.THRESHOLD_TYPE_ID
JAI_AP_TDS_THHOLD_TAXES FK Joins to TableJAI_AP_TDS_THHOLD_SLABS JAI_AP_TDS_THHOLD_TAXES.THRESHOLD_SLAB_ID
JAI_AP_TDS_THHOLD_TAXES FK Joins to TableJAI_CMN_TAXES_ALL JAI_AP_TDS_THHOLD_TAXES.TAX_ID
JAI_AP_TDS_THHOLD_TAXES FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_AP_TDS_THHOLD_TAXES.OPERATING_UNIT_ID
JAI_AP_TDS_THHOLD_TAXES FK Joins to TableJAI_CMN_TAX_CTGS_ALL JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID