oracle ebs常用数据表（oracle ebs常用数据表）

《oracle ebs常用数据表（oracle ebs常用数据表）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、oracleebs常用数据表（OracleEBS常用数据表）Source:http://space.itpub.net/126211/INVinventoryTwomeaningsoforganization:1.operatingunits,A/B/Cbranch,A,followingA1,A2andotherfactories,thethemeisforindependentaccountingoftheorganizationORG,ORG_ID;2.inventoryorganization,suchasmanufacturer'swarehouse,suchasA1,A2a

2、ndotherfactoriesOrganization_id;HR_ORGANIZATION_UNITSOrg_organization_definitionsMtl_subinventory_inventoryorganizationunitMTL_PARAMETERS-inventoryorganizationparameters(notusingID,directlyusingname)MTL_SYSTEM_ITEMS_b-materialinformation(ibid.,stockorganizationname)MTL_SECONDARY_INVENTORIES-subi

3、nventoryorganizations-MTL_ITEM_LOCATTIONS-space-SUBINVENTROY_CODEMtl_Material_Transactions-(inventory)materiallistCostmtl_transaction_accountsTransaction_costisthecostofthings;ACTUAL_COSTistheactualcostcalculatedthroughacostalgorithm,theprincipalmeasurementunitExistingquantitySummaryhistory(plus

4、andminustotals)Mtl_Material_TransactionsMTL_ONHAND_QUANTITIEStheexistingscale,organization/inventory/storage/itemsummarymayaccordingtopickingFIFOstatistics,ifyousetthe"nonegativeinventory",thisdoesnotappeartobenegativePORequisitionheadtablePo_Requisition_Headers_allRowtablePo_Requisition_lines_a

5、llPurchaseorderPO_HEADER_ALLPO_LINES_ALLProcurementreceipt-return/InterOrganizationaltransfer/normalconditionrequirestheuseofthismoduleRCV_TRANSACTIONS1.received100unitsofgoodsintothe"qualityinspection"section2.accept/reject3.inventory/returnTherearethreedifferentstates!Forexample,receive100,80a

6、cceptstorage,and20return,thenthereare80acceptedtransactions,/20returnsSelect,TRANSACTION_TYPE,DESTINATION_TYPE_CODE,from,RCV_TRANSACTIONSYoucanseethefollowingstages:A1.RECEIVE-RECEIVINGA2.ACCEPT-RECEIVINGA3.DELIERY–INVETORY(affectingexistinginventory)Ifyoufollowthenormalmode,youwillendupgenerati

7、ngMTL_MATERIAL_TRANSACTIONSSalesorderOE_ORDER_headers_allSOLD_FROM_ORG_IDSOLD_TO_ORG_IDistheclientlayerSHIP_FROM_ORG_IDSHIP_TO_ORG_IDisthecustomerreceivinglayerINVOICE_TO_ORG_IDisasinglelayerforcustomersDELIVER_TO_ORG_IDClie