INV_MSR_HDR_EVW

(SQL View)
Index Back

Create Stock Request EIP Hdr

EIP segment containing header information for a "Create Stock Request" 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.LEAD_DAYS , B.USE_LEAD_DAYS , B.RLS_RUN_CNTL_ID , B.AUTO_RELEASE_OPT FROM %Table(BCT_DTL) B , %Table(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 LEAD_DAYS Number(4,0) SMALLINT NOT NULL Lead Days for Calendar
10 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
11 RLS_RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
12 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