Oracle-ERP11i表结构、API接口笔记
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Oracle-ERP11i(OPM)
—表结构、API接口笔记
Author:Jarwang（王重东）
Create Date:July5th,2008
Update Date:November20th,2010
Control No:
Current Edition: 1.0
声明：本文可以任意免费转载、复制、传播。但您务必保持其完整性！If you copy this document,you ought to keep the document completely.
Document Control
Modify Record
Date Author Version Modified reference
July5th,2008jarwang 1.0
Approved
Name Position signature
Distribute
Num Name Location&Position
1
2
3
4
Index
Document Control2
Modify Record2
Approved2
Index3
Preface6
Application Developer7
Value Set7
Data Table7
Lookups7
Data Table7
E-R Diagram7
Frequently-Used SQL8
Query Lookup8
Query ValueSet8
Values Set8
Data Table8
E-R Diagram9 OPM Process Execution10
Formula10
Data Table10
E-R Diagram10
Recipe10
Data Table10
E-R Diagram11
Production Document11
Data Table11
E-R Diagram12
Frequently-Used SQL12
Frequently-Used API12
Create Batches API13
Batches completedAPI16 OPM Inventory17
Item Master17
Data Table17
E-R Diagram17
Organization18
Data Table18
E-R Diagram18
Inventory Quantity19
Data Table19
Frequently-Used SQL19
Query OPM Organization19
Query Lot Status20
Frequently-Used API20
OPM Adjust Immediate API20
OPM Move Immediate API22 Human Resource25
HR Employee25
Frequently-Used API25
Create HR Employee API25
Create HR Employee API--FULL27 Purchase Order33
Requisition33
Data Table33 E-R Diagram33 Purchase Document33 Data Table33 E-R Diagram34 Quotation34 Data Table34 Receiving35 Data Table35 E-R Diagram35 Position Hierarchy35 Data Table35 E-R Diagram36 Frequently-Used SQL36 PO relation ITEM36 Query PO37 Query PO Quotation40 Frequently-Used API40 Create PO By Interface40 Order Management41 Sales Orders41 Data Table41 E-R Diagram41 Deliver41 Data Table41 E-R Diagram42 Frequently-Used API42 Create Sales Order API43 Frequently-Used SQL47 Query Order47 Query Profit Center50 Query Monthy Sale Amount50 Workflow52 Workflow User&Role52 Data Table52 E-R Diagram53 General Legder55 Journals55 Data Table55 E-R Diagram55 Frequently-Used SQL56 Query GL56 OPM GL drilldown PO58 Account Receivable59 Customer59 Data Table59 E-R Diagram59 Transaction60 Data Table60 E-R Diagram61 Receipts61 Data Table61 E-R Diagram62 Frequently-Used SQL62 Query Customer62 Query Customer Address63 Frequently-Used API63 Create AR Invoices API63 Create AR Receipts API63 Apply AR Receipts API65 Accounts Payable67