How are Receiving Transaction Tied to Inventory Transactions?

How are Receiving Transaction Tied to Inventory Transactions?

Note:100298.1
 
Problem Description
-------------------
 
    How the MTL_MATERIAL_TRANSACTIONS table tie to the RCV_TRANSACTIONS table?
 
 
Solution Description
--------------------
 
    If the RECEIVING transaction information is known, then do the following:
 
       1. Get the transaction_id from rcv_transactions where the receiving
           transaction_type is CORRECT, DELIVER or RETURN TO RECEIVING.
 
       2. The transaction_id in rcv_transactions will be the
           rcv_transaction_id in mtl_material_transactions.
  
 
RCV_TRANSACTIONS.TRANSACTION_ID=MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID
 
 
    If the INVENTORY transaction information is known, then do the following:
 
       1. Get the transaction_id and the rcv_transaction_id from
           mtl_material_transactions.
 
       2. The rcv_transaction_id.mtl_material_transactions will equal the
           transaction_id in rcv_transactions.
 
        (rcv_transaction_id.mtl_material_transactions   ???)
 
   The Technical Reference Manual for the RCV_TRANSACTIONS table reads that
   the inv_transaction_id ties to mtl_material_transactions.
   This is true, but only applies to Internal Order Issue transactions.
   There is little documentation on the links between the tables.

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值