【文档说明】EBS财务模块基本功能和常用表.pptx，共(53)页，1.152 MB，由精品优选上传

转载请保留链接：https://www.ichengzhen.cn/view-261432.html

以下为本文档部分文字说明：

1Copyright2006PCCWSolutionsLtd.Allrightsreserved.OracleEBSTraining财务模块基本功能和相关表介绍PCCWConsultantPCCWSolution

s2008-07-292Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪单元1：财务模块功能概述▪单元2：应付模块▪单元3：资产模块▪单元4：应收模块▪单元5：总帐模块课程安排3Copyright2006PCCWSolutionsLtd.Al

lrightsreserved.▪单元1：财务模块功能概述▪单元2：应付模块▪单元3：资产模块▪单元4：应收模块▪单元5：总帐模块课程安排4Copyright2006PCCWSolutionsLtd.Allrightsreserved

.Oracle财务系统:综合数据流程5Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪单元1：财务模块功能概述▪单元2：应付模块▪单元3：资产模块▪单元4：应收模

块▪单元5：总帐模块课程安排6Copyright2006PCCWSolutionsLtd.Allrightsreserved.应付模块与其它模块的集成关系Oracle应付款管理Oracle人力资源会计分录Orac

le采购管理采购订单供应商Oracle库存管理资产采购发票Oracle资产管理职员计量单位库存项目Oracle总帐管理7Copyright2006PCCWSolutionsLtd.Allrightsreserved.应付模块功能和流程概览查询发票收到发票

修改发票发票批输入发票发票三项匹配复核发票过帐付款采购定单接收单8Copyright2006PCCWSolutionsLtd.Allrightsreserved.应付模块-发票功能9Copyright2006PCCWSolutionsLtd.Allrightsrese

rved.应付模块-发票常用表▪发票批：AP_BATCHES_ALL▪发票头：AP_INVOICES_ALL▪发票分配：AP_INVOICE_DISTRIBUTIONS_ALL▪付款计划：AP_PAYMENT_SC

HEDULES_ALL▪会计分录事件：AP_ACCOUNTING_EVENTS_ALL▪会计分录头：AP_AE_HEADERS_ALL▪会计分录行：AP_AE_LINES_ALL▪发票开发接口表(头)：AP_INVOICES_INTERFACE▪发票开发接口表(行)

：AP_INVOICE_LINES_INTERFACE10Copyright2006PCCWSolutionsLtd.Allrightsreserved.应付模块-发票表关系11Copyright2006PCCWSolutionsLtd.Allrightsreserved.应付模块-付款功能

12Copyright2006PCCWSolutionsLtd.Allrightsreserved.应付模块-付款常用表▪付款批：AP_INV_SELECTION_CRITERIA_ALL▪付款：AP_CHECKS_ALL▪付款与发票

对应：AP_INVOICE_PAYMENTS_ALL▪付款单据：AP_CHECK_STOCKS_ALL▪付款格式：AP_CHECK_FORMATS▪银行：AP_BANK_BRANCHES▪银行帐户：AP_BANK_ACCOUNTS_ALL13Copyright2

006PCCWSolutionsLtd.Allrightsreserved.应付模块-付款相关表14Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪单元1：财

务模块功能概述▪单元2：应付模块▪单元3：资产模块▪单元4：应收模块▪单元5：总帐模块课程安排15Copyright2006PCCWSolutionsLtd.Allrightsreserved.资产模块与其它模块的集成关系Oracle应付款管理Oracle人力资源会计分录Ora

cle应付款管理供应商信息Oracle库存管理资产采购发票Oracle总帐管理Oracle资产管理系统Employees计量单位库存项目16Copyright2006PCCWSolutionsLtd.A

llrightsreserved.资产模块功能和流程概览17Copyright2006PCCWSolutionsLtd.Allrightsreserved.资产模块-资产账簿功能基本表:FA_BOOK_CONTROLS18Copyright2006PCCWSolutions

Ltd.Allrightsreserved.▪资产系统控制：FA_SYSTEM_CONTROLS▪资产账簿：FA_BOOK_CONTROLS▪资产类别：FA_CATEGORIES_B▪资产类别描述：FA_CATEGORIES_TL▪资产类别帐

户：FA_CATEGORY_BOOKS▪资产类别默认规则：FA_CATEGORY_BOOK_DEFAULTS资产模块-资产账簿和资产类别常用表19Copyright2006PCCWSolutionsLt

d.Allrightsreserved.资产模块-资产账簿和资产类别相关表20Copyright2006PCCWSolutionsLtd.Allrightsreserved.资产模块-资产类别功能类别头:FA_CATEGORIES_

