VLOC_ADDR_EFFVW

(SQL View)
 Index Back

Supplier Loc Addresses Effdt V

Effective Dated view for Supplier Location Addresses

SELECT a.setid , a.vendor_id , a.vndr_loc , a.effdt , A.vndr_addr_type , a.address_seq_num , a.cntct_seq_num , a.contact_name , a.contact_type , a.contact_title , a.emailid , a.preferred_language , a.url FROM PS_VLOC_ADDR_VW a WHERE a.effdt = ( SELECT MAX(i.effdt) FROM PS_VLOC_ADDR_VW i WHERE i.setid = a.setid AND i.vendor_id = a.vendor_id AND i.vndr_loc = a.vndr_loc AND i.vndr_addr_type = a.vndr_addr_type AND i.effdt <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 VNDR_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Vendor Address Type
ORDR=Order Address
PRIM=Primary Address
REMT=Remit Address
6 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
7 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
8 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
9 CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
B=Billing Contact
C=Contract Collaborator
D=Commercial Paper Contact
E=External Contact
F=Cash Forecast
G=General
I=Internal Corporate Contact
L=Line of Credit Contact
M=Executive Management
O=Investment Pool Contact
P=Accounts Payable
R=Broker
S=Sales Contact
V=Service Contact
W=Warehousing/Shipping Contact
10 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.
11 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
12 PREFERRED_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese
13 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)