RE_LS_VNCNT_SUM

(SQL View)
 Index Back

Lease Supplier Contact Detail

This view is used in Supplier Contact of the Lease Abstract Summary

SELECT CONTACT.LS_KEY , VENDOR.PARTY_KEY , VENDOR.CONTACT_NAME , CONTACT.PARTY_TYPE_CD ,VENDOR.CONTACT_TYPE , VENDOR.PREFERRED_LANGUAGE , VENDOR.EMAILID , VENDOR.PHONE_TYPE , VENDOR.PHONE , VENDOR.EXTENSION ,%subrec(ADDRESS_SBR,VENDOR) FROM PS_RE_SUM_VN_CNTCT VENDOR , PS_RE_LS_CNTCT CONTACT , PS_RE_LS LEASE WHERE VENDOR.PARTY_KEY=CONTACT.PARTY_KEY AND CONTACT.LS_KEY = LEASE.LS_KEY AND VENDOR.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = LEASE.BUSINESS_UNIT AND RECNAME = 'VENDOR_CNTCT') AND CONTACT_NAME IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
2 PARTY_KEY Number(10,0) DECIMAL(10) NOT NULL Party Key
3 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
4 PARTY_TYPE_CD Character(20) VARCHAR2(20) NOT NULL Party type code (Internal or External)
5 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
6 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
7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
8 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business Phone
CAMP=Campus Phone
CELL=Cellular Phone
DORM=Dormitory Phone
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
10 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
14 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
15 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
16 CITY Character(30) VARCHAR2(30) NOT NULL City
17 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
18 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
19 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
20 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
21 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
22 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
23 COUNTY Character(30) VARCHAR2(30) NOT NULL County
24 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

25 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
26 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
27 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit