Oracle-ERP11i表结构、API接口笔记.pdf

《Oracle-ERP11i表结构、API接口笔记.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Oracle-ERP11i(OPM)—表结构、API接口笔记Author:Jarwang（王重东）CreateDate:July5th,2008UpdateDate:November20th,2010ControlNo:CurrentEdition:1.0声明：本文可以任意免费转载、复制、传播。但您务必保持其完整性！Ifyoucopythisdocument,yououghttokeepthedocumentcompletely.1DocumentControlModifyRecordDateAut

2、horVersionModifiedreferenceJuly5th,2008jarwang1.0ApprovedNamePositionsignatureDistributeNumNameLocation&Position12342IndexDocumentControl2ModifyRecord2Approved2Index3Preface6ApplicationDeveloper7ValueSet7DataTable7Lookups7DataTable7E-RDiagram7Frequentl

3、y-UsedSQL8QueryLookup8QueryValueSet8ValuesSet8DataTable8E-RDiagram9OPMProcessExecution10Formula10DataTable10E-RDiagram10Recipe10DataTable10E-RDiagram11ProductionDocument11DataTable11E-RDiagram12Frequently-UsedSQL12Frequently-UsedAPI12CreateBatchesAPI13

4、BatchescompletedAPI16OPMInventory17ItemMaster17DataTable17E-RDiagram17Organization18DataTable18E-RDiagram18InventoryQuantity19DataTable19Frequently-UsedSQL19QueryOPMOrganization19QueryLotStatus20Frequently-UsedAPI20OPMAdjustImmediateAPI20OPMMoveImmedia

5、teAPI22HumanResource25HREmployee25Frequently-UsedAPI25CreateHREmployeeAPI25CreateHREmployeeAPI--FULL27PurchaseOrder33Requisition333DataTable33E-RDiagram33PurchaseDocument33DataTable33E-RDiagram34Quotation34DataTable34Receiving35DataTable35E-RDiagram35P

6、ositionHierarchy35DataTable35E-RDiagram36Frequently-UsedSQL36POrelationITEM36QueryPO37QueryPOQuotation40Frequently-UsedAPI40CreatePOByInterface40OrderManagement41SalesOrders41DataTable41E-RDiagram41Deliver41DataTable41E-RDiagram42Frequently-UsedAPI42Cr

7、eateSalesOrderAPI43Frequently-UsedSQL47QueryOrder47QueryProfitCenter50QueryMonthySaleAmount50Workflow52WorkflowUser&Role52DataTable52E-RDiagram53GeneralLegder55Journals55DataTable55E-RDiagram55Frequently-UsedSQL56QueryGL56OPMGLdrilldownPO58AccountRecei

8、vable59Customer59DataTable59E-RDiagram59Transaction60DataTable60E-RDiagram61Receipts61DataTable61E-RDiagram62Frequently-UsedSQL62QueryCustomer62QueryCustomerAddress63Frequently-UsedAPI63CreateARInvoicesAPI63CreateARReceiptsAPI63ApplyARR