EBS-GL_Table关联图

R12OracleGeneralLedger-OverallProcess,Functions&TableSchema課程網要第一單元：Entities單一作業對應表格第二單元：Relationships整合作業關聯第三單元：Lab隨堂練習第一單元：Entities單一作業對應表格會計科目組合(AccountCombination)會計期間的開關控管(Open/ClosePeriod)幣別(Currency)匯率類別(ConversionRateType)匯率(DailyRate,PeriodRate,HistoricalRate)帳本(SetofBook)傳票來源(JournalSource)傳票種類(JournalCategory)Region01Asia02America03EuropeDepartment100FIN200MKT300R&D400MFGAccount1101Cash2143AP6101Expense01Asia300R&D6101ExpenseAccountCombinations一個科目組合(Combination)是由所定義的科目節段所組成，科目組合的架構使公司能更靈活地定義所要收集的資訊。定義會計科目組合Path:(GL)SetupAccountsCombinationsBaseTable:GL_CODE_COMBINATIONS設定會計期間的開關控管Path:(GL)SetupOpen/CloseBaseTable:GL_PERIOD_STATUSES設定幣別Path:(GL)SetupCurrenciesDefineBaseTable:FND_CURRENCIES設定匯率類別Path:(GL)SetupCurrenciesRatesTypesBaseTable:GL_DAILY_CONVERSION_TYPES設定匯率Path:(GL)SetupCurrenciesRatesDailyBaseTable:GL_DAILY_RATES設定帳本Path:(GL)SetupFinancialsAccountingSetupManagerAccountingSetupsBaseTable:GL_LEDGERSGL設定GL_CODE_COMBINATIONS•CHART_OF_ACCOUNTS_ID•CODE_COMBINATION_IDGL_LEDGERS•LEDGER_ID•NAME•CURRENCY_CODE•PERIOD_SET_NAME•CHART_OF_ACCOUNTS_IDFND_CURRENCIES•CURRENCY_CODE•DESCRIPTIONGL_PERIOD_SETS•PERIOD_SET_NAMEGL_PERIODS•PERIOD_SET_NAME•PERIOD_NAMEGL_PERIOD_STATUSES•APPLICATION_ID•LEDGER_ID•PERIOD_NAMEFND_APPLICATION•APPLICATION_ID•APPLICATION_SHORT_NAME=‘SQLGL’設定傳票來源Path:(GL)SetupJournalSourcesBaseTable:GL_JE_SOURCES設定傳票種類Path:(GL)SetupJournalCategoriesBaseTable:GL_JE_CATEGORIES設定暫時科目Path:(GL)SetupAccountsSuspenseBaseTable:GL_SUSPENSE_ACCOUNTS第二單元：Relationships整合作業關聯傳票作業─人工輸入(ManualJournal)傳票作業─系統轉入(JournalImport)科目餘額GL/AP/AR整合傳票作業-人工建立Path:(GL)JournalsEnterBaseTable:GL_JE_BATCHES傳票作業-人工建立Path:(GL)JournalsEnter(B)ReviewJournalBaseTable:GL_JE_HEADERS（JournalHeader）BaseTable:GL_JE_LINES(DETAIL)傳票作業-人工建立Path:(GL)JournalsEnter(B)ReviewJournalBaseTable:GL_JE_LINES（DETAIL）BaseTable:GL_JE_LINES(DETAIL)傳票作業-人工建立GL_JE_HEADERS•JE_HEADER_ID•JE_SOURCE•JE_CATEGORY•CURRENCY_CODE•STATUS•PERIOD_NAME•JE_BATCH_ID•DOC_SEQUENCE_VALUEGL_JE_LINES•JE_HEADER_ID•JE_LINE_NUM•EFFECTIVE_DATE•CODE_COMBINATION_ID•ACCOUNTED_DR•ACCOUNTED_CR•ENTERED_DR•ENTERED_CR•SUBLEDGER_DOC_SEQUENCT_VALUEGL_JE_SOURCES•JE_SOURCE_NAME•USER_JE_SOURCE_NAMEGL_JE_CATEGORIES•JE_CATEGORY_NAME•USER_JE_CATEGORY_NAMEGL_JE_BATCHES•JE_BATCH_ID•NAMEGL_CODE_COMBINATIONS•CODE_COMBINATION_ID•SEGMENT1~SEGMENT30傳票作業-系統轉入Path:(GL)JournalsImportRunImportBaseTable:GL_INTERFACE傳票作業-系統轉入GL_INTERFACE•USER_JE_SOURCE_NAME•USER_JE_CATEGORY_NAME•CURRENCY_CODE•STATUS•ACCOUNTING_DATE•LEDGER_ID•CODE_COMBINATION_ID•ACTUAL_FLAG•JE_HEADER_ID•JE_LINE_NUMGL_JE_SOURCES•JE_SOURCE_NAMEE•USER_JE_SOURCE_NAMEGL_JE_CATEGORIES•JE_CATEGORY_NAME•USER_JE_CATEGORY_NAMEGL_CODE_COMBINATIONS•CODE_COMBINATION_ID•SEGMENT1~SEGMENT30GL_LEDGERS•LEDGER_ID•NAMEGL_IMPORT_REFERENCES•JE_LINE_NUM•JE_HEADER_ID•REFERENCE1~10•SUBLEDGER_DOC_SEQUENCE_VALUEGL_JE_LINES•JE_LINE_NUM•JE_HEADER_ID•EFFECTIVE_DATE•CODE_COMBINATION_ID科目餘額GL_BALANCES•LEDGER_ID•CODE_COMBINATION_ID•CURRENCY_CODE•PERIOD_NAME•ACTUAL_FLAG•PERIOD_NET_DR本期發生交易金額•PERIOD_NET_CR•BEGIN_BALANCE_DR期初餘額•BEGIN_BALANCE_CRGL_CODE_COMBINATIONS•CODE_COMBINATION_ID•SEGMENT1~SEGMENT30GL_LEDGERS•LEDGER_ID•NAMEGL/APINVOICEAP_INVOICES_ALL•INVOICE_IDGL_IMPORT_REFERENCES•JE_LINE_NUM•JE_HEADER_ID•GL_SL_LINK_IDGL_JE_LINES•JE_HEADER_ID•JE_LINE_NUMGL_JE_HEADERS•JE_BATCH_ID•JE_HEADER_ID•JE_SOURCE•JE_CATEGORYGL_JE_BATCHES•JE_BATCH_IDGL_JE_SOURCES•JE_SOURCE_NAME•USER_JE_SOURCE_NAMEGL_JE_CATEGORIES•JE_CATEGORY_NAME•USER_JE_CATEGORY_NAMEXLA_AE_LINES•AE_HEADER_ID•AE_LINE_NUM•GL_SL_LINK_IDXLA_AE_HEADERS•.EVENT_ID•AE_HEADER_IDXLA_DISTRIBUTION_LINKS•ALLOC_TO_SOURCE_ID_NUM_1•ALLOC_TO_ENTITY_CODE=‘AP_INVOICES’•AE_HEAER_ID•AE_LINE_NUMGL/APPAYMENTAP_INVOICE_PAYMENTS_ALL•ACCOUNTING_EVENT_ID•INVOICE_PAYMENT_IDGL_IMPORT_REFERENCES•JE_LINE_NUM•JE_HEADER_ID•GL_SL_LINK_IDGL_JE_LINES•JE_HEADER_ID•JE_LINE_NUMGL_JE_HEADERS•JE_BATCH_ID•JE_HEADER_ID•JE_SOURCE•JE_CATEGORYGL_JE_BATCHES•JE_BATCH_IDGL_JE_SOURCES•JE_SOURCE_NAME•USER_JE_SOURCE_NAMEGL_JE_CATEGORIES•JE_CATEGORY_NAME•USER_JE_CATEGORY_NAMEXLA_AE_LINES•AE_HEADER_ID•AE_LINE_NUM•GL_SL_LINK_IDXLA_AE_HEADERS•.EVENT_ID•AE_HEADER_IDXLA_DISTRIBUTION_LINKS•SOURCE_DISTRIBUTION_ID_NUM_1•SOURCE_DISTRIBUTION_TYPE=‘AP_PMT_DIST'•AE_HEAER_ID•AE_LINE_NUMGL/ARInvoicesRA_CUST_TRX_LINE_GL_DIST_ALLL•EVENT_ID•CUST_TRX_LINE_GL_DIST_IDGL_IMPORT_REFERENCES•JE_LINE_NUM•JE_HEADER_ID•GL_SL_LINK_IDGL_JE_LINES•JE_HEADER_ID•JE_LINE_NUMGL_JE_HEADERS•JE_BATCH_ID•JE_HEADER_ID•JE_SOURCE•JE_CATEGORYGL_JE_BATCHES•JE_BATCH_IDGL_JE_SOURCES•JE_SOURCE_NAME•USER_JE_SOURCE_NAMEGL_JE_CATEGORIES•JE_CATEGORY_NAME•USER_JE_CATEGORY_NAMEXLA_AE_LINES•AE_HEADER_ID•AE_LINE_NUM•GL_SL_LINK_IDXLA_AE_HEADERS•.EVENT_ID•AE_HEADER_IDXLA_DISTRIBUTION_LINKS•SOURCE_DISTRIBUTION_ID_NUM_1•SOURCE_DISTRIBUTION_TYPE=‘RA_CUST_TRX_LINE_GL_DIST_ALL'•AE_HEAER_ID•AE_LINE_NUMGL/ARAdjustmentsAR_ADJUSTMENTS_ALL•EVENT_ID•ADJUSTMENT_IDGL_IMPORT_REFERENCES•JE_LINE_NUM•JE_HEADER_ID•GL_SL_LINK_IDGL_JE_LINES•JE_HEADER_ID•JE_LINE_NUMGL_JE_HEADERS•JE_B