PO_RTV_FEE_EVW2

(SQL View)
 Index Back

RTV Fee Stage View

This view is used in RTV pub rule defintion for supplier chunk rule record mappings

SELECT A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.BUSINESS_UNIT , A.RTV_ID , 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
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