连接在线 JST连接器库存清单
- 格式:doc
- 大小:595.50 KB
- 文档页数:8
接口表、错误信息表Table List:*不要使用xxx_temp接口表,如mtl_material_transactions_temp;用它们会绕过系统id验证,直接进入数据表Table Relation:仅启用批次mtl_transactions_interface.transaction_interface_id =mtl_transaction_lots_interface.transaction_interface_id仅启用序列mtl_transactions_interface.transaction_interface_id =mtl_serial_numbers_interface.transaction_interface_id同时启用批次、序列mtl_transactions_interface.transaction_interface_id =mtl_transaction_lots_interface.transaction_interface_idmtl_transaction_lots_interface.serial_transaction_temp_id =mtl_serial_numbers_interface.transaction_interface_idmtl_transactions_interfaceselect mti.error_code,mti.error_explanationfrom mtl_transactions_interface mti;并发程序Process transaction interfaceN: INV/Setup/Transactions/Interface Managers/Process transaction interface/Tools/Launch Manager这个是库存事务处理主程序,正式环境一般是Schedule运行的。