ORD_PRDCTG_SRCH

(SQL View)
 Index Back

Order Header Search Record


select oh.business_unit, oh.order_no, oh.order_status, oh.sold_to_cust_id, oh.bill_to_cust_id, oh.customer_po, oh.cntrct_id from ps_set_cntrl_rec sc, PS_ORD_HEADER oh, ps_prodctlg_cust c where sc.recname = 'PRODCTLG_CUST' and sc.setcntrlvalue = oh.business_unit and c.setid = sc.setid and c.cust_id = oh.sold_to_cust_id and oh.order_type_cd between 'SO' and 'SO'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

Prompt Table: SP_BU_OM_NONVW

2 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
3 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled
4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW

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

Prompt Table: CUST_BLL_VW

6 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
7 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID