ORD_HDR_SS_VW

(SQL View)
 Index Back

Order Header Search (SS)

Controlled by OPRID. Return only ones setup in CONTACT_CUST if 'E'xternal contact, all if 'I'nternal contact.

SELECT b.oprid , a.business_unit , a.order_no , a.sold_to_cust_id , a.bill_to_cust_id , a.order_status , a.customer_po , a.cntrct_id , a.ref_order_nbr FROM ps_ord_header a , PSOPRALIAS b , ps_contact c , ps_set_cntrl_rec d WHERE a.order_type_cd BETWEEN 'SO' AND 'SO' AND d.recname = 'CUSTOMER' AND d.setcntrlvalue = a.business_unit AND %Sql(OMSS_VALID_CUST_SQL, b, c, d.setid, a.sold_to_cust_id, sold_to_flg)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

Prompt Table: SP_BU_OM_NONVW

3 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SSSOLD_VW

5 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUST_SSBILL_VW

6 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled
7 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
8 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
9 REF_ORDER_NBR Character(15) VARCHAR2(15) NOT NULL Reference Order Number