OM销售设置

2013-12-30

Order Management设置需要预先在Inventory职责下定义组织，至少需要定义一个item validation organization和一个inventory organization（warehouses）。在inventory organization下建立Subinventories和Items。

1. profile设置

system administrator-> profile -> system

设置Responsibility级别的Profile值。如果不进行设置，则会沿用Site或者Application级别的设置。(待分析)

 

2. parameter 设置

order management super user -> setup ->system parameters-> values

设置item validation organization

 

3. Tax设置

tax manager-> home  (待分析)

 

4. document sequence 设置

4.1 order management super user -> setup->documents->define   定义单据序列号

查询： select * from fnd_document_sequences

4.2 order management super user-> setup -> documents-> assign 分配单据序列号

查询： select * from fnd_doc_sequence_assignments

 

5. units of measure 设置

5.1 order management super user-> setup->uom-> classes 定义计量单位类型

查询： select * from mtl_uom_classes_vl

5.2 order management super user-> setup-> uom->units  定义计量单位

查询： select * from mtl_units_of_measure_ vl

 

2013-12-31

6. transaction type设置

order management super user-> setup-> transaction types->define/approvals (待分析)

 

7. shipping parameter 设置

order management super user-> shipping-> setup->shipping parameters

查询： select * from wsh_shipping_parameters

 

8. freight carriers 设置

order management super user-> shipping-> setup-> freight carriers,cost types-> freight carriers

查询：select * from wsh_carriers_v

 

9. defaulting rules设置

order management super user-> setup->rules-> defaulting

查询：select * from oe_def_ak_obj_ext_v

 

10. credit check rules设置

order management super user-> setup -> rules->credit

查询：select * from oe_credit_check_rules

 

11. holds 设置

order management super user-> setup-> orders-> holds

查询： select * from oe_hold_definitions

 

12. customer设置

order management super user-> customers->standard

 

13. pricelist设置

13.1 system administrator-> profile->system  设置QP: Item Validation Organization

13.2 order management super user-> pricing-> price lists-> price list setup

查询：select * from qp_list_headers_b

            select * from qp_list_headers_tl

 

14. salesperson设置

order management super user-> setup-> sales-> salespersons

查询：select * from jtf_rs_defresources_v