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类型
最新推荐文章于 2024-07-25 13:12:13 发布