ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 转:Item Interface

转:Item Interface

原创 Linux操作系统 作者:i168t 时间:2008-01-11 14:28:22 0 删除 编辑

一.新增

主组织:

INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(
   PROCESS_FLAG,
   TRANSACTION_TYPE,
   SET_PROCESS_ID,
   ORGANIZATION_CODE,
   SEGMENT1,
   DESCRIPTION
)
VALUES
(
   
1,         --PROCESS_FLAG,
   'CREATE', 
--TRANSACTION_TYPE,
   
1000,       --SET_PROCESS_ID,
   'S00',      
--ORGANIZATION_CODE,
   'Test00',   
--SEGMENT1,
   'Test00'   
--DESCRIPTION,
)

从组织:

INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(
   PROCESS_FLAG,
   TRANSACTION_TYPE,
   SET_PROCESS_ID,
   ORGANIZATION_CODE,
   SEGMENT1,
   DESCRIPTION
)
VALUES
(
   
1,         --PROCESS_FLAG,
   'CREATE', 
--TRANSACTION_TYPE,
   
1000,       --SET_PROCESS_ID,
   'S01',      
--ORGANIZATION_CODE,
   'Test00',   
--SEGMENT1,
   'Test00'   
--DESCRIPTION,
)

备注:

PROCESS_FLAG :用于标识Interface中的当前记录的状态。

                                   一般选1 (Pending),其它数值意义请查阅相关资料。

TRANSACTION_TYPE:用于标识Interface中的当前记录的作用。

                                  CREATE or UPDATE,此处选CREATE。

SET_PROCESS_ID:对于同一料品随意填一个相同的值,以便让主组织和从组织同时处理,
                               
                                  避免从组织的数据在组织之前处理报错。

说明:

1.   主组织中记录中已经存在的某些字段在从组织记录中可以不必填,在导入从组织数据的时候会默认从对应的组织处取得。(如果是一次导入的,那作用不大。如果主组织已经导入了,再导从组织就方便多了)。

2.   要导入料品到从组织中,则必须在主组织中已经存在。

3. 对于ORGANIZATION_CODE 和 SEGMENT1 可以用ORGANIZATION_ID 和 ITEM_NUM进行替换,不过最后直接给ORGANIZATION_ID和SEGMENT1赋值,这样导入的速度会快一些。

 

二.修改

说明:要修改Master级别的属性,必须在主组织上进行修改,修改完后会直接反应到从组织中。

对于Org级别的属性,在主组织和从组织上的修改都只反应在本组织。

主组织:

修改Master级别的属性:

INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(
   PROCESS_FLAG,
   TRANSACTION_TYPE,
   SET_PROCESS_ID,
   ORGANIZATION_CODE,
   SEGMENT1,
   DESCRIPTION
)
VALUES
(
   
1,         --PROCESS_FLAG,
   'UPDATE', 
--TRANSACTION_TYPE,
   
1000,       --SET_PROCESS_ID,
   'S00',      
--ORGANIZATION_CODE,
   'Test00',   
--SEGMENT1,
   'Test000'   
--DESCRIPTION,
)

修改Org级别的属性:

主组织:

INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(
   PROCESS_FLAG,
   TRANSACTION_TYPE,
   SET_PROCESS_ID,
   ORGANIZATION_CODE,
   SEGMENT1,
   DESCRIPTION,
   BUYER_ID
)
VALUES
(
   
1,         --PROCESS_FLAG,
   'UPDATE', 
--TRANSACTION_TYPE,
   
1000,       --SET_PROCESS_ID,
   'S00',      
--ORGANIZATION_CODE,
   'Test00',   
--SEGMENT1,
   'Test000', 
--DESCRIPTION,
   
2891        --BUYER_ID
)

从组织: 

INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
(
   PROCESS_FLAG,
   TRANSACTION_TYPE,
   SET_PROCESS_ID,
   ORGANIZATION_CODE,
   SEGMENT1,
   DESCRIPTION,
   BUYER_ID
)
VALUES
(
   
1,         --PROCESS_FLAG,
   'UPDATE', 
--TRANSACTION_TYPE,
   
1000,       --SET_PROCESS_ID,
   'S01',      
--ORGANIZATION_CODE,
   'Test00',   
--SEGMENT1,
   'Test000', 
--DESCRIPTION,
   
4150        --BUYER_ID
)

三.Report Parameter

Path: Inventory -> Items -> Import -> Import Items

说明:

All organizations:

Yes: Run the interface for all organization codes in the item interface table.

No: Run the interface only for the organization you are currently in. Item interface rows for organizations other than your current organization are ignored.

Validate Items:

Yes: Validate all items and their data residing in the interface table that have not yet been validated. If items are not validated, they will not be processed into Oracle Inventory.

No: Do not validate items in the interface table, Note that items that have not been validated will not be processed into Oracle Inventory. You would use this option if you had previously run the item interface and responded Yes for Validate Items and No for Process Items, and now want to process your items.

Process Items:

Yes: All qualifying items in the interface table are inserted into Oracle Inventory.

No:  Do not insert items into Oracle Inventory, Use this option, along with Yes for Delete Processed Items, to remove successfully processed rows from the interface table without performing any other processing. You can also use this option, along with Yes for Validate Items, if you want to validate items without any processing.

Delete Processed Rows:

Yes: Delete successfully processed items from the item interface tables.

No: Leave all rows in the item interface tables.

Process Set:

Enter a set id number for the set of records in the interface table that you want to process. The program picks up the records having that id in the SET_PROCESS_ID column. If you leave this field blank, all rows are picked up for processing regardless of the SET_PROCESS_ID column value.

Create or Update Items:

1.Create new items.

2 Update existing items. See: Update Existing Items below. You can create or update items via separate executions of the Import Items program.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7735683/viewspace-135425/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 转:BOM Interface
请登录后发表评论 登录
全部评论

注册时间:2008-01-02

  • 博文量
    25
  • 访问量
    36983