Oracle EBS R12 常用表表結(jié)構(gòu)總結(jié)之AR應(yīng)收模塊

AR應(yīng)收

應(yīng)收事務(wù)處理相關(guān)表

SELECT*FROMar.ar_batches_all;--事務(wù)處理批SELECT*FROMar.ra_customer_trx_all;--應(yīng)收事務(wù)頭/發(fā)票頭

SELECT*FROMra.ra_customer_trx_lines_all;--應(yīng)收事務(wù)行項目/發(fā)票行

SELECT*FROMra.ra_cust_trx_line_gl_dist_all;--應(yīng)收事務(wù)分配行/發(fā)票分配

SELECT*FROMar.ar_payment_schedules_all;--收款計劃/發(fā)票調(diào)整收款相關(guān)表

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;--事務(wù)處理表SELECT*FROMxla.xla_ae_headers;--子分類帳日記賬頭SELECT*FROMxla.xla_ae_lines;--子分類帳日記賬行SELECT*FROMxla.xla_distributions_link;--子分類帳日記帳行關(guān)聯(lián)表

SELECT*FROMxla.xla_events_error;--會計事件錯誤提示表

接口相關(guān)表應(yīng)收臨時表

SELECT*FROMar.ra_interface_lines_all;--應(yīng)收接口行表

SELECT*FROMar.ra_interface_distributions_all;--應(yīng)收接口分配行表

接口相關(guān)表收款臨時表

SELECT*FROMar.ar_interim_cash_receipts_all;--收款標(biāo)準(zhǔn)接口

主數(shù)據(jù)相關(guān)表/視圖

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;--業(yè)務(wù)實體視圖稅相關(guān)表

SELECT*FROMzx_lines_det_factors;--稅決定因素表SELECT*FROMzx_lines;--稅行注：應(yīng)收模塊稅僅含這個表。

ra_customer_trx_all應(yīng)收發(fā)票

發(fā)票編號：customer_trx_id

客戶收單方編號：bill_to_site_use_id銷售員編號：primary_sales_id

reference是Oracle提供的外部編號輸入框，但是由于版本問題和長度(

擴展閱讀：oracle ebs常用表結(jié)構(gòu)及分類模塊

Oracleapplication表結(jié)構(gòu)":[{"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}})

表結(jié)構(gòu)，WHO字段來實現(xiàn)

通過菜單HELP下的HISTORY來找表2.通過LAST_QUERY來判斷所使用的表

LAST_QUERY是系統(tǒng)變量保存所執(zhí)行的最后一次的SQL語句BLOCK一定選SYSTEM作為一個虛擬的BLOCK

用HELP菜單下面的EXAMING子菜單3.用TRACE的辦法來實現(xiàn)找表4.查看源代碼來找表

基本表結(jié)構(gòu)

庫存模塊INV表結(jié)構(gòu)，主要是物料的保存和搬運

組織：分為庫存組織和經(jīng)營單位對于來說首先定義成一個經(jīng)營單位，主要是進行業(yè)務(wù)核算的基本單位，是經(jīng)營單位每一個生產(chǎn)單位作為一個庫存組織，庫存組織不作為核算單位組織表是HR_ORGANIZATION_UNITS存放所有的組織

ORG_ID表示的經(jīng)營單位ORGANIZATION_ID表示庫存組織

通過制造物料參數(shù)表MTL_PARAMETERS來查看庫存組織ID

MTL_SYSTEM_ITEM物料信息

原材料倉庫，半成品倉庫，成品倉庫

子庫存屬于庫存組織的一個結(jié)構(gòu)，子庫存下面還可以有一個叫庫位的結(jié)構(gòu)

物料的位置由：庫存組織+子庫存+庫位

子庫存放置在MTL_SECONDARY_INVENTORIES表中貨位信息放置在MTL_ITEM_LOCATIONS表中

在MTL_ITEM_LOCATIONS中的SEGMENT1存放其庫位名稱

MTL_ONHAND_QUANTITIES表存放物料的現(xiàn)有量表其中LOCATION_ID表示庫位信息

MTL_SYSTEM_ITEMS表存放所有庫存組織，所有物料

MTL_MATERIAL_TRANSACTIONS物料事務(wù)處發(fā)表（存放物料的進貨銷售）TRANSACTION_IDINVENTORY_ID表示操作的物料ID

TRANSACTION_QUANTITY表示貨物的數(shù)量正數(shù)為搬進負數(shù)為搬出PRIMARY_QUANTITY表示主計量單位TRANSACTION_COST表示物料的成本ACTUAL_COST表示通過算法得到的物料成本ITEM_MASTER物料主表PRIMAR_UNIT_OF_MEASURE表示主計量單位MTL_CATEGORY_SET表表示產(chǎn)品分類級MTL_CATAGROYS

PO采購模塊從供應(yīng)商訂購和接收貨物先請購-采購單-接收貨物

請購單頭表PO_REQUISITION_HEADERS_ALLORG_ID為經(jīng)營組織單位

行表PO_REQUISITION_LINES_ALL其中DESTINATION_ORGANIZATION_ID庫存組織ID表后帶ALL表示支持多組織的表，否則為單組織

有一些環(huán)境變量在運行環(huán)境下才有值，導(dǎo)致有一些表不能查找到數(shù)據(jù)

采購單PO_HEADERS_ALLVENDOR_ID供應(yīng)商ID表示我向那個供應(yīng)商采購的信息

PO_VENDORS為供應(yīng)商基表PO_LINES_ALLpo_LINE_ID主鍵

QUANTITY表示數(shù)量UNIT_PRICE為準(zhǔn)確價格ORG_ID表示經(jīng)營單位的采購訂單

采購接收

RCV_TRANSACTIONS表接收的數(shù)據(jù)事務(wù)

關(guān)心TRANSACTION_TYPE和DESTINATION_TYPE_CODE字段接收和退回都要考慮接收后會影響庫存

OM銷售模塊怎么做銷售定單，非常復(fù)雜從OE出來的核心是銷售訂單

挑庫---〉物料搬運單〉發(fā)運SO_HEADERS_ALL表已經(jīng)不用

客戶信息存放在表RA_CUSTOMERS其中RA_ADDRESS表示客戶地址RA_ADDRESSES_ALL

RA_SITE_USES_ALL表表示貨品抵達如果是BILL_TO表示可以開票SHIP_TO表示發(fā)貨銷售訂單表OE_ORDER_HEADERS_ALL

SOLD_TO_ORG_ID對應(yīng)的是客戶表的RA_CUSTOMERS的字段CUSTOMER_ID

SHIP_TO_ORG_ID對應(yīng)RA_SET_USES_ALL的SHIP_TOINVOICE_TO_ORG_ID對應(yīng)RA_SET_USES_ALL的BILL_TO

銷售訂單行表OE_ORDER_LINES_ALL

BOM物料清單

BOM_BILL_OF_MATERIALS表主建是BILL_SEQUENCE_IDORGANIZATION_ID庫存組織

ASSEMBLY_ITEM_ID裝配件ID(可以查系統(tǒng)物料表得到信息)BILL_SEQUENCE_ID內(nèi)部號碼適應(yīng)一個裝配件多個BOMBOM_INVENTORY_COMPONENTS

BOM_OPERATIONAL_ROUTING工藝路線表BOM_STANDARD_OPERATIONS

WIP（WORKINPROCESS）在制品依靠BOM模塊

關(guān)心JOB狀態(tài)，JOB的信息

WIP_ENTITIES表里的PRIMARY_ITEM_ID為此JOB生產(chǎn)的東西

WIP_ENTITY_NAMEJOB的名字

WIP_DISCREATE_JOBS所有離散任務(wù)DATE_RELEASED釋放日期DATE_CLOSE關(guān)閉日期

SCHEDUAL_COMPLETION_DATE完成日期

WIP_MOVE_TRANSACTIONS表示生產(chǎn)過程中的工序的移動怎么處理返工，怎么處理報廢

在一個個工序中分為幾個工布有排隊、報廢、和

WIP發(fā)放裝配件完工入庫產(chǎn)品退回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應(yīng)收

應(yīng)收發(fā)票表示RA_CUSTOMER_TRX_ALLCUSTOMER_TRX_ID發(fā)票編號

RA_CUSTOMER_TRX_LINES_ALL

發(fā)票行一般有兩種類型ITEM和TAX

收款情況表AR_CASH_RECEIPTS_ALL(包含非收款信息)

核銷關(guān)系表AR_RECEIVABLE_APPLICATIONS_ALL

AP應(yīng)付

應(yīng)付發(fā)票表AP_INVOICES_ALL

實際付款表AP_CHECKS_ALL

AP_INVOICE_PAYMENTS

FA固定資產(chǎn)

資產(chǎn)信息表FA_ADDITIONS

資產(chǎn)類別FA_CATEGORIES資產(chǎn)帳薄FA_BOOK_CONTROLS

CURRENT_UNITS資產(chǎn)的數(shù)量FA_BOOKS

折舊一般有直線法和產(chǎn)量法

FA_DISTRIBUTION_HISTORY資產(chǎn)分配信息，給部門使用多少FA_DEPRN_DETAIL折舊信息表FA_TRANSCATION_HEADERS折舊事務(wù)表主要報表庫存收發(fā)存報表不采購訂單表接收情況表銷售訂單表生產(chǎn)任務(wù)情況表嫂返工率分析表供應(yīng)商對帳單

采購接受事務(wù)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相關(guān)定單行指定的物料名稱

是RCV_TRANSACTIONS中的PRIMARY_UNIT_OF_MEASURE

庫存組織：是RCV_TRANSACTIONS中的ORGANIZATION_ID，其對應(yīng)HR_ORGANIZATION_UNITS里的NAME

子庫存：庫位：SEGEMENT1

數(shù)量：

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指定的定單行號

物料庫存現(xiàn)有量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

過帳狀態(tài):當(dāng)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限定憑證

友情提示：本文中關(guān)于《Oracle EBS R12 常用表表結(jié)構(gòu)總結(jié)之AR應(yīng)收模塊》給出的范例僅供您參考拓展思維使用，Oracle EBS R12 常用表表結(jié)構(gòu)總結(jié)之AR應(yīng)收模塊：該篇文章建議您自主創(chuàng)作。

來源：網(wǎng)絡(luò)整理 免責(zé)聲明：本文僅限學(xué)習(xí)分享，如產(chǎn)生版權(quán)問題，請聯(lián)系我們及時刪除。

《Oracle EBS R12 常用表表結(jié)構(gòu)總結(jié)之AR應(yīng)收模塊》由互聯(lián)網(wǎng)用戶整理提供,轉(zhuǎn)載分享請保留原作者信息,謝謝!
鏈接地址：http://m.hmlawpc.com/gongwen/747137.html

• 上一篇：大二下學(xué)期總結(jié)
• 下一篇：oracle建表命令總結(jié)