FND Design Data [Home] [Help]

Table: JAI_AP_TDS_CERT_NUMS

Product: JA - Asia/Pacific Localizations
Description: Stores the certificate ids by org anization tan where TDS year info is defined.
Implementation/DBA Data: TableJA.JAI_AP_TDS_CERT_NUMS
Primary Key: JAI_AP_TDS_CERT_NUMS_PK
  1. ColumnFIN_YR_CERT_ID
Primary Key: JAI_AP_TDS_CERT_NUMS_UK1
  1. ColumnORGANIZATION_ID
  2. ColumnLEGAL_ENTITY
  3. ColumnFIN_YR
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_AP_TDS_CERT_NUMS FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_AP_TDS_CERT_NUMS.LEGAL_ENTITY
JAI_AP_TDS_CERT_NUMS FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_AP_TDS_CERT_NUMS.ORGANIZATION_ID