PO_RTV_HDR_EVW2

(SQL View)
 Index Back

RTV HDR Stage View

This view is used in RTV Pub rule definition for Supplier Chunk Record Mappings SELECT SUPPLIER_SETID , SUPPLIER_ID , SUPP_LOC , BUSINESS_UNIT , RTV_ID , DESCR_BU , ADDRESS1_BU , ADDRESS2_BU , ADDRESS3_BU , ADDRESS4_BU , CITY_BU , STATE_BU , POSTAL_BU , COUNTRY_BU , STD_ID_NUM_SUPP , NAME1_SUPP , ADDRESS1_SUPP , ADDRESS2_SUPP , ADDRESS3_SUPP , ADDRESS4_SUPP , CITY_SUPP , STATE_SUPP , POSTAL_SUPP , COUNTRY_SUPP , BUYER_ID , ACTIVITY_DATE , CARRIER_ID , ENTERED_BY , ENTERED_DT , FREIGHT_TERMS , SHIP_TYPE_ID , PROCESS_INSTANCE , AUDIT_ACTN , IN_PROCESS_FLG FROM PS_RTV_DISPHDR_EC

SELECT VENDOR_SETID , VENDOR_ID , VNDR_LOC , BUSINESS_UNIT , RTV_ID , DESCR_BU , ADDRESS1_BU , ADDRESS2_BU , ADDRESS3_BU , ADDRESS4_BU , CITY_BU , STATE_BU , POSTAL_BU , COUNTRY_BU , STD_ID_NUM_VNDR , NAME1_VNDR , ADDRESS1_VNDR , ADDRESS2_VNDR , ADDRESS3_VNDR , ADDRESS4_VNDR , CITY_VNDR , STATE_VNDR , POSTAL_VNDR , COUNTRY_VNDR , BUYER_ID , ACTIVITY_DATE , CARRIER_ID , ENTERED_BY , ENTERED_DT , FREIGHT_TERMS , SHIP_TYPE_ID , PROCESS_INSTANCE , AUDIT_ACTN , IN_PROCESS_FLG FROM PS_RTV_DISPHDR_EC

# 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 DESCR_BU Character(30) VARCHAR2(30) NOT NULL Business Unit Description
7 ADDRESS1_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 1
8 ADDRESS2_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 2
9 ADDRESS3_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 3
10 ADDRESS4_BU Character(55) VARCHAR2(55) NOT NULL BU Address Line 4
11 CITY_BU Character(30) VARCHAR2(30) NOT NULL Business Unit City
12 STATE_BU Character(6) VARCHAR2(6) NOT NULL Business Unit State
13 POSTAL_BU Character(12) VARCHAR2(12) NOT NULL Business Unit Postal Code
14 COUNTRY_BU Character(3) VARCHAR2(3) NOT NULL Business Unit Country
15 STD_ID_NUM_VNDR Character(20) VARCHAR2(20) NOT NULL Vendor ID Number
16 NAME1_VNDR Character(40) VARCHAR2(40) NOT NULL Vendor Name
17 ADDRESS1_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 1
18 ADDRESS2_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 2
19 ADDRESS3_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 3
20 ADDRESS4_VNDR Character(55) VARCHAR2(55) NOT NULL Vendor Address Line 4
21 CITY_VNDR Character(30) VARCHAR2(30) NOT NULL Vendor City
22 STATE_VNDR Character(6) VARCHAR2(6) NOT NULL Vendor State
23 POSTAL_VNDR Character(12) VARCHAR2(12) NOT NULL Vendor Postal Code
24 COUNTRY_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Country
25 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
26 ACTIVITY_DATE Date(10) DATE Last Activity
27 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
28 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
29 ENTERED_DT Date(10) DATE Entered on
30 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
31 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
32 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
33 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
34 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag