linux物料管理,ERP物料单位修改方法

ERP物料一旦录入系统，它的物料单位就被固定，所有的事务处理都会将转换为主要单位进行处理，但单位的不同涉及到事务处理的数量和所有的价格，从而关联到订货量、发运量和物料清单等几乎所有内容，如果发现进入系统物料的单位错了就很难处理，当然最直接的方法就是重新编个新码进入系统维护正确的信息，把错误单位的物料信息转移到新编码上(采购订单或工单、库存事务、事务处理、发运事务、转账事务等)，然后把原码失效。最根本的办法也是比较麻烦的办法是从数据库调出对应的表，修改错误的代码。具体内容如下：一：mtl_system_items_b

物料单位：

selectmsib.inventory_item_id,---118473

msib.primary_uom_code,

msib.primary_unit_of_measure

frommtl_system_items_b msib

wheremsib.organization_id =101

andmsib.segment1 ='J91797'

PRIMARY_UOM_CODEPRIMARY_UNIT_OF_MEASURE

㎡平方米

二：mtl_material_transactions

selectmmt.transaction_id, mmt.transaction_uom

frommtl_material_transactions mmt

wheremmt.organization_id =101

andmmt.inventory_item_id =118473

TRANSACTION_IDTRANSACTION_UOM

13624745㎡

三：po_lines_all

select*

frompo_lines_all pll

wherepll.item_id =118473

andpll.org_id =81

UNIT_MEAS_LOOKUP_CODE

平方米

平方米

四：po_line_locations_all

select*

frompo_line_locations_all plla

whereplla.po_line_idin(98101,98437)

UNIT_MEAS_LOOKUP_CODE

平方米

五：rcv_transactions

selectrt.transaction_id,

rt.unit_of_measure,

rt.uom_code,

rt.primary_unit_of_measure

fromrcv_transactions rt

wherert.organization_id =101

andrt.po_line_location_id =292942

TRANSACTION_IDUNIT_OF_MEASUREUOM_CODEPRIMARY_UNIT_OF_MEASURE

285212平方米㎡平方米

285213平方米㎡平方米

六：rcv_shipment_lines

selectrsl.shipment_line_id,

rsl.unit_of_measure,

rsl.primary_unit_of_measure

fromrcv_shipment_lines rsl

wherersl.item_id =118473

SHIPMENT_LINE_IDUNIT_OF_MEASUREPRIMARY_UNIT_OF_MEASURE

192989平方米平方米

七：mtl_onhand_quantities_detail

selectmoq.transaction_uom_code

frommtl_onhand_quantities_detail moq

wheremoq.inventory_item_id =118473

TRANSACTION_UOM_CODE

㎡

/*******************************************************************/

更新代码

/*******************************************************************/

----mtl_system_items_b

selectmsib.inventory_item_id,---118473

msib.primary_uom_code,

msib.primary_unit_of_measure

frommtl_system_items_b msib

wheremsib.organization_id =101

andmsib.segment1 ='J91797'

updatemtl_system_items_b msib

setmsib.primary_uom_code ='M2'

wheremsib.organization_id =101

andmsib.segment1 ='J91797'

---mtl_material_transactions

selectmmt.transaction_id, mmt.transaction_uom

frommtl_material_transactions mmt

wheremmt.organization_id =101

andmmt.inventory_item_id =118473

updatemtl_material_transactions mmt

setmmt.transaction_uom ='M2'

wheremmt.organization_id =101

andmmt.inventory_item_id =118473

----rcv_transactions

select*

frompo_lines_all pll

wherepll.item_id =118473

andpll.org_id =81

select*

frompo_line_locations_all plla

whereplla.po_line_idin(98101,98437)

selectrt.transaction_id,

rt.unit_of_measure,

rt.uom_code,

rt.primary_unit_of_measure

fromrcv_transactions rt

wherert.organization_id =101

andrt.po_line_location_id =292942

updatercv_transactions rt

setrt.uom_code ='M2'

wherert.organization_id =101

andrt.po_line_location_id =292942

andrt.transaction_idin(285212,285213)

---mtl_onhand_quantities_detail

selectmoq.transaction_uom_code

frommtl_onhand_quantities_detail moq

wheremoq.inventory_item_id =118473

andmoq.organization_id =101

updatemtl_onhand_quantities_detail moq

setmoq.transaction_uom_code

wheremoq.inventory_item_id =118473

andmoq.organization_id =101