|
SELECT PROCESS_INSTANCE , OPRID , RUN_CNTL_ID , FULFILLMENT_LOC , REQUEST_ID , SELECT_UNFULFILLED , SELECT_RELEASABLE , SELECT_RELEASED , SELECT_CONFIRMED , SELECT_SHIPPED , SELECT_DEPLETED , TRANSACTION_CODE , SL_BUSINESS_UNIT , SL_DEMAND_SOURCE , SL_SOURCE_BUS_UNIT , SL_ORDER_NO , TO_ORDER_NO , SL_INV_ITEM_ID , SL_PARENT_PROD_ID , IN_KIT_EXPL_DATE , IN_KIT_EXEC_MODE FROM PS_RUN_CNTL_IN_FUL
|
| # |
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 |
SELECT_UNFULFILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
Y/N Table Edit
Default Value: N
|
| 7 |
SELECT_RELEASABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
Y/N Table Edit
Default Value: N
|
| 8 |
SELECT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Released state.
Y/N Table Edit
Default Value: N
|
| 9 |
SELECT_CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.
Y/N Table Edit
Default Value: N
|
| 10 |
SELECT_SHIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Picked state.
Y/N Table Edit
Default Value: N
|
| 11 |
SELECT_DEPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the RFID Tag Generation should include data in a Depleted state.
Y/N Table Edit
Default Value: N
|
| 12 |
TRANSACTION_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table:
BCT_XFUL_INV_VW
|
| 13 |
SL_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
%EDITTABLE40
|
| 14 |
SL_DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source selection
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Sourced Demand
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order Demand
|
| 15 |
SL_SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Business Unit selection
Prompt Table:
SP_BU_FS_NONVW
|
| 16 |
SL_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
Prompt Table:
%EDITTABLE2
|
| 17 |
TO_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
Prompt Table:
%EDITTABLE2
|
| 18 |
SL_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item selection
|
| 19 |
SL_PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
Prompt Table:
%EDITTABLE16
Set Control Field: SL_BUSINESS_UNIT
|
| 20 |
IN_KIT_EXPL_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Kit Effective Date to be used by the Kit Re-Explode program
1=Schedule Date
2=Order Date
3=Ship Early Date
4=Today's Date
|
| 21 |
IN_KIT_EXEC_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Execution Mode for the Kit Re-Explode program
1=Report and Re-Explode
2=Report Only
|