DMND_SHP_INV_VW

(SQL View)
Index Back

Demand Ship Cust Id View

04/27/04 MEG CN#IN890 Data Model Changes - Replaced demand_inv with in_demand and cancel_flag with in_fulfill_state.

SELECT DISTINCT business_unit , ship_to_cust_id , SHIP_CUST_NAME1 FROM PS_IN_DEMAND WHERE in_fulfill_state IN ('30','40') AND fulfill_flag = 'Y' AND ship_to_cust_id <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
3 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name