FND Design Data [Home] [Help]

Table: JAI_CMN_RG_PLA_TRXS

Product: JA - Asia/Pacific Localizations
Description: Stores the Transaction Information of PLA Register.
Implementation/DBA Data: TableJA.JAI_CMN_RG_PLA_TRXS
Primary Key: JAI_CMN_RG_PLA_TRXS_PK
  1. ColumnREGISTER_ID
Primary Key: JAI_CMN_RG_PLA_TRXS_UK1
  1. ColumnORGANIZATION_ID
  2. ColumnLOCATION_ID
  3. ColumnFIN_YEAR
  4. ColumnSLNO
Foreign Keys
Table
Foreign Table Foreign Key Column
JAI_CMN_RG_PLA_TRXS FK Joins to TableJAI_INV_ITM_SETUPS JAI_CMN_RG_PLA_TRXS.INVENTORY_ITEM_ID
JAI_CMN_RG_PLA_TRXS.ORGANIZATION_ID
JAI_CMN_RG_PLA_TRXS FK Joins to TableJAI_CMN_FIN_YEARS JAI_CMN_RG_PLA_TRXS.ORGANIZATION_ID
JAI_CMN_RG_PLA_TRXS.FIN_YEAR
JAI_CMN_RG_PLA_TRXS FK Joins to TableGL_CODE_COMBINATIONS JAI_CMN_RG_PLA_TRXS.CHARGE_ACCOUNT_ID
JAI_CMN_RG_PLA_TRXS FK Joins to TableHR_LOCATIONS_ALL JAI_CMN_RG_PLA_TRXS.LOCATION_ID
JAI_CMN_RG_PLA_TRXS FK Joins to TableHZ_PARTIES JAI_CMN_RG_PLA_TRXS.VENDOR_ID
JAI_CMN_RG_PLA_TRXS FK Joins to TableHZ_PARTY_SITES JAI_CMN_RG_PLA_TRXS.VENDOR_SITE_ID
JAI_CMN_RG_PLA_TRXS FK Joins to TableCE_BANK_ACCT_USES_ALL JAI_CMN_RG_PLA_TRXS.BANK_BRANCH_ID
JAI_CMN_RG_PLA_TRXS FK Joins to TableJAI_CMN_RG_ROUND_HDRS JAI_CMN_RG_PLA_TRXS.ROUNDING_ID
TableJAI_CMN_RG_PLA_CMP_DTLS FK Joins to JAI_CMN_RG_PLA_TRXS JAI_CMN_RG_PLA_CMP_DTLS.REGISTER_ID