ORD_HDR_SS_SRCH(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. 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL |
| SELECT b.oprid , a.business_unit , a.order_no , a.order_status , a.sold_to_cust_id , a.bill_to_cust_id , a.customer_po , a.cntrct_id , a.ref_order_nbr , L.in_process_flg FROM ps_ord_header a , ps_ord_header_lock L , 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 %Join(COMMON_KEYS, ord_header a, ord_header_lock L) 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
Prompt Table: ORD_HDR_SS_VW |
| 4 | ORDER_STATUS |
Character(3) | VARCHAR2(3) NOT NULL |
Order Status
C=Closed O=Open P=Pending X=Canceled |
| 5 | SOLD_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CUST_SSSOLD_VW
|
| 6 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
CUST_SSBILL_VW
|
| 7 | CUSTOMER_PO | Character(25) | VARCHAR2(25) NOT NULL |
Customer PO
Prompt Table: CUSTPO_SS_VW |
| 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 |
| 10 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |