INV_RSV_HDR_EVW (SQL View)	Index Back
Inventory Reserve Header EIP segment containing header information for a reservations fulfillment request.

INV_RSV_HDR_EVW

(SQL View)

Inventory Reserve Header

EIP segment containing header information for a reservations fulfillment request.

SELECT A.EIP_TRANS_SRC , A.EIP_TRANS_SRC_REF , B.EIP_TRANS_SRC_SEQ , A.OPRID , A.DEVICE_ID , B.DEVICE_DTTIME , B.BUSINESS_UNIT , B.PASS_THROUGH_LEVEL , B.AUTO_PICK_SEL , B.AUTO_SHIP_SEL , B.LEAD_DAYS , B.USE_LEAD_DAYS , B.RLS_RUN_CNTL_ID , B.AUTO_RELEASE_OPT FROM PS_BCT_DTL B , PS_BCT_CTL A WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EIP_TRANS_SRC Character(30) VARCHAR2(30) NOT NULL 08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)

2 EIP_TRANS_SRC_REF Character(30) VARCHAR2(30) NOT NULL Source Reference

3 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 DEVICE_ID Character(10) VARCHAR2(10) NOT NULL Device ID

6 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_IN

8 PASS_THROUGH_LEVEL Character(2) VARCHAR2(2) NOT NULL Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level.
10=Request
20=Order
30=Line

9 AUTO_PICK_SEL Character(1) VARCHAR2(1) NOT NULL The field is used to select the auto pick options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"

10 AUTO_SHIP_SEL Character(1) VARCHAR2(1) NOT NULL Used to capture the auto ship options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"

11 LEAD_DAYS Number(4,0) SMALLINT NOT NULL Lead Days for Calendar

12 USE_LEAD_DAYS Character(1) VARCHAR2(1) NOT NULL Use Lead Days
1=Use Fulfillment Lead Days
2=Override Fulfillment Lead Days
3=Ignore Lead Days

13 RLS_RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

14 AUTO_RELEASE_OPT Character(2) VARCHAR2(2) NOT NULL Auto Release Option
00=No Auto-Processing
10=Use Auto-Processing Default
20=Advance to Reserved
30=Advance to Releasable
40=Advance to Released
50=Advance to Confirmed
60=Advance to Shipped
70=Advance to Depleted

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_TRANS_SRC	Character(30)	VARCHAR2(30) NOT NULL	08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
2	EIP_TRANS_SRC_REF	Character(30)	VARCHAR2(30) NOT NULL	Source Reference
3	EIP_TRANS_SRC_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Source Transaction Sequence
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	DEVICE_ID	Character(10)	VARCHAR2(10) NOT NULL	Device ID
6	DEVICE_DTTIME	DateTime(26)	TIMESTAMP	Device Date Time
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_IN
8	PASS_THROUGH_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level. 10=Request 20=Order 30=Line
9	AUTO_PICK_SEL	Character(1)	VARCHAR2(1) NOT NULL	The field is used to select the auto pick options for fulfillment. 0=Use Default Values 1=Override to "Yes" 2=Override to "No"
10	AUTO_SHIP_SEL	Character(1)	VARCHAR2(1) NOT NULL	Used to capture the auto ship options for fulfillment. 0=Use Default Values 1=Override to "Yes" 2=Override to "No"
11	LEAD_DAYS	Number(4,0)	SMALLINT NOT NULL	Lead Days for Calendar
12	USE_LEAD_DAYS	Character(1)	VARCHAR2(1) NOT NULL	Use Lead Days 1=Use Fulfillment Lead Days 2=Override Fulfillment Lead Days 3=Ignore Lead Days
13	RLS_RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
14	AUTO_RELEASE_OPT	Character(2)	VARCHAR2(2) NOT NULL	Auto Release Option 00=No Auto-Processing 10=Use Auto-Processing Default 20=Advance to Reserved 30=Advance to Releasable 40=Advance to Released 50=Advance to Confirmed 60=Advance to Shipped 70=Advance to Depleted