mtl_material_transactions_temp作用????

billlyh

mtl_material_transactions_temp作用????
哪位兄弟说说这个表的具体作用是什么

tiansoft68

mtl_material_transactions_temp：主要功能是物料搬运单申请后，占用库存现有量。
等搬运单处理完后，自动将mtl_material_transactions_temp表数据清空。

tianpan

MTL_MATERIAL_TRANSACTIONS_TEMP is the gateway for all material
transactions.
.
Records are processed from this table into Inventory through the
transaction processor. All Inventory transaction forms write directly
to this table. Outside applications must write transaction records to
MTL_TRANSACTIONS_INTERFACE to be processed through
MTL_MATERIAL_TRANSACTIONS_TEMP and the transaction processor by the
Transaction Worker concurrent program.
.
Lots and serial numbers for a MTL_MATERIAL_TRANSACTIONS_TEMP(MMTT)
record are stored in the tables MTL_TRANSACTION_LOTS_TEMP(MTLT) and
MTL_SERIAL_NUMBERS_TEMP(MSNT). If the item is under lot control, then
MMTT.TRANSACTION_TEMP_ID joins to MTLT.TRANSACTION_TEMP_ID. If the
item is also under serial number control, then
MTLT.SERIAL_TRANSACTION_TEMP_ID joins to MSNT.TRANSACTION_TEMP_ID. If
the item is only under serial number control, then
MMTT.TRANSACTION_TEMP_ID joins to MSNT.TRANSACTION_TEMP_ID.
.
Transfer transactions are stored in this table as a single record.
The transaction processor creates two transactions from the single
record.

billlyh

tianpan 发表于 2013/3/19 19:51
MTL_MATERIAL_TRANSACTIONS_TEMP is the gateway for all material
transactions.
.

这段英文是在哪个帮助文档里面找到的呀

tianpan

billlyh 发表于 2013/3/20 16:26
这段英文是在哪个帮助文档里面找到的呀

Oracle eTRM: http://etrm.oracle.com/pls/etrm/etrm_search.search

lois80

收藏。。。。。。。。。。。

alexandre

是的， 多看下eTRM, 介绍很详细的