VCHRLN_CMMNT_VW

(SQL View)
 Index Back

Voucher Line Comment View

Voucher Line Comment View

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DESCR , A.DESCR254_MIXED , B.DESCR254_MIXED , %cast(A.DESCR %Concat ' ' %Concat A.DESCR254_MIXED %Concat ' ' %Concat B.DESCR254_MIXED %Concat ' ' %Concat V.DESCR254_MIXED , LONG , CHARACTER) FROM PS_VOUCHER_LINE A , PS_PYMNT_VCHR_XREF B , PS_VOUCHER V WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.BUSINESS_UNIT = V.BUSINESS_UNIT AND A.VOUCHER_ID = V.VOUCHER_ID

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

Prompt Table: BUS_UNIT_TBL_FS

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

Prompt Table: VOUCHER

3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

Default Value: 1

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
6 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description
7 SES_PROC_CMMT Long Character CLOB Common Procurement Comment Field