PO_RTV_LN_EVW1

(SQL View)
 Index Back

RTV Line Stage View

This view is used in RTV Message Definition SELECT A.BUSINESS_UNIT , A.RTV_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , B.RTV_LN_NBR , B.INV_ITEM_ID , B.DESCR254_MIXED , B.UNIT_MEASURE_STD , B.SHIP_TYPE_ID , B.UNIT_MEASURE_VNDR , B.CURRENCY_CD , B.LINE_NBR , B.PO_ID , B.PRICE_PO , B.QTY_LN_RETRN_VUOM , B.RECEIVER_ID , B.RECV_LN_NBR , B.RECV_SHIP_SEQ_NBR , B.RETURN_ACTION , B.RETURN_REASON , B.RMA_ID , B.RMA_LINE_NBR , B.MERCHANDISE_AMT , B.DISPOSITION_TYPE , B.PROCESS_INSTANCE , B.AUDIT_ACTN , B.IN_PROCESS_FLG FROM PS_RTV_DISPHDR_EC A , PS_RTV_DISPLN_EC B WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RTV_ID = B.RTV_ID

SELECT B.BUSINESS_UNIT , B.RTV_ID , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.RTV_LN_NBR , B.INV_ITEM_ID , B.DESCR254_MIXED , B.UNIT_MEASURE_STD , B.SHIP_TYPE_ID , B.UNIT_MEASURE_VNDR , B.CURRENCY_CD , B.LINE_NBR , B.PO_ID , B.PRICE_PO , B.QTY_LN_RETRN_VUOM , B.RECEIVER_ID , B.RECV_LN_NBR , B.RECV_SHIP_SEQ_NBR , B.RETURN_ACTION , B.RETURN_REASON , B.RMA_ID , B.RMA_LINE_NBR , B.MERCHANDISE_AMT , B.DISPOSITION_TYPE , B.PROCESS_INSTANCE , B.AUDIT_ACTN , B.IN_PROCESS_FLG FROM PS_RTV_DISPLN_EC B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
9 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
10 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
11 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
14 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
15 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
16 QTY_LN_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vndr Returned Qty
17 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
18 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
19 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
20 RETURN_ACTION Character(1) VARCHAR2(1) NOT NULL Return Action
C=Credit
E=Exchange
R=Replace
21 RETURN_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code
22 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
23 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
24 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
25 DISPOSITION_TYPE Character(1) VARCHAR2(1) NOT NULL Disposition Type
0=Ship
1=Destroy
26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
27 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
28 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag