CUST_HOLD_VW

(SQL View)
 Index Back

Customer Holds - OM

Date Init. Issue # Description 051304 dms F-KNANN-V59N4 Add new pass thru fields

SELECT A.SETID ,A.CUST_ID ,B.HOLD_CD ,B.MESSAGE_CD ,A.START_DT ,A.END_DT ,B.PASS_HOLD_TO_BI ,B.PASS_HOLD_TO_ID ,B.PASS_HOLD_TO_IP ,B.PASS_HOLD_TO_IR ,B.PASS_HOLD_TO_IS ,B.PASS_HOLD_TO_IU ,B.PASS_TO_PURCH ,B.INCL_IN_PLAN FROM PS_CUST_MSG A , PS_MESSAGE_TBL B , PS_SET_CNTRL_REC C WHERE C.RECNAME = 'MESSAGE_TBL' AND C.SETCNTRLVALUE = A.SETID AND B.SETID = C.SETID AND A.MESSAGE_CD = B.MESSAGE_CD AND B.MESSAGE_ACTION = 'H' AND %EffdtCheck(message_tbl, B, %currentdatein) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
4 MESSAGE_CD Character(6) VARCHAR2(6) NOT NULL Message Code
5 START_DT Date(10) DATE Start Date
6 END_DT Date(10) DATE End Date
7 PASS_HOLD_TO_BI Character(1) VARCHAR2(1) NOT NULL Pass to Billing
8 PASS_HOLD_TO_ID Character(1) VARCHAR2(1) NOT NULL Pass to Released
9 PASS_HOLD_TO_IP Character(1) VARCHAR2(1) NOT NULL Pass to Picked/Confirmed
10 PASS_HOLD_TO_IR Character(1) VARCHAR2(1) NOT NULL Pass to Releasable
11 PASS_HOLD_TO_IS Character(1) VARCHAR2(1) NOT NULL Pass to Shipped
12 PASS_HOLD_TO_IU Character(1) VARCHAR2(1) NOT NULL Pass to Unfulfilled
13 PASS_TO_PURCH Character(1) VARCHAR2(1) NOT NULL Pass to Purchasing
14 INCL_IN_PLAN Character(1) VARCHAR2(1) NOT NULL Include in Planning