B(基表)FA_CATEGORIES_TL(多语言)类别分配：FA_CATEGORY_BOOK_DEFAULTS21Copyright2006PCCWSolutionsLtd.Allrightsreserved.资产模块-资产

增加功能1.基本信息：FA_ADDITIONS_B，FA_ADDITIONS_TL(多语言)2.财务信息：FA_BOOKS3.分配：FA_DISTRIBUTION_HISTORY12322Copyright2006PCCWSolution

sLtd.Allrightsreserved.▪资产成批增加：FA_MASS_ADDITIONS▪资产成批增加分配：FA_MASSADD_DISTRIBUTIONS▪资产基础信息：FA_ADDITIONS_B▪资产财务信息：FA_BOOKS▪资产历史：FA_ASSET_H

ISTORY▪资产分配：FA_DISTRIBUTION_HISTORY资产模块-资产增加常用表▪资产来源：FA_ASSET_INVOICES▪资产事务处理：FA_TRANSACTION_HEADERS▪资产事务处理分录：FA_ADJUSTMENTS▪资产地点：FA_LOCA

TIONS23Copyright2006PCCWSolutionsLtd.Allrightsreserved.资产模块-资产增加表关系24Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪折旧期间：FA_DEPRN_PERIO

DS▪资产折旧汇总：FA_DEPRN_SUMMARY▪资产折旧明细：FA_DEPRN_DETAIL▪资产减值准备：FA_IMPAIRMENTS▪资产报废：FA_RETIREMENTS▪资产分配帐户：FA_DISTRIBUTION_ACCOUNTS资产模块-折旧与报废

常用表▪折旧方法：FA_METHODS▪按比例分摊惯例：FA_CONVERSIONS25Copyright2006PCCWSolutionsLtd.Allrightsreserved.资产模块-折旧表关系26Copyright2006PCCWSolutionsLtd.

Allrightsreserved.资产模块-资产转移功能27Copyright2006PCCWSolutionsLtd.Allrightsreserved.FA_DISTRIBUTION_HISTORY#×DISTRIBUTION_IDGL

_CODE_COMBINATIONS#×CODE_COMBINATION_IDFA_LOCATIONS#×LOCATION_IDFA_TRANSACTION_HEADERS#×TRANSACTION_ID资产模块-资产转移常用表及关系FA_EMPLOYEES#×EMPLOY

EE_ID28Copyright2006PCCWSolutionsLtd.Allrightsreserved.资产模块-资产调整功能29Copyright2006PCCWSolutionsLtd.Allrigh

tsreserved.资产模块-资产报废功能30Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪单元1：财务模块功能概述▪单元2：应付模块▪单元3：资产模块▪单元4：应收模块▪单元5：总帐模块课程安排31Copyrigh

t2006PCCWSolutionsLtd.Allrightsreserved.Oracle总帐管理Oracle库存管理Oracle订单管理•收款•调整•销售订单•退货订单•库存发货•退货接收•成本•库存Oracle应收款管理应收模块与其它模块的集成关系32Copyright200

6PCCWSolutionsLtd.Allrightsreserved.应收模块功能和流程概览收到发票批发票输入发票收到银行回单或现金批收款输入收款发票收款核销过帐调整查询33Copyright2006PC

CWSolutionsLtd.Allrightsreserved.应收模块-客户管理功能34Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪客户组织：HZ_PARTIES▪客户地点：HZ_CUST_ACCT_SITES_ALL▪客户地点

用途：HZ_CUST_SITE_USES_ALL▪客户组织地点：HZ_PARTY_SITES▪客户地址：HZ_LOCATIONS▪客户组织关系：HZ_PARTY_RELATIONSHIPS应收模块-客户常用表▪客户：

HZ_CUST_ACCOUNTS▪客户角色：HZ_CUST_ACCOUNT_ROLES▪客户组织地点用途：HZ_PARTY_SITE_USES35Copyright2006PCCWSolutionsLtd.Allrightsreserved.应收模块-客户表关系36

Copyright2006PCCWSolutionsLtd.Allrightsreserved.应收模块-发票（事务处理）功能37Copyright2006PCCWSolutionsLtd.Allrightsreser

ved.▪应收事务处理：RA_CUSTOMER_TRX_ALL▪事务处理类型：RA_CUST_TRX_TYPES_ALL▪通知单行：AR_MEMO_LINES_ALL_B▪付款计划：AR_PAYMENT_SCHEDULES_ALL▪应收事务处理行接口：RA_INTER

FACE_LINES_ALL▪应收事务处理分配接口：RA_INTERFACE_DISTRIBUTIONS_ALL应收模块-发票（事务处理）常用表▪应收事务处理行：RA_CUSTOMER_TRX_LINES_ALL▪应收事务处理分配：RA_CUST_TRX

