FND Design Data [Home] [Help]

Table: AP_SYSTEM_PARAMETERS_ALL

Product: AP - Payables
Description: Payables system defaults and parameters
Implementation/DBA Data: TableAP.AP_SYSTEM_PARAMETERS_ALL
Primary Key: AP_SYSTEM_PARAMETERS_PK
  1. ColumnSET_OF_BOOKS_ID
  2. ColumnORG_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableCE_BANK_ACCT_USES_ALL AP_SYSTEM_PARAMETERS_ALL.CE_BANK_ACCT_USE_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL AP_SYSTEM_PARAMETERS_ALL.BANK_ACCOUNT_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.DISC_LOST_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.DISC_TAKEN_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableAP_INCOME_TAX_REGIONS AP_SYSTEM_PARAMETERS_ALL.INCOME_TAX_REGION
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.TRANS_GAIN_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.PREPAY_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.GAIN_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.LOSS_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.INTEREST_ACCTS_PAY_CCID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.FREIGHT_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES AP_SYSTEM_PARAMETERS_ALL.DEFAULT_EXCHANGE_RATE_TYPE
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.RATE_VAR_GAIN_CCID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.RATE_VAR_LOSS_CCID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableAP_AWT_GROUPS AP_SYSTEM_PARAMETERS_ALL.DEFAULT_AWT_GROUP_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.ROUNDING_ERROR_CCID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableAP_EXPENSE_REPORTS_ALL AP_SYSTEM_PARAMETERS_ALL.EXPENSE_REPORT_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableHR_LOCATIONS_ALL AP_SYSTEM_PARAMETERS_ALL.LOCATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableAP_TOLERANCE_TEMPLATES AP_SYSTEM_PARAMETERS_ALL.TOLERANCE_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AP_SYSTEM_PARAMETERS_ALL.SET_OF_BOOKS_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableFND_CURRENCIES AP_SYSTEM_PARAMETERS_ALL.BASE_CURRENCY_CODE
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableFND_CURRENCIES AP_SYSTEM_PARAMETERS_ALL.INVOICE_CURRENCY_CODE
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableFND_CURRENCIES AP_SYSTEM_PARAMETERS_ALL.PAYMENT_CURRENCY_CODE
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.ACCTS_PAY_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SYSTEM_PARAMETERS_ALL.SALES_TAX_CODE_COMBINATION_ID