EBS財(cái)務(wù)模塊基本功能和常用表

1、1 copyright 2006 pccw solutions ltd. all rights reserved. oracle ebs training 財(cái)務(wù)模塊基本功能和相關(guān)表介紹財(cái)務(wù)模塊基本功能和相關(guān)表介紹 pccw consultant pccw solutions 2008-07-29 2 copyright 2006 pccw solutions ltd. all rights reserved. 單元單元1：財(cái)務(wù)模塊功能概述：財(cái)務(wù)模塊功能概述 單元單元2：應(yīng)付模塊：應(yīng)付模塊 單元單元3：資產(chǎn)模塊：資產(chǎn)模塊 單元單元4：應(yīng)收模塊：應(yīng)收模塊 單元單元5：總帳模塊：總帳模塊 課程安排課

2、程安排 3 copyright 2006 pccw solutions ltd. all rights reserved. 單元單元1：財(cái)務(wù)模塊功能概述：財(cái)務(wù)模塊功能概述 單元單元2：應(yīng)付模塊：應(yīng)付模塊 單元單元3：資產(chǎn)模塊：資產(chǎn)模塊 單元單元4：應(yīng)收模塊：應(yīng)收模塊 單元單元5：總帳模塊：總帳模塊 課程安排課程安排 4 copyright 2006 pccw solutions ltd. all rights reserved. oracle 財(cái)務(wù)系統(tǒng)財(cái)務(wù)系統(tǒng): 綜合數(shù)據(jù)流程綜合數(shù)據(jù)流程 5 copyright 2006 pccw solutions ltd. all rights reser

3、ved. 單元單元1：財(cái)務(wù)模塊功能概述：財(cái)務(wù)模塊功能概述 單元單元2：應(yīng)付模塊：應(yīng)付模塊 單元單元3：資產(chǎn)模塊：資產(chǎn)模塊 單元單元4：應(yīng)收模塊：應(yīng)收模塊 單元單元5：總帳模塊：總帳模塊 課程安排課程安排 6 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)付模塊與其它模塊的集成關(guān)系應(yīng)付模塊與其它模塊的集成關(guān)系 7 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)付模塊功能和流程概覽應(yīng)付模塊功能和流程概覽 查詢(xún)發(fā)票查詢(xún)發(fā)票 收到發(fā)票收到發(fā)票 修改發(fā)票修改發(fā)票 發(fā)票批

4、發(fā)票批 輸入發(fā)票輸入發(fā)票 發(fā)票發(fā)票 三項(xiàng)匹配三項(xiàng)匹配 復(fù)核發(fā)票復(fù)核發(fā)票 過(guò)帳過(guò)帳 付款付款 采購(gòu)定單采購(gòu)定單 接收單接收單 8 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)付模塊應(yīng)付模塊-發(fā)票功能發(fā)票功能 9 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)付模塊應(yīng)付模塊-發(fā)票常用表發(fā)票常用表 發(fā)票批：ap_batches_all 發(fā)票頭：ap_invoices_all 發(fā)票分配：ap_invoice_distributions_all 付款計(jì)劃：ap_pay

5、ment_schedules_all 會(huì)計(jì)分錄事件：ap_accounting_events_all 會(huì)計(jì)分錄頭：ap_ae_headers_all 會(huì)計(jì)分錄行：ap_ae_lines_all 發(fā)票開(kāi)發(fā)接口表(頭)：ap_invoices_interface 發(fā)票開(kāi)發(fā)接口表(行)：ap_invoice_lines_interface 10 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)付模塊應(yīng)付模塊-發(fā)票表關(guān)系發(fā)票表關(guān)系 11 copyright 2006 pccw solutions ltd. all rights rese

6、rved. 應(yīng)付模塊應(yīng)付模塊-付款功能付款功能 12 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)付模塊應(yīng)付模塊-付款常用表付款常用表 付款批：ap_inv_selection_criteria_all 付款：ap_checks_all 付款與發(fā)票對(duì)應(yīng)：ap_invoice_payments_all 付款單據(jù)：ap_check_stocks_all 付款格式：ap_check_formats 銀行：ap_bank_branches 銀行帳戶(hù)：ap_bank_accounts_all 13 copyright 2006 pcc

7、w solutions ltd. all rights reserved. 應(yīng)付模塊應(yīng)付模塊-付款相關(guān)表付款相關(guān)表 14 copyright 2006 pccw solutions ltd. all rights reserved. 單元單元1：財(cái)務(wù)模塊功能概述：財(cái)務(wù)模塊功能概述 單元單元2：應(yīng)付模塊：應(yīng)付模塊 單元單元3：資產(chǎn)模塊：資產(chǎn)模塊 單元單元4：應(yīng)收模塊：應(yīng)收模塊 單元單元5：總帳模塊：總帳模塊 課程安排課程安排 15 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊與其它模塊的集成關(guān)系資產(chǎn)模塊與其它模塊的集成關(guān)

8、系 16 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊功能和流程概覽資產(chǎn)模塊功能和流程概覽 17 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)賬簿功能資產(chǎn)賬簿功能 基本表基本表: fa_book_controls 18 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)系統(tǒng)控制：fa_system_controls 資產(chǎn)賬簿：fa_book_controls 資產(chǎn)類(lèi)

9、別：fa_categories_b 資產(chǎn)類(lèi)別描述：fa_categories_tl 資產(chǎn)類(lèi)別帳戶(hù)：fa_category_books 資產(chǎn)類(lèi)別默認(rèn)規(guī)則：fa_category_book_defaults 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)賬簿和資產(chǎn)類(lèi)別常用表資產(chǎn)賬簿和資產(chǎn)類(lèi)別常用表 19 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)賬簿和資產(chǎn)類(lèi)別相關(guān)表資產(chǎn)賬簿和資產(chǎn)類(lèi)別相關(guān)表 20 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)類(lèi)

10、別功能資產(chǎn)類(lèi)別功能 類(lèi)別頭類(lèi)別頭: fa_categories_b (基表基表) fa_categories_tl (多語(yǔ)言多語(yǔ)言) 類(lèi)別分配：類(lèi)別分配：fa_category_book_defaults 21 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)增加功能資產(chǎn)增加功能 1.基本信息：fa_additions_b， fa_additions_tl(多語(yǔ)言) 2.財(cái)務(wù)信息：fa_books 3.分配：fa_distribution_history 1 2 3 22 copyright 2006 pcc

11、w solutions ltd. all rights reserved. 資產(chǎn)成批增加：fa_mass_additions 資產(chǎn)成批增加分配：fa_massadd_distributions 資產(chǎn)基礎(chǔ)信息：fa_additions_b 資產(chǎn)財(cái)務(wù)信息：fa_books 資產(chǎn)歷史：fa_asset_history 資產(chǎn)分配：fa_distribution_history 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)增加常用表資產(chǎn)增加常用表 資產(chǎn)來(lái)源：fa_asset_invoices 資產(chǎn)事務(wù)處理：fa_transaction_headers 資產(chǎn)事務(wù)處理分錄：fa_adjustments 資產(chǎn)地點(diǎn)：fa_locat

12、ions 23 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)增加表關(guān)系資產(chǎn)增加表關(guān)系 24 copyright 2006 pccw solutions ltd. all rights reserved. 折舊期間：fa_deprn_periods 資產(chǎn)折舊匯總：fa_deprn_summary 資產(chǎn)折舊明細(xì)：fa_deprn_detail 資產(chǎn)減值準(zhǔn)備：fa_impairments 資產(chǎn)報(bào)廢：fa_retirements 資產(chǎn)分配帳戶(hù)：fa_distribution_accounts 資產(chǎn)模塊資產(chǎn)模塊-折

13、舊與報(bào)廢常用表折舊與報(bào)廢常用表 折舊方法：fa_methods 按比例分?jǐn)倯T例：fa_conversions 25 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-折舊表關(guān)系折舊表關(guān)系 26 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)轉(zhuǎn)移功能資產(chǎn)轉(zhuǎn)移功能 27 copyright 2006 pccw solutions ltd. all rights reserved. fa_distribution_history #d

14、istribution_id gl_code_combinations # code_combination_id fa_locations #location_id fa_transaction_headers #transaction_id 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)轉(zhuǎn)移常用表及關(guān)系資產(chǎn)轉(zhuǎn)移常用表及關(guān)系 fa_employees # employee_id 28 copyright 2006 pccw solutions ltd. all rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)調(diào)整功能資產(chǎn)調(diào)整功能 29 copyright 2006 pccw solutions ltd. a

15、ll rights reserved. 資產(chǎn)模塊資產(chǎn)模塊-資產(chǎn)報(bào)廢功能資產(chǎn)報(bào)廢功能 30 copyright 2006 pccw solutions ltd. all rights reserved. 單元單元1：財(cái)務(wù)模塊功能概述：財(cái)務(wù)模塊功能概述 單元單元2：應(yīng)付模塊：應(yīng)付模塊 單元單元3：資產(chǎn)模塊：資產(chǎn)模塊 單元單元4：應(yīng)收模塊：應(yīng)收模塊 單元單元5：總帳模塊：總帳模塊 課程安排課程安排 31 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)收模塊與其它模塊的集成關(guān)系應(yīng)收模塊與其它模塊的集成關(guān)系 32 copyright 2

16、006 pccw solutions ltd. all rights reserved. 應(yīng)收模塊功能和流程概覽應(yīng)收模塊功能和流程概覽 收到發(fā)票收到發(fā)票 批發(fā)票批發(fā)票 輸入發(fā)票輸入發(fā)票 收到銀行回單收到銀行回單 或現(xiàn)金或現(xiàn)金 批收款批收款 輸入收款輸入收款 發(fā)票發(fā)票收款收款 核銷(xiāo)核銷(xiāo) 過(guò)帳過(guò)帳 調(diào)整調(diào)整 查詢(xún)查詢(xún) 33 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)收模塊應(yīng)收模塊-客戶(hù)管理功能客戶(hù)管理功能 34 copyright 2006 pccw solutions ltd. all rights reserved. 客戶(hù)

17、組織：hz_parties 客戶(hù)地點(diǎn)：hz_cust_acct_sites_all 客戶(hù)地點(diǎn)用途： hz_cust_site_uses_all 客戶(hù)組織地點(diǎn)：hz_party_sites 客戶(hù)地址：hz_locations 客戶(hù)組織關(guān)系：hz_party_relationships 應(yīng)收模塊應(yīng)收模塊-客戶(hù)常用表客戶(hù)常用表 客戶(hù)：hz_cust_accounts 客戶(hù)角色：hz_cust_account_roles 客戶(hù)組織地點(diǎn)用途： hz_party_site_uses 35 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)收模

18、塊應(yīng)收模塊-客戶(hù)表關(guān)系客戶(hù)表關(guān)系 36 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)收模塊應(yīng)收模塊-發(fā)票（事務(wù)處理）功能發(fā)票（事務(wù)處理）功能 37 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)收事務(wù)處理：ra_customer_trx_all 事務(wù)處理類(lèi)型：ra_cust_trx_types_all 通知單行：ar_memo_lines_all_b 付款計(jì)劃：ar_payment_schedules_all 應(yīng)收事務(wù)處理行接口：ra_interface_l

19、ines_all 應(yīng)收事務(wù)處理分配接口：ra_interface_distributions_all 應(yīng)收模塊應(yīng)收模塊-發(fā)票（事務(wù)處理）常用表發(fā)票（事務(wù)處理）常用表 應(yīng)收事務(wù)處理行：ra_customer_trx_lines_all 應(yīng)收事務(wù)處理分配：ra_cust_trx_line_gl_dist_all 應(yīng)收事務(wù)處理調(diào)整：ar_adjustments_all 38 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)收模塊應(yīng)收模塊-發(fā)票（事務(wù)處理）表關(guān)系發(fā)票（事務(wù)處理）表關(guān)系 39 copyright 2006 pccw sol

20、utions ltd. all rights reserved. 應(yīng)收模塊應(yīng)收模塊-收款功能收款功能 40 copyright 2006 pccw solutions ltd. all rights reserved. 收款：ar_cash_receipts_all 收款與發(fā)票核銷(xiāo)：ar_receivable_applications_all 收款與核銷(xiāo)的會(huì)計(jì)分錄：ar_distributions_all 應(yīng)收款活動(dòng)：ar_receivables_trx_all 收款方法：ar_receipt_methods 應(yīng)收模塊應(yīng)收模塊-收款常用表收款常用表 收款歷史：ar_cash_receipt_h

21、istory_all 雜收分配：ar_misc_cash_distributions_all 41 copyright 2006 pccw solutions ltd. all rights reserved. 應(yīng)收模塊應(yīng)收模塊-收款表關(guān)系收款表關(guān)系 42 copyright 2006 pccw solutions ltd. all rights reserved. 單元單元1：財(cái)務(wù)模塊功能概述：財(cái)務(wù)模塊功能概述 單元單元2：應(yīng)付模塊：應(yīng)付模塊 單元單元3：資產(chǎn)模塊：資產(chǎn)模塊 單元單元4：應(yīng)收模塊：應(yīng)收模塊 單元單元5：總帳模塊：總帳模塊 課程安排課程安排 43 copyright 2006

