PO_RTV_FEE_EVW1 (SQL View)	Index Back
RTV Fee Stage View This view is used in RTV Message definition SELECT A.BUSINESS_UNIT , A.RTV_ID , C.VENDOR_SETID , C.VENDOR_ID , C.VNDR_LOC , A.RTV_LN_NBR , A.MISC_CHARGE_CODE , A.CURRENCY_CD , A.FEE_ACTION , A.FEE_AMOUNT , A.FEE_PERCENT , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_RTV_DISPFEE_EC A , PS_RTV_DISPLN_EC B , PS_RTV_DISPHDR_EC C WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND B.EIP_CTL_ID = C.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RTV_ID = B.RTV_ID AND B.RTV_ID = C.RTV_ID AND A.RTV_LN_NBR = B.RTV_LN_NBR

PO_RTV_FEE_EVW1

(SQL View)

RTV Fee Stage View

This view is used in RTV Message definition SELECT A.BUSINESS_UNIT , A.RTV_ID , C.VENDOR_SETID , C.VENDOR_ID , C.VNDR_LOC , A.RTV_LN_NBR , A.MISC_CHARGE_CODE , A.CURRENCY_CD , A.FEE_ACTION , A.FEE_AMOUNT , A.FEE_PERCENT , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_RTV_DISPFEE_EC A , PS_RTV_DISPLN_EC B , PS_RTV_DISPHDR_EC C WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND B.EIP_CTL_ID = C.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RTV_ID = B.RTV_ID AND B.RTV_ID = C.RTV_ID AND A.RTV_LN_NBR = B.RTV_LN_NBR

SELECT A.BUSINESS_UNIT , A.RTV_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.RTV_LN_NBR , A.MISC_CHARGE_CODE , A.CURRENCY_CD , A.FEE_ACTION , A.FEE_AMOUNT , A.FEE_PERCENT , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_RTV_DISPFEE_EC A

# 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 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

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

9 FEE_ACTION Character(2) VARCHAR2(2) NOT NULL Fee Action
CR=Credit
DB=Debit

10 FEE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The transaction fee amount.

11 FEE_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Fee Percent

12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

13 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

14 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

#	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	MISC_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	FEE_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Fee Action CR=Credit DB=Debit
10	FEE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The transaction fee amount.
11	FEE_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	Fee Percent
12	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
13	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
14	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag