RECV_HDR_VW3

(SQL View)
Index Back

Used by RCPT_RUN_CNTRL

Used by Accrual Receipts.

SELECT BUSINESS_UNIT , RECEIVER_ID FROM PS_RECV_HDR WHERE RECV_STATUS IN ('N', 'O', 'P','R', 'M', 'X')

# 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_PM.BUSINESS_UNIT_RECV

Prompt Table: SP_BU_PM_NONVW

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

Default Value: NEXT