INV_MSR_HDR_EVW(SQL View) |
Index Back |
---|---|
Create Stock Request EIP HdrEIP 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 |