OCD_HEADER_VW

(SQL View)
 Index Back

View of order capture header

This is the order management view of the capture header.

SELECT A.CAPTURE_ID , A.BULK_ORDER_FLAG , A.BUSINESS_UNIT , R1.SETID , A.CAPTURE_TYPE_CD , R2.SETID , A.SOURCE_CD , R3.SETID , A.STATUS_CODE , A.DUE_DATE , B.BO_ID_SOLD_TO_CUST , C.BO_ID_SOLD_TO_CNT , ' ' , A.CAPTURE_DATE FROM PS_RO_HEADER A , PS_SET_CNTRL_REC R1 , PS_SET_CNTRL_REC R2 , PS_SET_CNTRL_REC R3 , PS_OCD_SOLD_VW B , PS_OCD_SOLDC_VW C WHERE R1.SETCNTRLVALUE = A.BUSINESS_UNIT AND R1.RECNAME='RO_TYPE' AND R2.SETCNTRLVALUE = A.BUSINESS_UNIT AND R2.RECNAME='RO_DEFN_SOURCE' AND R3.SETCNTRLVALUE = A.BUSINESS_UNIT AND R3.RECNAME='RO_DEFN_HDSTAT' AND B.CAPTURE_ID=A.CAPTURE_ID AND C.CAPTURE_ID=A.CAPTURE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
2 BULK_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Flag used to determinate if an order is the master order when using bulk ordering.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RO_NONVW

4 SETID_CAPTURE_TYPE Character(5) VARCHAR2(5) NOT NULL MOC SETID Field
5 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order

Prompt Table: RO_TYPE

6 SETID_SRC_CD Character(5) VARCHAR2(5) NOT NULL Setid Source Code
7 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

Prompt Table: RO_DEFN_SOURCE

8 SETID_STATUS Character(5) VARCHAR2(5) NOT NULL MOC SETID Field
9 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code

Prompt Table: RO_DEFN_HDSTAT

10 DUE_DATE Date(10) DATE Delivery Due Date from PO
11 BO_ID_SOLD_TO_CUST Number(31,0) DECIMAL(31) NOT NULL BO ID for the sold to customer
12 BO_ID_SOLD_TO_CNT Number(31,0) DECIMAL(31) NOT NULL BO ID for the sold to contact.
13 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
14 CURRENCY_DATE Date(10) DATE Order capture date used for orders and quotes