PV_DELV_DTLS_VW

(SQL View)
 Index Back

ePro Delivery details view


SELECT D.BUSINESS_UNIT , D.RECEIVER_ID , D.RECV_LN_NBR , D.RECV_SHIP_SEQ_NBR , D.DISTRIB_LINE_NUM , S.INV_ITEM_ID , S.DESCR254_MIXED , S.SHIPTO_ID , S.DUE_DT , D.QTY_DS_ACCPT_VUOM , D.DELIVERED_FLG , D.DELIVERED_OPRID , D.DELIVERY_CART_ID , D.LOCATION , D.DELIVERED_TO , D.DELIVERY_FEEDBACK FROM PS_RECV_LN_SHIP S , PS_RECV_LN_DISTRIB D WHERE S.BUSINESS_UNIT = D.BUSINESS_UNIT AND S.RECEIVER_ID = D.RECEIVER_ID AND S.RECV_LN_NBR = D.RECV_LN_NBR AND S.RECV_SHIP_SEQ_NBR = D.RECV_SHIP_SEQ_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
8 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
9 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
10 QTY_DS_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Distributed Qty in Supp UOM
11 DELIVERED_FLG Character(1) VARCHAR2(1) NOT NULL Delivered Flag

Y/N Table Edit

Default Value: N

12 DELIVERED_OPRID Character(30) VARCHAR2(30) NOT NULL Deliverer

Prompt Table: PSOPRDEFN_VW

13 DELIVERY_CART_ID Character(10) VARCHAR2(10) NOT NULL Container ID
14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_VW

15 DELIVERED_TO Character(30) VARCHAR2(30) NOT NULL Delivered To
16 DELIVERY_FEEDBACK Character(240) VARCHAR2(240) NOT NULL Delivery Feedback