FND Design Data [Home] [Help]

Table: JAI_RGM_TRX_RECORDS

Product: JA - Asia/Pacific Localizations
Description: Repository to store recovery and liabilities due to taxes of different regimes
Implementation/DBA Data: TableJA.JAI_RGM_TRX_RECORDS
Primary Key: JAI_RGM_TRX_RECORDS_PK
  1. ColumnREPOSITORY_ID
Primary Key: JAI_RGM_TRX_RECORDS_UK1
  1. ColumnSOURCE
  2. ColumnSOURCE_TRX_TYPE
  3. ColumnORGANIZATION_ID
  4. ColumnLOCATION_ID
  5. ColumnTAX_TYPE
  6. ColumnSOURCE_TABLE_NAME
  7. ColumnSOURCE_DOCUMENT_ID
  8. ColumnREFERENCE_ID
  9. ColumnSERVICE_TYPE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_RGM_TRX_RECORDS FK Joins to TableJAI_RGM_CONC_REQUESTS JAI_RGM_TRX_RECORDS.BATCH_ID
JAI_RGM_TRX_RECORDS FK Joins to TableJAI_RGM_SETTLEMENTS JAI_RGM_TRX_RECORDS.SETTLEMENT_ID
JAI_RGM_TRX_RECORDS FK Joins to TableGL_CODE_COMBINATIONS JAI_RGM_TRX_RECORDS.CHARGE_ACCOUNT_ID
JAI_RGM_TRX_RECORDS FK Joins to TableGL_CODE_COMBINATIONS JAI_RGM_TRX_RECORDS.BALANCING_ACCOUNT_ID
JAI_RGM_TRX_RECORDS FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_RGM_TRX_RECORDS.ORGANIZATION_ID
JAI_RGM_TRX_RECORDS FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_RGM_TRX_RECORDS.INV_ORGANIZATION_ID
JAI_RGM_TRX_RECORDS FK Joins to TableHR_LOCATIONS_ALL JAI_RGM_TRX_RECORDS.LOCATION_ID
TableJAI_CMN_JOURNAL_ENTRIES FK Joins to JAI_RGM_TRX_RECORDS JAI_CMN_JOURNAL_ENTRIES.REPOSITORY_ID