WO_FUL_RC_VW(SQL View) |
Index Back |
|---|---|
Fulfillment Run ControlRun control for fulfillment requests. |
| SELECT PROCESS_INSTANCE , OPRID , RUN_CNTL_ID , FULFILLMENT_LOC , REQUEST_ID , LANGUAGE_CD , SL_BUSINESS_UNIT , SL_SOURCE_BUS_UNIT , SL_ORDER_NO , TO_ORDER_NO , SL_ORDER_INT_LINE , TO_ORDER_INT_LINE , SL_SCHED_LINE_NBR , TO_SCHED_LINE_NBR , SL_INV_ITEM_ID , SL_SHOP_ID , SL_WO_TYPE , SL_PROJECT_ID , SL_SRVC_GRP_ID , SL_WO_LOCATION FROM PS_RUN_CNTL_IN_FUL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | FULFILLMENT_LOC | Character(2) | VARCHAR2(2) NOT NULL |
Page or process the fulfillment setup applies to.
03/16/04 PWF Addition of 80 for depletions
06/29/04 MDS (CN# IN890): Addition of Picking Feedback AE.
10/15/2004 WAB (F-KNANN-V59N4): Added online pages -- Create/Update Stock Request, Material Picking Feedback, Express Issue and Shipping/Issues -- and renamed existing pages, to be consistent with PIA menu items.
10=Reserve Materials Process 11=Create/Update Stock Request 20=Order Release Request 25=Undo Fulfillment Request 30=Picking 31=Material Picking Feedback 40=Picking Confirmation 50=Front-end Shipping Requests 51=Express Issue 60=Shipping Requests 61=Shipping/Issues 65=Freight Processing 70=Deplete On Hand Quantity 75=Kit Re-Explode 80=Build Bill of Lading 95=Fulfillment Workbench 99=Transactions |
| 5 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | SL_BUSINESS_UNIT_I | Character(5) | VARCHAR2(5) NOT NULL | Business Unit selection field |
| 8 | SL_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table: SP_BUIN_NONVW |
| 9 | SL_WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Order Number selection |
| 10 | TO_WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Order Number selection |
| 11 | SL_WO_TASK_ID | Number(5,0) | INTEGER NOT NULL | Order Line selection |
| 12 | TO_WO_TASK_ID | Number(5,0) | INTEGER NOT NULL | Order Line selection |
| 13 | SL_RES_LN_NBR | Number(6,0) | INTEGER NOT NULL | 05/07/04 PWF Added field for new 8.9 data model changes |
| 14 | TO_RES_LN_NBR | Number(6,0) | INTEGER NOT NULL | 05/07/04 PWF Added field for new 8.9 data model changes |
| 15 | SL_INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item selection
Prompt Table: MST_ITM_PRPT_VW |
| 16 | SL_SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop |
| 17 | SL_WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Work Order Type |
| 18 | SL_PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 19 | SL_SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Group |
| 20 | SL_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location selection |