PO_RC_WB_SCR_SC

(SQL View)

SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR , CANCEL_STATUS , QTY_PO , CURRENCY_CD , MERCHANDISE_AMT , CURRENCY_CD_BASE , MERCH_AMT_BSE , MATCH_STATUS_LN_PO , MATCH_LINE_OPT , DUE_DT , PCT_UNDER_QTY 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]
Default Value: 1

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
Default Value: 1

5 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
Default Value: A

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

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

8 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

9 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

10 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

11 MATCH_STATUS_LN_PO Character(1) VARCHAR2(1) NOT NULL Match Status PO
M=Matched
N=Not Matched
P=Partially Matched
Default Value: N

12 MATCH_LINE_OPT Character(1) VARCHAR2(1) NOT NULL Match Line Option
E=ERS
F=Full Match
N=Don't Match
Default Value: N

13 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.

14 PCT_UNDER_QTY Signed Number(4,0) DECIMAL(3) NOT NULL Close PO Under Qty Pct Tol

#	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] Default Value: 1
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number Default Value: 1
5	CANCEL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cancel Status A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled Default Value: A
6	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
9	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
10	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
11	MATCH_STATUS_LN_PO	Character(1)	VARCHAR2(1) NOT NULL	Match Status PO M=Matched N=Not Matched P=Partially Matched Default Value: N
12	MATCH_LINE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Match Line Option E=ERS F=Full Match N=Don't Match Default Value: N
13	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.
14	PCT_UNDER_QTY	Signed Number(4,0)	DECIMAL(3) NOT NULL	Close PO Under Qty Pct Tol