PO_LNSHPORIG_VW

(SQL View)

SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR , PRICE_PO , DUE_DT , DUE_TIME , QTY_PO , SHIP_TYPE_ID FROM PS_PO_LINE_SHIP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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
Default Value: 1

5 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price

6 DUE_DT Date(10) DATE NOT NULL 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.

7 DUE_TIME Time(15) TIMESTAMP Due Time

8 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity

9 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: SHIP_METHOD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	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 Default Value: 1
5	PRICE_PO	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Purchase Order Price
6	DUE_DT	Date(10)	DATE NOT NULL	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.
7	DUE_TIME	Time(15)	TIMESTAMP	Due Time
8	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
9	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD