LC_ORD_HDR_SRCH

(SQL View)
 Index Back

Order Header Search Record

View to search the order header for a letter of credit

SELECT B.BUSINESS_UNIT_OM, A.ORDER_NO, A.ORDER_STATUS, A.SOLD_TO_CUST_ID, A.BILL_TO_CUST_ID, A.CUSTOMER_PO, A.CNTRCT_ID FROM PS_ORD_HEADER A, PS_LC_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_OM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
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