《oracle ebs常用數(shù)據(jù)表（oracle ebs常用數(shù)據(jù)表）》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。

1、oracleebs常用數(shù)據(jù)表（OracleEBS常用數(shù)據(jù)表）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