VNDR_PYINQ_VW4H

(SQL View)
Index Back

SELECT setid , vendor_id , vendor_name_short , ar_num , '0' , name1 FROM PS_VNDR_PYINQ_VW1 WHERE appr_status = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETVC_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_VW

3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

Prompt Table: VENDOR_SHRT_VW1

4 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number

Prompt Table: VNDR_AR_VW

5 DB_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

Prompt Table: VNDR_NAME1_VW