VMMT_UNP_RVS_VW

(SQL View)
 Index Back

Vchr Mass Mnt Unpost Rvsl View

Validation view used in mass maintenance "Unpost" operation, selects keys for vouchers to which user-specified "Reversal Accounting Date" option can be applied; i.e., unpost-able vouchers having one or more voucher accounting lines distributed to a GL/AM/PC/VAT subsystem and/or Doc Sequencing-enabled accounting lines.

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID FROM PS_VMMT_UNPOST_VW A WHERE EXISTS ( SELECT 'X' FROM PS_VCHR_ACCTG_LINE I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.VOUCHER_ID = A.VOUCHER_ID AND I.UNPOST_SEQ = 0 AND ((I.GL_DISTRIB_STATUS = 'D' OR I.PC_DISTRIB_STATUS = 'D' OR I.AM_DISTRIB_STATUS = 'D' OR I.VAT_DISTRIB_STATUS = 'D') OR (I.BUSINESS_UNIT_GL = A.BUSINESS_UNIT_GL AND I.DOC_SEQ_NBR <> ' ')))

# 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