1Oracle-ERP11i(OPM)—表结构、API接口笔记Author:Jarwang（王重东）Create Date:July5th,2008Update Date:Control No:Current Edition:1.0声明：本文可以任意免费转载、复制、传播。但您务必保持其完整性！If you copythis document,you ought to keep the document completely.2DocumentControlModifyRecordDateAuthorVersionModifiedreferenceJuly 5th,2008jarwang 1.0ApprovedNamePositionsignatureDistributeNumNameLocation&Position12343IndexDocumentControl2Modify Record2Approved2Index3Preface5Application Developer6Lookups6Data Table6E-R Diagram6Frequently-Used SQL6OPM Process Execution8Formula8Data Table8E-R Diagram8Recipe8Data Table8E-R Diagram9Production Document9Data Table9E-R Diagram10Frequently-Used SQL10Frequently-Used API10Create Batches API10OPM Inventory15Item Master15Data Table15E-R Diagram15Purchase Order16Requisition16Data Table16E-R Diagram16Purchase Document16Data Table16E-R Diagram17Receiving17Data Table17E-R Diagram18Position Hierarchy18Data Table18E-R Diagram19Order Management20Sales Orders20Data Table20E-R Diagram20Deliver20Data Table20E-R Diagram21Frequently-Used API21Create Sales Order API22Query Profit Center26Workflow27Workflow User &Role274Data Table27E-R Diagram28General Legder30Journals30Data Table30E-R Diagram30Account Receivable32Customer32Data Table32E-R Diagram32Transaction33Data Table33E-R Diagram34Receipts34Data Table34E-R Diagram35Frequently-Used API35Create AR Invoices API35Create AR Receipts API35Apply AR Receipts API37Accounts Payable39Supplier39Data Table39E-R Diagram39Invoices39Data Table39E-R Diagram40Payment40Data Table40E-R Diagram41Frequently-Used SQL41Query Vendor Liability41Query Unpaid Prepayment42Query UnApplied Prepayment42Frequently-Used API45Create AP Invoice API45Other Notes465PrefaceOracle ERP本身异常庞大，因此Oracle ERP的表结构也异常庞大。使用下述语句，可以得到Oracle ERP的表数量有1W多(此方法不精确，但也可以说明表的庞大)。selectcount(*)...
