Understanding How Mass Change is Used in People Soft Order Management
PeopleSoft Order Management uses mass change functionality in these processes:
Create Sales Orders (OMCNTRCT).
Sales Rebate Interface (OMSRBTIN).
The table contains the mass change definitions that are included in this Order Management process:
|
Step |
Mass Change Definition |
Description |
|---|---|---|
|
1 |
OMSCN-1 |
Insert sales buying agreement data into PS_OMSCN_TMP, selecting fields from PS_RUN_OM_SCON, PS_SCON_HDR, PS_SCON_LINE, and PS_SCON_RELEASE. |
|
2 |
OMSCN-2 |
Insert single order with multiple buying agreements into PS_OMSCN_DISTINCT, selecting distinct fields from PS_OMSCN_TMP. |
|
3 |
OMSCN-3 |
Insert single order buying agreements into PS_OMSCN_DISTINCT, selecting distinct fields from PS_OMSCN_TMP. |
|
4 |
OMSCN-4 |
Insert sales order header data into PS_ORD_HEADER, selecting fields from PS_OMSCN_DISTINCT and PS_RUN_OM_SCON. |
|
5 |
OMSCN-5 |
Insert sales line data into PS_ORD_LINE selecting fields from OMSCN_TMP, PS_SCON_LINE, PS_SCON_RELEASE, and RUN_OM_SCON. |
The table contains the mass change definitions that are included in this Order Management process:
|
Step |
Mass Change Definition |
Description |
|---|---|---|
|
1 |
OMRBT-INTFC |
Insert into INTFC_BI from RBTOM_INTFC_TMP, where TRANS_TYPE_BI in ('Line', NOTE', 'AHDR'). |
|
2 |
OMRBT-INTFC-AE |
Insert into INTFC_BI_AEDS from RBTOM_INTFC_TMP where TRANS_TYPE_BI in ('AE', 'DS'). |