INV_SHF_HDR_EVW

(SQL View)
 Index Back

Inventory FrontEnd Ship Header

EIP segment containing header information for a front-end shipping 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.SELECT_UNFULFILLED , B.SELECT_RELEASABLE , B.PASS_THROUGH_LEVEL , B.SHIP_ID , B.CARRIER_ID , B.CARRIER_ID_FLG , B.SHIP_TYPE_ID , B.SHIP_TYPE_ID_FLG , B.SHIP_DATE , B.SHIP_DATE_FLG , B.SHIP_TIME , B.SHIP_TIME_FLG , B.STORAGE_AREA , B.STOR_LEVEL_1 , B.STOR_LEVEL_2 , B.STOR_LEVEL_3 , B.STOR_LEVEL_4 , B.BILL_OF_LADING , B.BILL_OF_LADING_FLG , B.PRO_NUMBER , B.PRO_NUMBER_FLG , B.FREIGHT_TERMS , B.FREIGHT_TERMS_FLG , B.FREIGHT_CALC_FLAG , B.FREIGHT_AMT , B.TRACKING_NBR , B.TRACKING_NBR_FLG , B.SHIP_CNTR_ID , B.AUTO_RELEASE_OPT , B.IN_CREATE_DMD_FLG , B.IN_DFR_DPL_OVRD , B.DELIVERY_ID , B.IN_FRT_P_BILFRT , B.IN_FRT_P_CMPFRT , B.IN_FRT_P_MANFRT , B.FRT_TYPE_CODE , B.DEL_VALIDATE_OPT , B.IN_FRT_OPTION , B.IN_BEST_WAY_BTN 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 SELECT_UNFULFILLED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
9 SELECT_RELEASABLE Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
10 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
11 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
12 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
13 CARRIER_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Carrier ID should be overridden with a blank value
14 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
15 SHIP_TYPE_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Via should be overridden with a blank value
16 SHIP_DATE Date(10) DATE Item Shipping Date
17 SHIP_DATE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Date should be overridden with a blank value
18 SHIP_TIME Time(15) TIMESTAMP Ship Time
19 SHIP_TIME_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Ship Time should be overridden with a blank value
20 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
21 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
22 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
23 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
24 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
25 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
26 BILL_OF_LADING_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Bill of Lading should be overridden with a blank value
27 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
28 PRO_NUMBER_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Pro Number should be overridden with a blank value
29 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
30 FREIGHT_TERMS_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Freight Terms should be overridden with a blank value
31 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag
32 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
33 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
34 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number
35 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
36 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
37 IN_CREATE_DMD_FLG Character(1) VARCHAR2(1) NOT NULL Create Demand

Y/N Table Edit

38 IN_DFR_DPL_OVRD Character(1) VARCHAR2(1) NOT NULL used to override the defer depletions field on in_demand
1=Override to Yes
2=Override to No
39 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
40 IN_FRT_P_BILFRT Character(1) VARCHAR2(1) NOT NULL Commit Billable Freight
41 IN_FRT_P_CMPFRT Character(1) VARCHAR2(1) NOT NULL Freight Complete
42 IN_FRT_P_MANFRT Character(1) VARCHAR2(1) NOT NULL External Manifest
43 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code
44 DEL_VALIDATE_OPT Character(2) VARCHAR2(2) NOT NULL Delivery validation option
10=Validate Only
20=Validate/Assign to New
30=Validate/Auto Assign Open
40=Validate/Auto Assign All
50=Reassign/Consolidate
60=Do Not Validate
45 IN_FRT_OPTION Character(2) VARCHAR2(2) NOT NULL Freight Options
10=Shop For Rates
20=Best Way
30=Use Specified Carrier
40=Carrier with Best Way
46 IN_BEST_WAY_BTN Character(2) VARCHAR2(2) NOT NULL Best Way Freight Option
10=Least Cost
20=By Commit Date