DB_LOOKUPRS_VW

(SQL View)
 Index Back

SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION WHERE 'Y'='N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DB_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
2 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
3 DB_NAME1 Character(90) VARCHAR2(90) NOT NULL DB-Name
4 DB_ADDRESS1 Character(64) VARCHAR2(64) NOT NULL DB- Address
5 CITY Character(30) VARCHAR2(30) NOT NULL City
6 STATE_NAME Character(30) VARCHAR2(30) NOT NULL State Name
7 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
10 DB_HQBRANCH_IND Character(2) VARCHAR2(2) NOT NULL D&B Branch Indicator - indicates whether subject is a branch location. Possible value ares H, S, or B for a Lookup transaction; Y or N for a product order
B=Branch
H=Headquarter
N=No
S=Single Location
Y=Yes