22、pccw solutions ltd. all rights reserved. 子模塊傳送至總帳的財(cái)務(wù)數(shù)據(jù)子模塊傳送至總帳的財(cái)務(wù)數(shù)據(jù) po arap inv fa gl 應(yīng)計(jì)負(fù)債應(yīng)計(jì)負(fù)債 物料接收物料接收 物料發(fā)運(yùn)物料發(fā)運(yùn) 銷(xiāo)售成本銷(xiāo)售成本 調(diào)整標(biāo)準(zhǔn)成本調(diào)整標(biāo)準(zhǔn)成本 調(diào)整物理庫(kù)存調(diào)整物理庫(kù)存. 費(fèi)用費(fèi)用 負(fù)債負(fù)債 現(xiàn)金支出現(xiàn)金支出 資產(chǎn)成本資產(chǎn)成本 折舊折舊 銷(xiāo)售收入銷(xiāo)售收入 現(xiàn)金收入現(xiàn)金收入 pa 項(xiàng)目支出項(xiàng)目支出 44 copyright 2006 pccw solutions ltd. all rights reserved. 總賬模塊總賬模塊-賬套功能賬套功能 賬套基本表：賬套基本表

23、：gl_sets_of_books 45 copyright 2006 pccw solutions ltd. all rights reserved. 賬套：gl_sets_of_books 值集的值：fnd_flex_values 會(huì)計(jì)科目組合：gl_code_combinations 幣種：fnd_currencies 會(huì)計(jì)期間集：gl_period_sets 會(huì)計(jì)期間：gl_periods 總賬模塊總賬模塊-賬套常用表賬套常用表 會(huì)計(jì)科目彈性域結(jié)構(gòu)：fnd_id_flex_structures 會(huì)計(jì)科目彈性域段：fnd_id_flex_segments 值集：fnd_flex_valu

24、e_sets 會(huì)計(jì)期間狀態(tài)：gl_period_statuses 46 copyright 2006 pccw solutions ltd. all rights reserved. 總賬模塊總賬模塊-賬套表關(guān)系賬套表關(guān)系 47 copyright 2006 pccw solutions ltd. all rights reserved. 總賬模塊總賬模塊-日記賬批功能日記賬批功能 基本表：基本表：gl_je_batches 48 copyright 2006 pccw solutions ltd. all rights reserved. 總賬模塊總賬模塊-日記賬功能日記賬功能 日記賬頭：日

25、記賬頭：gl_je_headers 日記賬行：日記賬行：gl_je_lines 49 copyright 2006 pccw solutions ltd. all rights reserved. 日記賬批：gl_je_batches 日記賬來(lái)源：gl_je_sources_tl 日記賬類(lèi)別：gl_je_categories_tl 日記賬接口：gl_interface 日記賬接口控制：gl_interface_controls 日記賬導(dǎo)入?yún)⒖迹篻l_import_references 總賬模塊總賬模塊-日記賬常用表日記賬常用表 日記賬：gl_je_headers 日記賬行：gl_je_line

26、s 科目組合余額：gl_balances 內(nèi)部往來(lái)事務(wù)處理：gl_iea_transactions 內(nèi)部往來(lái)事務(wù)處理行：gl_iea_transaction_lines 50 copyright 2006 pccw solutions ltd. all rights reserved. 總賬模塊總賬模塊-日記賬表關(guān)系日記賬表關(guān)系 51 copyright 2006 pccw solutions ltd. all rights reserved. 預(yù)算組織：gl_budget_entities 預(yù)算類(lèi)型：gl_budget_types 預(yù)算接口：gl_budget_interface 總賬模塊總

27、賬模塊-預(yù)算常用表預(yù)算常用表 預(yù)算：gl_budgets 預(yù)算版本：gl_budget_versions 預(yù)算分配：gl_budget_assignments 52 copyright 2006 pccw solutions ltd. all rights reserved. 總賬模塊總賬模塊-預(yù)算表關(guān)系預(yù)算表關(guān)系 53 copyright 2006 pccw solutions ltd. all rights reserved. thank you the contents of this presentation are confidential and constitute proper

28、ty of pccw solutions limited. it is provided for your exclusive use on the basis that it will be held in complete confidence and is used solely for the purpose of informing you on the subject of this presentation. you acknolwedge and agree that pccw solutions limited retains all intellectual property now or hereinafter subsiting in the presentation 54 copyright 2006 pccw solutions ltd. all rights reserved. majpjmvcyzj21hlfrvy96dv02lppfygxus7iymzkyemz0kgeyz