FND Design Data [Home] [Help]

Table: JAI_RGM_STL_BALANCES

Product: JA - Asia/Pacific Localizations
Description: Stores the Settlement details by settlement of regime for each period
Implementation/DBA Data: TableJA.JAI_RGM_STL_BALANCES
Primary Key: JAI_RGM_STL_BALANCES_PK
  1. ColumnSTL_BALANCE_ID
Primary Key: JAI_RGM_STL_BALANCES_UK1
  1. ColumnSETTLEMENT_ID
  2. ColumnSETTLEMENT_DATE
  3. ColumnPARTY_ID
  4. ColumnPARTY_TYPE
  5. ColumnLOCATION_ID
  6. ColumnTAX_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_RGM_STL_BALANCES FK Joins to TableHR_LOCATIONS_ALL JAI_RGM_STL_BALANCES.LOCATION_ID
JAI_RGM_STL_BALANCES FK Joins to TableJAI_RGM_SETTLEMENTS JAI_RGM_STL_BALANCES.SETTLEMENT_ID
JAI_RGM_STL_BALANCES FK Joins to TableHR_ALL_ORGANIZATION_UNITS JAI_RGM_STL_BALANCES.PARTY_ID