RECV_PO_SHP_VW2

(SQL View)
Index Back

Receiver PO Sched View for EC


SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.DUE_DT , A.QTY_PO , A.SHIPTO_ID , %subrec(PUR_USR_SHP_SBR, A) FROM PS_PO_LINE_SHIP A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 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.
6 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
7 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
8 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
9 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
10 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
11 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
12 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
13 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
14 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2