FND Design Data [Home] [Help]

Table: FINANCIALS_SYSTEM_PARAMS_ALL

Product: AP - Payables
Description: Oracle Financials system parameters and defaults
Implementation/DBA Data: TableAP.FINANCIALS_SYSTEM_PARAMS_ALL
Primary Key: FINANCIALS_SYSTEM_PARAMS_PK
  1. ColumnSET_OF_BOOKS_ID
  2. ColumnORG_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableFND_CURRENCIES FINANCIALS_SYSTEM_PARAMS_ALL.INVOICE_CURRENCY_CODE
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableFND_CURRENCIES FINANCIALS_SYSTEM_PARAMS_ALL.PAYMENT_CURRENCY_CODE
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.ACCTS_PAY_CODE_COMBINATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.PREPAY_CODE_COMBINATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.DISC_TAKEN_CODE_COMBINATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.RES_ENCUMB_CODE_COMBINATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_ENCUMBRANCE_TYPES FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_TYPE_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_ENCUMBRANCE_TYPES FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_TYPE_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_ENCUMBRANCE_TYPES FINANCIALS_SYSTEM_PARAMS_ALL.INV_ENCUMBRANCE_TYPE_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.RATE_VAR_CODE_COMBINATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.RATE_VAR_GAIN_CCID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.RATE_VAR_LOSS_CCID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableHR_LOCATIONS_ALL FINANCIALS_SYSTEM_PARAMS_ALL.BILL_TO_LOCATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableHR_LOCATIONS_ALL FINANCIALS_SYSTEM_PARAMS_ALL.SHIP_TO_LOCATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.EXPENSE_CLEARING_CCID
FINANCIALS_SYSTEM_PARAMS_ALL FK Joins to TableGL_CODE_COMBINATIONS FINANCIALS_SYSTEM_PARAMS_ALL.FUTURE_DATED_PAYMENT_CCID