物料事物处理表的含义

1.     TRANSACTION_ACTION_ID
   

select TRANSACTION_ACTION_ID,count(*) from MTL_MATERIAL_TRANSACTIONS group by TRANSACTION_ACTION_ID

TRANSACTION_ACTION_ID

COUNT

REMARK

1

429123

从库存发放

2

22798

子库存转移

3

24

组织直接转移

24

2

成本更新

27

244138

接收至库存

28

619706

分段转移

29

48

交货调整

SELECT LOOKUP_CODE,MEANING,DESCRIPTION
FROM FND_LOOKUP_VALUES_VL
WHERE (nvl(’’, territory_code) = territory_code or territory_code is null)
AND lookup_type = ‘MTL_TRANSACTION_ACTION’
and (LOOKUP_TYPE LIKE ‘MTL_TRANSACTION_ACTION’)
and (VIEW_APPLICATION_ID = 700)
and (SECURITY_GROUP_ID = 0)
order by LOOKUP_CODE

1 从库存发放

12 在途接收

2 子库存转移

21 在途发货

24 成本更新

27 接收至库存

28 分段转移

29 交货调整

3 组织直接转移

30 WIP 报废事务处理

31 完成装配

32 退回装配件

33 负组件发放

34 负组件退货

35 集装箱事务处理 集装箱事务处理

4 周期盘点调整

40 分割批次 分割批次

41 合并批次 合并批次

42 批次转换 批次转换

43 批次更新数量 批次更新数量

5 计划转移 计划转移

50 集装箱装箱 集装箱装箱

51 集装箱卸货 集装箱卸货

52 集装箱分解

55 成本组转移

6 所有权转移 所有权转移

8 物理库存调整

transaction_type_id
select transaction_type_id,count(*) from MTL_MATERIAL_TRANSACTIONS group by transaction_type_id

TRANSACTION_TYPE_ID

COUNT

REMARK

2

2

Subinventory Transfer Transfer material between subinventories

3

24

Direct Org Transfer Direct transfer between two organizations

15

3856

RMA Receipt Return material authorization

18

204263

PO Receipt Receive Purchase Order

31

14896

Account alias issue Issue material against account alias

33

411916

Sales order issue Ship Confirm external Sales Order

36

2312

Return to Vendor Return to vendor from stores

41

36021

Account alias receipt Receive material against account alias

52

619708

Sales Order Pick Staging transfer on a Sales order

64

92

Move Order Transfer Transact Subinventory Transfer Move Order

71

48

PO Rcpt Adjust Delivery adjustments on a Purchase order receipt

80

2

Average cost update Update average cost information

100

9884

LENDING MOVE 借物出库

101

9564

LENDING RETURN 借物归还

102

834

DEFECTIVE MOVE 不良品

103

12

PROMOTION MOVE 促销品

104

542

BULK MOVE 散货

105

2

ESS MOVE ESS

106

1866

VMI MOVE VMI转移

select mtt.transaction_type_id,mtt.transaction_type_name,mtt.description from mtl_transaction_types mtt where mtt.transaction_type_id in(
select transaction_type_id from MTL_MATERIAL_TRANSACTIONS group by transaction_type_id
)

2 Subinventory Transfer Transfer material between subinventories

3 Direct Org Transfer Direct transfer between two organizations

15 RMA Receipt Return material authorization

18 PO Receipt Receive Purchase Order

31 Account alias issue Issue material against account alias

33 Sales order issue Ship Confirm external Sales Order

36 Return to Vendor Return to vendor from stores

41 Account alias receipt Receive material against account alias

52 Sales Order Pick Staging transfer on a Sales order

64 Move Order Transfer Transact Subinventory Transfer Move Order

71 PO Rcpt Adjust Delivery adjustments on a Purchase order receipt

80 Average cost update Update average cost information

100 LENDING MOVE 借物出库

101 LENDING RETURN 借物归还

102 DEFECTIVE MOVE 不良品

103 PROMOTION MOVE 促销品

104 BULK MOVE 散货

105 ESS MOVE ESS

106 VMI MOVE VMI转移

TRANSACTION_SOURCE_TYPE_ID
select TRANSACTION_SOURCE_TYPE_ID,count(*) from MTL_MATERIAL_TRANSACTIONS group by TRANSACTION_SOURCE_TYPE_ID

TRANSACTION_SOURCE_TYPE_ID

COUNT

REMARK

1

206624

Purchase order

2

1031624

Sales order

4

22796

Move order

6

50917

Account alias

12

3856

RMA

13

28

Inventory

select mts.transaction_source_type_id,mts.transaction_source_type_name from MTL_TXN_SOURCE_TYPES mts

1 Purchase order

2 Sales order

3 Account

4 Move order

5 Job or Schedule

6 Account alias

7 Internal requisition

8 Internal order

9 Cycle Count

10 Physical Inventory

11 Standard cost update

12 RMA

13 Inventory

14 Periodic Cost Update

16 Project Contract

15 Layer Cost Update

17 External Requisition

4.     rcv_transactions
   

附件图片是在哪个模块的没有找到，看是对应到哪张表？能否告诉我下

还有表rcv_transactions 的 transaction_type 值是在哪个模块维护的？

SELECT fvl.LOOKUP_CODE,fvl.MEANING,fvl.DESCRIPTION FROM FND_LOOKUP_VALUES_VL fvl
where fvl.lookup_type =‘RCV TRANSACTION TYPE’

1 SHIP 发运 在途发货或内部订单

2 CORRECT 更正 更正前一事务处理录入

3 DELIVER 交货 将物料发货交至申请人

4 RECEIVE 接收 接收物料发货

5 ACCEPT 接受 接受随后检验的物料

6 REJECT 拒绝 拒绝随后检验的物料

7 MATCH 匹配 将未订购物料匹配至采购订单

8 CANCEL 取消 取消 ASN 的提前发货通知事务处理

9 RETURN TO CUSTOMER 退回给客户 将物料退回给客户

10 RETURN TO VENDOR 退回供应商 将物料退回至供应商

11 RETURN TO RECEIVING 退回接收部门 将交货物料退回至接收

12 UNORDERED 未订购接收 接收与来源单据不匹配的物料

13 TRANSFER 转移 在接收地点之间转移物料