_LINE_GL_DIST_ALL▪应收事务处理调整：AR_ADJUSTMENTS_ALL38Copyright2006PCCWSolutionsLtd.Allrightsreserved.应收模块-发票（事务处理）表关

系39Copyright2006PCCWSolutionsLtd.Allrightsreserved.应收模块-收款功能40Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪收款：AR_CASH_RECEIPTS_AL

L▪收款与发票核销：AR_RECEIVABLE_APPLICATIONS_ALL▪收款与核销的会计分录：AR_DISTRIBUTIONS_ALL▪应收款活动：AR_RECEIVABLES_TRX_ALL▪收款方法：AR_RECEIPT_METHODS应收模块-收款常用表▪收款历史：AR

_CASH_RECEIPT_HISTORY_ALL▪杂收分配：AR_MISC_CASH_DISTRIBUTIONS_ALL41Copyright2006PCCWSolutionsLtd.Allrightsr

eserved.应收模块-收款表关系42Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪单元1：财务模块功能概述▪单元2：应付模块▪单元3：资产模块▪单元4：应收模块▪单元5：总帐模块课程安排43Cop

yright2006PCCWSolutionsLtd.Allrightsreserved.子模块传送至总帐的财务数据POARAPINVFAGL应计负债物料接收物料发运销售成本调整标准成本调整物理库存.费用负债现金支出资产成本折旧销售收入现金收入PA项目支出44Cop

yright2006PCCWSolutionsLtd.Allrightsreserved.总账模块-账套功能账套基本表：GL_SETS_OF_BOOKS45Copyright2006PCCWSolutionsLtd.Allr

ightsreserved.▪账套：GL_SETS_OF_BOOKS▪值集的值：FND_FLEX_VALUES▪会计科目组合：GL_CODE_COMBINATIONS▪币种：FND_CURRENCIES▪会计期间集：GL_PERIOD_SETS▪会计期间：GL_PERIOD

S总账模块-账套常用表▪会计科目弹性域结构：FND_ID_FLEX_STRUCTURES▪会计科目弹性域段：FND_ID_FLEX_SEGMENTS▪值集：FND_FLEX_VALUE_SETS▪会计期间状态：GL_PE

RIOD_STATUSES46Copyright2006PCCWSolutionsLtd.Allrightsreserved.总账模块-账套表关系47Copyright2006PCCWSolutionsLtd.Allrigh

tsreserved.总账模块-日记账批功能基本表：GL_JE_BATCHES48Copyright2006PCCWSolutionsLtd.Allrightsreserved.总账模块-日记账功能日记账头：GL_

JE_HEADERS日记账行：GL_JE_LINES49Copyright2006PCCWSolutionsLtd.Allrightsreserved.▪日记账批：GL_JE_BATCHES▪日记账来源：GL

_JE_SOURCES_TL▪日记账类别：GL_JE_CATEGORIES_TL▪日记账接口：GL_INTERFACE▪日记账接口控制：GL_INTERFACE_CONTROLS▪日记账导入参考：GL_IMPORT_REFER

ENCES总账模块-日记账常用表▪日记账：GL_JE_HEADERS▪日记账行：GL_JE_LINES▪科目组合余额：GL_BALANCES▪内部往来事务处理：GL_IEA_TRANSACTIONS▪内部往来事务处理行：GL_IEA_TRANSACTION_LINES50Co

pyright2006PCCWSolutionsLtd.Allrightsreserved.总账模块-日记账表关系51Copyright2006PCCWSolutionsLtd.Allrightsres

erved.▪预算组织：GL_BUDGET_ENTITIES▪预算类型：GL_BUDGET_TYPES▪预算接口：GL_BUDGET_INTERFACE总账模块-预算常用表▪预算：GL_BUDGETS▪预算版本：GL_BUDGET_VERSIONS▪预算分配：GL_BUDGET_ASSIG

NMENTS52Copyright2006PCCWSolutionsLtd.Allrightsreserved.总账模块-预算表关系53Copyright2006PCCWSolutionsLtd.Allrightsreserved.ThankYouThecontentsofth

isPresentationareconfidentialandconstitutepropertyofPCCWSolutionsLimited.Itisprovidedforyourexclusiveuseonthebasisthatitwillbeheld

incompleteconfidenceandisusedsolelyforthepurposeofinformingyouonthesubjectofthisPresentation.YouacknolwedgeandagreethatPCCWSolutions

LimitedretainsallintellectualpropertynoworhereinaftersubsitinginthePresentation