Oracle EBS R12 常用表表结构总结之AR应收模块
AR应收
应收事务处理相关表
SELECT*FROMar.ar_batches_all;--事务处理批SELECT*FROMar.ra_customer_trx_all;--应收事务头/发票头
SELECT*FROMra.ra_customer_trx_lines_all;--应收事务行项目/发票行
SELECT*FROMra.ra_cust_trx_line_gl_dist_all;--应收事务分配行/发票分配
SELECT*FROMar.ar_payment_schedules_all;--收款计划/发票调整收款相关表
SELECT*FROMar.ar_cash_receipts_all;--收款表SELECT*FROMar.ar_cash_receipt_history_all;--收款历史表
SELECT*FROMar.ar_distributions_all;--收款分配表/付款计划
SELECT*FROMar.ar_misc_cash_distributions_all;--杂项历史记录分配表
SELECT*FROMar.ar_receivable_applications_all;--收款核销表
Subledgeraccounting子分类账
SELECT*FROMar_adjustments_all;--会计分录
SELECT*FROMxla.xla_events;--会计事件表
SELECT*FROMxla.xla_transaction_entites;--事务处理表SELECT*FROMxla.xla_ae_headers;--子分类帐日记账头SELECT*FROMxla.xla_ae_lines;--子分类帐日记账行SELECT*FROMxla.xla_distributions_link;--子分类帐日记帐行关联表
SELECT*FROMxla.xla_events_error;--会计事件错误提示表
接口相关表应收临时表
SELECT*FROMar.ra_interface_lines_all;--应收接口行表
SELECT*FROMar.ra_interface_distributions_all;--应收接口分配行表
接口相关表收款临时表
SELECT*FROMar.ar_interim_cash_receipts_all;--收款标准接口
主数据相关表/视图
SELECT*FROMapps.po_vendors;--客户
SELECT*FROMapps.po_vendor_sites_all;--客户地点SELECT*FROMap.ap_bank_branches_all;--银行SELECT*FROMap.ap_bank_accounts_all;--银行账户SELECT*FROMap.ap_bank_account_uses_all;--银行账户使用表SELECT*FROMapps.gl_period_statuses_v;--期间,取期间视图SELECT*FROMapps.hr_operating_units;--业务实体视图税相关表
SELECT*FROMzx_lines_det_factors;--税决定因素表SELECT*FROMzx_lines;--税行注:应收模块税仅含这个表。
ra_customer_trx_all应收发票
发票编号:customer_trx_id
客户收单方编号:bill_to_site_use_id销售员编号:primary_sales_id
reference是Oracle提供的外部编号输入框,但是由于版本问题和长度(
扩展阅读:oracle ebs常用表结构及分类模块
Oracleapplication表结构":[{"c":{"ix":0,"iy":0,"iw":596,"ih":359},"p":{"h":359,"opacity":1,"rotate":0,"w":670.5,"x":69.449,"x0":69.449,"x1":69.449,"x2":739.95,"x3":739.95,"y":47.174,"y0":451.049,"y1":47.174,"y2":47.174,"y3":451.049,"z":0},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//171343276//171343276_2_0.jpg"},"t":"pic"},{"c":{"ix":0,"iy":364,"iw":592,"ih":358},"p":{"h":358,"opacity":1,"rotate":0,"w":666,"x":69.449,"x0":69.449,"x1":69.449,"x2":735.45,"x3":735.45,"y":460.949,"y0":863.849,"y1":460.949,"y2":460.949,"y3":863.849,"z":1},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//171343276//171343276_2_1.jpg"},"t":"pic"}],"page":{"ph":1262.879,"pw":892.979,"iw":596,"ih":722,"v":6,"t":"1","pptlike":false,"cx":69.449,"cy":47.174,"cw":670.5,"ch":816.675}})":[{"c":{"ix":0,"iy":0,"iw":638,"ih":346},"p":{"h":346,"opacity":1,"rotate":0,"w":717.9,"x":69.449,"x0":69.449,"x1":69.449,"x2":787.35,"x3":787.35,"y":43.574,"y0":432.9,"y1":43.574,"y2":43.574,"y3":432.9,"z":0},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//171343276//171343276_3_0.jpg"},"t":"pic"},{"c":{"ix":0,"iy":351,"iw":654,"ih":352},"p":{"h":352,"opacity":1,"rotate":0,"w":735.9,"x":69.449,"x0":69.449,"x1":69.449,"x2":805.35,"x3":805.35,"y":442.649,"y0":838.649,"y1":442.649,"y2":442.649,"y3":838.649,"z":1},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//171343276//171343276_3_1.jpg"},"t":"pic"}],"page":{"ph":1262.879,"pw":892.979,"iw":654,"ih":703,"v":6,"t":"1","pptlike":false,"cx":69.449,"cy":43.574,"cw":735.9,"ch":795.075}})":[{"c":{"ix":0,"iy":0,"iw":572,"ih":412},"p":{"h":412,"opacity":1,"rotate":0,"w":643.5,"x":69.449,"x0":69.449,"x1":69.449,"x2":712.95,"x3":712.95,"y":50.024,"y0":513.524,"y1":50.024,"y2":50.024,"y3":513.524,"z":0},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//171343276//171343276_4_0.jpg"},"t":"pic"},{"c":{"ix":0,"iy":417,"iw":588,"ih":419},"p":{"h":419,"opacity":1,"rotate":0,"w":661.5,"x":69.449,"x0":69.449,"x1":69.449,"x2":730.95,"x3":730.95,"y":524.699,"y0":996.149,"y1":524.699,"y2":524.699,"y3":996.149,"z":1},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//171343276//171343276_4_1.jpg"},"t":"pic"}],"page":{"ph":1262.879,"pw":892.979,"iw":588,"ih":836,"v":6,"t":"1","pptlike":false,"cx":69.449,"cy":50.024,"cw":661.5,"ch":946.125}})":[{"c":{"ix":0,"iy":0,"iw":636,"ih":442},"p":{"h":442,"opacity":1,"rotate":0,"w":715.5,"x":69.449,"x0":69.449,"x1":69.449,"x2":784.95,"x3":784.95,"y":43.949,"y0":541.274,"y1":43.949,"y2":43.949,"y3":541.274,"z":0},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//171343276//171343276_5_0.jpg"},"t":"pic"},{"c":{"ix":0,"iy":447,"iw":601,"ih":450},"p":{"h":450,"opacity":1,"rotate":0,"w":676.125,"x":69.449,"x0":69.449,"x1":69.449,"x2":745.575,"x3":745.575,"y":550.649,"y0":1056.975,"y1":550.649,"y2":550.649,"y3":1056.975,"z":1},"ps":null,"s":{"pic_file":"/home/iknow/conv//data//bdef//171343276//171343276_5_1.jpg"},"t":"pic"}],"page":{"ph":1262.879,"pw":892.979,"iw":636,"ih":897,"v":6,"t":"1","pptlike":false,"cx":69.449,"cy":43.949,"cw":715.5,"ch":1013.025}})
表结构,WHO字段来实现
通过菜单HELP下的HISTORY来找表2.通过LAST_QUERY来判断所使用的表
LAST_QUERY是系统变量保存所执行的最后一次的SQL语句BLOCK一定选SYSTEM作为一个虚拟的BLOCK
用HELP菜单下面的EXAMING子菜单3.用TRACE的办法来实现找表4.查看源代码来找表
基本表结构
库存模块INV表结构,主要是物料的保存和搬运
组织:分为库存组织和经营单位对于来说首先定义成一个经营单位,主要是进行业务核算的基本单位,是经营单位每一个生产单位作为一个库存组织,库存组织不作为核算单位组织表是HR_ORGANIZATION_UNITS存放所有的组织
ORG_ID表示的经营单位ORGANIZATION_ID表示库存组织
通过制造物料参数表MTL_PARAMETERS来查看库存组织ID
MTL_SYSTEM_ITEM物料信息
原材料仓库,半成品仓库,成品仓库
子库存属于库存组织的一个结构,子库存下面还可以有一个叫库位的结构
物料的位置由:库存组织+子库存+库位
子库存放置在MTL_SECONDARY_INVENTORIES表中货位信息放置在MTL_ITEM_LOCATIONS表中
在MTL_ITEM_LOCATIONS中的SEGMENT1存放其库位名称
MTL_ONHAND_QUANTITIES表存放物料的现有量表其中LOCATION_ID表示库位信息
MTL_SYSTEM_ITEMS表存放所有库存组织,所有物料
MTL_MATERIAL_TRANSACTIONS物料事务处发表(存放物料的进货销售)TRANSACTION_IDINVENTORY_ID表示操作的物料ID
TRANSACTION_QUANTITY表示货物的数量正数为搬进负数为搬出PRIMARY_QUANTITY表示主计量单位TRANSACTION_COST表示物料的成本ACTUAL_COST表示通过算法得到的物料成本ITEM_MASTER物料主表PRIMAR_UNIT_OF_MEASURE表示主计量单位MTL_CATEGORY_SET表表示产品分类级MTL_CATAGROYS
PO采购模块从供应商订购和接收货物先请购-采购单-接收货物
请购单头表PO_REQUISITION_HEADERS_ALLORG_ID为经营组织单位
行表PO_REQUISITION_LINES_ALL其中DESTINATION_ORGANIZATION_ID库存组织ID表后带ALL表示支持多组织的表,否则为单组织
有一些环境变量在运行环境下才有值,导致有一些表不能查找到数据
采购单PO_HEADERS_ALLVENDOR_ID供应商ID表示我向那个供应商采购的信息
PO_VENDORS为供应商基表PO_LINES_ALLpo_LINE_ID主键
QUANTITY表示数量UNIT_PRICE为准确价格ORG_ID表示经营单位的采购订单
采购接收
RCV_TRANSACTIONS表接收的数据事务
关心TRANSACTION_TYPE和DESTINATION_TYPE_CODE字段接收和退回都要考虑接收后会影响库存
OM销售模块怎么做销售定单,非常复杂从OE出来的核心是销售订单
挑库---〉物料搬运单〉发运SO_HEADERS_ALL表已经不用
客户信息存放在表RA_CUSTOMERS其中RA_ADDRESS表示客户地址RA_ADDRESSES_ALL
RA_SITE_USES_ALL表表示货品抵达如果是BILL_TO表示可以开票SHIP_TO表示发货销售订单表OE_ORDER_HEADERS_ALL
SOLD_TO_ORG_ID对应的是客户表的RA_CUSTOMERS的字段CUSTOMER_ID
SHIP_TO_ORG_ID对应RA_SET_USES_ALL的SHIP_TOINVOICE_TO_ORG_ID对应RA_SET_USES_ALL的BILL_TO
销售订单行表OE_ORDER_LINES_ALL
BOM物料清单
BOM_BILL_OF_MATERIALS表主建是BILL_SEQUENCE_IDORGANIZATION_ID库存组织
ASSEMBLY_ITEM_ID装配件ID(可以查系统物料表得到信息)BILL_SEQUENCE_ID内部号码适应一个装配件多个BOMBOM_INVENTORY_COMPONENTS
BOM_OPERATIONAL_ROUTING工艺路线表BOM_STANDARD_OPERATIONS
WIP(WORKINPROCESS)在制品依靠BOM模块
关心JOB状态,JOB的信息
WIP_ENTITIES表里的PRIMARY_ITEM_ID为此JOB生产的东西
WIP_ENTITY_NAMEJOB的名字
WIP_DISCREATE_JOBS所有离散任务DATE_RELEASED释放日期DATE_CLOSE关闭日期
SCHEDUAL_COMPLETION_DATE完成日期
WIP_MOVE_TRANSACTIONS表示生产过程中的工序的移动怎么处理返工,怎么处理报废
在一个个工序中分为几个工布有排队、报废、和
WIP发放装配件完工入库产品退回WIPWIP退回到库存
GL总帐
凭证:凭证批、凭证头、平整行GL_JE_BATCHES
凭证日期----DEFAULT_EFFECTIVE_DATE会计期间----DEFAULT_PERIOD_NAME
SET_OF_BOOKS_ID帐套ID镯
GL_JE_HEADERS批号:JE_BATCH_ID会计期间:PERIOD_NAME凭证类型:JE_CATEGORY凭证来源:JE_SOURCE帐套:SET_OF_BOOKS_IDCODINAE_COMBINATION_IDGL_JE_LINESGL_SET_OF_BOOKSGL_CODE_COMBINATIONS表保存会计科目GL_BALANCES总账余额表
AR应收
应收发票表示RA_CUSTOMER_TRX_ALLCUSTOMER_TRX_ID发票编号
RA_CUSTOMER_TRX_LINES_ALL
发票行一般有两种类型ITEM和TAX
收款情况表AR_CASH_RECEIPTS_ALL(包含非收款信息)
核销关系表AR_RECEIVABLE_APPLICATIONS_ALL
AP应付
应付发票表AP_INVOICES_ALL
实际付款表AP_CHECKS_ALL
AP_INVOICE_PAYMENTS
FA固定资产
资产信息表FA_ADDITIONS
资产类别FA_CATEGORIES资产帐薄FA_BOOK_CONTROLS
CURRENT_UNITS资产的数量FA_BOOKS
折旧一般有直线法和产量法
FA_DISTRIBUTION_HISTORY资产分配信息,给部门使用多少FA_DEPRN_DETAIL折旧信息表FA_TRANSCATION_HEADERS折旧事务表主要报表库存收发存报表不采购订单表接收情况表销售订单表生产任务情况表嫂返工率分析表供应商对帐单
采购接受事务RCV_TRANSACTIONSPO_HEADERS_ALLPO_LINES_ALLMTL_SYSTEM_ITEMSHR_ORGANIZATION_UNITSMTL_SECONDARY_INVENTORIESMTL_ITEM_LOCATIONS日期:
事物日期RCV_TRANSACTIONS中的TRANSACTION_DATE
类型:即RCV_TRANSACTIONS中的TRANSACTION_TYPE接收目的:物料名称:单位:
即RCV_TRANSACTIONS中的DESTINATION_TYPE_CODE相关定单行指定的物料名称
是RCV_TRANSACTIONS中的PRIMARY_UNIT_OF_MEASURE
库存组织:是RCV_TRANSACTIONS中的ORGANIZATION_ID,其对应HR_ORGANIZATION_UNITS里的NAME
子库存:库位:SEGEMENT1
数量:
RCV_TRANSACTIONS中的primary_QUANTITY
RCV_TRANSACTIONS中的PO_HEADER_ID指定的定单的号
RCV_TRANSACTIONS中的SUBINVENTORY_CODE
RCV_TRANSACTIONS中的LOCATOR_ID指定库位ID,在MTL_ITEM_LOCATIONS中的
定单号:定单行号:
RCV_TRANSACTIONS中的PO_LINE_ID指定的定单行号
物料库存现有量MTL_ONHAND_QUANTITIESMTL_SYSTEM_ITEMSHR_ORGANIZATIONS
MTL_SECONDARY_INVENTORIESMTL_ITEM_LOCATIONS
物料:即物料名称MTL_SYSTEM_ITEMS中的SEGEMENT1
单位:主计量单位MTL_SYSTEM_ITEMS中的PRIMARY_UNIT_OF_MEASURE库存组织:HR_ORGANIZATION_UNITS
子库存:子库存编码,MTL_SECONDARY_INVENTORIES中的SUBINVENTORY_CODE库位:库位编码,MTL_ITEM_LOCATIONS中的SEGEMENT1
总帐凭证
GL_JE_HEADERSGL_JE_LINES
GL_CODE_COMBINATIONS_KFVGL_SETS_OF_BOOKS
凭证名:凭证名称,GL_JE_HEADERS中的NAME
日期:凭证日期,GL_JE_HEADERS中的DEFAULT_EFFECTIVE_DATE
过帐状态:当GL_JE_HEADERS中的STATUS为P的时候表示”已过帐”,为U的时候表示”未过帐”币种:GL_JE_HEADERS中的CURRENCY_CODE
科目:GL_CODE_COMBINATIONS_KFV中的CONCATENATED_SEGEMENTS借方金额:GL_JE_LINES中的ENTERED_DR贷方金额:GL_JE_LINES中的ENTERED_CR说明:GL_JE_LINES中的DESCRIPTION
帐套:GL_SETS_OF_BOOKS中的NAME,SET_OF_BOOKS_ID限定凭证
友情提示:本文中关于《Oracle EBS R12 常用表表结构总结之AR应收模块》给出的范例仅供您参考拓展思维使用,Oracle EBS R12 常用表表结构总结之AR应收模块:该篇文章建议您自主创作。
来源:网络整理 免责声明:本文仅限学习分享,如产生版权问题,请联系我们及时删除。