CNTRCT_PSTBL_VW

(SQL View)
 Index Back

Contracts Eligible for Posting


select distinct business_unit, cntrct_id from PS_VOUCHER where entry_status = 'P' and in_process_flg = 'N' and (process_man_close = 'Y' or post_status_ap = 'U') and cntrct_id <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID