FND Design Data [Home] [Help]

Table: GL_SETS_OF_BOOKS

Product: GL - General Ledger
Description: Set of books definitions
Implementation/DBA Data: Not implemented in this database
Primary Key: GL_SETS_OF_BOOKS_PK
  1. ColumnSET_OF_BOOKS_ID
Primary Key: GL_SETS_OF_BOOKS_UK1
  1. ColumnNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_SETS_OF_BOOKS FK Joins to TableGL_CODE_COMBINATIONS GL_SETS_OF_BOOKS.RES_ENCUMB_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS FK Joins to TableGL_DAILY_CONVERSION_TYPES GL_SETS_OF_BOOKS.DAILY_TRANSLATION_RATE_TYPE
GL_SETS_OF_BOOKS FK Joins to TableGL_CODE_COMBINATIONS GL_SETS_OF_BOOKS.ROUNDING_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS FK Joins to TableGL_PERIOD_TYPES GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE
GL_SETS_OF_BOOKS FK Joins to TableGL_CODE_COMBINATIONS GL_SETS_OF_BOOKS.CUM_TRANS_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS FK Joins to TableGL_CODE_COMBINATIONS GL_SETS_OF_BOOKS.RET_EARN_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS FK Joins to TableFND_CURRENCIES GL_SETS_OF_BOOKS.CURRENCY_CODE
GL_SETS_OF_BOOKS FK Joins to TableGL_PERIOD_SETS GL_SETS_OF_BOOKS.PERIOD_SET_NAME
GL_SETS_OF_BOOKS FK Joins to TableGL_CODE_COMBINATIONS GL_SETS_OF_BOOKS.NET_INCOME_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS FK Joins to TableGL_TRANSACTION_CALENDAR GL_SETS_OF_BOOKS.TRANSACTION_CALENDAR_ID
TableAP_CHECK_TRANSMISSIONS FK Joins to GL_SETS_OF_BOOKS AP_CHECK_TRANSMISSIONS.SET_OF_BOOKS_ID
Table% FK Joins to GL_SETS_OF_BOOKS
Table% FK Joins to GL_SETS_OF_BOOKS
Table% FK Joins to GL_SETS_OF_BOOKS
TableAP_INVOICE_TRANSMISSIONS FK Joins to GL_SETS_OF_BOOKS AP_INVOICE_TRANSMISSIONS.SET_OF_BOOKS_ID
TableAR_MC_ADJUSTMENTS FK Joins to GL_SETS_OF_BOOKS AR_MC_ADJUSTMENTS.SET_OF_BOOKS_ID
TableAR_MC_BATCHES FK Joins to GL_SETS_OF_BOOKS AR_MC_BATCHES.SET_OF_BOOKS_ID
TableAR_MC_CASH_BASIS_DISTS_ALL FK Joins to GL_SETS_OF_BOOKS AR_MC_CASH_BASIS_DISTS_ALL.SET_OF_BOOKS_ID
TableAR_MC_CASH_RECEIPTS FK Joins to GL_SETS_OF_BOOKS AR_MC_CASH_RECEIPTS.SET_OF_BOOKS_ID
TableAR_MC_CASH_RECEIPT_HIST FK Joins to GL_SETS_OF_BOOKS AR_MC_CASH_RECEIPT_HIST.SET_OF_BOOKS_ID
TableAR_MC_DISTRIBUTIONS_ALL FK Joins to GL_SETS_OF_BOOKS AR_MC_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
TableAR_MC_MISC_CASH_DISTS FK Joins to GL_SETS_OF_BOOKS AR_MC_MISC_CASH_DISTS.SET_OF_BOOKS_ID
TableAR_MC_PAYMENT_SCHEDULES FK Joins to GL_SETS_OF_BOOKS AR_MC_PAYMENT_SCHEDULES.SET_OF_BOOKS_ID
TableAR_MC_RATE_ADJUSTMENTS FK Joins to GL_SETS_OF_BOOKS AR_MC_RATE_ADJUSTMENTS.SET_OF_BOOKS_ID
TableAR_MC_RECEIVABLE_APPS FK Joins to GL_SETS_OF_BOOKS AR_MC_RECEIVABLE_APPS.SET_OF_BOOKS_ID
Table% FK Joins to GL_SETS_OF_BOOKS
Table% FK Joins to GL_SETS_OF_BOOKS
Table% FK Joins to GL_SETS_OF_BOOKS
TableAX_SETUP_POSTING_BOOKS FK Joins to GL_SETS_OF_BOOKS AX_SETUP_POSTING_BOOKS.POSTING_SET_OF_BOOKS_ID
TableAX_SETUP_SUBLEDGERS FK Joins to GL_SETS_OF_BOOKS AX_SETUP_SUBLEDGERS.MAIN_SET_OF_BOOKS_ID
TableIGC_CC_BC_ENABLE FK Joins to GL_SETS_OF_BOOKS IGC_CC_BC_ENABLE.SET_OF_BOOKS_ID
TableCE_SYSTEM_PARAMETERS_ALL FK Joins to GL_SETS_OF_BOOKS CE_SYSTEM_PARAMETERS_ALL.SET_OF_BOOKS_ID
TableGL_ALLOC_HISTORY FK Joins to GL_SETS_OF_BOOKS GL_ALLOC_HISTORY.SET_OF_BOOKS_ID
TableGL_ARCHIVE_BALANCES FK Joins to GL_SETS_OF_BOOKS GL_ARCHIVE_BALANCES.SET_OF_BOOKS_ID
TableGL_ARCHIVE_BATCHES FK Joins to GL_SETS_OF_BOOKS GL_ARCHIVE_BATCHES.SET_OF_BOOKS_ID
TableGL_ARCHIVE_DAILY_BALANCES FK Joins to GL_SETS_OF_BOOKS GL_ARCHIVE_DAILY_BALANCES.SET_OF_BOOKS_ID
TableGL_ARCHIVE_HEADERS FK Joins to GL_SETS_OF_BOOKS GL_ARCHIVE_HEADERS.SET_OF_BOOKS_ID
TableGL_ARCHIVE_LINES FK Joins to GL_SETS_OF_BOOKS GL_ARCHIVE_LINES.SET_OF_BOOKS_ID
TableGL_AUTHORIZATION_LIMITS FK Joins to GL_SETS_OF_BOOKS GL_AUTHORIZATION_LIMITS.SET_OF_BOOKS_ID
TableGL_AUTO_ALLOC_SETS FK Joins to GL_SETS_OF_BOOKS GL_AUTO_ALLOC_SETS.SET_OF_BOOKS_ID
TableGL_MC_BOOK_ASSIGNMENTS FK Joins to GL_SETS_OF_BOOKS GL_MC_BOOK_ASSIGNMENTS.PRIMARY_SET_OF_BOOKS_ID
TableGL_MC_BOOK_ASSIGNMENTS FK Joins to GL_SETS_OF_BOOKS GL_MC_BOOK_ASSIGNMENTS.REPORTING_SET_OF_BOOKS_ID
TableGL_MC_CONVERSION_RULES FK Joins to GL_SETS_OF_BOOKS GL_MC_CONVERSION_RULES.PRIMARY_SET_OF_BOOKS_ID
TableGL_MC_CONVERSION_RULES FK Joins to GL_SETS_OF_BOOKS GL_MC_CONVERSION_RULES.REPORTING_SET_OF_BOOKS_ID
TableGL_MC_REPORTING_OPTIONS FK Joins to GL_SETS_OF_BOOKS GL_MC_REPORTING_OPTIONS.PRIMARY_SET_OF_BOOKS_ID
TableGL_MC_REPORTING_OPTIONS FK Joins to GL_SETS_OF_BOOKS GL_MC_REPORTING_OPTIONS.REPORTING_SET_OF_BOOKS_ID
TableGL_MC_REPORTING_OPTIONS FK Joins to GL_SETS_OF_BOOKS GL_MC_REPORTING_OPTIONS.AP_SECONDARY_SET_OF_BOOKS_ID
TableGL_MC_UPGRADE_HISTORY FK Joins to GL_SETS_OF_BOOKS GL_MC_UPGRADE_HISTORY.PRIMARY_SET_OF_BOOKS_ID
TableGL_OASIS_FIN_ASSIGNMENTS FK Joins to GL_SETS_OF_BOOKS GL_OASIS_FIN_ASSIGNMENTS.SET_OF_BOOKS_ID
TableGL_OASIS_FIN_METRICS FK Joins to GL_SETS_OF_BOOKS GL_OASIS_FIN_METRICS.SET_OF_BOOKS_ID
TableGL_POSTING_INTERIM FK Joins to GL_SETS_OF_BOOKS GL_POSTING_INTERIM.SET_OF_BOOKS_ID
TableGL_REVALUATION_ACCOUNTS FK Joins to GL_SETS_OF_BOOKS GL_REVALUATION_ACCOUNTS.SET_OF_BOOKS_ID
TableGL_AUTOMATIC_POSTING_SETS FK Joins to GL_SETS_OF_BOOKS GL_AUTOMATIC_POSTING_SETS.SET_OF_BOOKS_ID
TableGL_SYSTEM_SETUP FK Joins to GL_SETS_OF_BOOKS GL_SYSTEM_SETUP.SET_OF_BOOKS_ID
TableGL_TRANSACTION_RATE_EXCEPTIONS FK Joins to GL_SETS_OF_BOOKS GL_TRANSACTION_RATE_EXCEPTIONS.SET_OF_BOOKS_ID
TableGL_TRANSLATION_INTERIM FK Joins to GL_SETS_OF_BOOKS GL_TRANSLATION_INTERIM.SET_OF_BOOKS_ID
TableGL_TRANSLATION_RATES FK Joins to GL_SETS_OF_BOOKS GL_TRANSLATION_RATES.SET_OF_BOOKS_ID
TableGL_WEIGHTED_AVG_DETAILS FK Joins to GL_SETS_OF_BOOKS GL_WEIGHTED_AVG_DETAILS.SET_OF_BOOKS_ID
TableGL_ACCOUNT_HIERARCHIES FK Joins to GL_SETS_OF_BOOKS GL_ACCOUNT_HIERARCHIES.SET_OF_BOOKS_ID
TableIGC_CBC_BA_RANGES FK Joins to GL_SETS_OF_BOOKS IGC_CBC_BA_RANGES.SET_OF_BOOKS_ID
TableIGC_CBC_SUMMARY_TEMPLATES FK Joins to GL_SETS_OF_BOOKS IGC_CBC_SUMMARY_TEMPLATES.SET_OF_BOOKS_ID
TableIGC_CBC_MC_JE_BATCHES FK Joins to GL_SETS_OF_BOOKS IGC_CBC_MC_JE_BATCHES.REPORTING_SET_OF_BOOKS_ID
TableIGC_CBC_MC_JE_LINES FK Joins to GL_SETS_OF_BOOKS IGC_CBC_MC_JE_LINES.REPORTING_SET_OF_BOOKS_ID
TableIGC_CBC_JE_BATCHES FK Joins to GL_SETS_OF_BOOKS IGC_CBC_JE_BATCHES.SET_OF_BOOKS_ID
TableIGC_CBC_JE_LINES FK Joins to GL_SETS_OF_BOOKS IGC_CBC_JE_LINES.SET_OF_BOOKS_ID
TableIGC_CC_HEADERS FK Joins to GL_SETS_OF_BOOKS IGC_CC_HEADERS.SET_OF_BOOKS_ID
TableIGI_DUN_CHARGE_ALL FK Joins to GL_SETS_OF_BOOKS IGI_DUN_CHARGE_ALL.SET_OF_BOOKS_ID
TableIGI_EER_SETUP FK Joins to GL_SETS_OF_BOOKS IGI_EER_SETUP.GL_SET_OF_BOOKS_ID
TableJL_ZZ_GL_AXI_ACCOUNTS FK Joins to GL_SETS_OF_BOOKS JL_ZZ_GL_AXI_ACCOUNTS.SET_OF_BOOKS_ID
TableJL_ZZ_GL_AXI FK Joins to GL_SETS_OF_BOOKS JL_ZZ_GL_AXI.SET_OF_BOOKS_ID
TableJL_ZZ_GL_AXI_MODELS FK Joins to GL_SETS_OF_BOOKS JL_ZZ_GL_AXI_MODELS.SET_OF_BOOKS_ID
TableJL_ZZ_GL_AXI_MODEL_RANGES FK Joins to GL_SETS_OF_BOOKS JL_ZZ_GL_AXI_MODEL_RANGES.SET_OF_BOOKS_ID
TableIGC_CC_ARC_HEADERS FK Joins to GL_SETS_OF_BOOKS IGC_CC_ARC_HEADERS.SET_OF_BOOKS_ID
TableIGC_CC_HEADERS_INTERFACE FK Joins to GL_SETS_OF_BOOKS IGC_CC_HEADERS_INTERFACE.SET_OF_BOOKS_ID
TablePO_DISTRIBUTIONS_ARCHIVE_ALL FK Joins to GL_SETS_OF_BOOKS PO_DISTRIBUTIONS_ARCHIVE_ALL.SET_OF_BOOKS_ID
TablePO_DISTRIBUTIONS_ALL FK Joins to GL_SETS_OF_BOOKS PO_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
TablePO_REQ_DISTRIBUTIONS_ALL FK Joins to GL_SETS_OF_BOOKS PO_REQ_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
TablePO_VENDORS FK Joins to GL_SETS_OF_BOOKS PO_VENDORS.SET_OF_BOOKS_ID
TablePSP_ADJUSTMENT_CONTROL_TABLE FK Joins to GL_SETS_OF_BOOKS PSP_ADJUSTMENT_CONTROL_TABLE.SET_OF_BOOKS_ID
TablePSP_ADJUSTMENT_LINES FK Joins to GL_SETS_OF_BOOKS PSP_ADJUSTMENT_LINES.SET_OF_BOOKS_ID
TablePSP_ADJUSTMENT_LINES_HISTORY FK Joins to GL_SETS_OF_BOOKS PSP_ADJUSTMENT_LINES_HISTORY.SET_OF_BOOKS_ID
TablePSP_AUTO_ACCTS FK Joins to GL_SETS_OF_BOOKS PSP_AUTO_ACCTS.SET_OF_BOOKS_ID
TablePSP_AUTO_BYPASS FK Joins to GL_SETS_OF_BOOKS PSP_AUTO_BYPASS.SET_OF_BOOKS_ID
TablePSP_AUTO_LOOKUPS FK Joins to GL_SETS_OF_BOOKS PSP_AUTO_LOOKUPS.SET_OF_BOOKS_ID
TablePSP_AUTO_NA_BYPASS FK Joins to GL_SETS_OF_BOOKS PSP_AUTO_NA_BYPASS.SET_OF_BOOKS_ID
TablePSP_AUTO_SEGMENTS FK Joins to GL_SETS_OF_BOOKS PSP_AUTO_SEGMENTS.SET_OF_BOOKS_ID
TablePSP_DEFAULT_LABOR_SCHEDULES FK Joins to GL_SETS_OF_BOOKS PSP_DEFAULT_LABOR_SCHEDULES.SET_OF_BOOKS_ID
TablePSP_DISTRIBUTION_INTERFACE FK Joins to GL_SETS_OF_BOOKS PSP_DISTRIBUTION_INTERFACE.SET_OF_BOOKS_ID
TablePSP_DISTRIBUTION_LINES FK Joins to GL_SETS_OF_BOOKS PSP_DISTRIBUTION_LINES.SET_OF_BOOKS_ID
TablePSP_DISTRIBUTION_LINES_HISTORY FK Joins to GL_SETS_OF_BOOKS PSP_DISTRIBUTION_LINES_HISTORY.SET_OF_BOOKS_ID
TablePSP_ELEMENT_TYPE_ACCOUNTS FK Joins to GL_SETS_OF_BOOKS PSP_ELEMENT_TYPE_ACCOUNTS.SET_OF_BOOKS_ID
TablePSP_ORGANIZATION_ACCOUNTS FK Joins to GL_SETS_OF_BOOKS PSP_ORGANIZATION_ACCOUNTS.SET_OF_BOOKS_ID
TablePSP_PAYROLL_CONTROLS FK Joins to GL_SETS_OF_BOOKS PSP_PAYROLL_CONTROLS.SET_OF_BOOKS_ID
TablePSP_PAYROLL_INTERFACE FK Joins to GL_SETS_OF_BOOKS PSP_PAYROLL_INTERFACE.SET_OF_BOOKS_ID
TablePSP_PAYROLL_LINES FK Joins to GL_SETS_OF_BOOKS PSP_PAYROLL_LINES.SET_OF_BOOKS_ID
TablePSP_PRE_GEN_DIST_LINES FK Joins to GL_SETS_OF_BOOKS PSP_PRE_GEN_DIST_LINES.SET_OF_BOOKS_ID
TablePSP_PRE_GEN_DIST_LINES_HISTORY FK Joins to GL_SETS_OF_BOOKS PSP_PRE_GEN_DIST_LINES_HISTORY.SET_OF_BOOKS_ID
TablePSP_SCHEDULE_HIERARCHY FK Joins to GL_SETS_OF_BOOKS PSP_SCHEDULE_HIERARCHY.SET_OF_BOOKS_ID
TablePSP_SCHEDULE_LINES FK Joins to GL_SETS_OF_BOOKS PSP_SCHEDULE_LINES.SET_OF_BOOKS_ID
TablePSP_SUMMARY_LINES FK Joins to GL_SETS_OF_BOOKS PSP_SUMMARY_LINES.SET_OF_BOOKS_ID
TableRA_SALESREPS_ALL FK Joins to GL_SETS_OF_BOOKS RA_SALESREPS_ALL.SET_OF_BOOKS_ID
TableRCV_RECEIVING_SUB_LEDGER FK Joins to GL_SETS_OF_BOOKS RCV_RECEIVING_SUB_LEDGER.SET_OF_BOOKS_ID
TableGL_REVALUATION FK Joins to GL_SETS_OF_BOOKS GL_REVALUATION.SET_OF_BOOKS_ID