Transaction类型
来源:互联网 发布:wine怎么使用 mac 编辑:程序博客网 时间:2024/06/01 10:22
oracle在做库存事务处理的时候,经常有一些令人值列表,令人眼花缭乱的,如事务处理来源,事务处理活动等,正好做完项目了,因此总结一下其来源及内容,同时也给大家做个参照:
事务处理类型(transaction_type_id):
select transaction_type_id,
transaction_type_name
from mtl_transaction_types
order by 1;
TRANSACTION_TYPE_ID TRANSACTION_TYPE_NAME
=================== ==============================
1 Account issue
2 Subinventory Transfer
3 Direct Org Transfer
4 Cycle Count Adjust
5 Cycle Count Transfer
8 Physical Inv Adjust
9 Physical Inv Transfer
12 Intransit Receipt
15 RMA Receipt
17 WIP Assembly Return
18 PO Receipt
21 Intransit Shipment
24 Standard cost update
25 WIP cost update
26 Periodic Cost Update
28 Layer Cost Update
31 Account alias issue
32 Miscellaneous issue
33 Sales order issue
34 Internal order issue
35 WIP component issue
36 Return to Vendor
37 RMA Return
38 WIP Neg Comp Issue
40 Account receipt
41 Account alias receipt
42 Miscellaneous receipt
43 WIP Component Return
44 WIP Assy Completion
48 WIP Neg Comp Return
50 Internal Order Xfer
51 Backflush Transfer
52 Sales Order Pick
53 Internal Order Pick
54 Int Order Direct Ship
55 WIP Lot Split
56 WIP Lot Merge
57 Lot Bonus
58 Lot Update Quantity
61 Int Req Intr Rcpt
62 Int Order Intr Ship
63 Move Order Issue
64 Move Order Transfer
66 Project Borrow
67 Project Transfer
68 Project Payback
70 Shipment Rcpt Adjust
71 PO Rcpt Adjust
72 Int Req Rcpt Adjust
73 Planning Transfer
77 ProjectContract Issue
80 Average cost update
82 Inventory Lot Split
83 Inventory Lot Merge
84 Inventory Lot Translate
86 Cost Group Transfer
87 Container Pack
88 Container Unpack
89 Container Split
90 WIP assembly scrap
91 WIP return from scrap
92 WIP estimated scrap
93 Field Service USage
94 Field Service Recovery
100 Deposito presso terzi
101 Trasferimento interno
120 Obsolete Inventory
121 Charitable Contribution
122 Issue to Project
123 Receipt From
142 Field Service
162 FES Issue
163 FES Reciept
164 FES Wip Issue
182 Patient Issue
183 Window Issue
184 NL Issue to Project
185 NL Sub=inventory Transfer
186 eIB Issue to Project
187 eIB Subinventory Transfer
188 eIB Misc. Issue to Project
189 eIB Misc. Receipt from Project
事务处理类型(transaction_type_id):
select transaction_type_id,
transaction_type_name
from mtl_transaction_types
order by 1;
TRANSACTION_TYPE_ID TRANSACTION_TYPE_NAME
=================== ==============================
1 Account issue
2 Subinventory Transfer
3 Direct Org Transfer
4 Cycle Count Adjust
5 Cycle Count Transfer
8 Physical Inv Adjust
9 Physical Inv Transfer
12 Intransit Receipt
15 RMA Receipt
17 WIP Assembly Return
18 PO Receipt
21 Intransit Shipment
24 Standard cost update
25 WIP cost update
26 Periodic Cost Update
28 Layer Cost Update
31 Account alias issue
32 Miscellaneous issue
33 Sales order issue
34 Internal order issue
35 WIP component issue
36 Return to Vendor
37 RMA Return
38 WIP Neg Comp Issue
40 Account receipt
41 Account alias receipt
42 Miscellaneous receipt
43 WIP Component Return
44 WIP Assy Completion
48 WIP Neg Comp Return
50 Internal Order Xfer
51 Backflush Transfer
52 Sales Order Pick
53 Internal Order Pick
54 Int Order Direct Ship
55 WIP Lot Split
56 WIP Lot Merge
57 Lot Bonus
58 Lot Update Quantity
61 Int Req Intr Rcpt
62 Int Order Intr Ship
63 Move Order Issue
64 Move Order Transfer
66 Project Borrow
67 Project Transfer
68 Project Payback
70 Shipment Rcpt Adjust
71 PO Rcpt Adjust
72 Int Req Rcpt Adjust
73 Planning Transfer
77 ProjectContract Issue
80 Average cost update
82 Inventory Lot Split
83 Inventory Lot Merge
84 Inventory Lot Translate
86 Cost Group Transfer
87 Container Pack
88 Container Unpack
89 Container Split
90 WIP assembly scrap
91 WIP return from scrap
92 WIP estimated scrap
93 Field Service USage
94 Field Service Recovery
100 Deposito presso terzi
101 Trasferimento interno
120 Obsolete Inventory
121 Charitable Contribution
122 Issue to Project
123 Receipt From
142 Field Service
162 FES Issue
163 FES Reciept
164 FES Wip Issue
182 Patient Issue
183 Window Issue
184 NL Issue to Project
185 NL Sub=inventory Transfer
186 eIB Issue to Project
187 eIB Subinventory Transfer
188 eIB Misc. Issue to Project
189 eIB Misc. Receipt from Project
- Transaction类型
- Transaction
- Transaction
- Transaction
- transaction
- Transaction
- Transaction
- Transaction
- Transaction
- @Transaction
- transaction
- Transaction
- 论文类型Journal、magazin、transaction、letter等的区别
- 论文类型Journal、magazin、transaction、letter等的区别
- 论文类型Journal、magazin、transaction、letter等的区别
- 1008 transaction transaction transaction
- HDU6210 transaction transaction transaction
- hdu6201 transaction transaction transaction
- 【算法】AES算法优化
- 使用ListView应该注意的地方
- 电影站上线第30天 IP慢慢突破300的一点小经验
- 有12个乒乓球,其中一个是坏的,请你用天枰称3次将坏球分辨出来。你会用什么方法呢?
- hdu 2037 今年暑假不AC
- Transaction类型
- [MSSQL]【SQL SERVER 2005+版本行转列示例】(2012年1-8月水源槑党25强榜单新鲜出炉)
- 使用PLSQL Developer从oracle数据库 导入导出excel表数据
- JS for web developers的第十章的一段翻译
- 不同操作系统中文本文件换行符的区别
- 批处理去除空格
- stl排序之sort函数
- decode、encode、unicode解码
- 打印机步进电机补充说明