IN_RLS_SQR_TAO(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | TO_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit selection field |
| 5 | RLS_RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: RLS_RUN_CNTL_VW |
| 6 | 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 Default Value: 20 |
| 7 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 8 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 9 | PROCESSING_GROUP | Number(10,0) | DECIMAL(10) NOT NULL | A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level. |
| 10 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 11 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |