STAGED_REQ_VW1 (SQL View)	Index Back
Load Staged Req No Pcode

STAGED_REQ_VW1

(SQL View)

Load Staged Req No Pcode

SELECT OPRID , RUN_CNTL_ID , REQUEST_ID , REQUEST_NBR , BUSINESS_UNIT , LOAD_OPTION , RECEIVER_ID , PRODUCTION_ID , PRDN_AREA_CODE , PRODUCTION_TYPE , INV_ITEM_ID , LOAD_OPRID , TRANS_SOURCE , AUTO_PUTAWAY_FLAG , PROCESS_FREQUENCY , PROCESS_STATUS , PROCESS_ORIG , PROCESS_INSTANCE , DTTM_STAMP_SEC , DESCR FROM PS_STAGED_REQ_INV

# 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 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

4 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

6 LOAD_OPTION Character(2) VARCHAR2(2) NOT NULL Load Option
01=Receiver ID
02=Production ID
03=Production Schedule
04=User ID
05=Transaction Source
06=All Items
Default Value: 06

7 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
Prompt Table: STAGED_RECV_VW

8 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
Prompt Table: STAGED_PRDN_VW

9 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
Prompt Table: STAGE_SCHED_VW1

10 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
Default Value: PR

11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: STAGE_SCHED_VW2

12 LOAD_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
Prompt Table: OPRID_VW

13 TRANS_SOURCE Character(3) VARCHAR2(3) NOT NULL Transaction Source
01=Purchasing
02=WIP Completion
03=Inventory
04=WIP Component
05=Adjustment
06=Component Kit Returns
Default Value: 03

14 AUTO_PUTAWAY_FLAG Character(1) VARCHAR2(1) NOT NULL Flag Items for Auto-Putaway
Y/N Table Edit

15 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N

16 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N

17 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler
Default Value: N

18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

19 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

20 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW
6	LOAD_OPTION	Character(2)	VARCHAR2(2) NOT NULL	Load Option 01=Receiver ID 02=Production ID 03=Production Schedule 04=User ID 05=Transaction Source 06=All Items Default Value: 06
7	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number Prompt Table: STAGED_RECV_VW
8	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID Prompt Table: STAGED_PRDN_VW
9	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area Prompt Table: STAGE_SCHED_VW1
10	PRODUCTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	JNW 11/1/98 (CN#SF800-13) activated teardown xlat PR=Production RW=Rework SV=Service TD=Teardown Default Value: PR
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: STAGE_SCHED_VW2
12	LOAD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID Prompt Table: OPRID_VW
13	TRANS_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Transaction Source 01=Purchasing 02=WIP Completion 03=Inventory 04=WIP Component 05=Adjustment 06=Component Kit Returns Default Value: 03
14	AUTO_PUTAWAY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag Items for Auto-Putaway Y/N Table Edit
15	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
16	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: N
17	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler Default Value: N
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description