Interface: Cost

最新推荐文章于 2021-04-16 06:35:56 发布

原创最新推荐文章于 2021-04-16 06:35:56 发布 · 257 阅读

0 ·

CC 4.0 BY-SA版权

Oracle DB 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一种通过数据库接口批量更新成本详情的方法。具体操作包括设置标志位、组ID、交易类型等字段，并插入特定的成本类型ID、成本元素ID和其他相关信息。

1. System standard Conc. Prog. will remove all old lines, then insert new lines as replacement.

bom.cst_item_cst_dtls_interface

INSERT INTO bom.cst_item_cst_dtls_interface(process_flag,group_id,transaction_type,created_by,last_updated_by,last_update_login,creation_date,last_update_date,cost_type_id,cost_element_id,based_on_rollup_flag,organization_id,resource_id,basis_type,inventory_item_id,usage_rate_or_amount)
VALUES (1,741,'UPDATE',64427,64427,64427,sysdate,sysdate,3,1,2,4602,11207,1,2922440,12204.88);

INSERT INTO bom.cst_item_cst_dtls_interface(process_flag,group_id,transaction_type,created_by,last_updated_by,last_update_login,creation_date,last_update_date,cost_type_id,cost_element_id,based_on_rollup_flag,organization_id,resource_id,basis_type,inventory_item_id,usage_rate_or_amount)
VALUES (1,741,'UPDATE',64427,64427,64427,sysdate,sysdate,3,2,2,4602,10880,5,2925074,0.07); --Freight

INSERT INTO bom.cst_item_cst_dtls_interface(process_flag,group_id,transaction_type,created_by,last_updated_by,last_update_login,creation_date,last_update_date,cost_type_id,cost_element_id,based_on_rollup_flag,organization_id,resource_id,basis_type,inventory_item_id,usage_rate_or_amount)
VALUES (1,741,'UPDATE',64427,64427,64427,sysdate,sysdate,3,2,2,4602,10881,5,2925074,0.07); --Duty