eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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

SET_OF_BOOKS_ID

Primary Key: GL_SETS_OF_BOOKS_UK1

NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
GL_SETS_OF_BOOKS	GL_CODE_COMBINATIONS	GL_SETS_OF_BOOKS.RES_ENCUMB_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS	GL_DAILY_CONVERSION_TYPES	GL_SETS_OF_BOOKS.DAILY_TRANSLATION_RATE_TYPE
GL_SETS_OF_BOOKS	GL_CODE_COMBINATIONS	GL_SETS_OF_BOOKS.ROUNDING_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS	GL_PERIOD_TYPES	GL_SETS_OF_BOOKS.ACCOUNTED_PERIOD_TYPE
GL_SETS_OF_BOOKS	GL_CODE_COMBINATIONS	GL_SETS_OF_BOOKS.CUM_TRANS_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS	GL_CODE_COMBINATIONS	GL_SETS_OF_BOOKS.RET_EARN_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS	FND_CURRENCIES	GL_SETS_OF_BOOKS.CURRENCY_CODE
GL_SETS_OF_BOOKS	GL_PERIOD_SETS	GL_SETS_OF_BOOKS.PERIOD_SET_NAME
GL_SETS_OF_BOOKS	GL_CODE_COMBINATIONS	GL_SETS_OF_BOOKS.NET_INCOME_CODE_COMBINATION_ID
GL_SETS_OF_BOOKS	GL_TRANSACTION_CALENDAR	GL_SETS_OF_BOOKS.TRANSACTION_CALENDAR_ID
AP_CHECK_TRANSMISSIONS	GL_SETS_OF_BOOKS	AP_CHECK_TRANSMISSIONS.SET_OF_BOOKS_ID
%	GL_SETS_OF_BOOKS
%	GL_SETS_OF_BOOKS
%	GL_SETS_OF_BOOKS
AP_INVOICE_TRANSMISSIONS	GL_SETS_OF_BOOKS	AP_INVOICE_TRANSMISSIONS.SET_OF_BOOKS_ID
AR_MC_ADJUSTMENTS	GL_SETS_OF_BOOKS	AR_MC_ADJUSTMENTS.SET_OF_BOOKS_ID
AR_MC_BATCHES	GL_SETS_OF_BOOKS	AR_MC_BATCHES.SET_OF_BOOKS_ID
AR_MC_CASH_BASIS_DISTS_ALL	GL_SETS_OF_BOOKS	AR_MC_CASH_BASIS_DISTS_ALL.SET_OF_BOOKS_ID
AR_MC_CASH_RECEIPTS	GL_SETS_OF_BOOKS	AR_MC_CASH_RECEIPTS.SET_OF_BOOKS_ID
AR_MC_CASH_RECEIPT_HIST	GL_SETS_OF_BOOKS	AR_MC_CASH_RECEIPT_HIST.SET_OF_BOOKS_ID
AR_MC_DISTRIBUTIONS_ALL	GL_SETS_OF_BOOKS	AR_MC_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
AR_MC_MISC_CASH_DISTS	GL_SETS_OF_BOOKS	AR_MC_MISC_CASH_DISTS.SET_OF_BOOKS_ID
AR_MC_PAYMENT_SCHEDULES	GL_SETS_OF_BOOKS	AR_MC_PAYMENT_SCHEDULES.SET_OF_BOOKS_ID
AR_MC_RATE_ADJUSTMENTS	GL_SETS_OF_BOOKS	AR_MC_RATE_ADJUSTMENTS.SET_OF_BOOKS_ID
AR_MC_RECEIVABLE_APPS	GL_SETS_OF_BOOKS	AR_MC_RECEIVABLE_APPS.SET_OF_BOOKS_ID
%	GL_SETS_OF_BOOKS
%	GL_SETS_OF_BOOKS
%	GL_SETS_OF_BOOKS
AX_SETUP_POSTING_BOOKS	GL_SETS_OF_BOOKS	AX_SETUP_POSTING_BOOKS.POSTING_SET_OF_BOOKS_ID
AX_SETUP_SUBLEDGERS	GL_SETS_OF_BOOKS	AX_SETUP_SUBLEDGERS.MAIN_SET_OF_BOOKS_ID
IGC_CC_BC_ENABLE	GL_SETS_OF_BOOKS	IGC_CC_BC_ENABLE.SET_OF_BOOKS_ID
CE_SYSTEM_PARAMETERS_ALL	GL_SETS_OF_BOOKS	CE_SYSTEM_PARAMETERS_ALL.SET_OF_BOOKS_ID
GL_ALLOC_HISTORY	GL_SETS_OF_BOOKS	GL_ALLOC_HISTORY.SET_OF_BOOKS_ID
GL_ARCHIVE_BALANCES	GL_SETS_OF_BOOKS	GL_ARCHIVE_BALANCES.SET_OF_BOOKS_ID
GL_ARCHIVE_BATCHES	GL_SETS_OF_BOOKS	GL_ARCHIVE_BATCHES.SET_OF_BOOKS_ID
GL_ARCHIVE_DAILY_BALANCES	GL_SETS_OF_BOOKS	GL_ARCHIVE_DAILY_BALANCES.SET_OF_BOOKS_ID
GL_ARCHIVE_HEADERS	GL_SETS_OF_BOOKS	GL_ARCHIVE_HEADERS.SET_OF_BOOKS_ID
GL_ARCHIVE_LINES	GL_SETS_OF_BOOKS	GL_ARCHIVE_LINES.SET_OF_BOOKS_ID
GL_AUTHORIZATION_LIMITS	GL_SETS_OF_BOOKS	GL_AUTHORIZATION_LIMITS.SET_OF_BOOKS_ID
GL_AUTO_ALLOC_SETS	GL_SETS_OF_BOOKS	GL_AUTO_ALLOC_SETS.SET_OF_BOOKS_ID
GL_MC_BOOK_ASSIGNMENTS	GL_SETS_OF_BOOKS	GL_MC_BOOK_ASSIGNMENTS.PRIMARY_SET_OF_BOOKS_ID
GL_MC_BOOK_ASSIGNMENTS	GL_SETS_OF_BOOKS	GL_MC_BOOK_ASSIGNMENTS.REPORTING_SET_OF_BOOKS_ID
GL_MC_CONVERSION_RULES	GL_SETS_OF_BOOKS	GL_MC_CONVERSION_RULES.PRIMARY_SET_OF_BOOKS_ID
GL_MC_CONVERSION_RULES	GL_SETS_OF_BOOKS	GL_MC_CONVERSION_RULES.REPORTING_SET_OF_BOOKS_ID
GL_MC_REPORTING_OPTIONS	GL_SETS_OF_BOOKS	GL_MC_REPORTING_OPTIONS.PRIMARY_SET_OF_BOOKS_ID
GL_MC_REPORTING_OPTIONS	GL_SETS_OF_BOOKS	GL_MC_REPORTING_OPTIONS.REPORTING_SET_OF_BOOKS_ID
GL_MC_REPORTING_OPTIONS	GL_SETS_OF_BOOKS	GL_MC_REPORTING_OPTIONS.AP_SECONDARY_SET_OF_BOOKS_ID
GL_MC_UPGRADE_HISTORY	GL_SETS_OF_BOOKS	GL_MC_UPGRADE_HISTORY.PRIMARY_SET_OF_BOOKS_ID
GL_OASIS_FIN_ASSIGNMENTS	GL_SETS_OF_BOOKS	GL_OASIS_FIN_ASSIGNMENTS.SET_OF_BOOKS_ID
GL_OASIS_FIN_METRICS	GL_SETS_OF_BOOKS	GL_OASIS_FIN_METRICS.SET_OF_BOOKS_ID
GL_POSTING_INTERIM	GL_SETS_OF_BOOKS	GL_POSTING_INTERIM.SET_OF_BOOKS_ID
GL_REVALUATION_ACCOUNTS	GL_SETS_OF_BOOKS	GL_REVALUATION_ACCOUNTS.SET_OF_BOOKS_ID
GL_AUTOMATIC_POSTING_SETS	GL_SETS_OF_BOOKS	GL_AUTOMATIC_POSTING_SETS.SET_OF_BOOKS_ID
GL_SYSTEM_SETUP	GL_SETS_OF_BOOKS	GL_SYSTEM_SETUP.SET_OF_BOOKS_ID
GL_TRANSACTION_RATE_EXCEPTIONS	GL_SETS_OF_BOOKS	GL_TRANSACTION_RATE_EXCEPTIONS.SET_OF_BOOKS_ID
GL_TRANSLATION_INTERIM	GL_SETS_OF_BOOKS	GL_TRANSLATION_INTERIM.SET_OF_BOOKS_ID
GL_TRANSLATION_RATES	GL_SETS_OF_BOOKS	GL_TRANSLATION_RATES.SET_OF_BOOKS_ID
GL_WEIGHTED_AVG_DETAILS	GL_SETS_OF_BOOKS	GL_WEIGHTED_AVG_DETAILS.SET_OF_BOOKS_ID
GL_ACCOUNT_HIERARCHIES	GL_SETS_OF_BOOKS	GL_ACCOUNT_HIERARCHIES.SET_OF_BOOKS_ID
IGC_CBC_BA_RANGES	GL_SETS_OF_BOOKS	IGC_CBC_BA_RANGES.SET_OF_BOOKS_ID
IGC_CBC_SUMMARY_TEMPLATES	GL_SETS_OF_BOOKS	IGC_CBC_SUMMARY_TEMPLATES.SET_OF_BOOKS_ID
IGC_CBC_MC_JE_BATCHES	GL_SETS_OF_BOOKS	IGC_CBC_MC_JE_BATCHES.REPORTING_SET_OF_BOOKS_ID
IGC_CBC_MC_JE_LINES	GL_SETS_OF_BOOKS	IGC_CBC_MC_JE_LINES.REPORTING_SET_OF_BOOKS_ID
IGC_CBC_JE_BATCHES	GL_SETS_OF_BOOKS	IGC_CBC_JE_BATCHES.SET_OF_BOOKS_ID
IGC_CBC_JE_LINES	GL_SETS_OF_BOOKS	IGC_CBC_JE_LINES.SET_OF_BOOKS_ID
IGC_CC_HEADERS	GL_SETS_OF_BOOKS	IGC_CC_HEADERS.SET_OF_BOOKS_ID
IGI_DUN_CHARGE_ALL	GL_SETS_OF_BOOKS	IGI_DUN_CHARGE_ALL.SET_OF_BOOKS_ID
IGI_EER_SETUP	GL_SETS_OF_BOOKS	IGI_EER_SETUP.GL_SET_OF_BOOKS_ID
JL_ZZ_GL_AXI_ACCOUNTS	GL_SETS_OF_BOOKS	JL_ZZ_GL_AXI_ACCOUNTS.SET_OF_BOOKS_ID
JL_ZZ_GL_AXI	GL_SETS_OF_BOOKS	JL_ZZ_GL_AXI.SET_OF_BOOKS_ID
JL_ZZ_GL_AXI_MODELS	GL_SETS_OF_BOOKS	JL_ZZ_GL_AXI_MODELS.SET_OF_BOOKS_ID
JL_ZZ_GL_AXI_MODEL_RANGES	GL_SETS_OF_BOOKS	JL_ZZ_GL_AXI_MODEL_RANGES.SET_OF_BOOKS_ID
IGC_CC_ARC_HEADERS	GL_SETS_OF_BOOKS	IGC_CC_ARC_HEADERS.SET_OF_BOOKS_ID
IGC_CC_HEADERS_INTERFACE	GL_SETS_OF_BOOKS	IGC_CC_HEADERS_INTERFACE.SET_OF_BOOKS_ID
PO_DISTRIBUTIONS_ARCHIVE_ALL	GL_SETS_OF_BOOKS	PO_DISTRIBUTIONS_ARCHIVE_ALL.SET_OF_BOOKS_ID
PO_DISTRIBUTIONS_ALL	GL_SETS_OF_BOOKS	PO_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
PO_REQ_DISTRIBUTIONS_ALL	GL_SETS_OF_BOOKS	PO_REQ_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
PO_VENDORS	GL_SETS_OF_BOOKS	PO_VENDORS.SET_OF_BOOKS_ID
PSP_ADJUSTMENT_CONTROL_TABLE	GL_SETS_OF_BOOKS	PSP_ADJUSTMENT_CONTROL_TABLE.SET_OF_BOOKS_ID
PSP_ADJUSTMENT_LINES	GL_SETS_OF_BOOKS	PSP_ADJUSTMENT_LINES.SET_OF_BOOKS_ID
PSP_ADJUSTMENT_LINES_HISTORY	GL_SETS_OF_BOOKS	PSP_ADJUSTMENT_LINES_HISTORY.SET_OF_BOOKS_ID
PSP_AUTO_ACCTS	GL_SETS_OF_BOOKS	PSP_AUTO_ACCTS.SET_OF_BOOKS_ID
PSP_AUTO_BYPASS	GL_SETS_OF_BOOKS	PSP_AUTO_BYPASS.SET_OF_BOOKS_ID
PSP_AUTO_LOOKUPS	GL_SETS_OF_BOOKS	PSP_AUTO_LOOKUPS.SET_OF_BOOKS_ID
PSP_AUTO_NA_BYPASS	GL_SETS_OF_BOOKS	PSP_AUTO_NA_BYPASS.SET_OF_BOOKS_ID
PSP_AUTO_SEGMENTS	GL_SETS_OF_BOOKS	PSP_AUTO_SEGMENTS.SET_OF_BOOKS_ID
PSP_DEFAULT_LABOR_SCHEDULES	GL_SETS_OF_BOOKS	PSP_DEFAULT_LABOR_SCHEDULES.SET_OF_BOOKS_ID
PSP_DISTRIBUTION_INTERFACE	GL_SETS_OF_BOOKS	PSP_DISTRIBUTION_INTERFACE.SET_OF_BOOKS_ID
PSP_DISTRIBUTION_LINES	GL_SETS_OF_BOOKS	PSP_DISTRIBUTION_LINES.SET_OF_BOOKS_ID
PSP_DISTRIBUTION_LINES_HISTORY	GL_SETS_OF_BOOKS	PSP_DISTRIBUTION_LINES_HISTORY.SET_OF_BOOKS_ID
PSP_ELEMENT_TYPE_ACCOUNTS	GL_SETS_OF_BOOKS	PSP_ELEMENT_TYPE_ACCOUNTS.SET_OF_BOOKS_ID
PSP_ORGANIZATION_ACCOUNTS	GL_SETS_OF_BOOKS	PSP_ORGANIZATION_ACCOUNTS.SET_OF_BOOKS_ID
PSP_PAYROLL_CONTROLS	GL_SETS_OF_BOOKS	PSP_PAYROLL_CONTROLS.SET_OF_BOOKS_ID
PSP_PAYROLL_INTERFACE	GL_SETS_OF_BOOKS	PSP_PAYROLL_INTERFACE.SET_OF_BOOKS_ID
PSP_PAYROLL_LINES	GL_SETS_OF_BOOKS	PSP_PAYROLL_LINES.SET_OF_BOOKS_ID
PSP_PRE_GEN_DIST_LINES	GL_SETS_OF_BOOKS	PSP_PRE_GEN_DIST_LINES.SET_OF_BOOKS_ID
PSP_PRE_GEN_DIST_LINES_HISTORY	GL_SETS_OF_BOOKS	PSP_PRE_GEN_DIST_LINES_HISTORY.SET_OF_BOOKS_ID
PSP_SCHEDULE_HIERARCHY	GL_SETS_OF_BOOKS	PSP_SCHEDULE_HIERARCHY.SET_OF_BOOKS_ID
PSP_SCHEDULE_LINES	GL_SETS_OF_BOOKS	PSP_SCHEDULE_LINES.SET_OF_BOOKS_ID
PSP_SUMMARY_LINES	GL_SETS_OF_BOOKS	PSP_SUMMARY_LINES.SET_OF_BOOKS_ID
RA_SALESREPS_ALL	GL_SETS_OF_BOOKS	RA_SALESREPS_ALL.SET_OF_BOOKS_ID
RCV_RECEIVING_SUB_LEDGER	GL_SETS_OF_BOOKS	RCV_RECEIVING_SUB_LEDGER.SET_OF_BOOKS_ID
GL_REVALUATION	GL_SETS_OF_BOOKS	GL_REVALUATION.SET_OF_BOOKS_ID