VMMT_RELATED_VW

(SQL View)
 Index Back

Vchr Mass Mnt "Related " View

It is used when it is checking for, that a related Voucher exists for the Voucher trying to be Closed or Deleted

SELECT DISTINCT A.BUSINESS_UNIT , B.VOUCHER_ID_RELATED FROM PS_VOUCHER A , PS_VOUCHER_LINE B WHERE A.VOUCHER_STYLE IN ('ADJ','CORR') AND A.ENTRY_STATUS <> 'X' AND A.PROCESS_MAN_CLOSE = 'N' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND B.VOUCHER_ID_RELATED <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID