EMINV_VND_VW

(SQL View)
Index Back

Voucher Vendor Info

Voucher vendor information

SELECT a.business_unit , a.voucher_id , a.voucher_line_num , a.distrib_line_num , a.vendor_setid , a.vendor_id , b.vendor_name_short , b.name1 , b.name2 FROM PS_EM_VCH_LN_VW a , ps_vendor b WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

Default Value: NEXT

3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
9 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2