欢迎来到天天文库
浏览记录
ID:52796280
大小:3.57 MB
页数:84页
时间:2020-03-30
《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
此文档下载收益归作者所有