MILY: Arial; mso-bidi-font-size: 12.0pt; mso-bidi-font-family: " roman??="" new="" times="">--KEEP DEC JO資料
procedure:CM_BOM_KEEP_JO123M
table
cm_wip_jo1m_file
cm_wip_jo2m_file
cm_wip_jo3m_file
--result:
cm_bom_jo1m_file
cm_bom_jo2m_file
cm_bom_jo3m_file
--成品倉庫月結程式
procedure:CM_GET_FGMON_BAL_CC
table:
MTL_MATERIAL_TRANSACTIONS
MTL_ONHAND_QUANTITIES
--result:CM_FGMON_BAL2
每個月成品倉庫的縂的進出存，期初，期末，in,out.--海外倉庫月結程式
procedure:CM_GET_FGMON_OSBAL
table:
MTL_MATERIAL_TRANSACTIONS
MTL_ONHAND_QUANTITIES
--result:CM_FGMON_OSBAL
每個月海外倉庫的縂的進出存，期初，期末，in,out.
--keep wip and FG(skm) balance
procedure: CM_BOM_KEEP_WIPSKM_BAL
table:
CM_FGMON_BAL2 --FG(SKM) balance
CM_WIP_balance --wip balance
--result:cm_bom_wip_stock_balance WIP/SKM(FG) BAL
保存成品倉庫存量和WIP的存量
--WIP/SKM(FG) balance與訂單匹配
report: CMBOM913.rdf類似于IOB發料建議，跟有效
訂單進行match，可以區分有效庫存和有效庫存
table:
CM_BOM_WIP_STOCK_BALANCE wip/FG(SKM) BAL
CM_WIP_balance --wip balance
--result:
cm_BOM_wipstk_to_order --WIP/SKM(FG)與訂單匹配結果資料
CM_BOM_JO3M_LAM_QTY
wip/skm存量与配对订单
report:cmbom943.rdf
wip/skm存量
---wip存量
produre:cm_bom_keep_wip_bal
table:
cm_bom_wip_stock_balance (wip)
cm_bom_wipstk_to_order
result:
cm_dec_cst_value_qty
---skm存量
produre:cm_bom_keep_skm_bal
table:
cm_bom_wip_stock_balance(FG)
cm_bom_wipstk_to_order
result:
cm_dec_cst_value_qty
wip/skm異動
---SKM倉庫異動
procedure:CM_BOM_KEEP_SKT_TRX
table:
mtl_material_transactions
mtl_transaction_lot_numbers
上期的BAL(BEG期初存货)
CM_FGMON_BAL2 (FG)
CM_FGMON_OSBAL(OS)
本期的BAL(BAL期末存货）
CM_FGMON_BAL2 (FG)
CM_FGMON_OSBAL(OS)
result:cm_dec_cst_skt_qty
---wip異動
procedure:cm_bom_keep_wip_trx
table:
--output
cm_wip_iob_by_part_new (nor output)
CM_WIP_LOT_HISTORY (srcap trx --QTY_SCRAP )
--提復
cm_wip_stock_out_history
cm_wip_stock_out_qty
--調帳
cm_wip_adjust_history
cm_wip_adjust_qty
--外包
cm_osp_pr
--厰間調撥
cm_exchange
cm_exchange_qty
result:
cm_dec_cst_trx_qty
成本存量
CM_BOM_轉入DEC成本量_To_Oracle(cmbom940.rdf)
與JO1的單價,匯率，幣別聯係
cmbom940.rdf
procedure: cm_bom_keep_dec_val_cost
table:
cm_dec_cst_value_qty
result:cm_bom_cst_value_qty
FG/WIP存本產量
Wip存本產量
procedure: cm_bom_keep_dec_trx_cost
table :cm_bom_keep_dec_trx_cost
result: cm_dec_keep_dec_trx_cost
FG存本產量
procedure:cm_bom_keep_dec_skt_cost
table: cm_dec_cst_skt_qty
result:cm_bom_cst_skt_qty
修正沒有成本的資料。
Report: CMBOM修正DEC_WIP_PC(cmbom989.rdf)
Table:
CM_BOM_CST_VALUE_QTY
cm_bom_partnum_op_cost
result:
CM_WIP_CST_VALUE_QTY
海外倉庫存量成本
procedure:cm_bom_keep_OST_BAL
table:CM_DEC_CST_VALUE_QTY
result:cm_bom_cst_value_qty
文章来源于领测软件测试网 https://www.ltesting.net/
